Power BI Certification Bootcamp

Power BI Certification Bootcamp is an advanced 3-day training class designed to prepare students to pass Microsoft certification exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI. During the course, students will gain the real-world skills required to design, deploy, upgrade and monitor reporting and dashboard solutions using the rapidly-evolving Power BI platform. All the essential Power BI concepts and techniques discussed in lectures are reinforced with hands-on lab exercises in which students will move through the actual steps required to build reporting and dashboard solutions and then to distribute those solutions to a wide audience using app workspaces and the Power Bi app model.

This course includes in-depth coverage of the query tools and data modeling tools in Power BI Desktop. Students will learn how to design complex queries and to write advanced DAX expressions to calculate rankings, rolling averages and year-to-year comparisons. 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 the various types of datasets including imported datasets, DirectQuery datasets and LiveConnect 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.