Search: "data analysis"

#finance #cash flow #forecast

finance Advanced

Cash Flow Forecast Model Build with Scenario Analysis

Act as an FP&A lead. Walk me through building a 13-week cash flow forecast for a...

#business #pre-mortem #risk

business Intermediate

Pre-Mortem Analysis for a Major Project Before Kickoff

Run a pre-mortem on this project I'm about to greenlight. Imagine it's 12 months...

#coding #test-data #fixtures

coding Intermediate

Generate Realistic Test Fixtures from a Schema

I'll paste a database schema. Generate realistic test fixtures: 10-20 rows per t...

Define KPIs for a Product Without Falling Into Vanity Metrics

Act as a product analyst. I'll describe a product. Help me define 5-7 KPIs that ...

#data #kpis #metrics

#duplicates #data cleaning #excel

excel Intermediate

Excel Formula to Detect Duplicate Records Across Columns

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

#stakeholder #project management #analysis

business Intermediate

Stakeholder Analysis Matrix for Cross-Functional Project

Create a stakeholder analysis matrix for the project: [PROJECT NAME]. Project go...

Build a Python Pandas Pipeline for Data Cleaning

Write a reusable Python pandas pipeline that cleans a CSV with columns [COLUMN_L...

#data #python #pandas

#data #visualization #honesty

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

#legal #policy #ai-governance

legal Intermediate

Write an internal AI usage policy that doesn't ban anything useful

We need an internal AI usage policy. The default version — 'don't paste customer...

excel Advanced

Auto-Format New Data VBA

Write a VBA macro that automatically formats any new data pasted into an Excel s...

#excel #VBA #macro

#Google Analytics #GA4 #website analytics

Google Analytics Report Summary

Help me analyze and summarize my Google Analytics data for a stakeholder report....

#A/B testing #sample size #statistical significance

A/B Test Sample Size Calculator and Analysis

Help me plan and analyze an A/B test: **Planning Phase:** - Current conversion ...

#excel #shift schedule #data validation

excel Advanced

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for ...

#business #churn analysis #customer retention

business Advanced

Customer Churn Root Cause Analysis Framework

Act as a business strategy consultant. Help me build a customer churn root cause...

#excel #xlookup #index match

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#cohort retention analysis #subscription churn #sql retention

data Advanced

ChatGPT prompt for cohort retention analysis from subscription data

You are a product data analyst. I need help analyzing subscription retention by ...

#conversion rate drop analysis #marketing analytics prompt #funnel diagnosis

data Advanced

ChatGPT prompt for diagnosing a sudden drop in conversion rate from mixed-source metrics

Act as a data analyst investigating a sudden conversion-rate drop. I need a stru...

#data #survey analysis #qualitative research

ChatGPT Prompt for Survey Open-Text Response Coding Framework

Analyze these open-text survey responses and build a coding framework I can reus...

#tutoring #error analysis #guided questions

education Intermediate

ChatGPT Prompt for Explaining a Mistake Without Giving Away the Answer

Help me tutor a student by explaining their mistake clearly without immediately ...

#campaign #brief #strategy

Marketing Intermediate

Marketing Campaign Brief Generator

Act as a senior marketing strategist. I need a complete campaign brief for [PROD...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...

Excel Beginner

Budget Tracker Spreadsheet

Create a budget tracker Excel structure with: income categories, expense categor...

#Excel #budget #finance

#python #web scraping #beautifulsoup

coding Intermediate

ChatGPT prompt for building a Python web scraper with error handling and rate limiting

Act as a senior Python developer specializing in web scraping and data collectio...