Log On/Register  

855.838.5028

Power BI Bootcamp

Duration: 4 Days
Course Price: $2,200

Power BI allows the everyday Excel user to become a Business Intelligence Analyst. Create stunning reports, dashboards, and data visuals, and design highly insightful DAX measures with Power BI. Microsoft's Power BI landscape allows easy data clean-up and data modelling directly in the Power BI application, or the user has the choice to accomplish these same tasks in Excel. Create stunning dashboards that link to many reports. Drill down into your data with intelligent visuals and slicers. Create insightful business models with DAX expressions, and master Time Intelligence. KPI's, Pivot Tables, and custom visuals deliver your message efficiently and professionally. Learn how to create a well-designed report or dashboard using all Power BI has to offer.

Target Audience:

Business professionals who want to learn Power BI. Excel users who want to take their data mastery to the next level.

Power BI allows the everyday Excel user to become a Business Intelligence Analyst. Create stunning reports, dashboards, and data visuals, and design highly insightful DAX measures with Power BI. Microsoft's Power BI landscape allows easy data clean-up and data modelling directly in the Power BI application, or the user has the choice to accomplish these same tasks in Excel. Create stunning dashboards that link to many reports. Drill down into your data with intelligent visuals and slicers. Create insightful business models with DAX expressions, and master Time Intelligence. KPI's, Pivot Tables, and custom visuals deliver your message efficiently and professionally. Learn how to create a well-designed report or dashboard using all Power BI has to offer.

Target Audience:

Business professionals who want to learn Power BI. Excel users who want to take their data mastery to the next level.

Excel Day 2 or a general understanding of Pivot Tables and Excel Day 3 or a general understanding of Excel Functions.  

Software: 

Excel 2013 or later 

Day 1: Transform Messy Data into Beautiful Visuals

Getting Started 

  • What is Power BI? 
  • Getting the Tools 
  • Power BI and Excel 
  • Discovering Insights with PBI (Data Analysis Objectives) 
  • PBI Eco-System 

Getting and Transforming Data with Power Query

  • Concepts and Objectives 
  • Importing from Various Sources 
  • Appending and Merging Queries together 
  • Data Normalizing Strategies 
  • Reusing Queries

Introduction to Power BI Desktop

  • Concepts (Power BI compared to Excel) 
  • Importing Data from Excel 
  • Issue Queries Directly from Power BI 
  • Building Reports 
  • Creating Simple Visualization 
  • Telling a Story with your PBI Reports
  • Creating Slicers
  • Using Charts as Slicers

 

Day 2: Dashboards and Data Modelling

Data Modeling 

  • Concepts of Power Pivot and "Data Model" in Excel 
  • Importing Data from Various Sources 
  • Modelling & Relating  
  • Concepts of creating a Data Model (Decision Structures) 
  • Creating Relationships 
  • Creating Calculated Columns 
  • Designing Measures  
  • Building Hierarchies 
  • Data Analysis Strategies 

Power BI & Dashboards

  • Importing a Data Model from Excel 
  • Data Modelling directly in Power BI 
  • Creating Calculated Columns
  • Creating Measures 
  • DAX expressions 
  • Introduction to Time Intelligence
    • Creating Calendar Tables 
    • Essential Time Intelligence DAX expressions 
  • Creating Reports
  • Publish Reports  
  • Build Dashboards
  • Pinning Visuals to Dashboards
  • Sharing Dashboards

 

Day 3: Power BI to the Rescue: Advanced Querying and Time Intelligence

Power Query to the Rescue

  • Querying SharePoint Lists
  • UnPivot Data
  • Grouping Data
  • Writing M Script
  • Calendar Tables with M
  • Custom Calendars Concepts
  • Custom Functions in Power Query

Time Intelligence in Depth

  • PeriodToDate Functions
    • YTD
    • QTD
    • MTD
  • DATEADD
  • FIRSTDATE and LASTDATE
  • ENDOFMONTH, STARTOFYEAR
  • DATESBETWEEN

Complicated Relationships

OLAP Tools

 

Day 4: Design for your Decision Makers & Master the Data Model

Mastering the Concepts

  • Pivots and Visuals inherently Filter
  • Filter Context Flows Downstream
  • Order of Operations

Manipulating Implicit Filters

  • All
  • Filter

Disconnected Tables

Customizing Visuals and Reports

  • Disconnecting Visuals
  • Drilling Down with Hierarchies
  • Page Level Filters
  • Custom Visuals
  • Using R Code

Dashboards: Beyond the Basics

  • Excel Objects in PBI Online
  • Live Streaming Data Sets
  • Using Data Models in One Drive

Designing for Consumption

  • Mobile Design
  • Re-Designing for Q&A
  • Alerts
  • Row Level Security
Learn More
Please type the letters below so we know you are not a robot (upper or lower case):