Deep Dive into Power BI is an intensive 2-day training course designed to get students up to speed on building and deploying custom solutions using Microsoft’s rapidly evolving Power BI platform. Students will learn the benefits of using a project-based approach for creating custom BI solutions. The course also teaches students about the tools and techniques that are used to move a Power BI project through its lifecycle to the point where the project can be deployed into a production tenant 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 and Excel Online.
1.Introduction to the Power BI Platform
2.Extracting and Transforming Data using Power BI Desktop
3.Building a Data Model using Power BI Desktop
4.Modeling Data for Time Intelligence and Budgeting
5.Designing and Publishing Reports
6.Designing and Publishing Dashboards
7.Managing Gateways and On-premises Data
8.Integrating Power BI with Excel 2016 and Excel Online
Instructor: Ted Pattison of Critical Path Training
Audience: Business Users, Analysts and Data Wranglers
Prerequisites: Students should already be comfortable working in the Office 365 environment.
Preparation: Attendees need to bring a laptop that runs Windows so they can install Power BI Desktop and work on lab exercises. Each student will get a student manual containing the lab exercises.
Delivery Method: Classroom-based training with students attending in person