Search: "data cleaning"

#marketing #avatar #persona

marketing Intermediate

Customer Avatar Profile from Limited Data

Build a detailed customer avatar from the limited info provided (product, price ...

#data #analytics #investigation

data Advanced

Data: Find the Real Cause When a Metric Drops 12% Overnight

[METRIC] dropped 12% on [DATE]. The execs want an answer by EOD. Help me investi...

#data #visualization #honesty

Visualize a comparison without inventing a story that isn't there

I want to visualize a comparison between [GROUP A] and [GROUP B] on [METRIC]. Th...

data Advanced

Validate a survey result that contradicts your hypothesis

My survey of 400 users says they want [feature X], but everything else I know (s...

#data #research #survey

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

#difficult conversation #performance #management

hr Advanced

Difficult Conversation Script for Performance Improvement

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

customer-service Intermediate

Refund Request Response with Retention Approach

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

#refund #retention #customer service

#privacy policy #gdpr #ccpa

legal Advanced

Privacy Policy Template Compliant with GDPR and CCPA

Draft a privacy policy template covering both GDPR (EU) and CCPA/CPRA (Californi...

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

#legal #decisions #lawyers

legal Beginner

Diagnose Whether a Document Needs a Lawyer or You Can Self-Serve

Help me decide whether [DOCUMENT OR SITUATION] actually needs a lawyer or whethe...

#data-questions #stakeholder #requirements

Translate a Vague Stakeholder Question Into an Answerable Data Question

Translate a vague stakeholder request into a precise, answerable data question. ...

#data-viz #chart-selection #storytelling

data Beginner

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

Help me pick the right chart for the story I'm trying to tell. Data shape: [ROWS...

#excel #goal-seek #solver

excel Advanced

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#rolling #trend #dynamic-range

excel Intermediate

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

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

#excel #data-cleaning #power-query

excel Intermediate

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

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

#excel #power-query #data-cleanup

excel Intermediate

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

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

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

#business #strategy #product

business Advanced

Decide Whether to Launch a Feature Customers Asked For But Nobody on the Team Believes In

My team has a feature request that 12 customers have explicitly asked for over t...

data Advanced

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

#data #visualization #charts

Pick the Right Chart Type When Stakeholders Keep Asking for Pie Charts of Everything

My stakeholders default to asking for pie charts for every dataset, including on...