Search: "data modeling"

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

#UX design #design brief #product redesign

design Intermediate

UI/UX Design Brief Template for Product Redesign Projects

Create a comprehensive UI/UX design brief for redesigning [product/feature, e.g....

#persona #segmentation #survey

marketing Intermediate

Customer Persona Builder from Survey Data

Act as a senior marketing strategist. I will paste raw responses from a customer...

customer-service Intermediate

Refund Decision Matrix for Support Agents

Act as a head of customer support. Build a decision matrix for refund requests a...

#refund #policy #support

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

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

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

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

#data #warehouse #star schema

data Advanced

Data Warehouse Star Schema Design for Analytics Workloads

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

#email #nurture-sequence #sales

email Intermediate

Email Sequence to Nurture an Inbound Lead Who Went Cold After a Demo

Build a 4-email nurture sequence for an inbound SaaS lead who attended a demo, s...

#finance #financial-model #saas

finance Advanced

Three-Statement Financial Model for a Bootstrap SaaS Startup

Build a 36-month, monthly three-statement financial model (P&L, cash flow, balan...

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

#sql #cohort analysis #retention

data Advanced

SQL Query to Find User Cohort Retention by Month

Write a SQL query to compute monthly cohort retention. Tables: - users(id, signu...

#data #analytics #investigation

data Advanced

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

data Intermediate

Data: Pick the Right Chart for Data That Has No Good Chart

I'm trying to visualize [DESCRIBE DATA — many dimensions, sparse, unequal catego...

#data validation #dropdown lists #dependent dropdowns

Excel Data Validation and Dropdown Lists

Teach me how to create advanced data validation and dependent dropdown lists in ...

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

#sql migration prompt #rollback safe deployment #database schema change

coding Advanced

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

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

#legal #nda #non-disclosure

legal Advanced

ChatGPT prompt for creating a non-disclosure agreement template for business partnerships

Act as a business attorney experienced in commercial agreements and intellectual...

#legal #privacy policy #gdpr

legal Advanced

ChatGPT prompt for writing a privacy policy compliant with GDPR and CCPA

Act as a privacy law specialist familiar with GDPR, CCPA, and general data prote...

#writing #linkedin #thought-leadership

writing intermediate

LinkedIn Thought Leadership Article

Write a LinkedIn article that establishes me as a thought leader in [my industry...