Search: "SQL"

#postgresql #indexing #performance

coding advanced

PostgreSQL Database Indexing Strategy for Slow Queries

Analyze and fix slow query performance in PostgreSQL for [describe your schema a...

excel advanced

Excel Power Pivot Data Model for Cross-Table Business Analysis

Build a complete Excel Power Pivot data model for multi-table business analysis....

#excel #power-pivot #dax

SQL Query Builder for Complex Analytics

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

#data #sql #analytics

data advanced

Database Indexing Strategy & Query Performance Optimization Guide

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

#database #indexing #sql

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

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

#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 #sql #performance

coding Advanced

SQL Query Optimizer With EXPLAIN Plan Walk-Through

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

#data #sql #window-functions

Write Window Functions That Replace a Subquery Loop

Act as a senior SQL engineer. I need to compute {{describe: e.g., 7-day rolling ...

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

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

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

#SQL #window functions #analytics

data advanced

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

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

Generate a SQL Migration With Safe Rollback

Act as a database engineer. Write a {{database: e.g., PostgreSQL 15}} migration ...

#coding #sql #migration

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