Search: "pivot table"

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

data Advanced

Data: Write a Backfill Query That Won't Take Down the Database

I need to backfill [COLUMN/TABLE] with [LOGIC]. The table has [N] rows. Write th...

#data #sql #backfill

#excel #power-query #office-scripts

excel Advanced

Automate a weekly Excel report that pulls from three CSVs and emails itself

You are an automation engineer. I get three CSVs every Monday — [CSV_1], [CSV_2]...

Sanity-check a dataset in 30 minutes before you build anything on top of it

I just got handed a dataset I'm going to use for [analysis / model / dashboard]....

#data #sanity-check #eda

#decision #async #escalation

email Intermediate

Write the email that pushes a decision out of a stuck Slack thread

Act as a senior PM who is tired of decisions dying in Slack. A thread has been g...

#excel #formulas #commission

Build a Nested IF Formula for Tiered Commission

You are an expert Excel formula engineer. Help me write and explain a single Exc...

#education #study #spaced-repetition

education Beginner

Create a Spaced-Repetition Study Plan

You are an expert learning-science coach. Help me build a spaced-repetition plan...

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

#education #quiz #assessment

education Intermediate

Design a 10-Minute Quiz That Actually Reveals What Students Know

I want to give a 10-minute quiz at the start of class to find out where my stude...

data Advanced

Data: Write a SQL Query for a Cohort Retention Table

I want a SQL query that returns a cohort retention table — rows = signup month, ...

#data #sql #retention

#marketing #launch #campaign

marketing Advanced

Plan a launch that doesn't fizzle two days in

I'm launching [PRODUCT/FEATURE] on [DATE]. Help me build a launch that has a sec...

#SQL #window functions #query optimization

data Advanced

Rewrite a slow correlated subquery as a window function

I have a query with a correlated subquery that runs once per row to find each cu...

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

#positioning #messaging #value-prop

marketing Intermediate

Find the one message that makes a feature actually matter to buyers

You're a positioning strategist. I will describe a feature or product and tend t...

#excel #formulas #xlookup

Write a nested IF that a coworker can actually read

I need an Excel formula that assigns a grade band based on a score, with at leas...

Write Nested IF and IFS Formulas for Tiered Commission

Act as an Excel formula expert. I need to calculate sales commission using tiere...

#excel #formulas #ifs

#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 #analysis #insights

Interpret a Dataset and Surface Insights

You are a data analyst. I'll paste a summary table or describe a dataset: [PASTE...

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

#excel #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...

#email #meeting-notes #follow-up

email Intermediate

Turn Meeting Notes into a Follow-Up Email

You are a meeting-summary assistant. I will paste rough meeting notes and you wi...

#business #stakeholders #communication

business Intermediate

Create a Stakeholder Communication Plan

You are a project management coach. Help me build a stakeholder communication pl...