Search: "pivot tables"

#excel #dashboard #reporting

excel intermediate

Build a weekly dashboard people actually open without retraining them

Act as a BI designer. I want a one-tab Excel dashboard that a non-analyst team o...

#excel #pivot-table #sales

Design a Pivot Table for Monthly Sales Analysis

You are an expert Excel reporting analyst. Guide me through building a pivot tab...

#data #data-modeling #spreadsheets

Design a Simple Data Model for My Spreadsheet

You are a spreadsheet/data modeling expert. Help me structure my data so it's cl...

Data Quality Audit Checklist for New Dataset

Run a data quality audit on the dataset described below. Check for: missing valu...

#data #quality #audit

#excel #pivot-tables #reporting

excel Beginner

Excel: Build a Pivot Table That Answers the Question Your Boss Actually Asked

I have a dataset and a vague question from leadership. Help me design a pivot ta...

#excel #pivot-tables #analysis

Excel: Rebuild a Pivot That Lies to Stakeholders

Look at this pivot table setup: [PASTE COLUMNS, FILTERS, AND VALUES]. Tell me wh...

Build a SQL Style Guide That Survives a Growing Team

Act as a data platform tech lead. Write me a SQL style guide tailored to a 10-pe...

#sql #style-guide #dbt

#writing #interview #reporting

writing Advanced

Turn 90 minutes of background interview tape into a 600-word reported piece

You are a magazine editor. I just conducted a 90-minute interview with [SUBJECT]...

data Advanced

Write a SQL query that returns the right answer when the data has duplicates

I'm writing a SQL query against tables [paste schemas, especially the join keys]...

#sql #joins #duplicates

data intermediate

Write SQL Queries from a Question

Act as a SQL expert. My tables are: [describe tables and key columns]. Write a S...

#data #sql #queries

Choose the right join before I merge two datasets

I have two tables I want to combine and I'll describe the key columns and what e...

#data #joins #sql

#excel #pivot-table #reporting

Design a Pivot Table Reporting Plan

You are an Excel reporting consultant. Based on the dataset I describe, design t...

#pivot-table #debugging #totals

Diagnose Why a Pivot Table Is Showing the Wrong Totals

Help me diagnose why my Excel pivot table is showing wrong totals. Source data r...

#power-query #data-cleaning #pivot

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#coding #database #performance

coding Advanced

Optimize a Slow Database Query

Act as a database performance engineer. Here is a slow query and its context: [P...

Write and Explain a SQL Query From Plain English

Act as a SQL expert. I will describe what I want in plain English and you will w...

#data #sql #databases