Search: "pivot table"

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

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

#excel #formulas #xlookup

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#excel #pivot-table #data-cleanup

Find the rows that broke a pivot table without scrolling 40,000 rows

My pivot table is showing #N/A or a mysterious 'blank' row, and the source data ...

#excel #dashboard #pivottable

excel Advanced

Create a Dynamic Dashboard with Slicers and PivotTables

You are an Excel dashboard designer. Guide me through building an interactive sa...

#data #analysis #insights

data Intermediate

Interpret a Dataset and Find Insights

You are an expert data analyst. Help me find the story in a set of numbers I'll ...

#data validation #dropdown lists #dependent dropdowns

Excel Data Validation and Dropdown Lists

Teach me how to create advanced data validation and dependent dropdown lists in ...

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

#excel #vlookup #index-match

excel beginner

VLOOKUP vs INDEX-MATCH: Smart Data Lookup Formulas

I need to retrieve data from a lookup table in Excel. My main table has [column ...

#kpi #scorecard #dashboard

excel intermediate

Excel Dashboard KPI Scorecard with Traffic Lights

Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...

data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization

#power query #excel #data combine

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

#data quality #audit #pipeline

data Advanced

Data Quality Audit Checklist Pipeline Reliability Framework

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

#tabletop rpg #worldbuilding #game master

creative Advanced

Tabletop RPG Campaign Setting Worldbuilding Bible Template

You are a tabletop RPG game master. Build a campaign setting bible for a [GENRE ...

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

#creative #storyboard #film

creative Intermediate

Storyboard Template for a Short Film with Detailed Shot List

Act as a storyboard artist and director. I will give you a short script (under 5...

#excel #test-data #random

excel Beginner

Generate Realistic Test Data With Random Functions

I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...

#data #quality #validation

data Intermediate

Write a Data Quality Checklist for a New Pipeline

Act as a data reliability engineer. I'm shipping a new pipeline that loads {{sou...

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

customer-service Advanced

Handle a Customer Who's Threatening a Public Complaint

Help me handle a customer who's threatening to post about [ISSUE] on Twitter / T...

#customer-service #escalation #social media

#writing #editing #revision

writing Intermediate

Find the One Sentence Doing All the Work in Your Draft

Here's a draft I'm editing: [paste draft, 500-1500 words]. Help me find the sent...

#excel #pivot tables #reporting

Turn a messy operational export into a pivot table that someone will actually read

I have an operational export with [N] rows and columns like [DATE, REGION, PRODU...