Search: "matching data"

#power-query #csv #data-cleaning

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...

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

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

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

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

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

#empty-state #ux #onboarding

design Intermediate

Design an Empty State That Teaches the Product

You are a product designer. Help me design an empty state for [feature] that tea...

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

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

#excel #reconciliation #xlookup

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#data #experimentation #ab-testing

Diagnose an A/B test that shows a 4% lift on a metric that should be flat

You are an experimentation lead. We ran an A/B test on [CHANGE] and saw a +4% li...

legal Advanced

Write a privacy notice that meets GDPR and CCPA without being unreadable

You are a privacy program lead. Draft a privacy notice for [PRODUCT] that satisf...

#legal #privacy #gdpr

#coding #flaky-test #debugging

coding Advanced

Debug a flaky test without just retry-marking it and moving on

I have a test that fails ~1 in 20 runs. The test does [what]. The failure shows ...

Explain a metric movement to a skeptical stakeholder without overclaiming

[Metric] moved [direction + magnitude] in [period]. The first plausible explanat...

#data #metrics #analysis

#excel #dashboard #reporting

excel intermediate

Build a weekly dashboard people actually open without retraining them

Act as a BI designer. I want a one-tab Excel dashboard that a non-analyst team o...

#dashboards #review #leadership

data Intermediate

Stress-test a dashboard before showing it to the leadership team

Act as a data lead reviewing my work before I show it up. I built a dashboard fo...

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

data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization

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

#net worth #personal finance #financial tracking

finance Beginner

ChatGPT Prompt: Personal Net Worth Statement Builder with Trend Analysis

Help me build a personal net worth statement and track changes over time. Here's...