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