Search: "data monitoring"

#data-quality #dashboard #sanity-check

Sanity Check a Dashboard Number That Looks Too Good to Be True

A number on my dashboard looks too good to be true. Metric: [METRIC NAME]. Repor...

data Advanced

Cohort Retention Analysis from Event Log

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

#data #cohort #retention

#rolling #trend #dynamic-range

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

#charts #visualization #dataviz

Data: Pick the Right Chart Type for the Thing You Actually Want to Say

I have a dataset and I know what I want the audience to take away — but I keep d...

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

#excel #power-query #data-cleaning

Excel: Convert a Messy Paste-from-PDF Table Into a Clean Dataset

I pasted a table from a PDF and Excel split it badly — values are stuck together...

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

#data #reporting #automation

Data: Build a Weekly Report That Survives Its Author Leaving

Help me design a weekly [TOPIC] report so that if I'm out — or quit — it still g...

#excel #data-cleaning #names

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

I have an Excel sheet with about 4,000 customer records. The Name column is a di...

#business #partnerships #due diligence

business Intermediate

Evaluate a partnership pitch that sounds great in the deck but feels off in the gut

A bigger company pitched me a partnership. The deck shows complementary audience...

#data #cleaning #preprocessing

Clean a messy dataset without losing the rows that actually mattered

I have a dataset with [N] rows and [LIST PROBLEMS: missing values, duplicates, m...

#data #analysis #statistics

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

excel Advanced

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

#migration #sql #zero-downtime

coding Advanced

Write a Defensive Migration Script for a NOT NULL Column Addition

Act as a database migration specialist. I need to add a NOT NULL column [column_...

#analytics #debugging #metrics

Diagnose Why a Dashboard Metric Suddenly Changed

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

legal Advanced

Draft a Plain-English MSA Summary for a Non-Lawyer Executive

Act as in-house counsel translating contracts for executives. I will paste a Mas...

#msa #contracts #summary

excel Advanced

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

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

#email #sales #re-engagement

email Intermediate

Re-engage a prospect who ghosted after a great second meeting

Act as an enterprise sales coach. Write a re-engagement email to [CONTACT] at [C...

#coding #architecture #microservices

coding Advanced

Decide whether to extract a service from your monolith yet

Act as a software architect. We have a [LANGUAGE]/[FRAMEWORK] monolith and a tea...

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

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