SharePoint Training Courses Icon
Microsoft Server Training Courses Icon
Data Analyst Training Courses Icon

Microsoft Power BI Boot Camp


3 Days
Classroom Session   |  
4 Days
Live Online

IIBA (CDU)

ASPE is an IIBA Endorsed Education Provider of business analysis training. Select Project Delivery courses offer IIBA continuing development units (CDU) in accordance with IIBA standards.

NASBA (CPE)

NASBA continuing professional education credits (CPE) assist Certified Public Accountants in reaching their continuing education requirements.

PMI (PDU)

Select courses offer Leadership (PDU-L), Strategic (PDU-S) and Technical PMI professional development units that vary according to certification. Technical PDUs are available in the following types: ACP, PBA, PfMP, PMP/PgMP, RMP, and SP.

NASBA
NASBA
24.00 CPEs

Expertise Level: Intermediate
Certification
Classroom Registration Fees
Individual:
$1995.00
Group Rate:
$1795.00
(per registrant, 2 or more)
Live Online Registration
Live Online:
$1995.00
Private Onsite Package

This course can be tailored to your needs for private, onsite delivery at your location.

Learn More About Enterprise Team Training

Overview

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 needs
Upcoming Dates and Locations
Guaranteed To Run
Apr 24, 2017 – Apr 27, 2017    12:00pm – 5:30pm Live Online
12:00pm – 5:30pm
Register
May 15, 2017 – May 18, 2017    12:00pm – 5:30pm Live Online
12:00pm – 5:30pm
Register
Jun 19, 2017 – Jun 22, 2017    12:00pm – 5:30pm Live Online
12:00pm – 5:30pm
Register
Jul 24, 2017 – Jul 27, 2017    12:00pm – 5:30pm Live Online
12:00pm – 5:30pm
Register
Aug 21, 2017 – Aug 24, 2017    12:00pm – 5:30pm Live Online
12:00pm – 5:30pm
Register
Sep 18, 2017 – Sep 21, 2017    12:00pm – 5:30pm Live Online
12:00pm – 5:30pm
Register
Oct 23, 2017 – Oct 26, 2017    12:00pm – 5:00pm Live Online
12:00pm – 5:00pm
Register
Oct 23, 2017 – Oct 26, 2017    12:00pm – 5:30pm Live Online
12:00pm – 5:30pm
Register
Nov 27, 2017 – Nov 30, 2017    12:00pm – 5:00pm Live Online
12:00pm – 5:00pm
Register
Nov 27, 2017 – Nov 30, 2017    12:00pm – 5:30pm Live Online
12:00pm – 5:30pm
Register
Dec 18, 2017 – Dec 21, 2017    12:00pm – 5:00pm Live Online
12:00pm – 5:00pm
Register
Dec 18, 2017 – Dec 21, 2017    12:00pm – 5:30pm Live Online
12:00pm – 5:30pm
Register
Course Outline
  1. What is Business Intelligence
    1. Evolution of Business Intelligence
    2. Common Difficulties of BI Systems
    3. Benefits of Microsoft BI Solutions
    4. Summary of the BI Stack Components
    5. What’s new
    6. Hardware/Software Requirements
    7. Licensing Options
    8. Edition Comparison
  2. Power Query & Excel
    1. Overview of Capability
    2. System Requirements
    3. Power Query Ribbon
    4. Online Search
    5. Creating Queries
    6. Combining Queries
    7. Managing Queries
    8. Advanced Scenarios
  3. PowerPivot
    1. Overview
    2. Visual Data modeling
    3. Combining Data from many Sources
    4. Interactive Slicers
    5. OLAP Data Modeling
    6. Data Modeling for Analysis
    7. DAX Evaluation Concepts
  4. Power BI Dashboards & Designer
    1. The Power BI service explained
    2. Power BI Mobile Apps
    3. Power BI Admin Center
    4. Configuring Permissions
    5. Setting up the Data Management Gateway
    6. Connecting On-Premise Data Sources to the Cloud
    7. Managing Dashboards
  5. Power BI Desktop
    1. Overview
    2. Basic Functions of the Desktop tool
    3. Publishing from Power BI Desktop
    4. Connect to Data
      1. Using Excel Data
      2. Connecting to Databases
      3. Connecting to Other Services
    5. Transforming Data
      1. Writing DAX queries
      2. Calculations and Measures
    6. Modeling your Data
    7. Data Visualizations
    8. Creating Reports
  6. Power View
    1. Overview
    2. Connecting Data Sources and Models
    3. Creating data visualizations
    4. Filtering and Highlighting Data
    5. Reports with multiple views
    6. Tuning Performance
    7. Advanced Visualizations
  7. Power Map
    1. Overview
    2. Steps for Geospatial Analysis
    3. Bubble maps, Column maps, Region Maps, and Heat Maps
    4. Interactive and time-play axis
    5. Create and share visual tours
    6. Adding multiple layers
    7. Controlling visual elements and controls
    8. Scenes and Tours
    9.  
  8. Excel Services
    1. Overview and Components
    2. Configuration
    3. Using the WebPart
  9. SharePoint Integration
    1. The SharePoint Business Intelligence Center
    2. Publishing Dashboards to SharePoint
    3. Utilizing Business Connectivity Services
  10. Summary
    1. Choosing the Right Tool
    2. 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

Who should attend
  • Analysts
  • Database Administrators
  • Project Managers
  • Senior Business Intelligence Architects and Consultants
  • Senior Business Analysts
  • Anyone responsible for implementing BI.

Yes, this course looks perfect for my needs!

Download the brochure