Power BI Bootcamp

In just over 2 years Power BI has become the most popular self-service business intelligence tools out there. The ease at which business users can create and share their own reports results in more meaningful and timely reports
 
Course details
Duration 3 Days
Cost R6 000 Per Person
Audience This course is intended for people who have had some experience using Power BI or other reporting tools such as Excel, Reporting Services or tableau. Experience writing TSQL or Excel formula is helpful but not necessary.
Schedule View shedule or contact us for private training at your offices
 
Module 1 Introduction to Power BI
Why Business Intelligence? Understanding the problem we are trying to solve
The components of Power BI
Versions and licencing of Power BI
First look at Power BI desktop
Lab 1: installing Power BI desktop and signing up on PowerBI.com
Module 2 Importing your data
Introduction to Power Query
Data sources
Cleansing and transforming data
Custom transformation using M
Lab 2: Importing data
Module 3 Modelling your data
Creating relationships
Understanding filters
Introduction to DAX
Calculated Columns and Measures
Filtering and aggregating data
Lab 3: Creating your first data model
Module 4 Visualising your data
Adding Visuals to the report
Creating interactive reports with filtering
Using Themes
Report navigation with Bookmarks and drill through
Using Custom Visuals
Lab 4: Adding visualisations for an interactive report
Module 5 Publishing your report
First look at PowerBI.com
Reports and dashboards
Sharing data with PowerBI Apps
Scheduled refresh and the data gateway
Q&A and Quick insights
Row-level security
Lab 5: Publish the First dashboard to PowerBI.com