Microsoft Training Icon
Microsoft Server Training Icon
Data Analyst Training Icon

Microsoft Power BI Boot Camp

3 Days Classroom Session   |  
3 Days Live Online
Classroom Registration
Group Rate:
(per registrant, 2 or more)
GSA Individual:
Live Online Registration
Live Online:
Private Onsite Package

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

Request a Private Onsite Price Quote

Professional Credits


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.


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.


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 your 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 course 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.

Do you have a specific Power BI issue or initiative that needs addressing? Learn how our expert Power BI consultants can help. 

In this Microsoft Power BI Training Course, You Will: 

  • Obtain a deep understanding of the entire Microsoft BI stack
  • 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
All Live Online times are listed in Eastern Time Guaranteed To Run
Request a quote for private onsite training Request
Feb 10, 2020 – Feb 12, 2020    8:30am – 4:30pm Indianapolis, Indiana

Courtyard Indianapolis Castleton
8670 Allisonville Road
Indianapolis, IN 46250
United States

Feb 10, 2020 – Feb 12, 2020    9:30am – 5:30pm Live Online Register
Mar 16, 2020 – Mar 18, 2020    8:30am – 4:30pm Live Online Register
Mar 16, 2020 – Mar 18, 2020    8:30am – 4:30pm Reston, Virginia

Attune, formerly Microtek Reston
12950 Worldgate Drive
Monument II Bldg 4th Flr
Herndon, VA 20170
United States

Apr 13, 2020 – Apr 15, 2020    8:30am – 4:30pm Live Online Register
Apr 13, 2020 – Apr 15, 2020    8:30am – 4:30pm Charlotte, North Carolina

Doubletree Hotel Charlotte Airport
2600 Yorkmont Road
Charlotte, NC 28208
United States

May 11, 2020 – May 13, 2020    8:30am – 4:30pm Portland, Oregon

Kinetic Technology Solutions
15495 SW Sequoia Parkway
Suite 100
Portland, OR 97224
United States

May 11, 2020 – May 13, 2020    11:30am – 7:30pm Live Online Register
Jun 15, 2020 – Jun 17, 2020    8:30am – 4:30pm Live Online Register
Jun 15, 2020 – Jun 17, 2020    8:30am – 4:30pm Philadelphia, Pennsylvania

Hyatt Place
440 American Avenue
King Of Prussia, PA 19406
United States

Jul 13, 2020 – Jul 15, 2020    8:30am – 4:30pm Phoenix, Arizona

Dynamic Worldwide
4500 S. Lakeshore Dr
Suite 600
Tempe, AZ 85282
United States

Jul 13, 2020 – Jul 15, 2020    10:30am – 6:30pm Live Online Register
Aug 10, 2020 – Aug 12, 2020    8:30am – 4:30pm Kansas City, Missouri

Centriq Training
1740 W 92nd Street
Kansas City, MO 64114
United States

Aug 10, 2020 – Aug 12, 2020    9:30am – 5:30pm Live Online Register
Sep 14, 2020 – Sep 16, 2020    8:30am – 4:30pm Live Online Register
Sep 14, 2020 – Sep 16, 2020    8:30am – 4:30pm Raleigh, North Carolina

ASPE, a Cprime Company
2000 Regency Parkway
Suite 335
Cary, NC 27518
United States

Oct 13, 2020 – Oct 15, 2020    8:30am – 4:30pm Live Online Register
Oct 13, 2020 – Oct 15, 2020    8:30am – 4:30pm Tampa, Florida

Embassy Suites Tampa Airport Westshore
555 North Westshore Blvd
Tampa, FL 33609
United States

Nov 9, 2020 – Nov 11, 2020    8:30am – 4:30pm Denver, Colorado

Attune, formerly Microtek Denver
999 18th Street
Suite 300 South Tower
Denver, CO 80202
United States

Nov 9, 2020 – Nov 11, 2020    10:30am – 6:30pm Live Online Register
Course Outline

Part 1: What is BI?

  1. Business Intelligence Overview
  2. Common Challenges
  3. Benefits of Power BI

