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.

Role
Guest Experience & Digital Operations Lead
Period
2024 – 2025
Stack
Tableau, Python, Menu engineering
Evidence
Modelled
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

  1. Point of sale. Sales, items, covers and guests.
  2. Excel and Sheets. I clean and summarise the data.
  3. Tableau views. Busy hours, item margin and guest spend.
  4. Manager. Reads the views each week.
  5. Staffing. Shifts set from the busy hours.
  6. Menu. An item cut or repriced.
  7. 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.

Tableau calculated field · menu class
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"
END