Search: "data monitoring"

#design #empty-state #ux-writing

design Intermediate

Empty State Copy and Illustration Brief

For the feature described, design the empty state. Provide: 1-line headline that...

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

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

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

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

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

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

#slo #data-quality #pipelines

data Advanced

Design a Data Quality SLO Framework for a Critical Pipeline

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

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

#excel #dates #data cleaning

Turn a messy date column into clean, consistent dates in Excel

I have an Excel column of dates entered in mixed formats (some text, some real d...

#excel #sumifs #debugging

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

#code review #pull request #quality assurance

coding Intermediate

Code Review Checklist for Pull Request Quality Assurance

Create a comprehensive code review checklist for [programming language/framework...

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

data Intermediate

Build a Pandas Data Quality Report for a Raw CSV Drop

Write a Python script using pandas that takes a CSV path and produces a one-page...

#data #pandas #python

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

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

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

#empty-states #ux-writing #onboarding

design Beginner

Design: Write Empty-State Copy That Teaches Instead of Apologizes

Write empty-state copy for [feature] that does three things: (1) tells the user ...

#excel #charts #data-visualization

excel Beginner

Excel: Pick a Chart That Doesn't Need a Caption to Be Understood

I want to show [DESCRIBE COMPARISON OR TREND] to [AUDIENCE]. Tell me the right c...

#data #analysis #statistics

data Advanced

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

#coding #architecture #microservices

coding Advanced

Coding: Decide Whether to Split a Service Before It Hurts

Our [MONOLITH/SERVICE] is growing and the team is debating splitting it: [SYMPTO...