Search: "power query"

#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, ...

#creative #character #antagonist

creative Advanced

Creative: Make This Villain More Than 'Wants Power Because Evil'

Here's my antagonist: [PASTE BRIEF]. Right now their motivation is basically 'wa...

#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

#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....

coding Advanced

Database Query Optimization with EXPLAIN Analysis

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

#coding #sql #database

#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...

#excel #vlookup #reconciliation

Reconcile two lists that should match but somehow never do

You are an Excel power user. I have two lists in Excel that are *supposed* to be...

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

#power-query #m-language #etl

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

#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 ...

#data #ab-testing #experimentation

Choose between A/B test variants when results are statistically tied

My A/B test ran for 3 weeks. Variant B is +0.4% on the primary metric, not stati...

#excel #power-query #office-scripts

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]...

Write a SQL Query from a Plain-English Question

You are a SQL expert and data analyst. I will describe a question in plain Engli...

#data #sql #query

#data-quality #dashboard #sanity-check

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...

#data #ab-testing #experimentation

A/B Test Sample Size and Duration Calculator

Calculate the required sample size and test duration for an A/B test given: base...

#duplicates #dedupe #power-query

Excel: Detect Duplicate Rows Across Multiple Key Columns

I have an Excel sheet where 'duplicates' aren't exact matches — they share a cus...

#data #sql #query-optimization

Data: Rewrite a Slow Query Without Changing What It Returns

I have a SQL query that's slow. Make it fast while keeping the result set identi...

Data: Write a SQL Query for a Cohort Retention Table

I want a SQL query that returns a cohort retention table — rows = signup month, ...

#data #sql #retention

Data: Write a Backfill Query That Won't Take Down the Database

I need to backfill [COLUMN/TABLE] with [LOGIC]. The table has [N] rows. Write th...

#data #sql #backfill

Write a SQL query to find customers who used to engage but have quietly dropped off

I want to find 'silently churning' customers — users who used to be active and h...

#data #sql #churn