Building BI with Pivot Tables

Module 01A - The Value of Pivot Tables (The Business Intelligence Life Cycle) 
Module 01B - The Value of Pivot Tables (Why You Care About Pivot Tables) 
Module 01C - The Value of Pivot Tables (Creating Your First Pivot Table) 
Module 02A - Pivot Compliant Data Sets (Required Data Layout) 
Module 02B - Pivot Compliant Data Sets (Connecting to your Source Data) 
Module 02C - Pivot Compliant Data Sets (Using Data Direct from Databases) 
Module 03A - Modifying Pivot Table Look & Feel (Value Field Formats) 
Module 03B - Modifying Pivot Table Look & Feel (Report Layout) 
Module 03C - Modifying Pivot Table Look & Feel (Grouping Data) 
Module 03D - Modifying Pivot Table Look & Feel (PivotTable Styles) 
Module 03E - Modifying Pivot Table Look & Feel (Sorting PivotTables) 
Module 04A - Sourcing Data (Using Power Query to Get & Transform your Data) 
Module 04B - Sourcing Data (Appending Data Tables) 
Module 04C - Sourcing Data (Consolidating Excel Data) 
Module 04D - Sourcing Data (Un-pivoting Data) 
Module 04E - Sourcing Data (Flattening Datasets) 
Module 05A - Changing Pivot Table Aggregations (SUM, COUNT and Others) 
Module 05B - Changing Pivot Table Aggregations (Show Values As) 
Module 05C - Changing Pivot Table Aggregations (Calculated Fields) 
Module 06A - Slicing and Filtering (Filtering with Classic Controls) 
Module 06B - Slicing and Filtering (Filtering with Slicers) 
Module 06C - Slicing and Filtering (Timelines) 
Module 06D - Slicing and Filtering (The Show Details Feature) 
Module 06E - Slicing and Filtering (Keeping Your Pivots Looking Nice) 
Module 07A - Building Pivot Based Dashboards (Conditional Formatting on Pivots) 
Module 07B - Building Pivot Based Dashboards (Keeping Pivots in Sync) 
Module 07C - Building Pivot Based Dashboards (Tricks for Extracting Key Info) 
Module 07D - Building Pivot Based Dashboards (Working with Pivot Charts) 
Module 08A - Data Refresh & Security (Driving Pivot Table Refresh) 
Module 08B - Data Refresh & Security (How Secure is Your Data) ​