Search: "sql"

SQL Query Builder for Complex Analytics

Help me write an optimized SQL query for my analytics need. Database details: D...

#data #sql #analytics

Database Indexing Strategy & Query Performance Optimization Guide

Help me optimize my database performance through indexing. My context: Database...

#database #indexing #sql

#data quality #etl #data engineering

ChatGPT Prompt: Data Quality Audit Framework for ETL Pipelines

Build a data quality audit framework for [PIPELINE/TABLE]. Context: - Source sy...

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres

#data #power-bi #dashboard

Power BI Dashboard Design: Sales Performance Metrics

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

#power-bi #dashboard #dax

Power BI Dashboard Design: Best Practices for Business Intelligence

Help me design an effective Power BI dashboard. My situation: Data source: [EXC...

#SQL optimization #query performance #database

SQL Query Optimization Guide for Slow Database Queries

Analyze and optimize the following slow SQL query that is causing performance is...

#data #documentation #data-dictionary

data Beginner

ChatGPT Prompt: Data Dictionary Documentation Template for Production Tables

You are a data governance lead. Generate a data dictionary template I can fill o...

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

#coding #database #migration

coding Intermediate

Write a Migration Script That Can Be Re-run Safely

Act as a database engineer. I need a migration script that can be re-run safely ...

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

ChatGPT prompt for SQL migration plan with rollback safeguards

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

#SQL #window functions #analytics

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

#data #quality #assessment

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#SQL #GROUP BY #window functions

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

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

#coding #sql #performance

SQL Query Optimizer With EXPLAIN Plan Walk-Through

I have a slow SQL query against [DB ENGINE — Postgres / MySQL / SQL Server]. The...

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

#coding #postgres #migration

Write a Postgres Migration That Adds a NOT NULL Column to a Large Table

Write a safe Postgres migration for a 50M-row production table (heavy write traf...

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

#coding #sql #query optimization

ChatGPT prompt for reviewing SQL query performance and suggesting optimizations

Act as a senior SQL performance engineer. I will share a slow SQL query, the ta...

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

#Power BI #DAX #dashboard

Power BI Dashboard Design Executive Sales Report

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

#data #sql #cohort-analysis

Customer Cohort Analysis SQL Query Templates for Retention Insights

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

#data quality #audit #pipeline

Data Quality Audit Checklist Pipeline Reliability Framework

You are a data engineer. Audit data quality for [PIPELINE / TABLE]. Run through:...