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
Individual:
$1995.00
Group Rate:
$1795.00
(per registrant, 2 or more)
GSA Individual:
$1456.35
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.

Request a Private Onsite Price Quote

Professional Credits

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.

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.

Certification
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 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
Apr 13, 2020 – Apr 15, 2020    10:30am – 6:30pm Live Online Register
Apr 20, 2020 – Apr 22, 2020    8:30am – 4:30pm Live Online Register
May 5, 2020 – May 7, 2020    11:00am – 7:00pm Live Online Register
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

Register
May 11, 2020 – May 13, 2020    8:30am – 4:30pm New York, New York

NYC Seminar and Conference Center
71 West 23rd
Suite 515-Lower Level
New York, NY 10010
United States

Register
May 19, 2020 – May 21, 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

Register
Jun 16, 2020 – Jun 18, 2020    10:30am – 6:30pm Live Online Register
Jun 22, 2020 – Jun 24, 2020    8:30am – 4:30pm Cary, North Carolina

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

Register
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

Register
Jul 13, 2020 – Jul 15, 2020    8:30am – 4:30pm Chicago, Illinois

Attune, formerly Microtek Chicago
230 W. Monroe
Suite 900
Chicago, IL 60606
United States

Register
Jul 13, 2020 – Jul 15, 2020    10:30am – 6:30pm Live Online Register
Aug 10, 2020 – Aug 12, 2020    8:30am – 4:30pm Washington, District of Columbia

Attune, Formerly Microtek-Washington, DC
1110 Vermont Avenue NW
Suite 700
Washington, DC 20005
United States

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

Register
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

Register
Sep 14, 2020 – Sep 16, 2020    8:30am – 4:30pm Dallas, Texas

Attune, formerly Microtek Dallas
5430 Lyndon B Johnson Fwy
Three Lincoln Centre, Suite 300
Dallas, TX 75240
United States

Register
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

Register
Course Outline

Part 1: What is BI

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

Part 2: Getting Started with Power BI

  1. Overview & Pricing/Licensing
  2. Components of Power BI
    • Power BI Desktop
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Gateway
  3. Building Blocks of Power BI
    • Datasets
    • Visualization
    • Reports
    • Tiles
    • Dashboards
  4. Power BI Workflows
  5. Resources for Inspiration
  6. Demo: Quick Tour of Power BI Service
  7. Lab Exercise: Quick Tour of Power BI Service

Part 3: Getting Data

  1. Navigating Power BI Desktop
  2. Connect to Data Sources in Power BI Desktop
    • File Data Sources
    • Database Data Sources
    • Azure Data Sources
    • Online Service Data Sources
    • Miscellaneous Data Sources
  3. Clean and Transform your Data
  4. Advanced Data Sources
    • Advanced Editor
    • Shaping Data
    • Applied Steps
  5. Transformations
  6. Cleaning Irregularly Formatted Data
  7. Data Types
  8. Combining Data
  9. AI Analytics
    • Text Analytics
    • Vision
    • Azure Machine Learning
    • Invoking the Shared Models
    • Considerations and Limitations
  10. Demo: Quick Tour of Power Query Editor
  11. Lab Exercise: Import Data and Create Queries with Power BI Desktop
  12. Lab Exercise: Transform Data
  13. Lab Exercise: Combining Data
  14. Lab Exercise: Create a Report using Power BI Desktop
  15. Lab Exercise: Publish a PBIX File to the Power BI Service

Part 4: Power BI and Excel

  1. Excel Integration
    • Import an Excel Table into Power BI
    • Use Excel as a Dataset
    • Import Excel Files with Data Models
    • Connect, Manage and View Excel in Power BI
  2. Publishing and Sharing

Part 5: Modeling Data

  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
  8. Grouping
  9. Binning
  10. Hierarchies
  11. Demo: Modeling Relationships Column by Example Conditional Columns, Groups, Hierarchies

