Search: "data tables"

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

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

#data #data-quality #monitoring

Data Quality Monitoring Rules for a Production Table

I need to monitor data quality on a production table loaded daily from upstream ...

#data #quality #validation

Write a Data Quality Checklist for a New Pipeline

Act as a data reliability engineer. I'm shipping a new pipeline that loads {{sou...

#terms of service #saas #legal

legal Advanced

Terms of Service Outline for SaaS Product

Outline a Terms of Service agreement for a B2B SaaS product. Product: [DESCRIPTI...

#data #communication #forecasting

Explain a Forecasting Model to Non-Technical Stakeholders

I built a [MODEL_TYPE] forecasting model with MAPE [MAPE_VALUE]. Write a 1-page ...

#excel #power query #survey

Convert a Messy Survey Export Into Clean Long-Format Data

I exported a survey to Excel. Each respondent is one row, each question is its o...

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

#data #statistics #ab-testing

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

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

#excel #pivot tables #reporting

Turn a messy operational export into a pivot table that someone will actually read

I have an operational export with [N] rows and columns like [DATE, REGION, PRODU...

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