• Using Power BI
• Using Power BI In Windows
• Writing Your First Program - Hello, World!
• Entering And Running A Program In Windows

Exercise 1

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

Importing Data into Power Pivot

• Introduction
• 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
• Summary

Creating the Data Model

• Introduction
• 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
• Summary

Creating Calculations with DAX

• Introduction
• 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
• Summary

Creating Measures with DAX

• Introduction
• Measures Versus Attributes
• Creating Common Aggregates
• Mastering Data Context
• Altering the Query Context
• Using Filter Functions
• Creating KPIs
• Summary

Incorporating Time Intelligence

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

Data Analysis with Pivot Tables and Charts

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

Optimizing Power Pivot Models for Power View

• Introduction
• Visualizing Data with Power View
• Creating a Basic Report
• Improving the Power View Experience
• Summary

Creating Standard Visualizations with Power View

• Introduction
• Creating Tables and Matrices
• Constructing Bar, Column, and Pie Charts
• Building Line and Scatter Charts
• Creating Map-Based Visualizations
• Summary

Creating Interactive Dashboards with Power View

• Introduction
• Linking Visualizations in Power View
• Using Tiles t
• Organize the Data
• Filtering Groups and Views
• Exposing the Dashboard
• Summary

Data Discovery with Power Query

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

Geospatial Analysis with Power Map

• Introduction
• Preparing Data for Mapping
• Creating a Map-Based Graph
• Creating Heat and Region Maps
• Adding Multiple Layers to a Power Map
• Analyzing Changes over Time
• Creating a Tour
• Summary

Mining Your Data with Excel

• Introduction
• Table Analysis Tools in Excel
• Analyzing Key Influencers
• Identifying Data Groups
• Forecasting Future Trends
• Using Shopping Basket Analysis
• Summary