Power BI Bootcamp with Ted Pattison

Power BI Bootcamp is fast-paced 3-day training course designed to get students up to speed on building and deploying custom analytics and reporting solutions using Microsoft’s rapidly evolving Power BI platform. Students will work through in-depth, hands-on lab exercises to reinforce the benefits of using a project-based approach for creating custom analytics solutions using Power BI Desktop. The course also teaches students about team-based development in Power BI and how to use group workspaces to move a projects and its assets from a design/development environment into production use in the Office 365 environment.

Students will learn what can be accomplished with the Power BI service using just a browser as well as which types of project work must be completed using Power BI Desktop. Students will learn how to use Power Query to import and transform data as it loads into a project’s data model. The course also teaches students how to use Power Pivot and the DAX programming language to extend the data model to support rich data analytics and reporting. Students will additionally learn how to create reports and dashboards as well as how to deploy a project using dashboard sharing and using organizational content packs.

Along the way, students will learn how to create and manage custom Power BI solutions which analyze, report on and refresh data extracted from SharePoint lists and SQL server databases in an on-premises environment. Students will also learn how to create reports and dashboards which target mobile devices. The course concludes by examining how to integrate the Power BI platform together with Excel 2016, Excel Online and SQL Server Reporting Services 2016. Students will also be introduced to the new Power BI support for using the R programming language to build custom solutions that use predictive analysis.