Search: "data-modeling"

excel Advanced

Audit a Workbook for Broken Formulas and Hidden Dependencies

I inherited a 30-sheet Excel workbook and it gives slightly wrong totals. Walk m...

#excel #audit #formulas

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

#data-questions #stakeholder #requirements

Translate a Vague Stakeholder Question Into an Answerable Data Question

Translate a vague stakeholder request into a precise, answerable data question. ...

Decide If This Data Is Worth Analyzing Before You Spend a Week On It

Before I dig into [dataset and analysis question], help me decide if it's worth ...

#data #analysis #scoping

#data #communication #slack

data Beginner

Write a Slack Update About a Metric Movement Without Hand-Waving

I need to post a Slack update about [metric name] moving [direction and magnitud...

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

#form-design #ux #completion-rate

design Intermediate

Design: Audit a Form for Friction That's Costing You Completions

Audit this form and find the friction that's costing me completions. Look for: (...

#empty-states #ux-writing #onboarding

design Beginner

Design: Write Empty-State Copy That Teaches Instead of Apologizes

Write empty-state copy for [feature] that does three things: (1) tells the user ...

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

#excel #charts #visualization

excel Beginner

Excel: Pick the Right Chart for the Story You're Trying to Tell

I have data and a point I want to make, but I don't know which chart conveys it ...

#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 #statistics #ab-testing

Data: Decide Whether a Difference in Two Numbers Is Real or Noise

I have two numbers (a metric this period vs last period) and a stakeholder askin...

#data #dashboards #metrics

data Beginner

Data: Cut a Dashboard Down to the 5 Metrics Anyone Actually Uses

I have a dashboard that's grown to 30 charts and nobody knows where to look. Aud...

#marketing #funnel #conversion-rate

marketing Intermediate

Marketing: Find the One Funnel Step That's Quietly Killing Conversions

I have funnel data and a conversion rate that should be higher. Find the leak. O...

#data #visualization #charts

Data: Choose the Right Chart for the Question I'm Trying to Answer

I have a dataset and a question I want to answer. Don't just suggest a chart — i...

data Advanced

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

#data #reporting #automation

Data: Build a Weekly Report That Survives Its Author Leaving

Help me design a weekly [TOPIC] report so that if I'm out — or quit — it still g...

#data #database-design #schema

data Advanced

Data: Design a Schema That Won't Need a Migration in 6 Months

I'm designing a schema for [DOMAIN] from scratch. The team wants to ship fast, b...

#excel #formulas #running-total

Build a Running Total in Excel That Resets Every Month Without a Pivot Table

I'm working in Excel with a table that has a Date column and an Amount column. I...

#excel #data-cleaning #names

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

I have an Excel sheet with about 4,000 customer records. The Name column is a di...

#email #vendor-management #offboarding

email Intermediate

Tell a Vendor You're Leaving Without Burning the Bridge

I need to email a vendor we've used for three years to tell them we're moving to...