Analytics Tool - Power BI
Build practical data analytics skills with Microsoft Power BI, from connecting and preparing data to developing models and dashboards. This course introduces Power Query, table relationships, and DAX, then brings these skills together through a workshop based on departmental business questions. Participants develop a working dashboard prototype, explore its findings, and consider how to apply the insights in their work. The course scope can also include advanced DAX, performance optimization, and Row-Level Security, depending on the agreed learning needs.
Course at a Glance
| Description | Detail |
|---|---|
| Duration | 2 days; a 1-day foundation program is also available. |
| Format | Classroom workshop. |
| Learning Approach | Practical exercises, dashboard development, and presentation with feedback. |
| Prerequisites | Data connections, Power Query, data modelling, DAX, and dashboard development. |
| Course Output | A working Power BI dashboard prototype for a departmental use case. |
Learning Objectives
By the end of the course, participants will be able to:
- Connect Power BI to relevant data sources.
- Clean and transform data using Power Query.
- Build a data model with appropriate table relationships.
- Use DAX to support analytical calculations.
- Develop a dashboard that addresses departmental business questions.
- Interpret dashboard findings and identify practical next steps.Â
Course Outline
Day 1 — Prepare Data & Build the Foundation
Module 1: Power BI Fundamentals & Data Connections
Explore the Power BI workflow and connect to data sources for analysis.
Module 2: Data Preparation with Power Query
Practice cleaning and transforming data into a structure suitable for reporting and analysis.
Module 3: Data Modelling & Table Relationships
Organize data into a model and establish relationships between tables.
Module 4: Dashboard Development Workshop
Begin building a dashboard based on a departmental business question.
Day 2 — Develop the Dashboard & Apply Insights
Module 5: Analytics Model & Dashboard Workshop
Continue developing the model and dashboard, applying calculations and visuals relevant to the selected use case.
Module 6: Insight Discovery & Action Planning
Explore the dashboard to identify meaningful findings and discuss how they can support business actions.
Module 7: Presentation & Feedback
Present the dashboard, explain its findings, and receive feedback to refine the output.
Optional 1-Day Foundation Program
A focused introduction covering data connections, basic Power Query, introductory data modelling and DAX, followed by a dashboard workshop and presentation with feedback.
Advanced Topics
Advanced DAX, performance optimization, and Row-Level Security can be included according to the agreed course scope and participant readiness.
Who Should Attend
Professionals, analysts, and departmental teams who want to use Power BI to prepare data and build reports or dashboards for their work. The foundation program suits participants starting with Power BI, while the broader program supports those seeking to develop their modelling, calculation, and analytical reporting skills.