Search: "data-pipeline"

excel Beginner

ChatGPT Prompt: Excel SUMIFS Formula Builder for Multi-Condition Aggregation

You are an Excel formula expert. I need to build a SUMIFS formula that totals va...

#excel #sumifs #formulas

#essay writing #long-form writing #argument structure

writing Advanced

ChatGPT Prompt: Long-Form Essay Outline with Research-Backed Argument Structure

Outline a 3000-5000 word essay arguing [THESIS STATEMENT] for [PUBLICATION/AUDIE...

#ab testing #statistics #hypothesis testing

ChatGPT Prompt: Statistical Hypothesis Testing for Product Experiments

Help me design a hypothesis test for a product experiment. Context: - Hypothesi...

#gdpr #data protection #privacy law

legal Advanced

ChatGPT Prompt: GDPR Data Processing Agreement Section-by-Section Builder

Help me draft or review a GDPR-compliant Data Processing Agreement (DPA). Conte...

#excel #pivot table #sales analysis

Pivot Table Mastery for Multi-Year Sales Data Analysis

Act as an Excel data analyst. I will paste a sales dataset with columns Date, Re...

coding Intermediate

Refactor a Tangled React Component Into Custom Hooks

Refactor the React component below by extracting state and side effects into cus...

#coding #react #hooks

Funnel Analysis Query Diagnosing the Worst Drop-Off Step

I have an events table (event_name, user_id, event_time, properties JSON). Write...

#data #funnel #sql

#excel #test-data #random

excel Beginner

Generate Realistic Test Data With Random Functions

I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...

data Intermediate

Design a Minimal Data Model From a Vague Spec

Act as a data architect. From this rough description of what we need to track: {...

#data #schema #modeling

#legal #contracts #negotiation

legal Advanced

Review a Vendor Contract for Hidden Risk

Act as in-house counsel. I'll paste a vendor contract. Flag clauses that need ne...

#pivot table #sales analysis #excel

Build Dynamic Pivot Table from Sales Data

Act as an Excel data analyst. I have a sales dataset with columns: [Date, Region...

#excel #dashboard #slicers

Excel Dashboard with Dynamic Slicers

Help me design a single-page Excel dashboard for KPIs (revenue, orders, conversi...

#data #outliers #cleaning

Identify Outliers Without Throwing Away Real Signal

Help me detect outliers in my dataset and decide what to do with them. Compare m...

#excel #forecasting #revenue

Forecast Monthly Revenue With Excel's FORECAST.ETS

I have 36 months of revenue data (column A: month-end dates, column B: revenue)....

#data #visualization #charts

data Beginner

Choose the Right Chart Type for the Question You're Asking

I have [DATA DESCRIPTION] and I'm trying to answer [QUESTION] for [AUDIENCE]. Wa...

#template #data-validation #conditional-formatting

Build a Reusable Excel Template With Input Validation Built In

Help me design a reusable Excel template for [USE CASE: e.g. expense report, pro...

#data #visualization #charts

data Intermediate

Data: Choose the Right Chart for the Question I'm Trying to Answer

I have a dataset and a question I want to answer. Don't just suggest a chart — i...

#excel #formulas #xlookup

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

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 #power-query #unpivot

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...