Power BI
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