Microsoft Power BI Foundations

Book Now

Course Description

Microsoft Power BI is quickly becoming one of the world’s most powerful self-service business intelligence platforms, as well as an absolutely essential tool for today’s top data professionals

Curriculum

• Introduction to Power BI Desktop
  Downloading Power BI Desktop
  Power BI Desktop Interphase & Workflow
  

• Connecting & Shaping Data
  Types of Data Connectors
  Power Query Editor
  Connecting to a Database
  Calculated Columns
  Grouping & Aggregating
  Pivoting & Unpivoting
  Merging Queries
  Appending Queries
  Refreshing Queries
  

• Creating a Data Model
  Fact & Dimension Tables
  Primary & Foreign Keys
  Creating Table Relationships
  Star & Snowflake Schema
  Filter Context & Filter Flow
  Date Formats & Hierarchy
  

• Calculated Fields with DAX

  Intro to Calculated Columns
  Intro to DAX Measures
  Implicit vs Explicit Measures
  Basic Math & Stats Functions
  Conditional & Logical Functions
  Calculate the Most Important DAX
  Time Intelligence Functions
  

• Creating Reports & Dashboards
  Dashboard Design Framework
  Adding Report Pages & Objects
  Cards & Multi-Row Cards
  Building & Formatting Charts
  Line Charts
  Bar & Donut Charts
  Report Slicers
  Editing Report Interactions
  Power BI Mobile Apps