Search: "data entry"

#data #cohort analysis #retention

Design a Cohort Retention Analysis from Raw Event Data

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

excel Advanced

Audit a Workbook for Broken Formulas and Hidden Dependencies

I inherited a 30-sheet Excel workbook and it gives slightly wrong totals. Walk m...

#excel #audit #formulas

#business #growth #diagnosis

business Advanced

Diagnose Why a Healthy Business Suddenly Stopped Growing

Walk me through how to diagnose why my business — profitable, retention-strong —...

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

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

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

A/B Test Sample Size and Duration Calculator

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

#rolling #trend #dynamic-range

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

#charts #visualization #dataviz

data Intermediate

Data: Pick the Right Chart Type for the Thing You Actually Want to Say

I have a dataset and I know what I want the audience to take away — but I keep d...

#form-design #ux #completion-rate

design Intermediate

Design: Audit a Form for Friction That's Costing You Completions

Audit this form and find the friction that's costing me completions. Look for: (...

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

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

#excel #power-query #data-cleanup

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

#writing #journalism #openings

writing Intermediate

Writing: Write the Lede That Earns the Rest of the Article

My draft article: [PASTE OR SUMMARIZE]. The current opening is fine — meaning no...

#data #database-design #schema

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

#excel #data-cleaning #names

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

Write a Cohort Retention Query That Doesn't Secretly Double-Count Users

I need a SQL cohort retention query that groups users by their signup week and s...

#data #sql #cohort

#excel #data cleaning #dates

Clean up a sheet where dates are stored in five different formats

I inherited a spreadsheet where the 'Date' column has dates entered as '3/5/26',...

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

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

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

data Intermediate

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