Search: "sql"

#RFM analysis #customer segmentation #data analysis

Customer Segmentation Analysis with RFM Model

Help me perform customer segmentation using the RFM (Recency, Frequency, Monetar...

👁 12 views

#data #sales analysis #insights

Analyze Sales Data and Find Insights

Act as a data analyst. I have sales data with columns: Date, Product, Category, ...

👁 11 views

#database design #schema #SQL

Database Schema Design from Requirements

Act as a senior database architect. Design a normalized database schema based on...

👁 11 views

#data #SQL #business intelligence

SQL for Business Intelligence

Write SQL queries for a business intelligence dashboard. Tables: orders, custome...

#cohort retention analysis #subscription churn #sql retention

ChatGPT prompt for cohort retention analysis from subscription data

You are a product data analyst. I need help analyzing subscription retention by ...

#SQL #optimization #performance

Coding Advanced

SQL Query Optimizer

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

#coding #sql #stored-procedure

coding advanced

SQL Stored Procedure for Data Transformation

Write a SQL stored procedure in [MySQL / PostgreSQL / SQL Server] for the follow...

SQL Query Optimization for Slow Database Queries

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

#coding #sql #database

data advanced

Database Indexing Strategy & Query Performance Optimization Guide

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

#database #indexing #sql

#data #sql #window-functions

ChatGPT Prompt: SQL Window Function Tutorial With Practical Examples

You are a SQL teacher. Walk me through window functions using realistic examples...

#data quality #anomaly detection #data monitoring

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., '...

#clean CRM export #sales data cleanup #pipeline analysis

ChatGPT prompt for cleaning CRM export before sales analysis

Act as a sales operations analyst. I have a messy CRM export that I want to clea...

coding Intermediate

ChatGPT Prompt for SQL Query to Build Weekly Active User Trend and Segments

Write a SQL query for weekly active user reporting from this schema: [paste tabl...

#coding #sql #analytics

#sql optimization #query tuning #performance

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

#sql review #board reporting #metric qa

ChatGPT Prompt for SQL Query Review Before Sharing a Board Report

Review my SQL query before I use it in an executive or board report where mistak...

ETL Pipeline Design for Data Warehouse

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

#data #etl #pipeline

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

#code review #security #performance

coding intermediate

Code Review Checklist: Security, Performance, and Maintainability

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

#cohort analysis #retention #sql

ChatGPT Prompt: Cohort Retention Analysis SQL with Visualization Plan

Write SQL for a cohort retention analysis and explain how to visualize it. Cont...

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

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

#data cleaning #csv #pandas

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

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