Search: "power analysis"

#data #communication #slack

data Beginner

Write a Slack Update About a Metric Movement Without Hand-Waving

I need to post a Slack update about [metric name] moving [direction and magnitud...

#excel #variance-analysis #budget

Excel Variance Analysis Budget vs Actual

Build an Excel variance analysis report comparing Budget vs Actual for revenue a...

#excel #data-cleaning #power-query

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#data #statistics #ab-testing

data Intermediate

Data: Decide Whether a Difference in Two Numbers Is Real or Noise

I have two numbers (a metric this period vs last period) and a stakeholder askin...

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

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

marketing Intermediate

Plan SEO Content Around a Keyword

You are an expert SEO content strategist. Help me plan content that can actually...

#marketing #seo #content

#creative #writing #fantasy

creative advanced

Fantasy World-Building for Creative Writing

Help me build a detailed fantasy world for a [novel / short story / game / scree...

excel Advanced

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#finance #runway #burn rate

finance Intermediate

Build a Runway Calculator With Burn Sensitivity

Help me build a runway calculator with sensitivity analysis. Inputs: current cas...

data Intermediate

Decide If This Data Is Worth Analyzing Before You Spend a Week On It

Before I dig into [dataset and analysis question], help me decide if it's worth ...

#data #analysis #scoping

#excel #power-query #data-cleaning

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

#excel #power-query #vlookup

excel Advanced

Excel: Replace a Fragile VLOOKUP Chain With Power Query

I have a workbook stitched together by [N] VLOOKUPs across [M] sheets, and it br...

#creative #character #antagonist

creative Advanced

Creative: Make This Villain More Than 'Wants Power Because Evil'

Here's my antagonist: [PASTE BRIEF]. Right now their motivation is basically 'wa...

#excel #power query #decision

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

#data #analysis #incident

Investigate a sudden 20% drop in a metric before the CEO asks at 9am

It's 7am. A key business metric dropped 20% yesterday. The CEO will ask at 9am. ...

#data #storytelling #presentation

data Intermediate

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

#excel #vlookup #reconciliation

Reconcile two lists that should match but somehow never do

You are an Excel power user. I have two lists in Excel that are *supposed* to be...

#excel #pivot-table #data-cleanup

Find the rows that broke a pivot table without scrolling 40,000 rows

My pivot table is showing #N/A or a mysterious 'blank' row, and the source data ...

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

#data #ab-testing #experimentation

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