Search: "KPI query"

#excel #power query #survey

Convert a Messy Survey Export Into Clean Long-Format Data

I exported a survey to Excel. Each respondent is one row, each question is its o...

#excel #data-cleaning #power-query

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#slo #data-quality #pipelines

Design a Data Quality SLO Framework for a Critical Pipeline

Act as a data reliability engineer. Help me design a data quality SLO framework ...

#excel #dashboard #pivottable

Create a Dynamic Dashboard with Slicers and PivotTables

You are an Excel dashboard designer. Guide me through building an interactive sa...

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#power-query #csv #data-cleaning

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...

#excel #power-query #data-cleaning

Excel: Convert a Messy Paste-from-PDF Table Into a Clean Dataset

I pasted a table from a PDF and Excel split it badly — values are stuck together...

#excel #power-query #vlookup

Excel: Replace a Fragile VLOOKUP Chain With Power Query

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

#coding #debugging #production

coding Advanced

Coding: Find the Bug That Only Happens at 3am in Production

We have a bug: [SYMPTOMS]. It only shows up [WHEN/WHERE]. We can't reproduce it ...

#excel #power query #decision

Decide when to use Power Query vs formulas vs a real database

I keep solving the same data problem three different ways across my team's sprea...

#excel #power-query #data-cleanup

Excel: Clean a Messy Address Column Without Losing Edge Cases

I have a column of free-text addresses scraped from a form: [PASTE 20 SAMPLES]. ...

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

#data #warehouse #cost-optimization

Reduce data pipeline cost without losing freshness or completeness

You are a data platform engineer. Our [WAREHOUSE] bill is up 60% YoY while data ...

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

#excel #auditing #debugging

excel intermediate

Trace a broken cell reference across a workbook before fixing it blindly

Act as an Excel auditor. A formula on the summary tab is returning #REF! after a...

#excel #dashboard #slicers

excel intermediate

Build a Dynamic Excel Dashboard with Slicers

Act as an Excel expert. Guide me through building a dynamic dashboard for [datas...

finance intermediate

Financial KPIs Dashboard for Startup Founders

You are a startup CFO advisor. I need to build a financial KPIs dashboard that g...

#finance #kpis #startup

#data-quality #dashboard #sanity-check

data Intermediate

Sanity Check a Dashboard Number That Looks Too Good to Be True

A number on my dashboard looks too good to be true. Metric: [METRIC NAME]. Repor...

#creative #logline #pitch

creative Intermediate

Write a Logline That Sells the Story Without Spoiling It

I need a logline for [project name] that I'll use on [where — a pitch deck, my a...

coding Advanced

Database Query Optimization with EXPLAIN Analysis

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

#coding #sql #database

Build a Weekly KPI Dashboard in Excel That Doesn't Break When Someone Renames a Tab

I'm building a weekly KPI dashboard in Excel for a small operations team. The so...

#excel #dashboard #kpi

#excel #automation #power-query

Schedule an Excel file refresh without setting up a server

I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....

data Intermediate

Write a query that survives the source table being renamed in six months

I need to write a SQL query that pulls weekly metrics for a dashboard. The sourc...

#sql #data #query