108 prompts matching "query"
I need an Excel formula to detect duplicate records based on a combination of mu...
Write a SQL query to compute monthly cohort retention. Tables: - users(id, signu...
You are a Power Query specialist. I have raw data that needs cleaning and transf...
Act as a financial analyst. Help me build a pivot table from [DATA RANGE] (colum...
Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...
Act as a Power Query (M language) developer. I will describe a messy raw export ...
Act as a database performance engineer with deep SQL optimization expertise. Hel...
I have an events table (event_name, user_id, event_time, properties JSON). Write...
Write a portable SQL query (works on PostgreSQL and BigQuery) that produces a mo...
Generate Power Query M code that consolidates all .xlsx files in a folder into a...
You are an Excel Power Query specialist. Walk me step-by-step through combining ...
I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...
Write a SQL query that finds users stuck mid-funnel for re-engagement. Schema: e...
A stakeholder asked me 'how is our growth doing?' Help me turn that into a real,...
Write a SQL query that answers this question: [QUESTION]. Tables and columns I h...
I have one column containing several fields concatenated together (name, email, ...
We have a bug: [SYMPTOMS]. It only shows up [WHEN/WHERE]. We can't reproduce it ...
I need a SQL cohort retention query that groups users by their signup week and s...
I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....
I have a budget spreadsheet in wide format: one row per account, then 12 columns...
I exported a survey to Excel. Each respondent is one row, each question is its o...
Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...
I pasted a table from a PDF and Excel split it badly — values are stuck together...
I have a workbook stitched together by [N] VLOOKUPs across [M] sheets, and it br...