Example · Hospitality
Hospitality KPI dashboard: restaurants, gyms, and multi-site operations
Searches such as gym KPI dashboard or restaurant Power BI report are the same job in different clothing: sites, visits or covers, people (trainers, waiters), and money. The dashboard should start from those questions, not from a fitness-app screenshot.
Business problem
A chain — gyms, studios, restaurants, or mixed leisure — needs to see which sites make money, whether occupancy or covers are healthy, and which offers or staff patterns explain the week.
Business questions
What is occupancy or covers versus capacity? Revenue per visit or per cover? Which sites or dayparts lag? For a gym: membership vs visits, trainer utilisation. For a restaurant: average check, food margin, no-shows if you capture them.
KPIs and the model
Facts around visits, bookings, or tickets. Dimensions for site, offer or product, staff, and date. KPIs stay in business words first (occupancy, revenue per visit, utilisation) so DAX is a translation, not the brief.
Dashboard
A network page for all sites, a site page for the manager, and a diagnostic page for mix (membership vs walk-in, lunch vs dinner, class vs gym floor). Generate your own variant in BiDesignLab from your table names — this page is the map, not a locked template.