Search: "power query"

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

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

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

#sales commission tracker #tiered commission excel #clawback formula

excel Advanced

ChatGPT prompt for Excel sales commission tracker with tiered rates and clawbacks

Act as a sales operations analyst who is great at Excel. I need a commission tra...

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

#SQL #optimization #performance

Coding Advanced

SQL Query Optimizer

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

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

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

#data visualization #chart design #business intelligence

data beginner

Data Visualization Best Practices: Chart Selection and Design Guide

I have the following data and need to visualize it effectively: Data type: [desc...

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

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

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

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

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

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

#excel #power-query #data-cleaning

excel Intermediate

Convert a Messy Paste from PDF into a Clean Table

I pasted a table from a PDF into Excel and the data is jumbled — some rows are s...

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

#budget variance report #excel finance analysis #accounting export cleanup

excel Intermediate

ChatGPT prompt for monthly budget variance report from exported accounting data

I need help turning exported accounting data into a monthly budget variance repo...

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

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

#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

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

#pivot-table #yoy #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...