Search: "power analysis"

#excel #power-query #data-cleanup

excel Intermediate

Excel: Clean a Messy Address Column Without Losing Edge Cases

I have a column of free-text addresses scraped from a form: [PASTE 20 SAMPLES]. ...

#data #analysis #anomaly-detection

Explain a Confusing Spike in the Data Without Jumping to Conclusions

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

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

data Advanced

Investigate a metric that suddenly moved

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

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

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

#marketing #growth #activation

marketing Advanced

Find the activation moment that predicts a paying user

You are a growth analyst. We have [N] signed-up users and want to find the singl...

#excel #auditing #debugging

excel intermediate

Trace a broken cell reference across a workbook before fixing it blindly

Act as an Excel auditor. A formula on the summary tab is returning #REF! after a...

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

#data #analysis #insights

Interpret a Dataset and Find Insights

You are an expert data analyst. Help me find the story in a set of numbers I'll ...

#data #analysis #data-science

Find the Story Hidden in My Dataset

You are a data analyst who turns numbers into decisions. I will describe or past...

#SaaS metrics #financial model #unit economics

finance Advanced

Financial Model Template for SaaS Business Unit Economics

Build a financial model framework for a SaaS business covering unit economics an...

#burn rate #runway #startup

finance Advanced

Startup Burn Rate Runway Analysis Investor Reporting Framework

You are a startup CFO. Build a burn rate and runway analysis for [STAGE / FUNDRA...

#data #cohort analysis #retention

data Advanced

Design a Cohort Retention Analysis from Raw Event Data

Help me design a cohort retention analysis. My raw data: an events table with us...

Build a Funnel Analysis That Answers Which Step to Fix First

Help me run a funnel analysis on [PRODUCT FLOW — e.g., signup → activate → retai...

#data #funnel #analytics

#marketing #campaign #analysis

marketing Intermediate

Decide If This Campaign Worked Without Lying to Yourself

I just ran [campaign — channel, offer, audience, dates, spend]. Results: [paste ...

#business #stakeholder-management #project-management

business Intermediate

Stakeholder Map for a Cross-Functional Project

Build a stakeholder map for the following cross-functional project. Categorize e...

coding Advanced

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database

#data #ab-testing #experimentation

data Advanced

A/B Test Sample Size and Duration Calculator

Calculate the required sample size and test duration for an A/B test given: base...

customer-service Advanced

Voice-of-Customer Theme Synthesis from Tickets

Analyze the batch of customer support tickets provided. Synthesize into: top 5 r...

#customer-service #voc #insights

#excel #pivot-tables #analysis

excel Intermediate

Excel: Rebuild a Pivot That Lies to Stakeholders

Look at this pivot table setup: [PASTE COLUMNS, FILTERS, AND VALUES]. Tell me wh...

#finance #accounting #cash-flow

finance Advanced

Finance: Read a Cash Flow Statement and Find the Real Problem

Here's a company's cash flow statement: [PASTE]. The income statement looks fine...

#coding #refactoring #legacy-code

coding Advanced

Coding: Refactor Code I Don't Have Tests For Without Breaking It

I need to refactor [MODULE/FUNCTION] and there are no tests. Yes, I should add t...