Log On/Register  

855.838.5028

Power BI Essentials

Duration: 2 Days
Course Price: $1,195

Power BI allows the everyday Excel user to become a Business Intelligence Analyst. Create stunning reports and dashboards, poignant 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.  

 

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 and dashboards, poignant 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.  

 

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

 

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

 

Software: Excel 2013 or later 

Outline

Day 1 

Getting Started 

What is Power BI? 

Getting the Tools 

Power BI and Excel 

Discovering Insights with PBI (Data Analysis Objectives) 

PBI Eco-System 

Getting Data 

Concepts of Power Query and "Get & Transform" in Excel 

Importing from Various Sources 

Appending and Merging Queries together 

Data Normalizing Strategies 

Re-Using Queries 

Introduction to Power BI 

Concepts (Power BI compared to Excel) 

Importing Data from Excel 

Issue Queries directly from Power BI 

Building Reports 

Creating Simple Visualization 

Displaying Excel Objects in PBI 

Telling a Story with you PBI Reports 

Day 2 

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 

Essential DAX expressions 

 

Power BI 

Concepts (Power BI compared to Excel) 

Importing a Data Model from Excel 

Data Modelling directly in Power BI 

  • Importing Additional Data 
  • Creating Calculated Columns and Measures in Power BI 

Introduction to Time Intelligence 

  • Calendar Tables 
  • Essential Time Intelligence DAX expressions 

Building Interactive Reports 

  • Concepts: Reports for Consumption 
  • Standard slicers 
  • Charts as Slicers 
  • Disconnecting Visuals  
  • Drilling Down with Hierarchies 

 

Power BI Online 

Dashboards vs. Reports 

Pinning Visuals 

Excel Objects Online 

Publish and Share Dashboards and Reports  

Using Q&A 

 

 

 



Learn More
Please type the letters below so we know you are not a robot (upper or lower case):