Part 2: Getting Started

  1. Overview
  2. Pricing and Licensing
  3. Components of Power BI
  4. Building Blocks of Power BI
  5. Quick Tour of Power BI Service
  6. Installing Power BI Desktop

Part 3: Getting Data

  1. Navigating Power BI Desktop
  2. Connect to Data Sources in Power BI Desktop
  3. Clean and Transform your Data
  4. Advanced Data Sources and Transformation
  5. Cleaning Irregularly Formatted Data
  6. Combining Data

Part 4: Modeling

  1. Overview
  2. How to Manage Your Data Relationships
  3. Create Calculated Columns
  4. Optimizing Data Models for Better Visuals
  5. Create Measures and Work with Time-Based Functions
  6. Create Calculated Tables
  7. Explore Time-Based Data

Part 5: Visualizations

  1. Overview
  2. Create and Customize Simple Visualizations
  3. How to Use Combination Charts
  4. Create and Format Slicers
  5. How to Use Map Visualizations
  6. How to Use Tables and Matrixes
  7. How to Use Scatter Charts
  8. How to Use Water & Funnel Charts
  9. How to Use Gauges and Single Number Cards
  10. How to modify colors
  11. Style Your Reports
  12. Create Complex Interactions Between Visualizations
  13. Duplicate a Report Page
  14. Show Categories with No Data
  15. Customize Visuals with Summarizations
  16. Arrange the Z-Order of Report Elements
  17. Visual Hierarchies and drill-down behavior

Part 6: Exploring Data

  1. Using Quick Insights
  2. Configuring Dashboards
  3. Ask Questions of your Data with Natural Language
  4. Create custom Q&A Suggestions
  5. Share Dashboards with your Organization
  6. Display Visuals and Tiles Full-Screen
  7. Edit Tile Details
  8. Get More Space on your Dashboard
  9. Install and Configure an On-premise Gateway

Part 7: Power BI and Excel

  1. Integrating Excel
  2. Import an Excel Table into Power BI
  3. Import Excel files with data models
  4. Connect OneDrive for Business to Power BI

Part 8: Publishing and Sharing

  1. Print and Export Power BI Dashboards
  2. Power BI Mobile
  3. Creating Groups in Power BI
  4. Creating Content Packs
  5. Publishing to Web
  6. Embed in SharePoint
  7. Export to PowerPoint

Part 9: Administration and Security

  1. Securing Content in Power BI
  2. Row-Level Security
  3. Auditing
  4. Managing Data Capacity
  5. Governance
  6. Data Classifications
  7. Subscriptions

Part 10: Introduction to DAX

  1. Overview
  2. DAX Calculation Types
  3. DAX Functions
  4. Using variables in DAX expressions
  5. Table Relationships in DAX
  6. DAX Tables and Filtering

Part 11: End-to-End Reporting Solutions – Exercises

  1. Retail Sales Exercise
  2. Customer Profitability Exercise
  3. Opportunity Analysis Exercise
  4. Creating InfoGraphics

Part 12: Summary

  1. More Resources


  • Quick tour
  • Installing Power BI Desktop
  • Logging into Power BI Service
  • Loading and Combining Data with Power BI Desktop
  • Creating a Basic Report
  • Publishing Reports to Power BI Service
  • Manage Table Relationships
  • Measures – Last Year Comparison
  • Measures – Year to Date
  • Measures – Market Share
  • Optimize the Data Model
  • Column from Examples
  • Conditional Columns
  • Cross-Tabular Report
  • Part-to-Whole Report
  • Relationship Report
  • Trend Report
  • Rank Report
  • Upload PBI Report and Pinning
  • Sharing Dashboard
  • Quick Insights
  • Setup On-Premise Gateway
  • Schedule Data Refresh
  • Importing Excel Models and Data
  • Exporting to PowerPoint
  • Integrating with SharePoint
  • DAX Formulas
Who should attend

This 3-Day Microsoft Power BI Training Course is Perfect for:

  • Analysts
  • Database Administrators
  • Project Managers
  • Senior Business Intelligence Architects and Consultants
  • Senior Business Analysts
  • Marketers
  • Anyone responsible for implementing BI

Download the brochure