Search: "case-study"

data Intermediate

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

#business #investment #cfo

business advanced

Defend a long-payback investment in a quarterly-EBITDA-obsessed room

Act as a CFO who has had to sell long-horizon investments to short-horizon board...

#code-review #pr #reviews

coding Advanced

Review a pull request for the thing the author didn't realize they were doing

You're a senior engineer doing a code review. I'll paste the diff. Don't comment...

#productivity #weekly review #habits

productivity Beginner

Design a weekly review that takes 20 minutes and sticks

Help me design a weekly review I'll actually do. I'll tell you what tools I use ...

#design #ux #simplification

design Advanced

Simplify a cluttered screen by ranking what earns its place

I'll describe a screen that's trying to do too much. Help me thin it out: rank e...

productivity Intermediate

Make a Tough Decision With a Clear Framework

Act as a decision coach. I'm stuck on a decision and you'll help me think it thr...

#productivity #decision-making #frameworks

#business #business-case #proposal

Draft a One-Page Business Case

You are a management consultant. Help me write a one-page business case to get a...

#email #re-engagement #sales

email Beginner

Write a Re-Engagement Email to a Lapsed Customer

Write a re-engagement email to a customer who hasn't purchased in 9 months. Cust...

#business #headcount #hiring

Business Case Template for New Hire Headcount

Draft a business case to justify a new headcount request. Include: Role and leve...

customer-service Intermediate

Customer Service: Write a Refund Reply for a Borderline Case

A customer is asking for a refund that's outside policy but the case isn't unrea...

#customer-service #refunds #policy

#business #strategy #sunset

Business: Kill a Project That Has Defenders But No Customers

Help me build the case to shut down [PROJECT/PRODUCT]. The numbers say it's not ...

design Advanced

Design: Redesign an Onboarding Flow Without Adding a Tour

Here's our current onboarding: [DESCRIBE]. Drop-off happens at [STEP]. Resist th...

#design #ux #onboarding

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

#business-case #cfo #investment

Stress-test a business case before you present it to a skeptical CFO

I'm presenting a business case for [initiative] next week. The headline is: inve...

#debugging #trace #root-cause

coding Intermediate

Find the bug by explaining the code back to me

Act as a debugging partner. I will paste code that is misbehaving and tell you t...

data Intermediate

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 Advanced

Plan an Excel Macro or Office Script

You are an Excel automation expert. I will describe a repetitive task and you wi...

#excel #automation #vba

#dependencies #architecture #build-vs-buy

coding Intermediate

Coding: Decide Between a Library and Writing It Yourself (Honestly)

I'm choosing between adding a dependency for [feature] and writing ~50-200 lines...

#coding #debugging #testing

coding Intermediate

Coding: Debug a Test That Passes Locally but Fails in CI

I have a test that passes on my laptop and fails in CI, and I've already tried '...

#email #vendor-management #difficult-conversations

email Intermediate

Email: Tell a Vendor We're Switching Without Burning the Relationship

We're moving off [VENDOR] to [REPLACEMENT] after [N] years. Help me write the em...

#design #design-system #components

design Advanced

Decide what to put in the design system and what to leave alone

Our team is building (or rebuilding) a design system. The instinct is to systemi...

#charts #visualization #chart selection

data Beginner

Pick the right chart when you can't decide between a bar and a line

I want to show how 4 product lines have grown over 12 months. I keep flip-floppi...

#marketing #brand #performance

marketing advanced

Decide whether to invest in brand or performance for the next quarter

Act as a head of marketing trying to defend a budget split to a quantitative CEO...