18 Oct Academy - Deep Dive into Power BI 2 Day Workshop Oct 2017 Academy - Deep Dive into Power BI 2 Day Workshop Oct 2017 Wednesday, October 18, 2017 (10:00 AM) to Thursday, October 19, 2017 (6:00 PM) (Eastern Time) GoToMeeting Ted Pattison ... Details You're Registered! DescriptionSpeakers 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. Class Dates: Oct. 18 - 19 (10AM-6PM Eastern Time) 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. Course Modules: 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 Level: Intermediate Prerequisites: Students should already be comfortable working in the Office 365 environment. Preparation: Attendees need 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: Group Internet Based Ted Pattison Ted Pattison is an author, instructor and owner of Critical Path Training, a company dedicated to education on Microsoft technologies including SharePoint, Office 365, Windows Azure and Power BI. Ted is a 11-time recipient of Microsoft’s MVP award for SharePoint Server development and for Office 365 development. Since 2014, Ted has worked extensively with the Power BI platform and he teaches technical classes such as Power BI Bootcamp to get business users and analysts up to speed on self-service BI technologies such as Power BI Desktop, Power Query and Power Pivot.