Power BI Training Course Content
Learning PowerPivot
  • What is PowerPivot for Excel
  • Importing Your Data PowerPivot
  • Creating a PowerPivot Data Model
  • Creating PivotTables with PowerPivot
  • Creating a Date Table
  • Using Slicers to Filter Data
  • Connecting Slicers to more than one PivotTable
  • Using Charts and Slicers to create interactive Dashboards
  • Using DAX in PowerPivot
  • Creating Calculated Columns
  • Creating Calculated Fields
  • Implicit and Explicit Calculated Fields
  • Using DAX aggregate functions in a PowerPivot PivotTable
  • Using Count Rows and Distinct Count Functions
  • The difference between evaluations using Row Context and evaluations using Filter Context
Advanced DAX functions
  • SUMX and CALCULATE
  • Time Intelligence Functions
  • Creating Key Performance Indicators
  • Using PowerPivot Sets
POWER QUERY
  • Adding Data to Power Query from various data sources
  • Creating a Query, the Query Editor Window
  • Load to Worksheet and Load to Data Model
  • Remove Duplicate Data in Columns
  • Split and Merge Columns of Data
  • Group data to create summary Queries
  • Merge and Append Queries
  • Transpose Data to swap Rows and Columns
  • Filling data Down to populate missing values
  • Unpivot Columns: flatten a “cross tab” table
  • Duplicate Columns, Creating Custom Columns and Additional Date Columns
  • Working with Applied Steps
  • Importing Data From a Folder
POWER VIEW
  • The Power View Field List
  • Using Text Boxes
  • Creating Tables
  • Changing Table Visualisations
  • Using a Matrix and Enable Drill Down
  • Using Cards; Setting up Titles and Pictures for Cards
  • Creating Chart Visualisations and Interactive Charts
  • Creating Power View Slicers
  • Using Tiles
  • Using Power View Filters
  • Working with interactive Bubble Charts using the Play Axis
  • Creating Power View Maps
POWER MAPS
  • Create a Power Map and Plot Geographic Data
  • Creation Visualisation; Column, Bubble, Heat map, Regions
  • Using the 3-D Environment
  • Using Charts with Power Maps
  • Working with Layers and adding Scenes
  • Adding Annotations
  • Visualising Data over Time
  • Playing the Tour