Search: "pivot tables"

#finance #budget #variance-analysis

finance intermediate

Business Budget Variance Analysis Template Monthly Reporting

Build a complete budget variance analysis system for business financial manageme...

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

#typography #type-scale #design-system

design intermediate

Typography Hierarchy & Type Scale System for Digital Products

Help me design a robust typography system for my digital product. Context: Prod...

#pivot table #sales analysis #monthly report

Excel Pivot Table Report for Monthly Sales Analysis

Design a step-by-step guide for creating an Excel pivot table report to analyze ...

#data #warehouse #star schema

data Advanced

Data Warehouse Star Schema Design for Analytics Workloads

You are a senior data engineer. Design a star schema for [DOMAIN] analytics. Pr...

#sql #cohort analysis #retention

data Advanced

SQL Query to Find User Cohort Retention by Month

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

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

#sql migration prompt #rollback safe deployment #database schema change

coding Advanced

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

#excel #pivot table #sales analysis

Pivot Table Mastery for Multi-Year Sales Data Analysis

Act as an Excel data analyst. I will paste a sales dataset with columns Date, Re...

data Intermediate

Design a Minimal Data Model From a Vague Spec

Act as a data architect. From this rough description of what we need to track: {...

#data #schema #modeling

#pivot table #sales analysis #excel

Build Dynamic Pivot Table from Sales Data

Act as an Excel data analyst. I have a sales dataset with columns: [Date, Region...

#excel #dashboard #slicers

Excel Dashboard with Dynamic Slicers

Help me design a single-page Excel dashboard for KPIs (revenue, orders, conversi...

#excel #power-query #unpivot

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#excel #pivot-table #sales

excel intermediate

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

#pivot tables #excel #data analysis

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

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

#excel #pivot-table #calculated-field

Excel Pivot Table Calculated Field for Margin Percentage by Segment

I have a sales table with columns: order_id, date, customer_segment, product, re...

#excel #dashboard #index-match

Build a Dynamic Dashboard Using INDEX-MATCH and Slicers

Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...

#excel #goal-seek #solver

excel Advanced

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#email-design #html-email #newsletter-design

design intermediate

Email Newsletter Design: Responsive HTML Template Best Practices

Help me design and code a high-quality responsive email newsletter template. Con...

#excel #pivot-table #calculated-field

ChatGPT Prompt: Excel Pivot Table Calculated Field for Custom Metrics

You are an Excel pivot table expert. Help me add a calculated field to my pivot ...

#excel #scenarios #data tables

Create a What-If Scenario Comparison Table With Data Tables

I have a financial model with three driver inputs (cells B2: pricing, B3: churn,...

#coding #sql #readability

coding Intermediate

Write a SQL query that you'll still understand in six months

Write a SQL query that answers this question: [QUESTION]. Tables and columns I h...