Search: "data cleaning"

#finance #cashflow #forecasting

finance Intermediate

Forecast cashflow for a business with lumpy revenue and predictable costs

I run a business with predictable costs but lumpy revenue — some months are 3x o...

#excel #charts #visualization

excel Beginner

Pick the chart that tells the story instead of the chart that's easy to make

I have a dataset and I'm about to default to a bar chart because that's what Exc...

#data #cleaning #preprocessing

Clean a messy dataset without losing the rows that actually mattered

I have a dataset with [N] rows and [LIST PROBLEMS: missing values, duplicates, m...

#business #growth #funnel-analysis

business Advanced

Audit my growth funnel for the leak that's actually costing the most

My team has a list of 'growth ideas' a mile long, but I suspect we're working on...

#finance #forecasting #revenue

finance Advanced

Forecast revenue when sales cycles are long and the data is thin

I'm forecasting revenue for the next 6 months. Our sales cycle is 4-8 months. We...

#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

#experimentation #ab-testing #significance

data Advanced

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

#visualization #charts #communication

data Beginner

Decide which chart actually fits the point you are making

Act as a data visualization expert. I will tell you the comparison or trend I wa...

#excel #data cleaning #power query

excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#legal #privacy policy #compliance

legal intermediate

Write a Privacy Policy for a Website

Act as a privacy compliance assistant. Draft a clear privacy policy for a [type ...

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

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

#data #charts #visualization

Choose the chart that fits my data and my question

I'll tell you what data I have and the question I'm trying to answer with it. Re...

#data #visualization #charts

data Beginner

Choose the Right Chart for Your Data

You are an expert data visualization specialist. Help me pick the best chart typ...

#data #analysis #insights

Interpret a Dataset and Surface Insights

You are a data analyst. I'll paste a summary table or describe a dataset: [PASTE...

#excel #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...

#contract-review #vendor-contract #redline

legal Advanced

Spot the 5 Riskiest Clauses in a Vendor Contract Before Sending to Counsel

Pre-screen a vendor contract before I send it to legal. Contract: [PASTE OR DESC...

#data #definitions #quality

Spot a Data Definition Disagreement Before It Burns You

Two teams at my company are reporting different numbers for [metric name]. Team ...

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