Search: "power query"

#power-bi #dashboard #dax

data intermediate

Power BI Dashboard Design: Best Practices for Business Intelligence

Help me design an effective Power BI dashboard. My situation: Data source: [EXC...

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

#pivot tables #excel #data analysis

excel Intermediate

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

#ab testing #statistics #hypothesis testing

ChatGPT Prompt: Statistical Hypothesis Testing for Product Experiments

Help me design a hypothesis test for a product experiment. Context: - Hypothesi...

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

#data #power-bi #dashboard

data intermediate

Power BI Dashboard Design: Sales Performance Metrics

Act as a Power BI specialist and data visualization expert. Help me design a sal...

#creative #fantasy #world-building

creative intermediate

Fantasy World Building: Magic System and Lore Template

Act as a fantasy world building specialist and author consultant. Help me design...

#data quality #audit #pipeline

Data Quality Audit Checklist Pipeline Reliability Framework

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

#sql #optimization #performance

SQL Query Optimizer with Explain-Plan Reading

Act as a database performance engineer. I will paste a slow SQL query and its EX...

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

#power query #excel #web scraping

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

#excel #power query #m code

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

#creative #writing #fantasy

creative advanced

Fantasy World-Building for Creative Writing

Help me build a detailed fantasy world for a [novel / short story / game / scree...

#power query #excel #data combine

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

#ab testing #statistics #significance

A/B Test Analysis Statistical Significance Sample Size Calculator

You are a data scientist. Help me analyze an A/B test on [METRIC] comparing [VAR...

#xlookup #formulas #excel

excel Intermediate

Excel XLOOKUP Formula Builder for Multi-Criteria Match

Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...

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

#data #sql #cohort-analysis

data advanced

Customer Cohort Analysis SQL Query Templates for Retention Insights

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

#business #competitive analysis #porter

business Advanced

Competitive Teardown Framework Using Porter's Five Forces

You are a strategy MBA professor. Run a Porter's Five Forces analysis for [INDUS...

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

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