Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "query-optimization"

91 prompts matching "query-optimization"

"query-optimization" ✕ Clear all ✕
data Advanced

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
👁 14 views
excel Intermediate

Convert Messy Text Column Into Clean Structured Fields

I have a single column in Excel containing messy entries like "{{example raw ent...

#excel #text-functions #parsing
👁 14 views
data Intermediate

Google Sheets Dashboard with Automated Data Import

Act as a Google Sheets expert. Create a complete marketing dashboard in Google S...

#data #Google Sheets #dashboard
👁 13 views
excel Intermediate

ChatGPT prompt for reconciling two Excel lists with duplicates and near matches

I need to reconcile two Excel lists that should overlap, but the data is messy. ...

#excel list reconciliation #duplicate matching #near match cleanup
👁 13 views
data advanced

SQL Window Functions Advanced Analytics Queries

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

#SQL #window functions #analytics
👁 12 views
excel intermediate

Excel Power Query: Clean & Transform Raw Data Automatically

I have raw data in Excel that needs cleaning and transformation. Help me build a...

#power query #data cleaning #ETL
👁 12 views
excel Advanced

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

#excel #power query #m code
👁 12 views
coding Advanced

REST API Design Checklist with Versioning and Pagination Strategy

You are a senior API architect. I will paste a REST API design (endpoints, reque...

#coding #api #rest
👁 12 views
data Advanced

Cohort Retention Analysis SQL Query With Visualization Stub

Write a SQL query that produces a monthly cohort retention table for [SaaS PRODU...

#data #sql #cohort-analysis
👁 12 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
marketing Beginner

Content Repurposing Plan to Turn One Long Podcast Into 12 Assets

Turn one 60-minute podcast episode (transcript pasted below) into 12 derivative ...

#marketing #content #repurposing
👁 12 views
excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#power query #CSV import #data transformation
👁 11 views
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...

#sql #churn analysis #customer retention
👁 11 views
excel advanced

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl
👁 11 views
data advanced

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
👁 11 views
data Advanced

Data Quality Audit Checklist Pipeline Reliability Framework

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

#data quality #audit #pipeline
👁 11 views
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
👁 11 views
excel Advanced

ChatGPT Prompt: Excel Power Query M Code for Web Data Scraping

Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...

#power query #excel #web scraping
👁 11 views
data Advanced

Write Window Functions That Replace a Subquery Loop

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

#data #sql #window-functions
👁 11 views
excel Intermediate

Excel Formula to Detect Duplicate Records Across Columns

I need an Excel formula to detect duplicate records based on a combination of mu...

#duplicates #data cleaning #excel
👁 11 views
data Advanced

SQL Query to Find User Cohort Retention by Month

Write a SQL query to compute monthly cohort retention. Tables: - users(id, signu...

#sql #cohort analysis #retention
👁 11 views
data Advanced

Funnel Analysis Query Diagnosing the Worst Drop-Off Step

I have an events table (event_name, user_id, event_time, properties JSON). Write...

#data #funnel #sql
👁 9 views
data Advanced

Write a SQL Query for Cohort Retention Analysis

Write a portable SQL query (works on PostgreSQL and BigQuery) that produces a mo...

#data #sql #cohort
👁 9 views
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
👁 8 views
excel Advanced

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl
👁 8 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval