Search: "data combine"

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

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

#coding #architecture #microservices

coding Advanced

Decide whether this new feature belongs in our existing service or its own

We're about to build a new feature. Someone on the team wants to put it in our e...

Write a query that survives the source table being renamed in six months

I need to write a SQL query that pulls weekly metrics for a dashboard. The sourc...

#sql #data #query

#data #reporting #dashboard

Turn a daily metrics email no one reads into one a busy exec will open

We send a daily metrics email to the leadership team. Nobody opens it. I want to...

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

Automate Variance-to-Budget Reporting in Excel with LET and LAMBDA

You are an FP&A automation specialist. I have a monthly actuals sheet and a budg...

#lambda #let #variance

#analytics #debugging #metrics

Diagnose Why a Dashboard Metric Suddenly Changed

You are a senior data analyst. Walk me through a structured investigation for: [...

#sql #analytics #business-questions

Translate a Business Question into a Defensible SQL Query

You are an analytics engineer. I will paste a fuzzy business question (e.g., 'ho...

legal Advanced

Build a Privacy Policy Checklist for a New Consumer App

You are a privacy counsel specializing in consumer apps. Build me a checklist fo...

#privacy #gdpr #ccpa

#excel #sensitivity-analysis #data-table

Build a sensitivity table that stress-tests three assumptions at once

Act as a financial modeling instructor. Walk me through building a two-input dat...

#data #machine-learning #churn

data Advanced

Build a churn model whose features the business actually understands

Act as an applied ML practitioner. Build a churn prediction model for [PRODUCT] ...

#data #warehouse #cost-optimization

data Advanced

Reduce data pipeline cost without losing freshness or completeness

You are a data platform engineer. Our [WAREHOUSE] bill is up 60% YoY while data ...

legal Advanced

Write a privacy notice that meets GDPR and CCPA without being unreadable

You are a privacy program lead. Draft a privacy notice for [PRODUCT] that satisf...

#legal #privacy #gdpr

#excel #power-query #reconciliation

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

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 #working-capital #finance-model

excel advanced

Build a working capital model from a P&L extract without manual joins

Act as a finance analyst. I will paste a monthly P&L extract plus a trial-balanc...

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

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

#analysis #metrics #stakeholders

Translate a stakeholder question into something a dataset can answer

Act as an analytics translator. A stakeholder asked me a fuzzy question like "ar...