Search: "data-pipeline"

#pivot table #sales analysis #monthly report

Excel Pivot Table Report for Monthly Sales Analysis

Design a step-by-step guide for creating an Excel pivot table report to analyze ...

#pitch deck #investor presentation #startup

business Advanced

Startup Pitch Deck Script for Investor Presentations

Write a complete script for a 10-minute investor pitch presentation for [company...

#data cleaning #CSV #pandas

data Intermediate

Data Cleaning Checklist for Messy CSV and Excel Datasets

Create a systematic data cleaning checklist and workflow for a messy dataset in ...

#excel #conditional formatting #dashboard

Excel Conditional Formatting Heatmap Project Status Dashboard

You are an Excel dashboard designer. Build a conditional-formatting heatmap for ...

#sql #optimization #performance

SQL Query Optimizer with Explain-Plan Reading

Act as a database performance engineer. I will paste a slow SQL query and its EX...

ChatGPT Prompt: Excel Macro VBA Generator for Repetitive Data Cleanup Tasks

You are a VBA developer. I want a macro that automates a repetitive cleanup task...

#excel #vba #macro

customer-service Advanced

ChatGPT Prompt: Customer Cancellation Save Conversation Script

You are a customer success lead with strong retention skills. Write a script for...

#customer-service #retention #cancellation

#ux writing #microcopy #error messages

design Intermediate

ChatGPT Prompt: UX Microcopy Guide for Form Errors and Empty States

Generate microcopy for [PRODUCT/FEATURE] covering all common UX scenarios: Prod...

#swot analysis #strategic planning #business strategy

business Intermediate

ChatGPT Prompt: SWOT Analysis with Strategic Action Plan and Owner Assignment

Conduct a strategic SWOT analysis for [COMPANY/DIVISION/PRODUCT] and translate i...

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

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

#excel #power query #m code

excel Advanced

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

#business #competitive analysis #porter

business Advanced

Competitive Teardown Framework Using Porter's Five Forces

You are a strategy MBA professor. Run a Porter's Five Forces analysis for [INDUS...

#data #warehouse #star schema

Data Warehouse Star Schema Design for Analytics Workloads

You are a senior data engineer. Design a star schema for [DOMAIN] analytics. Pr...

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

coding Intermediate

Generate End-to-End Tests for a Login Flow With Playwright

Write Playwright end-to-end tests in TypeScript for a login flow at [URL]. Cover...

#coding #playwright #e2e

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

#hr #compensation #benchmarking

hr Advanced

Compensation Benchmark Memo for a Specific Role and Geography

Write a compensation benchmark memo for [ROLE] in [GEOGRAPHY]. Include: 25th/50t...

legal Advanced

DPA Gap Analysis Against GDPR Article 28 Requirements

Compare this Data Processing Agreement against GDPR Article 28 requirements. Bui...

#legal #gdpr #dpa

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

legal Advanced

Plain-Language Summary of a SaaS Master Services Agreement

Below is a SaaS Master Services Agreement (MSA) sent by a vendor. Produce a plai...

#legal #contracts #msa

#legal #privacy-policy #gdpr

legal Advanced

Privacy Policy Generator for a Small Web App with Analytics and Email

Generate a clear, GDPR + CCPA compliant privacy policy for a small web app. Inpu...

#excel #text-functions #parsing

Convert Messy Text Column Into Clean Structured Fields

I have a single column in Excel containing messy entries like "{{example raw ent...