Search: "data-questions"

#metrics #variance #signal-vs-noise

Data: Spot When a Metric Movement Is Just Noise

My weekly metric moved 12% — is that signal or noise? Help me decide without doi...

#contracts #vendor #review

legal Intermediate

Legal: Spot the Risky Clauses in a Vendor Contract Before Signing

Read this vendor contract and flag the clauses that would matter in a bad scenar...

#coding #debugging #production

coding Intermediate

Coding: Trace a Bug That Only Reproduces in Production

I have a bug that won't reproduce locally but appears in production. Help me hun...

#excel #power-query #data-cleaning

excel Intermediate

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

#data #analysis #debugging

Data: Investigate a Metric That Suddenly Moved Without Obvious Cause

A metric jumped (or dropped) and nobody knows why. Give me a structured investig...

Data: Write a SQL Query for a Cohort Retention Table

I want a SQL query that returns a cohort retention table — rows = signup month, ...

#data #sql #retention

legal Advanced

Legal: Write a Privacy Policy Section for a New Data Collection Practice

We're starting to collect [type of data] for [purpose] and we need to update our...

#legal #privacy #gdpr

#legal #compliance #data-policy

legal Intermediate

Write an Internal Data Handling Policy That Employees Will Actually Follow

I need to write an internal data handling policy for a small company. The usual ...

#excel #power query #decision

excel Intermediate

Decide when to use Power Query vs formulas vs a real database

I keep solving the same data problem three different ways across my team's sprea...

Write a SQL query to find customers who used to engage but have quietly dropped off

I want to find 'silently churning' customers — users who used to be active and h...

#data #sql #churn

#finance #cashflow #forecasting

finance Intermediate

Forecast cashflow for a business with lumpy revenue and predictable costs

I run a business with predictable costs but lumpy revenue — some months are 3x o...

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

Investigate a metric that suddenly moved

A metric I track moved unexpectedly. The metric is [METRIC]. It usually sits aro...

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

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

#dates #data cleaning #DATEVALUE

excel Intermediate

Detect mixed date formats in one column and pick the safest fix

Act as a spreadsheet auditor. I will paste 20 cells from a date column that came...

#cohort #retention #heatmap

excel Advanced

Build a Cohort Retention Heatmap Workbook in Excel

Act as a senior analytics engineer. I will paste a list of user signup events wi...

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

#slo #data-quality #pipelines

Design a Data Quality SLO Framework for a Critical Pipeline

Act as a data reliability engineer. Help me design a data quality SLO framework ...

#analytics #debugging #metrics

Diagnose Why a Dashboard Metric Suddenly Changed

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

Build a SQL Style Guide That Survives a Growing Team

Act as a data platform tech lead. Write me a SQL style guide tailored to a 10-pe...

#sql #style-guide #dbt