Microsoft Power BI

Course Overview

This 2 day course will give delegates a thorough introduction with practical exercises to using the Microsoft Power BI. This hands on course is ideal for beginners.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Course Syllabus:

Day 1
Getting started with Microsoft Power BI
What is Power BI
Understanding BI
Understanding Microsoft Power BI

Power BI Designer
Basic concepts of Power BI
Using Microsoft Power BI to get data
Types of Microsoft Power BI Datasources
Connecting to Data Sources
Merging Queries

Power BI Reports
Creating Power BI Reports
Saving a Power BI Report
Uploading Power BI Designer files
Difference between Report and Dashboards

Refreshing Data in Power BI
Data sources that support refresh in Power BI
Setting up a refresh schedule

Power BI features in Tablets and Mobile
Accessing your report & dashboards from Mobile

Data Alerts
Setting up Data driven alerts
Using Annotations

Day 2
Transforming and shape your Data
Query Overview in Power BI Designer
Shape and Combine Data in Power BI Designer
Common Query Tasks in Power BI
Using Variables under Queries
Error Handing in Queries

Data Modelling within PowerBI
Create and manage relationships in Power BI Designer
Calculated Columns in Power BI Designer
Measures in Power BI Designer
Data Types in Power BI
Sort by Columns in Power BI Designer

Visualistion types in Power BI
Creating a column chart
Creating Bar, Line and Pie Charts
Creating a scatter chart

Power BI Dashboards
Creating a dashboard
Sharing a dashboard

Working with Natural Language using Q & A
How to ask questions in Power BI Q & A
Preparing a workbook for Q & A