The Microsoft Power BI collection of software, apps and services helps analyze your data to uncover insights and trends. This course shows you how to link and model data in Power BI and to create visual reports that reveal data insights so that better business decisions can be made. The class focuses on the Power BI desktop client and includes an introduction to the Power BI web app. This class will cover the purposes and basic functions of the core Power BI components; using the Power BI desktop client and web app; connecting to a data source using either the Power BI desktop client or the web app; as well as modeling data and creating reports and visualizations. 

• Excel 2019: Level 2 or equivalent knowledge  

This course schedule may be modified by the instructor based on the needs of the class. 

Lesson 1: Getting started 

• An introduction to Power BI 
• Working with Power BI Desktop files 
• Connecting to Data Sources with Power BI Desktop 
• Creating a Report with Visualizations 
• Doing more with Visualizations 

Lesson 2: Working with data 

• Transforming and sanitizing data 
• Using the Query Editor 
• Data modeling 
• Managing relationships 

Lesson 3: Working with Reports and Visualizations  

• Managing Report Pages 
• Changing Report View options 
• Working with Visualizations 
• Adding Static Objects to a Report 

Lesson 4: A closer look at Visualizations 

• Matrixes, Tables, and Charts 
• Maps 
• Cards, Gauges, and KPIs 
• Slicers 

Lesson 5: Introduction to the Power BI Web App 

• Getting started 
• Connecting to Data Sources with the Power BI Web App 
• Using Workspaces, Dashboards, and Reports 
• Creating custom Dashboards 
• Power BI Web App features