Search: "data analysis"

#sensitivity #what-if #modeling

excel Advanced

Excel: Two-Way Sensitivity Table Without the Data Table Feature

Excel's built-in Data Table feature recalculates the whole workbook and freezes ...

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

#data #analysis #statistics

data Advanced

Data: Stop a Stakeholder From Acting on a Spurious Correlation

A [ROLE] just sent me [CHART/CLAIM] showing [X correlates with Y] and they're ab...

#business #operations #customer-management

business Intermediate

Business: Fire a Customer Who's Costing More Than They Pay

We have a customer [DESCRIBE: revenue, support load, custom requests, behavior]....

#coding #debugging #production

coding Advanced

Coding: Debug a Heisenbug That Only Shows Up in Production

I have a bug that reproduces in prod but not in any other environment: [SYMPTOM,...

#excel #formulas #xlookup

excel Intermediate

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#anomaly detection #metrics #WAU

Decide if a weekly metric drop is signal or noise

Our weekly active users dropped 8% week-over-week. Before I escalate, help me de...

#business #management #performance

business Advanced

Diagnose why a high-performing team suddenly missed quarterly targets

A team that hit target 6 quarters in a row just missed by 30%. Help me diagnose ...

#excel #power-query #unpivot

excel Intermediate

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#react #performance #virtualization

coding advanced

React Performance Optimization Techniques for Large Lists

Optimize a React application that renders a large list of [data type, e.g., 10,0...

#legal #terms-of-service #saas

legal advanced

Terms of Service Template for SaaS Platform User Agreements

Act as a technology attorney advisor specializing in SaaS agreements. Help me dr...

#budget tracker #personal finance #Excel template

excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

#finance #budget #personal-finance

finance beginner

Personal Budget Planner and Financial Health Analyzer

Create a personalized budget plan and financial health analysis. My situation: ...

#mortgage refinance #break-even analysis #home loan

finance Intermediate

ChatGPT Prompt: Mortgage Refinance Break-Even Analysis Calculator

Analyze whether I should refinance my mortgage based on these details: Current ...

hr Advanced

Diversity Hiring Funnel Audit with Bias Checkpoints

You are a DEI hiring expert. Audit a hiring funnel and propose interventions. I...

#hr #diversity #hiring

#business #swot #strategy

business Intermediate

Build a Lean SWOT Analysis Tied to Concrete Actions

Act as a strategy consultant. Build a SWOT analysis for {{company / product / te...

#data cleaning #addresses #standardization

Clean and Standardize Messy Customer Address Data

I have a messy customer address dataset (~500K rows, CSV). Issues observed: inco...

#difficult conversation #performance #management

hr Advanced

Difficult Conversation Script for Performance Improvement

Help me prepare a difficult conversation with a direct report whose performance ...

#terms of service #saas #legal

legal Advanced

Terms of Service Outline for SaaS Product

Outline a Terms of Service agreement for a B2B SaaS product. Product: [DESCRIPTI...

writing Advanced

Outline a Long-Form Essay With Argument Mapping

Help me outline a long-form essay (2000-3000 words) on [topic]. Use argument map...

#writing #essay #outline

data Advanced

Run a Power Analysis Before an A/B Test

Help me calculate the required sample size for an A/B test. Walk me through: def...

#data #ab-test #power

Spot-Check a Dataset for Quality Issues Before Modeling

I'm about to train a model on this dataset: [DESCRIBE COLUMNS, ROW COUNT, SOURCE...

#data #data quality #EDA

#data #SQL #funnel analysis

Write a SQL Query to Find Users Stuck Mid-Funnel

Write a SQL query that finds users stuck mid-funnel for re-engagement. Schema: e...