Search: "split data"

#vendor selection #scorecard #procurement

business Intermediate

Vendor Selection Scorecard for Procurement Decisions

Design a vendor selection scorecard for evaluating [type of vendor, e.g., cloud ...

#data quality #audit #pipeline

Data Quality Audit Checklist Pipeline Reliability Framework

You are a data engineer. Audit data quality for [PIPELINE / TABLE]. Run through:...

writing Intermediate

Book Chapter Outline from Rough Notes

Act as a developmental editor. I will paste my rough notes for a chapter on [TOP...

#book #chapter #outline

writing Intermediate

ChatGPT Prompt: Long-Form Blog Post Outline From a Single Idea or Question

You are a content strategist. Turn one rough idea into a structured long-form bl...

#writing #blog #content

#excel formulas #dynamic arrays #dashboard

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

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

#data #ab testing #statistics

A/B Test Power Analysis and Sample Size Calculator Walkthrough

Act as a statistics tutor for product analysts. Walk me through a complete power...

#legal #contracts #vendor

legal Advanced

Vendor Contract Redline Checklist with Risk Tiers

You are an in-house contracts attorney. I will paste a vendor contract. Run it t...

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

#duplicates #data cleaning #excel

Excel Formula to Detect Duplicate Records Across Columns

I need an Excel formula to detect duplicate records based on a combination of mu...

#business model canvas #startup #strategy

business Advanced

Business Model Canvas for Service-Based Startup

Build a complete Business Model Canvas for a [SERVICE TYPE] startup targeting [C...

#data quality #dashboard #monitoring

Build a Data Quality Dashboard Specification

Specify a data quality monitoring dashboard for a data warehouse with [N] tables...

#email marketing #win-back #customer retention

marketing Intermediate

Customer Win-Back Email Sequence

Design a 4-email win-back sequence for churned customers. Context: - Product: [P...

#excel #dashboard #slicers

Excel Dashboard with Dynamic Slicers

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

business Advanced

Write a Crisp Business Memo in the Amazon Style

Help me draft a 6-page narrative memo (Amazon-style) for [topic / proposal]. Str...

#business #memo #amazon

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

#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 #analytics #investigation

Data: Find the Real Cause When a Metric Drops 12% Overnight

[METRIC] dropped 12% on [DATE]. The execs want an answer by EOD. Help me investi...

#data #visualization #honesty

data Intermediate

Visualize a comparison without inventing a story that isn't there

I want to visualize a comparison between [GROUP A] and [GROUP B] on [METRIC]. Th...