Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "joins"

16 prompts matching "joins"

"joins" ✕ Clear all ✕
coding Intermediate

SQL Query - Complex Joins and Aggregation

Write SQL queries for a database with tables: orders (id, customer_id, order_dat...

#coding #SQL #joins
👁 17 views
data Advanced

ChatGPT Prompt for SQL Query Review Before Sharing a Board Report

Review my SQL query before I use it in an executive or board report where mistak...

#sql review #board reporting #metric qa
👁 15 views
data Advanced

ETL Pipeline Design for Data Warehouse

Design an ETL (Extract, Transform, Load) pipeline for loading data from [source ...

#data #etl #pipeline
👁 15 views
data Advanced

Write Window Functions That Replace a Subquery Loop

Act as a senior SQL engineer. I need to compute {{describe: e.g., 7-day rolling ...

#data #sql #window-functions
👁 11 views
coding Advanced

ChatGPT prompt for reviewing SQL query performance and suggesting optimizations

Act as a senior SQL performance engineer. I will share a slow SQL query, the ta...

#coding #sql #query optimization
👁 10 views
data Advanced

Funnel Analysis Query Diagnosing the Worst Drop-Off Step

I have an events table (event_name, user_id, event_time, properties JSON). Write...

#data #funnel #sql
👁 9 views
excel Advanced

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

#excel #power query #m code
👁 8 views
data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization
👁 7 views
coding Advanced

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database
👁 5 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
data Advanced

Write a Cohort Retention Query That Doesn't Secretly Double-Count Users

I need a SQL cohort retention query that groups users by their signup week and s...

#data #sql #cohort
👁 4 views
excel Advanced

Excel: Replace a Fragile VLOOKUP Chain With Power Query

I have a workbook stitched together by [N] VLOOKUPs across [M] sheets, and it br...

#excel #power-query #vlookup
👁 3 views
excel Advanced

Automate a weekly Excel report that pulls from three CSVs and emails itself

You are an automation engineer. I get three CSVs every Monday — [CSV_1], [CSV_2]...

#excel #power-query #office-scripts
👁 3 views
excel advanced

Build a working capital model from a P&L extract without manual joins

Act as a finance analyst. I will paste a monthly P&L extract plus a trial-balanc...

#excel #working-capital #finance-model
👁 2 views
data Intermediate

Choose the right join before I merge two datasets

I have two tables I want to combine and I'll describe the key columns and what e...

#data #joins #sql
👁 2 views
data Intermediate

Sanity-check a dataset in 30 minutes before you build anything on top of it

I just got handed a dataset I'm going to use for [analysis / model / dashboard]....

#data #sanity-check #eda
👁 1 views
data Advanced

Write a SQL query that returns the right answer when the data has duplicates

I'm writing a SQL query against tables [paste schemas, especially the join keys]...

#sql #joins #duplicates
👁 1 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval