Search: "data combine"

#excel #fuzzy-match #deduplication

excel Advanced

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

Spot the leak in a funnel that drops 60% between two healthy steps

I have a 5-step funnel. Step 1→2 is healthy (95%), step 3→4 is healthy (88%), bu...

#data #analytics #funnel

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

#finance #margin #gross-margin

finance Advanced

Diagnose margin compression that crept in over 4 quarters

Our gross margin dropped 6 points over 4 quarters and no single quarter triggere...

#excel #reconciliation #xlookup

excel Intermediate

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

#email #salary-negotiation #offer

email Advanced

Counter a salary offer that is 15% below your number without burning the relationship

You are a compensation negotiation coach. Draft an email reply to a recruiter wh...

#email #sales #re-engagement

email Intermediate

Re-engage a prospect who ghosted after a great second meeting

Act as an enterprise sales coach. Write a re-engagement email to [CONTACT] at [C...

#coding #architecture #microservices

coding Advanced

Decide whether to extract a service from your monolith yet

Act as a software architect. We have a [LANGUAGE]/[FRAMEWORK] monolith and a tea...

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

design Intermediate

Redesign an empty state from punishment to onboarding moment

You are a UX designer. The empty state of [FEATURE] currently shows 'No items ye...

#design #ux #empty-state

#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

#data #documentation #metrics

data intermediate

Write a metric definitions document that survives one analyst quitting

Act as a head of data preparing for an analyst's last day. I want the metric def...

#dashboards #review #leadership

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

#excel #data validation #conditional formatting

excel Beginner

Design a self-updating Excel tracker with data validation

Help me build an Excel tracker (for tasks, inventory, or expenses — I'll tell yo...

#excel #pivot table #data cleaning

excel Intermediate

Turn a flat sales export into a pivot-ready table

I have a raw sales export with merged headers, blank rows, and totals mixed into...

#coding #debugging #learning

coding Beginner

Explain Unfamiliar Code Line by Line

You are a patient senior engineer mentoring a junior developer. I will paste a b...

Write a SQL Query from a Plain-English Question

You are a SQL expert and data analyst. I will describe a question in plain Engli...

#data #sql #query

#coding #refactoring #clean code

coding Advanced

Refactor a 400-Line Function Into Cohesive Smaller Pieces

I'll paste a 400-line function that does too much. Help me refactor it. Walk thr...

#data #bias #machine learning

Audit a Dataset for Bias Before You Train On It

Help me audit [DATASET DESCRIPTION] for bias before I train on it for [TASK]. Co...

productivity Intermediate

Run a Personal Quarterly Review That Changes Next Quarter

Walk me through a personal quarterly review that actually changes how I spend th...

#productivity #reviews #planning

#power-query #csv #data-cleaning

excel Intermediate

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-quality #dashboard #sanity-check

Sanity Check a Dashboard Number That Looks Too Good to Be True

A number on my dashboard looks too good to be true. Metric: [METRIC NAME]. Repor...