COURSES
Here you find details of the Training Modules
POWER BI FOR BEGINNERS (ACCELERATED)
Objectives
Rapidly analyse, transform and present data
Understand the Power BI platform
Set up queries to extract and transform data
Create efficient data models
Design and publish interactive reports
Confidently use basic DAX calculations
Topics
​
MODULE 1
Introduction
Loading Data
Data Modelling
Power Query Fundamentals
Basic M-Language
​
MODULE 2
Power BI Visualisations
Basic Visualisations​
Formatting Visuals
Types of Filters
MODULE 3
DAX Fundamentals
Calculated Columns
Calculated Measures
Power BI Service
Publishing and Sharing Reports
Creating Dashboards
Case Study​ Project
POWER BI FOR BEGINNERS (INTENSIVE)
Objectives
· Rapidly analyse, transform and present data
· Understand the Power BI platform
· Set up queries to extract and transform data
· Create efficient data models
· Design and publish interactive reports
· Confidently use basic DAX calculations
Topics
​
MODULE 1
· Introduction
· Power BI Suite​
· Loading Data (CSVs, Excel, PDF, Google Sheets, Web, Folders)
· Understanding Relational Data Modelling/Relationships
· Power Query Fundamentals
· Cleaning Data​
· Transforming Data
· Basic M-Language
​
MODULE 2
· Power BI Visualisations
· Basic Visualisations​
· Map Visualisations
· Formatting Visuals
· Types of Filters
· Report Visual Interactions
MODULE 3
· DAX Fundamentals
· D​AX Functions
· DAX Calculation Types
· Calculated Columns
· Calculated Measures
MODULE 4
· Power BI Service
· Publishing and Sharing Reports
· Creating Dashboards
MODULE 5
· End-To-End Case Study​ Project
· Build Data Model
· Create Report
· Publish Report
POWER BI FOR DEVELOPERS
***Course Prerequisite***
Completed Power BI For Beginners / Power BI User
​
Objectives
Understand complex data modelling scenarios
Using M to extend the standard data extraction and transformation capabilities of Power BI
Advanced Data Visualisations beyond the basics
​
Topics
​
MODULE 1
M Query
M Syntax
M Query Basics
Variables and Parameters
Expanding Lists
M Query Functions
MODULE 2
Loading Data
Google Analytics, Web Scraping, Power BI Data sets
Query Folding
MODULE 3
Advanced Data Modelling
Filtering
Cross-Filtering and Time Intelligence
Many to Many with DAX
Role Playing Tables with DAX
MODULE 4
Advanced Visualisations
Digital Story Telling
Bookmarks
Selection Pane
Drill through
Visuals with DAX
Custom Visuals
Custom Themes
Measures in Sub Folders
MODULE 5
Advanced DAX
D​AX Variables in Measures
​​What If Analysis
​Dynamic Measures
Financial Measures
​
MODULE 6
Power BI Administration
Data Refresh
Scheduling Data Refresh
Incremental Refresh
Implementing Row Level Security
​
Power BI Embedded
​
End-To-End Case Study​
Build Data Model
Create Report
Refresh Report
POWER BI FOR P6/PMO ANALYSTS
Learning more advanced features in the Visualisation
SAMPLE DATASETS FOR TRAINING
Here are customised sample data to be used during the training sessions
​