Restaurant margin and guest retention dashboards
Two Tableau dashboards that map each view to a margin, labour or retention decision. The model gives a projected 2% net-margin lift.
- Question
- The owner wanted a 2% higher net margin without a bet on more volume. Which changes in menu, staffing and guest retention give that lift, and in which order?
- Data
- 41,664 modelled transactions over 180 business days. 850 modelled guests with visit history, party size and spend. Menu items with cost and price, staff shifts and daily costs.
- Method
- Menu engineering by margin and popularity against the menu average. Staffed hours against demand by day part. Guest segments by visit frequency and value, with a flag for regulars who stopped coming.
- ProjectionModelled
- A projected 2% net-margin lift from three changes together: a smaller menu with more high-margin items, staffing that follows demand, and a win-back offer to lapsed regulars.
The data is synthetic. I generated it in Python. The dashboards and the method are real. The money figures in the model are not results, so this page does not quote them.
Weekly reporting flow at Autostrada, 2024 – 2025
- Point of sale. Sales, items, covers and guests.
- Excel and Sheets. I clean and summarise the data.
- Tableau views. Busy hours, item margin and guest spend.
- Manager. Reads the views each week.
- Staffing. Shifts set from the busy hours.
- Menu. An item cut or repriced.
- Regulars. Top guests contacted.
My part is the export, the sheets and the Tableau views. The manager reads the views each week and acts in three areas.
Before a rollout
I would test each change on its own for four weeks, and then start the next one. A projected lift is not a result until a test shows it.
IF [Margin Percent] >= WINDOW_AVG([Margin Percent])
AND [Popularity Weight] >= WINDOW_AVG([Popularity Weight])
THEN "Star"
ELSEIF [Margin Percent] >= WINDOW_AVG([Margin Percent])
AND [Popularity Weight] < WINDOW_AVG([Popularity Weight])
THEN "Puzzle"
ELSE "Dog"
ENDMore work
- Stay for the exhale
I turned a yoga teacher's classes into a membership product. I did the strategy, the design, the build and the operations.
- A bank reconciliation that explains each difference
A working sample of the reconciliation method from my years as Operations & Finance Lead. Excel formulas match 119 bank lines to 121 ledger entries, explain each difference and reconcile to 0.00.
- SQL case studies: revenue share, donor segments and a 3NF schema
Three SQL studies on small course datasets. Each one starts with a business question. Every figure is query output that you can run again.