Search: "data pipelines"

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

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

#data #storytelling #insights

Turn Raw Numbers into a Clear Data Story

Act as a data storyteller who helps non-technical stakeholders understand number...

Write and Explain a SQL Query

You are an expert SQL expert. Help me write a correct SQL query and understand e...

#data #sql #query

#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

#data #data-modeling #spreadsheets

Design a Simple Data Model for My Spreadsheet

You are a spreadsheet/data modeling expert. Help me structure my data so it's cl...

#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

👁 3 views

#excel #pivot-tables #analysis

Excel: Rebuild a Pivot That Lies to Stakeholders

Look at this pivot table setup: [PASTE COLUMNS, FILTERS, AND VALUES]. Tell me wh...

👁 3 views