Search: "data-questions"

#data #analysis #statistics

Decide whether a metric change is real or just noise this week

A metric I track jumped by 15% this week compared to last week. Before I tell an...

Fix a column where 30% of values are 'kind of right but not parseable'

I have a column in a dataset that's supposed to be a phone number, date, or addr...

#data #cleaning #etl

#SQL #window functions #query optimization

Rewrite a slow correlated subquery as a window function

I have a query with a correlated subquery that runs once per row to find each cu...

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

#data #dashboards #metrics

Build a one-glance metrics dashboard for a non-technical CEO

Help me design a single-screen weekly metrics dashboard my CEO will actually rea...

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

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

Explain a metric movement to a skeptical stakeholder without overclaiming

[Metric] moved [direction + magnitude] in [period]. The first plausible explanat...

#data #metrics #analysis

#data #metrics #north-star

data advanced

Decide which metric to make the team's North Star without flattening the work

Act as a data leader who has watched teams pick the wrong North Star and live wi...

#data #quality #monitoring

data intermediate

Detect a data-quality problem before stakeholders find it for you

Act as an analytics engineer who has had to apologize for wrong dashboards. Help...

#debugging #audit #trace-precedents

Find which formula in a 12-tab workbook is wrong without checking every cell

You're an Excel auditor. A summary total on my Dashboard tab is off by $4,200 fr...

#code-review #pr #reviews

coding Advanced

Review a pull request for the thing the author didn't realize they were doing

You're a senior engineer doing a code review. I'll paste the diff. Don't comment...

#experimentation #ab-testing #significance

Decide whether an experiment result is real, lucky, or a measurement artifact

You're an experimentation lead. I ran an A/B test, the headline metric moved 4.2...

#formulas #validation #helper-column

Build a formula that flags rows where two columns disagree

Act as an Excel expert. I have a spreadsheet where two columns should always agr...

#power-query #data-cleaning #pivot

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

data intermediate

Write SQL Queries from a Question

Act as a SQL expert. My tables are: [describe tables and key columns]. Write a S...

#data #sql #queries

#data #statistics #interpretation

data intermediate

Interpret Statistical Results in Plain English

Act as a statistics tutor. Explain these results in plain English: [paste number...

#data #charts #visualization

Decide which chart actually fits my data and question

I'll describe my dataset and the question I'm trying to answer. Recommend the ri...

#legal #policy #compliance

legal Intermediate

Turn a fuzzy intention into a clear written policy

I have a rough intention for an internal policy (returns, remote work, data hand...

#excel #dropdown #data validation

excel Advanced

Build a dynamic dropdown that filters a second dropdown

I want two dependent dropdowns in Excel: pick a Region in cell A2, and the City ...

#excel #sumifs #debugging

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

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

#data #data quality #validation

data Beginner

Sanity-check a dataset before I trust it

I'll describe a dataset I just received. Give me a checklist of the first things...