Overview
This practical 2‑day Power BI programme equips delegates with the skills to transform raw data into meaningful, interactive insights. Through hands‑on exercises, real‑world datasets, and guided instruction, participants learn how to import, clean, model, analyse, and visualise data effectively using Microsoft Power BI.
The course bridges foundational understanding with intermediate analytical skills—empowering attendees to design dynamic dashboards, apply DAX for enhanced insights, and publish reports to support data‑driven decision‑making across the organisation. Why Should an Individual Attend?
-
Create professional, interactive dashboards: Gain the skills to design compelling, user‑friendly visual reports that enable clear insights for stakeholders.
-
Improve data quality and reliability: Learn to clean, shape, and transform data to ensure accuracy and consistency for reporting.
-
Strengthen analytical capabilities: Develop confidence in using DAX formulas, calculated columns, and measures to extract deeper insights.
-
Support organisational decision‑making: Empower teams by producing reports that reveal trends, highlight performance, and guide strategy.
-
Enhance efficiency through automation: Automate report refreshes and streamline processes by publishing reports to the Power BI service.
Outcomes
On completion of this course, the delegate will be able to:
-
Understand the Power BI ecosystem, including Desktop, Service, and Mobile apps.
-
Import data from multiple sources and perform data cleaning, shaping, and transformation using Power Query.
-
Build efficient, well‑structured data models and manage relationships between tables.
-
Create calculated columns and measures using DAX, and understand filter context and time intelligence.
-
Design visually appealing dashboards using charts, slicers, filters, images, and formatting techniques.
-
Publish, share, and manage reports securely via the Power BI Service.
Program Outline
Day 1
Module 1: Introduction to Power BI
-
What is Power BI
-
Understanding the Power BI architecture
-
Installing Power BI Desktop
-
Signing up for the Power BI Service
-
Power BI licensing overview
Module 2: Importing Data Using Power BI
-
Loading data from files and databases
-
Removing unwanted rows and columns
-
Transforming data
-
Cleansing and shaping data
-
Using functions and parameters
-
DirectQuery vs Live Query
-
Power Query best practice
Module 3: Building the Data Model
-
Building relationships
-
Working with complex relationships
-
Usability enhancements
-
Data model performance considerations
Day 2
Module 4: Enriching Your Data Model with DAX
-
Creating calculated columns and measures
-
Understanding filter context
-
Time intelligence functions
-
Role‑playing tables
-
DAX best practice
Module 5: Visualising Data
-
Chart types
-
Formatting charts
-
Reports, pages, visual filters, and slicers
-
Designing interactive reports
-
Enhancing reports with text boxes, annotation shapes, and images
Who Should Attend?
-
Business Analysts seeking to deepen reporting capabilities
-
Managers and Executives who rely on data‑driven insights
-
Data Enthusiasts beginning their BI journey
-
IT Professionals supporting BI systems
-
Small Business Owners leveraging data for competitive advantage
-
Engineers, Technologists, Technicians
-
Project Managers
-
Senior Managers
|