Search: "data analysis"

#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 #storytelling #presentation

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

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

#business #competitive analysis #positioning

business Intermediate

Compare yourself to a competitor without flattering yourself

Compare my company [MY COMPANY + ONE-LINE DESCRIPTION] to [COMPETITOR]. Do this ...

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

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

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

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

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

#slo #data-quality #pipelines

data Advanced

Design a Data Quality SLO Framework for a Critical Pipeline

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

#win-loss #product-marketing #sales

marketing Advanced

Run a Win/Loss Analysis That Actually Changes Sales Behavior

Act as a product marketing leader. Design a win/loss analysis program that actua...

#commission #sales #formulas

excel Intermediate

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

Spot the leak in a funnel that drops 60% between two healthy steps

I have a 5-step funnel. Step 1→2 is healthy (95%), step 3→4 is healthy (88%), bu...

#data #analytics #funnel

#data #ab-testing #experimentation

data Advanced

Choose between A/B test variants when results are statistically tied

My A/B test ran for 3 weeks. Variant B is +0.4% on the primary metric, not stati...

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

#data #experimentation #ab-testing

data Advanced

Diagnose an A/B test that shows a 4% lift on a metric that should be flat

You are an experimentation lead. We ran an A/B test on [CHANGE] and saw a +4% li...

#hr #pay-equity #compensation

hr Advanced

Run a pay equity audit that finds the actual gaps, not the surface ones

Act as a compensation analyst. Run a pay equity audit across [DIMENSION — gender...