Search: "query-optimization"

31 prompts matching "query-optimization"

"query-optimization" ✕ Clear all ✕

SQL Window Functions Advanced Analytics Queries

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

#SQL #window functions #analytics

coding advanced

PostgreSQL Database Indexing Strategy for Slow Queries

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

#postgresql #indexing #performance

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

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

Customer Cohort Analysis SQL Query Templates for Retention Insights

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

#data #sql #cohort-analysis

excel Intermediate

Pivot Table Refactor for Year-over-Year Analysis

Act as a financial analyst. Help me build a pivot table from [DATA RANGE] (colum...

#pivot-table #yoy #analysis

excel Intermediate

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

#power query #excel #data combine

Data Quality Audit Checklist Pipeline Reliability Framework

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

#data quality #audit #pipeline