Power BI Training
Three Day Power BI Course
Introduction
This three day training course consists of hands on exercises providing knowledge on designing Power BI reports / dashboards, importing and shaping data, understanding the Power BI Service as well as Management and Security of the Power BI environment. The training will consist of explanation of concepts and techniques, demonstration and exercises throughout and a practice time at the end.
Topics covered
Attendees will perform instructor-led exercises that cover the following elements of Power BI
DAY 1
INTRODUCTION
Course Outline
Overview of BI Principles & Best Practice
Power BI overview
GETTING STARTED WITH POWER BI
Data sources that Power BI can connect to
Direct Connect vs Import
Importing data
Creating a simple visualisation
Creating a visualisation from Q&A
Visualisation interaction
Hierarchies and drill down
Drill through
Creating Measures
Duplicating report pages
Publishing the results
SHAPING THE DATA
Transformation capabilities – Query Editor
The Power BI Data Model
DAY 2
THE POWER BI SERVICE
Data Refreshes
Power BI Gateway
Scheduling Refreshes
Sharing the data model
BEST PRACTICE
What to do where
Granularity & aggregation
Columns & Measures
Naming Objects and Transformation Steps
Structuring the data model
Structuring the data fields and measures
Testing
DASHBOARDS
Creating a new dashboard & pinning tiles
Pinning a live page
Dashboard Q & A
DAY 3
MANAGEMENT & SECURITY
Publishing a report
Sharing a dashboard
Deleting shared dashboards and published reports
Usage
Row Level Security
Power BI Premium features
PRACTICE
Build dashboard from a data set
Rebuild/ improve existing dashboards
Prerequisties
Attendees should:
– Have an understanding of basic database theory or working with pivot tables in Excel
– Bring their own device with Power BI installed
– Have a Power BI account