Search: "data-analysis"

#excel #power-query #reconciliation

excel Advanced

Reconcile two messy spreadsheets when the join keys don't match

I have two Excel files I need to reconcile, but the join columns aren't clean ma...

#excel #dashboard #reporting

excel intermediate

Build a weekly dashboard people actually open without retraining them

Act as a BI designer. I want a one-tab Excel dashboard that a non-analyst team o...

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

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

data Beginner

Clean a messy CSV that nobody owns and everyone depends on

Act as a data engineer doing cleanup. I have a CSV that gets dropped into a shar...

#cleaning #csv #etl

#forecasting #new-product #zero-history

finance Advanced

Forecast revenue for a new product line with no historical data

You're a finance lead. I need to build a revenue forecast for a new product line...

#excel #dates #data cleaning

Turn a messy date column into clean, consistent dates in Excel

I have an Excel column of dates entered in mixed formats (some text, some real d...

#data #statistics #critical thinking

Spot what's misleading in a statistic before I quote it

I'll paste a statistic, claim, or chart I'm tempted to cite. Play careful analys...

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

#excel #data cleaning #deduplicate

excel Beginner

Clean and Deduplicate a Messy Excel Contact List

Act as an Excel data-cleaning specialist. I have a contact list with inconsisten...

#excel #formulas #xlookup

excel Beginner

Convert a Business Question into an Excel Formula

You are an Excel formula expert. I want to answer this question from my spreadsh...

Clean and Deduplicate a Raw Dataset

Act as a data engineer. I have a raw dataset with these issues: [DESCRIBE — dupl...

#data #cleaning #etl

#excel #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

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

#data #ab-testing #statistics

data Advanced

Interpret the Results of an A/B Test

You are an experimentation analyst. I will give you the numbers from an A/B test...

Data Quality Audit Checklist for New Dataset

Run a data quality audit on the dataset described below. Check for: missing valu...

#data #quality #audit

#excel #data cleaning #dates

Clean up a sheet where dates are stored in five different formats

I inherited a spreadsheet where the 'Date' column has dates entered as '3/5/26',...

#legal #privacy #compliance

legal Intermediate

Figure out which privacy regulations actually apply to a small business

I run a small business. I keep getting told I 'need to be GDPR compliant' and 'C...

excel Advanced

Write a VBA macro that does one boring task perfectly instead of ten things badly

I want to automate a small, repetitive Excel task with VBA. The task is: [DESCRI...

#excel #vba #macro

#legal #privacy #transparency

legal Intermediate

Write a privacy notice users might actually read

Write a user-facing privacy notice for [PRODUCT]. I'll separately have lawyers w...

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

#legal #compliance #privacy

legal Advanced

Figure out if a new data flow needs a privacy review or just a note in the doc

We're about to start collecting [type of data] from [type of user] for [purpose]...