Module 1: Course Overview
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We will Be Discussing
Module 2: Power View
- Exploring the Power View Interface
- Visualizing Power View Reports
- Working with Tables
- Understanding Aggregations
- Utilizing Matrix
- Configuring Drill Through
- Using Cards
- Applying Filters
- Creating Charts
- Examining Tiles
- Adding Slicers to Reports
- Theming Reports
Module 3: PowerPivot
- Exploring the PowerPivot Interface
- Loading Data
- Examining Relationships
- Configuring Calculated Columns and Calculated Fields
- Creating PivotTables
- Understanding DAX
- Utilizing DAX Functions
- Using KPIs
- Working with Hierarchies
- Managing Perspectives
Module 4: Power Query
- Exploring The Power Query Interface
- Loading Data
- Managing Modifications
- Examining Data Cleaning
Module 5: Power Map
- Exploring The Power Map Interface
- Using Bing Maps
- Examining Map Data
- Reviewing Map Types and Presentation
Module 6: Introduction to Power BI
- Introducing Power BI
- Explaining Excel and Power BI
- Examining Data Sources
- Querying with Natural Language