Reporting and Analytics with Power BI Desktop

COURSE CONTENT

Overview

Reporting and Analytics with Power BI Desktop is a course that teaches you how to use Power BI, a suite of business analytics tools. You'll learn how to connect to various data sources, simplify data preparation, and perform ad hoc analysis. The course covers Power Query, DAX, Data Modeling (Power Pivot), and M, and teaches you how to automate your reporting needs. You'll also learn how to create stunning reports and dashboards that give you a complete view of your business. You'll use Microsoft's free Power BI Desktop application to build a reporting model from scratch and then share insights with others by publishing the report to the powerbi.com service.

Learning Outcomes:

By the end of the course, participants will have gained the following skills:

• Understand the Power BI Technologies and ecosystem
• Ability to work with Power Query to simplify data preparation
• Use a framework for building a Data Model to organize data
• Assess various data visualization options in Power BI Desktop to create engaging reports
• Understand the DAX formula language and use it to create complex calculations
• Create typical business reports using DAX formulas that are built on a Power BI Data Model
• Incorporate budget data into reporting by building budget variable analysis reports
• Create a complete reporting solution from scratch in a full-day case study session

Day 1:

• Introduction to Power BI Desktop
• Building your first report
• Framework for building a data model
• Building a data model in Power BI Desktop
• Review of DAX formula language
• Time intelligence calculation in DAX
• Utilizing quick measures

Day 2:

• Comparisons to budget
• Power BI standard and custom visualizations
• Introduction to Power Query
• Practice case study application
• Overview of advanced features in Power BI
• Publishing to PowerBI.com