Skip to content
NexBI
HospitalityRecreated from a real Power BI project · synthetic data

Restaurant Group Analytics

Sales, covers, food cost and tips for a nine-location restaurant group — three report pages on one shared data model.

  • Slicers for location, year, month and channel
  • Click a weekday or a location to cross-filter
  • Actual vs theoretical food cost, split into waste and unexplained variance
  • Transparent tip-out and tip-pool logic
NexBI demo · Power BI report recreated for the web · synthetic data

Sales & Covers

Data as of 31 Oct 2026 · Refreshed daily

311K

Covers

109K

Checks

€191.31

Avg check

0.96

Seat turns per day

32.3%

Beverage mix

8.7%

Takeaway & delivery

78

Avg minutes at table

Covers by weekday

Covers by hour of arrival

Sales by payment method

€20.8MTotal
  • PIN / debit€11.9M · 57.4%
  • Credit card€6M · 28.9%
  • Cash€1.68M · 8.1%
  • Invoice€1.17M · 5.6%

Covers by location and weekday

LocationMonTueWedThuFriSatSunTotal
Harbor House4,2574,5275,0655,9077,7318,9607,31943,766
Marlow2,2202,3362,6983,0244,0734,4173,86722,635
Copper Grill3,7073,9074,6155,1796,7777,7736,54438,502
Olive Row4,3774,6195,4876,1518,1378,9777,74645,494
Saltwater North2,8123,1053,4193,9115,2015,8004,95529,203
Saltwater South2,5372,7193,0543,5564,5955,2454,47126,177
Pier Nine3,6483,9864,3915,1246,6577,4186,42137,645
Blue Fin3,1563,4223,8354,3405,6586,4815,45132,343
Sunday Club3,4203,5984,0314,6955,9837,1226,06034,909
Total30,13432,21936,59541,88754,81262,19352,834310,674

Average spend per cover by concept

BeachFine diningGrillItalianOyster barSeafood

Tip: click bars and table rows to cross-filter. All figures are synthetic.

Behind the dashboard

Read how this report was designed and built.

Read the case study

Let’s turn your data into decisions.

Tell us what you need to see. We reply within one business day with next steps — no sales pitch.