Building BI with Pivot Tables

Building BI with Pivot Tables - What you need to get started

Module 01A - The Value of Pivot Tables (The Business Intelligence Life Cycle) 7 min.

Module 01B - The Value of Pivot Tables (Why You Care About Pivot Tables) 7 min.

Module 01C - The Value of Pivot Tables (Creating Your First Pivot Table) 13 min.

Module 02A - Pivot Compliant Data Sets (Required Data Layout) 14 min.

Module 02B - Pivot Compliant Data Sets (Connecting to your Source Data) 22 min.

Module 02C - Pivot Compliant Data Sets (Using Data Direct from Databases) 15 min.

Module 03A - Modifying Pivot Table Look & Feel (Value Field Formats) 11 min.

Module 03B - Modifying Pivot Table Look & Feel (Report Layout) 14 min.

Module 03C - Modifying Pivot Table Look & Feel (Grouping Data) 16 min.

Module 03D - Modifying Pivot Table Look & Feel (PivotTable Styles) 7 min.

Module 03E - Modifying Pivot Table Look & Feel (Sorting PivotTables) 8 min.

Module 04A - Sourcing Data (Using Power Query to Get & Transform your Data) 30 min.

Module 04B - Sourcing Data (Appending Data Tables) 30 min.

Module 04C - Sourcing Data (Consolidating Excel Data) 13 min.

Module 04D - Sourcing Data (Un-pivoting Data) 17 min.

Module 04E - Sourcing Data (Flattening Datasets) 22 min.

Module 05A - Changing Pivot Table Aggregations (SUM, COUNT and Others) 9 min.

Module 05B - Changing Pivot Table Aggregations (Show Values As) 24 min.

Module 05C - Changing Pivot Table Aggregations (Calculated Fields) 16 min.

Module 06A - Slicing and Filtering (Filtering with Classic Controls) 7 min.

Module 06B - Slicing and Filtering (Filtering with Slicers) 14 min.

Module 06C - Slicing and Filtering (Timelines) 8 min.

Module 06D - Slicing and Filtering (The Show Details Feature) 6 min.

Module 06E - Slicing and Filtering (Keeping Your Pivots Looking Nice) 7 min.

Module 07A - Building Pivot Based Dashboards (Conditional Formatting on Pivots) 10 min.

Module 07B - Building Pivot Based Dashboards (Keeping Pivots in Sync) 8 min.

Module 07C - Building Pivot Based Dashboards (Tricks for Extracting Key Info) 16 min.

Module 07D - Building Pivot Based Dashboards (Working with Pivot Charts) 18 min.

Module 08A - Data Refresh & Security (Driving Pivot Table Refresh) 14 min.

Module 08B - Data Refresh & Security (How Secure is Your Data) 8 min.