Part 6: Visualizations

  1. Overview
  2. Create and Customize Simple Visualization
    • Numerical Fields
    • Text Fields
    • Geographic Fields
  3. Modify Colors Insert Static Objects, and Set Page Properties
  4. Styling with Shapes, Text Boxes, and Images
  5. Page Layout and Formatting
  6. Z-Order of Report Elements
  7. Customize Visuals with Summarizations
  8. How to:
    • Use Combination Charts
    • Manage Slicers and Sync Slicer
    • Use Map Visualizations
    • Implement Tables and Matrixes
    • Apply Conditional Formatting
    • Interpret Scatter Charts
    • Work with Water & Funnel Chart
    • Use Gauges and Single Number Cards
  9. Creating Complex Interactions Between Visuals
  10. Advance Concepts and New Features
    • Decomposition Tree
    • Key Influencers
    • Insights
    • Visual Hierarchies and drill-down behavior
    • Custom Visualizations
    • Drillthrough
    • Analytics Pane
    • Forecasting
    • Tooltips
    • Chiclet Slicer
    • Hierarchy Slicer
    • Synoptic Panel
  11. Other Powerful Custom Visualizes
    • Pivot Slicer
    • Smart Filter
    • Hierarchy Filter
    • Card Browser
    • Visio Visual
    • Infographic Designer
    • D3JS Visualizer
  12. Demo: Visualizations, Slicers, and Advanced Interactions

Part 7: Publishing and Sharing

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

Part 8: Exploring Data

  1. Overview
  2. Use Quick Insights
  3. Create and Configure a Dashboard
  4. Shared Dashboards with your Organization
  5. Display Visuals and Tiles Full-Screen
  6. Edit Tile Details
  7. Get More Space on Your Dashboard
  8. Ask Questions of your Data with Natural Language
    • Custom Q&A suggestions
    • Adding Q&A to a Report
    • Adding a Q&A to a Report
    • Q&A Tooling
    • Review Questions
    • Teach Q&A
    • Manage Terms
    • Data Sources for Q&A
    • Bulk Synonyms
    • Q&A Best Practices
  9. Bookmarks
  10. Themes
  11. Demo: Quick sights
  12. Demo: Q&A in Dashboards and Reports
  13. Demo: Bookmarks

Part 9: Administration & Security

  1. Securing Content in Power BI
    • My workspace
    • Sharing a Dashboard
    • Sharing to Web
    • Admin Access
  2. Row-level Security
  3. Permissions
  4. Defining and Creating toles within Power BI Desktop
  5. Row-Level Security
  6. Managing Data Capacity
  7. Subscriptions
  8. Resources

Part 10: Introduction to DAX

  1. DAX Calculation Types
    • Calculated Columns
    • Calculated Measures
  2. DAX Functions
    • Aggregation Functions
    • Counting Functions
    • Logical Functions
    • Information Functions
    • Text Functions
    • Date Functions
  3. Using Variables in DAX Expressions
  4. Table Relationships in DAX
  5. DAX Tables and Filtering
  6. Quick Measures
  7. What-if Parameters
  8. Dynamic Labeling
  9. Resources
  10. Demo: Quick Measures
  11. Demo: What-if
  12. Demo: Dynamic Labeling

Hands-on Lab Exercises:

  • Retail Sales Exercise
    • Retail Analysis – Overview
    • Retail Analysis – District Monthly Sales
    • Retail Analysis – New Stores
  • Customer Profitability Exercise
    • Customer Profitability – Team Scorecard
    • Customer Profitability – Industry Margin Analysis
    • Customer Profitability – Executive Scorecard
  • Opportunity Analysis: Exercise
    • Opportunity Analysis – Opportunity Count
    • Opportunity Analysis – Revenue Overview
    • Opportunity Analysis – Upcoming Opportunities
    • Opportunity Analysis – Region Stage Counts
    • Opportunity Analysis Data Model
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
  • Digital Marketers
  • IT Specialists
  • IT Managers/IT Directors
  • Anyone responsible for implementing BI
Pre-Requisites

In order to follow along with all of the hands-on lab exercises, students should be comfortable using Excel to perform data analysis tasks and should have foundational database management knowledge. 

0
1

Download the brochure