Search: "data-dictionary"

#pivot-table #yoy #analysis

Pivot Table Refactor for Year-over-Year Analysis

Act as a financial analyst. Help me build a pivot table from [DATA RANGE] (colum...

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

design Intermediate

ChatGPT Prompt: Empty State Copy and Design Direction for First-Time Users

You are a product designer with content design experience. Design the empty stat...

#design #ux #empty-state

#privacy-policy #gdpr #ccpa

legal Advanced

Privacy Policy Section Drafting Prompt

Act as a data protection lawyer. Draft the privacy policy section for [COMPANY],...

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

#press-release #pr #launch

writing Beginner

Press Release Writer for Product Launch

Act as a PR writer. Write a press release for the launch of [PRODUCT] from [COMP...

#data-quality #audit #validation

data Intermediate

Data Quality Audit Framework for New Source

Act as a data quality lead. I am onboarding a new data source: [SOURCE NAME], fo...

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

#excel #pivot-table #calculated-field

ChatGPT Prompt: Excel Pivot Table Calculated Field for Custom Metrics

You are an Excel pivot table expert. Help me add a calculated field to my pivot ...

#excel #data-validation #dropdown

ChatGPT Prompt: Excel Data Validation Drop-Down with Dependent Lists

You are an Excel expert. Build me a cascading drop-down where the second list de...

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

data Intermediate

ChatGPT Prompt: Exploratory Data Analysis Plan for a New Dataset

You are a senior data analyst. Walk me through a systematic EDA plan for a datas...

#data #eda #analysis

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

#cohort analysis #retention #sql

data Advanced

ChatGPT Prompt: Cohort Retention Analysis SQL with Visualization Plan

Write SQL for a cohort retention analysis and explain how to visualize it. Cont...

#terms-of-service #risk #review

legal Advanced

Terms of Service Risk Review Checklist

Act as a SaaS commercial lawyer. Review the following Terms of Service [PASTE TO...

#sql #optimization #performance

data Advanced

SQL Query Optimizer with Explain-Plan Reading

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

#ab-test #power-analysis #experimentation

data Advanced

A/B Test Power Analysis Pre-Launch Check

Act as an experimentation statistician. Before launching an A/B test on [METRIC]...

#data #sql #window-functions

data Intermediate

ChatGPT Prompt: SQL Window Function Tutorial With Practical Examples

You are a SQL teacher. Walk me through window functions using realistic examples...

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

#net worth #personal finance #financial tracking

finance Beginner

ChatGPT Prompt: Personal Net Worth Statement Builder with Trend Analysis

Help me build a personal net worth statement and track changes over time. Here's...

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

#customer persona #user research #marketing strategy

marketing Intermediate

ChatGPT Prompt: Customer Persona Development from User Interview Notes

Synthesize user interview transcripts into actionable customer personas. Here ar...

#power query #excel #web scraping

excel Advanced

ChatGPT Prompt: Excel Power Query M Code for Web Data Scraping

Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...