This course provides students with an introduction to Microsoft PowerBI by building a foundation for all subsequent courses and learning. The main end-user features of PowerBI are introduced including how to use PowerBI to interact with reports, visualizations and dashboards. Students will learn important end user skills including how to proficiently work in Microsoft PowerBI to connect to data sources, consume content packs and apps, share visualizations, and start to create your own reports and dashboards in the PowerBI service.
No previous experience of Microsoft PowerBI is needed to sit this course. This course applies to end users and provides at foundation for subsequent learning and courses.
This course has been designed to apply to end users of Microsoft PowerBI.
It is recommended that attendees of this course have an existing working knowledge of Microsoft Office, Microsoft Excel and Microsoft Outlook. However, this course assumes no prior knowledge of Microsoft PowerBI.
At course completion
After completing this course, students will be able to:
Module 1: Introduction
This module provides the attendee with an introduction to Microsoft PowerBI.
Lab 1: Setting up your lab environment
Lab 2: PowerBI Orientation
Module 2: Data sources, Content Packs and Apps
This module presents the basic concepts of Data sources, Content Packs and Apps in Microsoft PowerBI. We examine the process to connect to a Data source, consume a Content Pack and App in the PowerBI Service. We also look at the significance of Workspaces in PowerBI.
Lab 1: Connect to a Data source in Power BI
Lab 2: Consume a Content Pack and App
Module 3: Reports and Visualizations
This module presents common skills the end user requires to efficiently interact with and create Reports in Microsoft PowerBI. You will learn how to work with the PowerBI navigation to view Reports as well as create your own Reports from a connected Data source. You will also learn how to create report filters, charts, visualizations and create basic formulas.
Lab 1: Working with Reports
Lab 2: Create a Report
Module 4: Working with Dashboards
In this module we will learn how to work with Dashboards in PowerBI. The differences between Reports and Dashboards will be considered as well as the process to create a new Dashboard from an existing PowerBI Report.
Lab 1: Creating a Dashboard
Module 5: Sharing and Managing Reports and Dashboards
In this module we will learn how to share and manage Reports and Dashboards in Microsoft PowerBI.
Lab 1: Sharing in Microsoft PowerBI
Module 6: PowerBI and Office365
This module looks at the relationship between Microsoft PowerBI and other Office365 apps. We look at the interface differences the end user will need to consider when Microsoft PowerBI is surfaced in SharePoint and Dynamics 365 as well as other features presented to the user within Office365.
Lab 1: Using PowerBI in SharePoint
Lab 2: Using PowerBI in Dynamics 365
Lab 3: Using PowerBI with Microsoft Teams
A working knowledge of Microsoft Office, Microsoft Excel and Microsoft Outlook. However, this course assumes no prior knowledge of Microsoft PowerBI.