3 of 12 labs complete
MasterClass Executive The University of Chicago Booth School of Business

AI Lab 02 · Data & Financial Analysis & Dashboards with AI · Completed November 5, 2026

More orders didn't mean more profit.
So I changed my recommendation.

Button & Bear, a fictional online teddy-bear business, had to pick its Q4 offer: keep the promotion, reset prices and shipping, or launch a bundle. I used AI to reconcile the data, model nine scenarios and stress-test the answer. The bundle looked best on profit alone, but its lead disappeared once customers could switch to it, so I recommended piloting the reset first.

Case
Button & Bear, fictional DTC
Q4 offer decision
Evidence
10,800 orders reconciled
67 checks · 9 scenarios
Deliverable
Interactive dashboard
plus a 10-sheet working model

Level 2 · The recording

My presentation

An executive walkthrough of the decision, the verified findings and the recommendation, recorded over the finished dashboard.

4 min 22 s · recorded in my own voiceOfficial lab page and recording (cohort login) →

How I approached it

The decisions that shaped the work

  • Check the data before trusting it.Every order and item line was audited and reconciled to the monthly records. Shipping was calculated per order, not per line, so it was not counted twice. The original workbooks stayed unchanged.
  • Explain the gap.Q3 orders beat budget by 20%, yet operating profit was about $5,500 against a $31,400 plan. Discounts removed about $21,000 and higher shipping cost per order another $9,000.
  • Challenge the first answer.In the base case the bundle led the reset by only about $2,200. When customers who planned to buy both bears switched to the cheaper bundle, its profit fell below the reset.
  • Recommend a pilot, not a leap.Pilot the price and shipping reset, track contribution per visitor, then test the bundle against it with limited stock exposure.

Level 3 · The deliverable

The deliverable

Live app

Q4 decision dashboard

Reviewed data, scenario comparisons, the profit bridge, inventory and cash by day, and the sources behind each number.

Open the dashboard →

Working model · XLSX

Supporting analysis workbook

Ten sheets with editable formulas, a scenario selector, daily cash schedules, competitor pricing and 67 reconciliation checks.

Download the workbook →

Reader

Recording script

The timed script with screen cues and reading controls, as used for the recording.

Read the script →