Search: "power query"

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

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

#A/B testing #statistical analysis #hypothesis testing

data advanced

A/B Test Results Analysis: Statistical Significance and Reporting

Help me analyze the results of an A/B test I ran: Experiment name: [name], Test ...

#stakeholder management #communication plan #project management

business Intermediate

Stakeholder Management Communication Plan Template

Help me create a comprehensive stakeholder management and communication plan for...

#creative #writing #children-books

creative intermediate

Children Book Writing Character and Story Structure Complete Guide

Write a comprehensive guide to creating and publishing a children's picture book...

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

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

#excel #text-functions #parsing

excel Intermediate

Convert Messy Text Column Into Clean Structured Fields

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

#power query #CSV import #data transformation

excel Advanced

Power Query: Merge and Transform Multiple CSV Files

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

#excel list reconciliation #duplicate matching #near match cleanup

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

#coding #react #typescript

coding Advanced

React Component with TypeScript and Custom Hook

Build a React component in TypeScript for a [component type, e.g., paginated dat...

#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 Query Data Transformation Masterclass

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

#excel #power-query #etl

#creative #childrens-book #writing

creative beginner

Children Book Story Structure and Writing Guide

You are a children book author and editor with published picture books and early...

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

#design #animation #micro-interactions

design intermediate

UI Animation and Micro-Interaction Design Principles Guide

Create a comprehensive guide to designing meaningful UI animations and micro-int...

data intermediate

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

#dashboard design #KPI #data visualization

data Intermediate

Data Dashboard Design Blueprint for Business KPI Reporting

Design a KPI dashboard blueprint for [department: sales / operations / marketing...

#ab-test #power-analysis #experimentation

A/B Test Power Analysis Pre-Launch Check

Act as an experimentation statistician. Before launching an A/B test on [METRIC]...

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