Power BI for Excel 2016 - Report Builders, Power BI Tools, Data Model Designers, and DAX Functions

Lesson Id	Title	Description
1	Introducing Power BI for Excel	What Is Power BI for Excel? <br />Power BI Key Features <br />The Self-Service BI Model <br />Power BI in Excel <br />PowerPivot Add-In <br />Using Power BI
2	Defining a Report	What is a PowerPivot Report? <br />Defining a Report <br />Data-Driven Storytelling
3	Understanding PowerPivot Data	Understanding Data Terminology <br />Tables <br />Relationships <br />Diagnosing Data Models <br />Data Model Schemas
4	Create Reports using PowerPivot Data	Making Changes to PowerPivot Data <br />Creating PowerPivot PivotTables <br />Creating PowerPivot PivotCharts <br />Creating Slicers <br />Graphing Data
5	Understanding PowerPivot Functions	Calculated Columns <br />What is DAX? <br />Understanding DAX Functions <br />Common DAX Functions <br />Dates and Date Functions
6	Introducing Power BI Tools	Microsoft’s Self-Service Power Bi Model <br />What Is Power BI for Excel
7	Power View for Excel	What Is Power View? <br />Creating Power View Reports <br />Power View Interface Components <br />Understanding Table Visualizations <br />Chart Visualizations <br />Power View Tiles, Slicers, & Multiples
8	Power Map/3D Maps for Excel	What Is 3D Map/Power Map? <br />Preparing a 3D Maps/Power Map Tour <br />3D Maps/Power Map Designer <br />3D Maps/Power Map Formatting Tools <br />Finalizing a 3D Maps/Power Map Tour
9	BI Data Query Basics	What Is a BI Data Query? <br />Planning a BI Data Query
10	Query Editor Transformations	Basic Transformations <br />Merging & Appending Queries <br />Calculated Columns <br />Grouping and Summarizing Data <br />Unpivoting Data <br />Dealing with Malformed Data <br />Finalizing Queries
11	Understanding BI Data	Business Intelligence Data Sources <br />Data Source Types <br />Table Roles
12	Creating Data Models	Creating a Data Model - Excel <br />Creating a Data Model - Database <br />Creating a Data Model - Hybrid
13	Creating DAX Functions	Review of Syntax and Calculated Columns <br />Best Practices <br />DAX Measures <br />Creating Measures (Calculated Fields)
14	Dates and Hierarchies	Building Data Tables <br />Building Data Hierarchies
15	Shaping Reports	Building Communication Worksheets <br />Controlling Item Ordering <br />PowerPivot Metadata
16	Basic DAX Functionality	Review Of Calculated Column <br />PivotTable Function <br />Review Of Measure <br />Rules Of DAX Measure <br />Evaluation Context <br />Formatting DAX Code
17	Controlling Content & Values	Controlling Values <br />Switch Function <br />Error Handling
18	Context Control Functions	Filter Function <br />All Function <br />Iterative Functions <br />Earlier Function <br />Calculate Function <br />Additional Uses Of The All Function
19	Contexts In Relationships	Working With Many Tables <br />Row Context & Relationships <br />Filter Context & Relationships <br />Values Function
20	Advanced Concepts	Circular Dependencies <br />Controlling Totals <br />Advanced Hierarchy Concepts
21	Time Intelligence Calculations	Working With Date Tables <br />Calculating Operating Periods <br />Working With Missing Periods <br />DAX Date Functions <br />Advanced Date Functions <br />Prior Year Functions <br />Moving Averages
22	DAX Dashboard Techniques	Parameter Tables <br />Banding <br />Ranking <br />Advanced Slicer Techniques