Search: "tables"

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

#education #study #spaced repetition

education Intermediate

Spaced Repetition Study Schedule Generator for Exam Prep

Act as a learning science coach. Build a spaced-repetition study schedule for [E...

#data #documentation #metrics

data Intermediate

Write a Data Definition Doc That Stops 'Wait, How Is This Calculated' Questions

Help me write a data definition doc for [METRIC NAME] that ends ambiguity foreve...

#excel inventory tracker #reorder point #stock management

ChatGPT prompt for Excel inventory reorder tracker with lead times

Act as an Excel operations specialist. I need an inventory reorder tracker for a...

#chatgpt prompt for KPI summary #SaaS metrics #weekly report

data Beginner

ChatGPT Prompt for Building a Weekly SaaS KPI Narrative from Raw Metrics

Act as a data storyteller for a SaaS business. I will paste weekly KPI numbers s...

#excel #pivot-table #sales

excel intermediate

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

#excel #pivot table #sales analysis

excel Beginner

Excel Pivot Table Sales Analysis from Raw Data

Guide me through creating a comprehensive sales analysis using Excel Pivot Table...

#data #power-bi #dashboard

data intermediate

Power BI Dashboard Design: Sales Performance Metrics

Act as a Power BI specialist and data visualization expert. Help me design a sal...

#design #typography #font-pairing

design intermediate

Typography System Design: Font Pairing and Type Scale Guide

Act as a typography expert and brand designer. Help me create a comprehensive ty...

#pivot table #grouping #calculated fields

excel intermediate

Excel Pivot Table: Advanced Grouping and Summarization Techniques

I have a dataset in Excel with the following columns: [list your columns, e.g., ...

#SQL #GROUP BY #window functions

data intermediate

SQL Advanced Queries: GROUP BY, HAVING, and Window Functions

Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...

#data #sql #cohort-analysis

data advanced

Customer Cohort Analysis SQL Query Templates for Retention Insights

Build a complete SQL-based customer cohort analysis system for subscription or e...

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

#pivot table #sales analysis #excel

Build Dynamic Pivot Table from Sales Data

Act as an Excel data analyst. I have a sales dataset with columns: [Date, Region...

#sql #cohort analysis #retention

SQL Query to Find User Cohort Retention by Month

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

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

#sql #churn analysis #customer retention

ChatGPT prompt for building a SQL query to analyze customer churn patterns

Act as a senior data analyst specializing in customer retention. I need SQL que...

#typography #type-scale #design-system

design intermediate

Typography Hierarchy & Type Scale System for Digital Products

Help me design a robust typography system for my digital product. Context: Prod...

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

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

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

data Intermediate

Design a Minimal Data Model From a Vague Spec

Act as a data architect. From this rough description of what we need to track: {...

#data #schema #modeling

#data quality #dashboard #monitoring

Build a Data Quality Dashboard Specification

Specify a data quality monitoring dashboard for a data warehouse with [N] tables...