Search: "data-policy"

#data #analysis #anomaly-detection

data Intermediate

Explain a Confusing Spike in the Data Without Jumping to Conclusions

Our daily signups jumped 340% last Tuesday and have stayed elevated. The marketi...

#data #analysis #incident

data Advanced

Investigate a sudden 20% drop in a metric before the CEO asks at 9am

It's 7am. A key business metric dropped 20% yesterday. The CEO will ask at 9am. ...

#data #storytelling #presentation

data Intermediate

Turn a 6-tab analysis into a 3-slide story for executives

I have a 6-tab analysis with 14 charts. I have 10 minutes with the leadership te...

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

#writing #editing #concision

writing Intermediate

Cut a draft in half without losing the argument

I have a draft that's [N] words and needs to be roughly half that length. The pi...

#coding #debugging #production

coding Advanced

Diagnose a bug that only shows up in production

I have a bug that only happens in production and never reproduces locally. The s...

#excel #formulas #xlookup

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#excel #pivot-table #data-cleanup

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

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

#design #critique #feedback

design Intermediate

Critique a screen mockup without rewriting the designer's solution

I want to critique a screen mockup someone on the team is sharing. I want my fee...

#anomaly detection #metrics #WAU

data Intermediate

Decide if a weekly metric drop is signal or noise

Our weekly active users dropped 8% week-over-week. Before I escalate, help me de...

#power-query #m-language #etl

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

#five-whys #root-cause #management

business Intermediate

Diagnose a Stalled Initiative Using the Five Whys with Evidence

You are a management consultant. I will describe an initiative at my company tha...

#commission #sales #formulas

Build a self-updating commission tracker for a sales team in Excel

Act as a RevOps analyst. Help me design an Excel commission tracker that auto-ca...

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda

#excel #fuzzy-match #deduplication

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

data Advanced

Validate a survey result that contradicts your hypothesis

My survey of 400 users says they want [feature X], but everything else I know (s...

#data #research #survey

#excel #reconciliation #xlookup

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

#email #salary-negotiation #offer

email Advanced

Counter a salary offer that is 15% below your number without burning the relationship

You are a compensation negotiation coach. Draft an email reply to a recruiter wh...

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

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

#coding #flaky-test #debugging

coding Advanced

Debug a flaky test without just retry-marking it and moving on

I have a test that fails ~1 in 20 runs. The test does [what]. The failure shows ...

#excel #pivot table #data cleaning

Turn a flat sales export into a pivot-ready table

I have a raw sales export with merged headers, blank rows, and totals mixed into...