Search: "pivot tables"

#sales commission tracker #tiered commission excel #clawback formula

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

#chatgpt prompt for MRR waterfall #subscription revenue #excel finance model

ChatGPT Prompt for Creating an Excel Subscription Revenue Waterfall

Act as a finance analyst who specializes in subscription businesses. Help me bui...

#coding #sql #stored-procedure

coding advanced

SQL Stored Procedure for Data Transformation

Write a SQL stored procedure in [MySQL / PostgreSQL / SQL Server] for the follow...

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

Power BI Dashboard Design: Sales Performance Metrics

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

#data cleaning #CSV #pandas

data Intermediate

Data Cleaning Checklist for Messy CSV and Excel Datasets

Create a systematic data cleaning checklist and workflow for a messy dataset in ...

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

#data quality #dashboard #monitoring

data Advanced

Build a Data Quality Dashboard Specification

Specify a data quality monitoring dashboard for a data warehouse with [N] tables...

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

#chatgpt prompt for KPI summary #SaaS metrics #weekly report

data Beginner

ChatGPT Prompt for Building a Weekly SaaS KPI Narrative from Raw Metrics

Act as a data storyteller for a SaaS business. I will paste weekly KPI numbers s...

ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...

#excel #vba #macros

Python Pandas Advanced GroupBy and Aggregation Techniques

Demonstrate advanced Pandas GroupBy operations for [dataset type, e.g., sales tr...

#pandas #python #groupby

#pivot table #grouping #calculated fields

excel intermediate

Excel Pivot Table: Advanced Grouping and Summarization Techniques

I have a dataset in Excel with the following columns: [list your columns, e.g., ...

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

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

#excel #power query #m code

Power Query M Code Generator for Repeatable Data Transformation

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

#education #study #spaced repetition

education Intermediate

Spaced Repetition Study Schedule Generator for Exam Prep

Act as a learning science coach. Build a spaced-repetition study schedule for [E...

#excel #pivot-table #reporting

excel intermediate

Excel Pivot Table Design for Management Reporting

You are an Excel reporting expert. I need to build a professional pivot table re...

#data #looker-studio #dashboard

Google Looker Studio Dashboard Design for Business Intelligence

You are a BI analyst and data visualization expert. I need to build a profession...

#design #typography #font-pairing

design intermediate

Typography System Design: Font Pairing and Type Scale Guide

Act as a typography expert and brand designer. Help me create a comprehensive ty...

#scenario manager #goal seek #sensitivity analysis

excel advanced

Excel Financial Modeling: Scenario Manager and Goal Seek Analysis

I'm building a financial model in Excel for [project/business type]. Help me set...

#data #Google Sheets #dashboard

data Intermediate

Google Sheets Dashboard with Automated Data Import

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

👁 15 views