Power BI Master Class

Power BI Master Class is an intensive, hands-on training class designed for people who already have hands-on experience with Power BI Desktop and the Power BI Service and are ready to move their Power BI builder skills to the next level. Students will learn best practices for extracting data using advanced queries and dataflows, building data models with DAX and creating visualizations using reports ad dashboards. This course has also been designed to prepare student to pass Microsoft Certification Exam DA-100: Analyzing Data with Microsoft Power BI.

All the essential Power BI concepts and techniques discussed in lectures are reinforced through hands-on lab exercises in which students will move through the actual steps required to build dataflows as well as data models that are deployed as shared datasets. Students will also learn how to design interactive reports using slicers, bookmarks and drillthrough pages. The course discusses essential differences between reports and dashboards and also examines the strengths and weaknesses between imported datasets and DirectQuery datasets.

This course discusses distributing Power BI content and administrating the Power BI environment at the tenant-level. Students will learn when and how to install an on-premises data gateway to provide connectivity to on-premises data sources such as SQL Server. The course demonstrates how to configure tenant-level settings for Power BI and how to monitor report and dashboard usage within an organization using Power BI audit logs. Along the way, students will learn how to configure row-level security (RLS) and how to leverage the R data analytics platform to extend a Power BI Desktop project using R script visuals.