Search: "pivot table"

#plain-language #jargon #accessibility

writing Beginner

Rewrite Corporate Jargon Into Plain Language a Customer Will Actually Read

Rewrite this corporate text into plain language a non-technical customer will ac...

#migrations #zero-downtime #schema

coding Advanced

Coding: Write a Migration Plan for a Schema Change That Can't Take Downtime

I need to change a schema (rename column, change type, add NOT NULL) on a high-t...

#writing #structure #essay

writing Advanced

Restructure an essay that has a great middle but a weak opening and ending

I have an essay where paragraphs 4-8 are doing real work but the opening (paragr...

data Intermediate

Write a query that survives the source table being renamed in six months

I need to write a SQL query that pulls weekly metrics for a dashboard. The sourc...

#sql #data #query

#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 #dashboard #slicers

excel intermediate

Build a Dynamic Excel Dashboard with Slicers

Act as an Excel expert. Guide me through building a dynamic dashboard for [datas...

data Intermediate

Write a SQL Query from a Plain-English Question

You are a SQL expert and data analyst. I will describe a question in plain Engli...

#data #sql #query

#finance #decision #comparison

finance Intermediate

Compare Two Financial Options with a Clear Breakdown

You are a financial decision analyst who helps people think clearly about money ...

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

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#writing #editing #passive-voice

writing Intermediate

Rewrite Passive Voice to Active Voice Editor

Rewrite the following text by converting passive voice constructions to active v...

coding Advanced

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database

data Advanced

Write a Cohort Retention Query That Doesn't Secretly Double-Count Users

I need a SQL cohort retention query that groups users by their signup week and s...

#data #sql #cohort

#excel #dashboard #formulas

Build a self-updating sales dashboard using only formulas (no PivotTables)

I want to build a sales dashboard in Excel that updates automatically when I pas...

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

#finance #debt #investing

finance Intermediate

Decide between paying off debt and investing without overthinking it

I have [DEBTS — type, balance, interest rate] and [INVESTMENT/SAVINGS CAPACITY —...

#excel #fuzzy-match #deduplication

excel Advanced

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

legal Advanced

Write a privacy notice that meets GDPR and CCPA without being unreadable

You are a privacy program lead. Draft a privacy notice for [PRODUCT] that satisf...

#legal #privacy #gdpr

#finance #variance #reporting

finance Intermediate

Explain a budget variance without listing every line that moved

We closed [period]. Spend was [over / under] budget by [%]. Leadership wants an ...

#data #cohort analysis #retention

data Advanced

Design a Cohort Retention Analysis from Raw Event Data

Help me design a cohort retention analysis. My raw data: an events table with us...

#power-query #csv #data-cleaning

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...

#excel #power-query #data-cleaning

Excel: Convert a Messy Paste-from-PDF Table Into a Clean Dataset

I pasted a table from a PDF and Excel split it badly — values are stuck together...

#excel #pivot-tables #executive-reporting

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...