Course Overview
This Intermediate Power BI training course builds on the Introduction class, teaching the advanced dashboard skills participants need for building more sophisticated data visualizations. During class, students connect to various data sources, shape, and combine data, work with reports, and create and share more sophisticated dashboards. Attendees’ own data is eagerly incorporated into the class if available.
Key Learning Areas
- Navigate the Power BI environment
- Plan Power BI projects with organization goals in mind
- Use the Power BI Query Editor for a wide range of operations, including joining multiple data sources
- Connect to diverse data sources and transform data
- Develop DAX measures and implement security roles
- Generate visualizations with Python and R
- Build more sophisticated Power BI dashboards
- Work with paginated reports
- Use Power Automate with visualizations
- Work with Power BI Apps
- Integrate Power BI with Office 365
Course Outline
Introduction
Data Modeling Advanced Topics
- Aggregation & historical reporting
- Working with RLS
- Optimizing models
In-Depth Power Query Usage
- Working with M
- Importing data from an external site
- Using functions and parameters
Building Visualizations
- Using quick measures
- Adding parameters for "What If" reporting
- Advanced slicer techniques
- Adding interactive functionality
- Using bookmarks and page navigation
Using More DAX
- Conditional formatting with DAX
- Modifying report context with DAX
- Handling time functions
- Working with semi-additive measures
- Using DAX for dynamic reports
Scripting with R & Python in Power BI
- Introduction to scripting
- Building a visualization with Python
- Building a visualization with R
- Using scripts in Power Query
Paginated Reporting
- Understanding paginated reports
- Opening a dataset
- Creating a data source
- Building a report
- Publishing a report
Using Power Automate on Visualizations
- Review Power Automate
- Add a widget to a visualization
Working More with the Power BI Service
- Discuss security options
- Using Power BI Apps
- Office 365 integration
- Custom application integration
Prerequisites
Participants should have attended the Introduction to Power BI class or have equivalent experience.