Paris Baguette × BI Consulting Services
Demonstration · Illustrative data · BI Consulting Services

Daily Flash — Café Performance

Your Excel Daily Flash, rebuilt as a 4-page Power BI report on top of Toast POS and your ERP — refreshed overnight, emailed at 6:00 AM, and filterable by region, café cohort and day view.

Prepared for Peter · September 2026 Franchisor FP&A view · North America
Anchored to 300+ cafés across 29+ states, ~600 in development, AUV above $3M — 1851franchise.com, Q1 2026 update. Sales figures below are illustrative.
Toast close of business Wed 16 Sep · refreshed Thu 17 Sep 05:40 ET

Page 1 · Daily Flash

Net sales by day — actual vs plan vs prior year

1–16 September 2026, filtered set · selected day view shaded

ActualPlanPrior year (comp-base growth applied to scope)

What this board answers

The three questions in the 6:00 AM email

Page 2 · Café ranking

40-café illustrative sample of the 300+ network

The bakery case — every café as a tile, shaded by plan attainment

One shelf per region · tile width = trailing-12-month sales run-rate · colour = net sales vs plan for the selected day view

< 92% of plan92–98%98–102%102–108%> 108%

AUV run-rate vs the $3M benchmark

Trailing-12-month net sales, annualised for cafés open less than a year · top 8 and bottom 5 of the filtered set

Mature (2+ yrs)Opened 2025Opened 2026$3.0M benchmark

New-café ramp by cohort

Average AUV run-rate per cohort with café count · 100+ openings planned for 2026

Page 3 · Product mix

Toast item-level data · category × daypart

Category share by daypart

Net sales share of bread, pastry, cake and beverage for the selected day view

BreadPastryCakeBeverage

Category totals

Net sales, share and vs plan for the filtered set

Page 4 · Ops & pipeline

Labour from the ERP · openings from development tracking

Labour % of net sales by region

Scheduled labour cost ÷ net sales, selected day view · 28% target

Store-count pipeline — open vs in development

Network-level counts by region (illustrative split of the published 300+ open / ~600 in development)

OpenIn development

Ask the data · private AI over the Daily Flash model

Peter:
Also from BI Consulting Services

Private AI on your own server

The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.

Private AI Servers — slide 1 of 14
Private AI Servers — slide 2 of 14
Private AI Servers — slide 3 of 14
Private AI Servers — slide 4 of 14
Private AI Servers — slide 5 of 14
Private AI Servers — slide 6 of 14
Private AI Servers — slide 7 of 14
Private AI Servers — slide 8 of 14
Private AI Servers — slide 9 of 14
Private AI Servers — slide 10 of 14
Private AI Servers — slide 11 of 14
Private AI Servers — slide 12 of 14
Private AI Servers — slide 13 of 14
Private AI Servers — slide 14 of 14

Questions? Book 30 minutes: calendly.com/powerbiconsultingservices/30min