Search: "analytics SQL"

#sql optimization #query tuning #performance

coding Advanced

ChatGPT Prompt for Refactoring a Slow SQL Query Without Breaking Results

Help me refactor a slow SQL query so it runs faster without changing the busines...

#data dictionary #analytics schema #documentation

data Intermediate

ChatGPT Prompt for Data Dictionary from a Messy Analytics Schema

Help me create a clear data dictionary from a messy analytics database so busine...

#SQL #optimization #performance

Coding Advanced

SQL Query Optimizer

Analyze this SQL query for performance issues: [QUERY]. Provide: execution plan ...

#data #visualization #charts

Data Visualization Chart Selection Guide

I have the following dataset: [describe data type, dimensions, and what I want t...

#ab-testing #statistics #analytics

data advanced

A/B Test Analysis Statistical Significance Calculator Guide

Walk through a complete A/B test analysis for [experiment, e.g., testing two ema...

#coding #sql #query optimization

coding Advanced

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

#chatgpt prompt for sql query #month over month analysis #KPI query

coding Intermediate

ChatGPT Prompt for Writing SQL to Compare This Month vs Last Month KPIs

Act as a senior SQL analyst. I need SQL that compares this month versus last mon...

#excel #cohort analysis #retention

excel Advanced

ChatGPT Prompt for Excel Cohort Retention Tracker from Raw Transactions

I have raw transaction data in Excel with columns for customer_id, first_purchas...

#exit interview #employee retention #hr analytics

hr Advanced

ChatGPT Prompt for Exit Interview Summary That Reveals Retention Problems

Act as an HR analyst. Help me turn raw exit interview notes into a summary that ...

#sql #churn analysis #customer retention

data Advanced

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

#data cleaning #csv #pandas

data Intermediate

ChatGPT prompt for creating a data cleaning pipeline for messy CSV files

Act as a senior data engineer who specializes in data quality and ETL pipelines....

coding Advanced

SQL Query Optimization for Slow Database Queries

Help me optimize this slow SQL query: [paste your query]. The database is [MySQL...

#coding #sql #database

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

coding intermediate

Python FastAPI: Build Production-Ready REST APIs

Act as a senior Python backend engineer experienced with FastAPI. Help me build ...

#coding #python #fastapi

#coding #sql #window-functions

coding advanced

SQL Window Functions: Advanced Analytics Query Guide

Act as a senior data engineer and SQL expert. Help me master SQL window function...

#data #quality #assessment

Data Quality Assessment Framework and Cleaning Checklist

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

#code review #security #performance

coding intermediate

Code Review Checklist: Security, Performance, and Maintainability

Create a comprehensive code review checklist for [language: Python/JavaScript/Ty...

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

data advanced

ETL Pipeline Design for Data Warehouse

Design an ETL (Extract, Transform, Load) pipeline for loading data from [source ...

#data #etl #pipeline

#database design #SQL #schema

coding advanced

Database Schema Design E-Commerce Platform

Design a normalized relational database schema for a multi-vendor e-commerce pla...

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

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

#tableau #churn #analytics

Tableau Dashboard Design for Customer Churn Analysis

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

#data #looker-studio #dashboard

Google Looker Studio Dashboard Design for Business Intelligence

You are a BI analyst and data visualization expert. I need to build a profession...