• Why Use Power Pivot?
• The xVelocity In-memory Analytics Engine
• Enabling Power Pivot for Excel
• Exploring the Data Model Manager Interface

• Importing Data from Relational Databases
• Importing Data from Text Files
• Importing Data from a Data Feed
• Importing Data from an OLAP Cube
• Reusing Existing Connections to Update the Model

• Discovering and Importing Data
• Transforming, Cleansing, and Filtering Data
• Merging and Shaping Data
• Grouping and Aggregating Data
• Inserting Calculated Columns

• What Is a Data Model?
• Creating Table Relations
• Creating a Star Schema
• Understanding When to Denormalize the Data
• Creating Linked Tables
• Creating Hierarchies
• Making a User-Friendly Model

• What Is DAX?
• Implementing DAX Operators
• Working with Text Functions
• Using DAX Date and Time Functions
• Using Informational and Logical Functions
• Getting Data from Related Tables
• Using Math, Trig, and Statistical Functions
• Tips for Creating Calculations in Power Pivot

• Measures vs. Attributes
• Creating Common Aggregates
• Mastering Data Context
• Altering the Query Context
• Using Filter Functions
• Creating KPIs

• Date-Based Analysis
• Creating a Date Table
• Time Period–Based Evaluations
• Shifting the Date Context
• Using Single Date Functions
• Creating Semi-Additive Measures

• Pivot Table Fundamentals
• Slicing the Data
• Adding Visualizations to a Pivot Table
• Working with Pivot Charts
• Using Multiple Charts and Tables
• Using Cube Functions

• Setting Up the Power BI Environment
• Getting, Cleaning, and Shaping Data
• Creating Table Relationships
• Adding Calculations and Measures
• Incorporating Time-based Analysis

• Creating Tables and Matrices
• Constructing Bar, Column, and Pie Charts
• Building Line and Scatter Charts
• Creating Map-Based Visualizations
• Linking Visualizations in Power BI
• Drilling Through Visualizations

• Creating a User-Friendly Model
• Publishing Power BI Desktop Files to the Power BI Service
• Adding Tiles to a Dashboard
• Sharing Dashboards
• Refreshing Data in Published Reports

Use Case 1: Reseller Sales Analysis

• Load the Data
• Create the Model
• Create Calculated Columns
• Create Measures
• Create the Dashboard

Use Case 2: Sales Quota Analysis

• Load the Data
• Create the Model
• Create Measures
• Create the Report

Use Case 3: Sensor Analysis

• Load the Data

• Writing Queries with M
• Creating and Using Parameters
• Creating and Using Functions

• Using Custom Visuals
• Implementing Geo-spatial Analysis
• Implementing Row-Based Security
• Creating Templates and Content Packs