Build an Interactive Business KPI Dashboard with Power BI (Guided Project)
43mBeginner2025-07-11
Authors

Maven Analytics

Aaron Parry
Course details
In this course, Aaron Parry—Chief Customer Officer at Maven Analytics—shows you how to build a simple, interactive KPI report to track key metrics and explore high-level trends. Learn how to connect and profile the data as you connect to the source data files, conduct basic profiling and QA tasks, and familiarize yourself with the tables and fields you'll use in this project. Find out how to create a relational model by defining relationships between fact and dimension tables, creating simple hierarchies, and adjusting model properties. Explore ways to enhance the data model and prepare for analysis by defining new measures and calculated fields. Plus, put what you’ve learned to use as you visualize the data and create an interactive report that shows orders, revenue, and profit over time and by product category.
Skills covered
Business AnalyticsBusiness IntelligenceData AnalysisLimited SeriesData ScienceBusiness Analysis and StrategyBusiness Software and Tools
Concepts
Introduction
- Your project briefing
Connect and Profile the Data
- Objective 1 - Connect and profile the data solution guide
Create a Relational Model
- Objective 2 - Create a relational model solution guide
Add Calculated Measures and Fields
- Objective 3 - Add calculated measures and fields solution guide
Build an Interactive Report
- Objective 4 - Build an interactive report solution guide
Conclusion
- Expanding your Power BI dashboard building skills