Power BI Course

Description

Power BI Course

Microsoft Power BI is a powerful data visualization tool, giving your team dynamic reporting to make better decisions.
Our training allows you and your team to make the most of the strategies and solutions, so you can bring your everyday processes in-house.
This ensures your data is taken care of by a team that knows your business and industry intimately.

Introduction to Power BI
Your entrance into Power BI. This in-person instructor-led training course will provide introduction to the tool, its applications, and train users on how to build their reports from scratch. As the name suggests, this is suitable for anyone who is new to Power BI and would like to start their journey in mastering the tool.
This course will be completed in 12 hours, comprising of 4 sessions.
Learners are involved in end-to-end solutions using a combination of lectures and dynamic, hands-on labs to reinforce concepts.

• Import, transform, and cleanse data using Power Query Editor
• Build and optimize a data model for self-service reporting
• Build, publish, and share visualizations with end-users

About Instructor

Murtaza ul Hasan

Murtaza is a Business Intelligence Specialist with over 10 years demonstrated experience solving business problems by converting data into visual, useable information. Currently employed at the University of Calgary as a Business Intelligence Specialist, he has developed training materials and trained staff and other learners to use Power BI. With a specialization in financial management reporting, Murtaza automated existing processes to produce meaningful reports using the Power BI Platform. Being a Microsoft certified Power BI developer with extensive hands-on experience, he has helped develop new procedures, Power BI governance, and has successfully trained others to use Power BI. Murtaza has been told many times that he has a gift for teaching Power BI and for making the learning practical and relatable.

Course Outline
LEVEL I – INTRODUCTORY

This training will provide introduction to the tool, its applications, and train users on how to build their reports from scratch. As the name suggests, this is suitable for anyone who is new to Power BI and would like to start their journey in mastering the tool.

This course will be completed in 12 hours, comprising of 4 sessions.

DESIRED LEARNING OUTCOME
At the end of this training, users will be able to:
1. Install Power BI Desktop
2. Create their reports using Power BI Desktop, including but not limited to:
o Import data
o Transform data
o Model data
o Create visuals

3. Use Power BI Service and interact with the Report

LEVEL I – COURSE OUTLINE

Section 01 – Introduction to Power BI

1. Introduction to Business Intelligence and Power BI
2. Parts of Power BI
3. Power BI Desktop vs Power BI Service
4. Creating an account in Power BI Service
5. Overview of Power BI Service Interface
6. Installing Power BI Desktop Application
7. Overview of Power BI Desktop Interface

Section 02 – Creating Report with Power BI Desktop

1. Understanding ETL process (Extract, Transform and Load)
2. Extract – Connecting data from different datasources
3. Transform – Shape data using Power Query
4. Load – Loading data into Power BI
5. Data Modeling fundamentals
6. Creating Reports using visuals

Section 03 – Consume Report with Power BI Service

1. Publishing a report to Power BI Service
2. Core Power BI Service blocks (Reports, Dashboards, Datasets)
3. Reports vs Dashboards
4. Report Reading View vs Report Editing View
5. Interacting with Reports and Dashboards
6. Introduction to Power BI Apps

Section 04 – Hands on Training – Sample Project

1. Create a Power BI Report from scratch
2. Publish report to Power BI Service
3. Create Dashboard
4. Interact with the report in Power BI Service