Course Description
Microsoft Power BI Boot Camp
This 3-day instructor led course will teach how to use the entire Power BI and Power BI Desktop toolset as your business intelligence platform. You'll learn how to implement solutions using the Power Query, PowerPivot, PowerView, Power Map, Power BI, Power BI Desktop, and Excel Services for SharePoint.
This class is packed with hands-on labs to re-enforce class topics and provide you with the skills to successfully create impressive dashboards, reports, and other business intelligence solutions. You'll learn best practices for implementing Power BI solutions and practical ideas for implementing the solutions within you organization.
Companies today generate enormous amounts of valuable information, but often have poor reporting capabilities – inhibiting the sharing of key information. This course will teach you how to provide executives, managers, and your entire staff with insights into your data through state-of-the-art business intelligence solutions built on the Microsoft Power BI and Office 365 platform. BI has never been more accessible and capable before! This courses teaches you everything you need to know to implement BI solutions using, Power Query, PowerView, PowerPivot, Power Map, Excel Services, and Power BI.
Make better decisions and provide strategic information to the entire organization with the solutions you build!
Obtain a deep understanding of the entire Microsoft BI stack
Surface Analysis Services cubes via Power BI features
Learn how to connect on-premise data sources to the cloud
Learn how to build an enterprise Data Catalog to share queries
Implement scorecards, dashboards, and KPIs
Understand the capabilities of PowerPivot and how to analyze data with PowerPivot
Integrate data from many different external data sources
Learn best practices for implementing effective, high-performing BI solutions
Learn how to provide intuitive ad-hoc reporting for business users by implementing Power View
Learn the benefits and limitations of each BI tool and which ones will work best for your needsPower BI Boot Camp
Substitution & Cancellation Policy:
You may cancel or reschedule up to 21 days prior to the start date of the class at no penalty. For any cancellation or reschedule requests within 21 days, the full course tuition is still due and not eligible for refund. Any paid tuition will be credited towards a future class and must be used within 12 months.
*Partner delivered courses may be subject to different cancellation terms
Agenda
- What is Business Intelligence
- Evolution of Business Intelligence
- Common Difficulties of BI Systems
- Benefits of Microsoft BI Solutions
- Summary of the BI Stack Components
- What’s new
- Hardware/Software Requirements
- Licensing Options
- Edition Comparison
- Power Query & Excel
- Overview of Capability
- System Requirements
- Power Query Ribbon
- Online Search
- Creating Queries
- Combining Queries
- Managing Queries
- Advanced Scenarios
- PowerPivot
- Overview
- Visual Data modeling
- Combining Data from many Sources
- Interactive Slicers
- OLAP Data Modeling
- Data Modeling for Analysis
- DAX Evaluation Concepts
- Power BI Dashboards & Designer
- The Power BI service explained
- Power BI Mobile Apps
- Power BI Admin Center
- Configuring Permissions
- Setting up the Data Management Gateway
- Connecting On-Premise Data Sources to the Cloud
- Managing Dashboards
- Power BI Desktop
- Overview
- Basic Functions of the Desktop tool
- Publishing from Power BI Desktop
- Connect to Data
- Using Excel Data
- Connecting to Databases
- Connecting to Other Services
- Transforming Data
- Writing DAX queries
- Calculations and Measures
- Modeling your Data
- Data Visualizations
- Creating Reports
- Power View
- Overview
- Connecting Data Sources and Models
- Creating data visualizations
- Filtering and Highlighting Data
- Reports with multiple views
- Tuning Performance
- Advanced Visualizations
- Power Map
- Overview
- Steps for Geospatial Analysis
- Bubble maps, Column maps, Region Maps, and Heat Maps
- Interactive and time-play axis
- Create and share visual tours
- Adding multiple layers
- Controlling visual elements and controls
- Scenes and Tours
-
- Excel Services
- Overview and Components
- Configuration
- Using the WebPart
- SharePoint Integration
- The SharePoint Business Intelligence Center
- Publishing Dashboards to SharePoint
- Utilizing Business Connectivity Services
- Summary
- Choosing the Right Tool
- Setting up your own Test Environment
Hands on-Labs:
Labs 1 and 2: Setting up your environment
Business Intelligence Center
Lab 3 - Create the Business Intelligence Center Site
Power Query
Lab 4 - Importing Data from External Data Sources
Lab 5 - Transforming Data with Power Query
Lab 6 - Custom Columns
Lab 7 - Appending Queries
Lab 8 - Duplicating Queries
Lab 9 - Merging Queries
Lab 10 - Troubleshooting and Cleaning Data
Power Pivot
Lab 11 - Adding Data
Lab 12 - Creating Relationships
Lab 13 -Tuning the Data Model
Lab 14 - PivotTables
Lab 15 - Slicers and Timelines
Lab 16 - PivotCharts
Lab 17 - Larger Datasets with Contoso data
Lab 18 - Calculated Columns
Lab 19 - Related Columns with DAX
Lab 20 - Hierarchies
Lab 21 - Measures
Lab 22 - Key Performance Indicators (KPI)
Power BI
Lab 23 – Creating a Simple Dashboard
Lab 24 - Sharing a Report
Lab 25 – Advanced Data Connections
Lab 26 - Setting up Data Refresh
Lab 27 – Using Visualizations
Lab 28 - Using Power BI Q&A
Lab 29 - Using Q&A Synonyms
Power View
Lab 30 -Creating Basic Tables
Lab 31 - Formatting Reports
Lab 32 - Matrix Visualization
Lab 33 - Adding Data and Filters
Lab 34 - Bar, line, and pie charts
Lab 35 - Chart Multiples
Lab 36 - Scatter Charts
Lab 37 - Map Visualizations
Lab 38 - Slicers
Lab 39 - Card Visualizations
Lab 40 - Navigation Tiles
Power Map
Lab 41 - Creating a Tour
Lab 42 - Formatting Tools
Lab 43 - Scenes
Lab 44 - Adding Charts
Lab 45 - Data Over Time
Lab 46 - Screenshots and Videos
Excel Services
Lab 47 - Using the Excel Services Web Part
Lab 48 - Using Named Items
Lab 49 - Excel Dashboard using a Data Model
Lab 50 - Create Territory Sales Report
Lab 51 - Product Orders and Sales Report
Lab 52 - Adding Filters
Lab 53 - Publishing to SharePoint