Search: "data cleaning"

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

#excel #dashboard #formulas

Build a self-updating sales dashboard using only formulas (no PivotTables)

I want to build a sales dashboard in Excel that updates automatically when I pas...

#email #executive #decline

email Intermediate

Write an email declining a meeting request from a senior exec without burning the relationship

I need to decline a meeting request from a senior executive (two levels above me...

#slo #data-quality #pipelines

Design a Data Quality SLO Framework for a Critical Pipeline

Act as a data reliability engineer. Help me design a data quality SLO framework ...

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

#data #machine-learning #churn

Build a churn model whose features the business actually understands

Act as an applied ML practitioner. Build a churn prediction model for [PRODUCT] ...

#writing #outline #content

writing Intermediate

Create a Detailed Article Outline

You are an expert content strategist. Help me outline a long-form article so the...

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

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

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

customer-service Intermediate

Refund Request Response with Retention Approach

Write a response template for a refund request. Customer context: - Subscription...

#refund #retention #customer service

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

#email #customer #apology

email Intermediate

Reply to a Customer Who Got Wrong Advice From Your Team

Help me write a reply to a customer who was given incorrect advice by someone on...

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 #charts #visualization

excel Beginner

Excel: Pick the Right Chart for the Story You're Trying to Tell

I have data and a point I want to make, but I don't know which chart conveys it ...

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

#excel #formulas #running-total

Build a Running Total in Excel That Resets Every Month Without a Pivot Table

I'm working in Excel with a table that has a Date column and an Amount column. I...

#legal #compliance #data-policy

legal Intermediate

Write an Internal Data Handling Policy That Employees Will Actually Follow

I need to write an internal data handling policy for a small company. The usual ...

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