Dashboard · Power BI rebuild

Bean & Brew

Eight coffee shops, 21 months of sales. Four report pages: where we stand, how each store's week went, where growth comes from, and whether delivery pays. Data to 30 September 2026.

Demo data: Bean & Brew, a made-up coffee chain. Rebuilt in HTML from my Power BI report.

Year

Of target
Stores inside normal
Months inside normal

2026 · Jan to Sep · All 8 stores

2 of 6 measures outside their normal range.

  • Net sales −26.2K vs target · ▼ 0.3 pts since Aug
  • Last 4 weeks −5.9% vs plan · usually −2.6%

Pulse: figures

Net sales

599,607

Target 625,800

Below target, usual pace

Gross margin

71.9%

Last year 71.8%

Above normal, good

Avg order value

29.95

Last year 30.14

Within normal

Discounts, % of gross

1.97%

Last year 2.01%

Within normal

Delivery share

19.3%

Last year 20.0%

Within normal

Mix by category

Coffee is 62% of net sales.

62%12%
  • Coffee370.2K61.7%
  • Food74.8K12.5%
  • Bakery56.6K9.4%
  • Tea49.7K8.3%
  • Smoothies25.0K4.2%
  • Retail15.9K2.6%
  • Other7.6K1.3%
Net sales by category, 2026 · Jan to Sep: Coffee 370.2K, Tea 49.7K, Bakery 56.6K, Food 74.8K, Smoothies 25.0K, Other 7.6K, Retail 15.9K.

Off target by accident, or by design?

Each month against target, with last year’s normal range

By design: 89% of the gap is our normal pace.

Target
Variance against target each month, with last year's normal range −5.4% to −2.0%: 2025-01 −4.1%, 2025-02 −3.4%, 2025-03 −6.0%, 2025-04 −1.4%, 2025-05 −4.8%, 2025-06 −5.4%, 2025-07 −3.5%, 2025-08 −2.0%, 2025-09 −4.2%, 2025-10 −1.9%, 2025-11 −1.5%, 2025-12 −6.1%, 2026-01 −5.6%, 2026-02 −2.1%, 2026-03 −2.3%, 2026-04 −2.7%, 2026-05 −9.0%, 2026-06 −3.3%, 2026-07 −0.7%, 2026-08 −4.1%, 2026-09 −6.3%.

9 of 9 months below target. The plan asks 3.7 pts more than we usually reach.

  • Built into the plan 23.3K
  • Went wrong this year 2.9K
Gap to target −26.2K: −23.3K built into the plan, −2.9K went wrong this year.

Gap to target by store

Tap a store to filter the page

Downtown and Old Town hold 45% of the gap.

Gap to target by store, 2026 · Jan to Sep: Downtown −7.5K, Harbor View −2.4K, Old Town −4.4K, Tech Park −3.7K, Airport T1 +0.8K, University −4.3K, Lakeside −2.4K, Central Mall −2.3K.

Act first: decisions ranked by money

7 decisions. Owners are suggested.
Decisions ranked by the money involved, with evidence and a suggested owner
What it isOpen
Re-base the plan, or fund the growth it assumesThe plan sits 3.7 pts above our normal pace23,314Gap built into the planFinance and leadership
Renegotiate delivery commissionEach 5 pts is 5.8K. Delivery keeps 52% vs 72% in store23,158Commission paidPartnerships
Target discounts instead of spreading themEvery loyalty tier gets the same mix. Spread 1.5 pts12,047Discounts givenMarketing
Reprice or bundle Chicken Wrap and Fruit SmoothieGrowing slower than the company (+10.6%)5,565Lost against the company paceMenu team
Recover Old Town2 of the last 4 weeks below its normal range. −18.6% vs plan1,852Short of plan, last 4 weeksArea manager, South
Recover Tech Park3 of the last 4 weeks below its normal range. −15.8% vs plan1,434Short of plan, last 4 weeksArea manager, South
Capture customer ID on delivery orders54% of delivery sales can't be called new or movedNo amountData gap, no amountOps and IT