About this Course

Power BI Bootcamp is fast-paced 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 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.

Course Outline

Module 1: Introduction to the Power BI Platform

• What is Power BI
• Power BI Platforms
• Power BI Versus Excel
• Understanding Data

Module 2: Working with Power BI Data Sources

• Connecting to Different Data Stores
• Transforming Data
• Making Data more useful before reporting

Module 3: Modeling Data

• How to Manage Relationships
• Calculated Columns
• Calculated Tables
• Explore Time Based Data

Module 4: Visualizations in Power BI

• Creating Data Tables
• Charts and Maps
• Filtering Data on Report
• Using Slicers
• Adding Repot Pages
• Drill Downs
• R Integration

Module 5: Working with Excel and Power BI

• Using Power Query and Power Pivot in excel
• Brining Excel Data into Power BI
• Power Views

Module 6: Publishing and Sharing Dashboards

• Using Power BI web interface
• Mobile Devices
• Using Excel in SharePoint