Search: "data modeling"

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

#pivot tables #excel #data analysis

excel Intermediate

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

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

excel Advanced

Executive KPI Dashboard Template Build in Excel

Design a one-page executive KPI dashboard in Excel for a [INDUSTRY] company. The...

#excel #dashboard #kpi

#legal #privacy policy #saas

legal Advanced

SaaS Privacy Policy Clause-by-Clause Builder

Act as a privacy lawyer. Help me draft a SaaS privacy policy clause by clause. W...

#marketing #paid search #ppc

marketing Advanced

Paid Search Campaign Brief with Negative Keyword Strategy

Act as a paid search strategist. Build a campaign brief for [BUSINESS] launching...

#data #sql #cohort-analysis

Cohort Retention Analysis SQL Query With Visualization Stub

Write a SQL query that produces a monthly cohort retention table for [SaaS PRODU...

#data #ab-testing #bayesian

A/B Test Results Analysis With Bayesian Probability of Winning

Analyze the A/B test results below using a Bayesian approach. Output: probabilit...

data Intermediate

Pandas Cleanup Pipeline for a Messy Real-World CSV

Below is a sample of a messy CSV (10 rows shown). Build a pandas cleaning pipeli...

#data #pandas #csv

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 Advanced

Build Dynamic Dashboard With Slicers and Pivot Charts

Act as an Excel dashboard designer. I have a dataset of {{describe data: e.g., m...

#excel #dashboard #pivot

#finance #modeling #three-statement

finance Advanced

Build a Three-Statement Model Skeleton From Scratch

Act as an FP&A senior. Sketch the structure of a three-statement model (Income S...

#data #root-cause #analysis

Investigate an Unexpected Drop in a Key Metric

You are a data detective. A key metric dropped 18% week-over-week with no obviou...

#power query #CSV import #data transformation

excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#business #swot analysis #strategy

business Intermediate

ChatGPT prompt for creating a SWOT analysis framework for a new business idea

Act as a business strategy consultant with MBA-level analytical skills. Conduct...

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

#coding #regex #validation

coding intermediate

Regex Patterns for Form Data Validation

Provide production-ready regex patterns for validating the following form fields...

#pandas #EDA #data analysis

data intermediate

Python Pandas Data Analysis Pipeline Exploratory Analysis

Write a Python data analysis script using Pandas for exploratory data analysis (...

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

#tableau #churn #analytics

data intermediate

Tableau Dashboard Design for Customer Churn Analysis

Design a Tableau dashboard to analyze customer churn. Include: 1) Overall churn ...

coding intermediate

Docker Containerization for Python Flask Applications

You are a DevOps engineer specializing in containerization. I need to containeri...

#coding #docker #python

customer-service advanced

Customer Win-Back Campaign Strategy for Churned Users

You are a customer success and retention marketing expert. I need to design a wi...

#customer-service #win-back #retention

#finance #cash-flow #forecast

finance advanced

13-Week Rolling Cash Flow Forecast Model Template

You are a CFO advisor and financial modeling expert. I need to build a 13-week r...

excel intermediate

Excel SUMIF & COUNTIF: Advanced Multi-Criteria Formula Guide

Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...

#excel #sumif #countif