Search: "data-warehouse"

#excel #pivot-table #data-cleanup

excel Intermediate

Find the rows that broke a pivot table without scrolling 40,000 rows

My pivot table is showing #N/A or a mysterious 'blank' row, and the source data ...

#excel #automation #power-query

excel Advanced

Schedule an Excel file refresh without setting up a server

I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....

#data #analysis #statistics

data Intermediate

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

#finance #expenses #budget

finance Intermediate

Find the 3 expense lines that drifted up while no one was watching

I'm reviewing the last 6 months of company expenses. I want to find the 3 line i...

#finance #margin #gross-margin

finance Advanced

Diagnose margin compression that crept in over 4 quarters

Our gross margin dropped 6 points over 4 quarters and no single quarter triggere...

#excel #reconciliation #xlookup

excel Intermediate

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

design Intermediate

Redesign an empty state from punishment to onboarding moment

You are a UX designer. The empty state of [FEATURE] currently shows 'No items ye...

#design #ux #empty-state

#excel #template #validation

excel Advanced

Build a self-checking Excel template that catches user-entered errors before they propagate

I'm building a template that non-technical colleagues will fill in monthly. Past...

#excel #data validation #conditional formatting

excel Beginner

Design a self-updating Excel tracker with data validation

Help me build an Excel tracker (for tasks, inventory, or expenses — I'll tell yo...

#data #analysis #planning

Write the analysis plan before I touch the data

I have a dataset and a business question (I'll describe both). Before I start qu...

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

#data #analysis #insights

data Intermediate

Interpret a Dataset and Surface Insights

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

#data #analysis #data-science

data Intermediate

Find the Story Hidden in My Dataset

You are a data analyst who turns numbers into decisions. I will describe or past...

#data #cohort analysis #retention

Design a Cohort Retention Analysis from Raw Event Data

Help me design a cohort retention analysis. My raw data: an events table with us...

#data #bias #machine learning

Audit a Dataset for Bias Before You Train On It

Help me audit [DATASET DESCRIPTION] for bias before I train on it for [TASK]. Co...

productivity Intermediate

Run a Personal Quarterly Review That Changes Next Quarter

Walk me through a personal quarterly review that actually changes how I spend th...

#productivity #reviews #planning

#excel #comparison #vlookup

excel Intermediate

Compare Two Excel Sheets and Highlight Real Differences

I need to compare two Excel sheets that should match but probably don't. Sheet A...

#marketing #cac #attribution

marketing Advanced

Spot Which Channel Is Quietly Eating Your CAC and Lying About It

My overall CAC has crept up over the last [period]. Here's the channel mix: [lis...

coding Advanced

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database

Cohort Retention Analysis from Event Log

From the event log table with columns user_id, event_name, occurred_at, build a ...

#data #cohort #retention

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