Corporate KPI Dashboard + Mobile App

The dashboard can be viewed on both Power BI Web and the Mobile App.

Following demo showcases Mobile layout towards the end.

Problem Statement

This dashboard provides the heads of Singapore SportsHub with comprehensive insights into event metrics, including the number of events, attendance figures, total footfall, and EBITDA for their various venues on a monthly and year-to-date basis. It enables SportsHub to assess the performance of each venue while offering a quick overview of upcoming events, ticket sales, and venue capacities. The summary page highlights SportsHub's profitability and identifies areas for improvement.

Steps followed

• Step 1: Load data into Power BI Desktop from various sources. The footfall and event data were sourced from Azure Synapse DB, while financial data was retrieved from monthly Excel files stored in a shared folder managed by the Finance Team for enhanced data security.

• Step 2: Open the Power Query Editor to append all monthly finance files into a single consolidated file for reporting purposes.

• Step 3: In the Model View, establish a data model by connecting the various tables based on common keys. Additionally, create a Date table utilizing time intelligence functions.

• Step 4: In the Report View, select a theme under the View tab to maintain visual consistency across the dashboard.

• Step 5: Create separate pages within the report for a summary and detailed analysis of footfall, events, and financial KPIs.

• Step 6: Add visual filters (slicers) for "Year" and "Month" to the left pane of each page, allowing users to filter data interactively.

• Step 7: On the Summary Page, incorporate two card visuals for each KPI — one displaying monthly figures and the other showing year-to-date (YTD) values (e.g., Monthly Footfall and YTD Footfall).

• Step 8: Create measures and calculated columns for Monthly and YTD KPIs. For instance, the following DAX expression was written to generate a new column:

  Footfall YTD = TOTALYTD(Sum(Footfall[Footfall]), 'Date'[Date])

  

  • Step 9: Repeat similar steps to create measures for the remaining KPIs, ensuring consistency and accuracy across all calculations.

  • Step 10: Publish the completed report to Power BI Service for distribution and accessibility to stakeholders.

Snapshot of Dashboard

• KPI Summary Page

• Footfall Page

  

• Event Attendance Page

  

• Finance Page

  

Data Model