Search: "data analysis"

#SaaS metrics #financial model #unit economics

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

Startup Burn Rate Runway Analysis Investor Reporting Framework

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

#coding #refactoring #clean code

Refactor a 400-Line Function Into Cohesive Smaller Pieces

I'll paste a 400-line function that does too much. Help me refactor it. Walk thr...

data Intermediate

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

productivity Intermediate

Run a Personal Quarterly Review That Changes Next Quarter

Walk me through a personal quarterly review that actually changes how I spend th...

#productivity #reviews #planning

#data-quality #dashboard #sanity-check

data Intermediate

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

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

#marketing #cac #attribution

marketing Advanced

Spot Which Channel Is Quietly Eating Your CAC and Lying About It

My overall CAC has crept up over the last [period]. Here's the channel mix: [lis...

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

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

Excel: Write a VBA Macro That Emails a Filtered Report to Each Manager

I have a master sheet with sales data tagged by manager. I want a VBA macro that...

#excel #vba #automation

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

#legal #privacy #compliance

legal Advanced

Legal: Decide Whether a New Feature Triggers a Privacy Review

We're shipping [FEATURE DESCRIPTION]. Help me decide whether this needs to go th...

#finance #accounting #cash-flow

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

#coding #architecture #microservices

Coding: Decide Whether to Split a Service Before It Hurts

Our [MONOLITH/SERVICE] is growing and the team is debating splitting it: [SYMPTO...

#data #database-design #schema

data Advanced

Data: Design a Schema That Won't Need a Migration in 6 Months

I'm designing a schema for [DOMAIN] from scratch. The team wants to ship fast, b...

#finance #business #financial-analysis

Finance: Read a P&L and Find What the CEO Doesn't Want to See

Here's the latest P&L: [PASTE OR SUMMARIZE]. The CEO is presenting it in a board...

#excel #data-cleaning #names

excel Intermediate

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

excel Advanced

Build a Weekly KPI Dashboard in Excel That Doesn't Break When Someone Renames a Tab

I'm building a weekly KPI dashboard in Excel for a small operations team. The so...

#excel #dashboard #kpi