Monthly revenue by business unit
BQ1 · Is performance rising, falling or stable?
Revenue by branch
BQ2/BQ3 · Where does revenue come from, Gym or Bar?
Operating profit margin by branch
BQ2/BQ3 · Which branch and unit turns revenue into profit?
Branches needing attention
BQ5 · Exceptions vs. thresholds, selected period
Membership renewal rate by branch (3-month rolling)
Gym · Which branches are losing members?
Bar gross margin and member share of sales
Bar · What did the 15% member discount (from Jan 2026) do?
Bar products by gross profit
BQ4 · Which Bar products contribute most?
Gym revenue by membership plan and service
BQ4 · Which Gym offerings contribute most?
KPI definitions
How every number on this dashboard is calculated
Data-quality log
Issues found in the source exports and how the preparation step treated them
About this prototype
Data: simulated ArmBar operating data, Jan 2025 – Jun 2026, 5 branches. Sources: Gym membership system,
Bar point-of-sale, Finance expense sheet. Pipeline: generate_raw.py → prepare.py (cleaning,
integration, star schema) → this dashboard. Revenue is recorded on a cash basis (membership fees count in the month paid).