Learn data sourcing, cleaning, tabular and visual presentation for easy analysis. Level up your BI skills.
Building Business Intelligence with Pivot Tables is an online video course that is perfect for anyone looking to build reports and quickly summarize 10s to 1,000s of rows of data quickly. This course will provide the analyst with the best ways to source and clean up source data for reporting. As the data is cleansed, the course will show you how to present the data in a way that is easy to use for analysis by presenting data in both tabular and visually. The course will further explore the best ways to analyze the data and drill in and out of data. By the end of this course, you will feel confident sourcing data, cleansing it, and analyzing it through pivot tables and dashboards.
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)7 min.
Module 04A – Sourcing Data (Using Power Query to Get & Transform your Data)30 min.
Module 04B – Sourcing Data (Appending Data Tables)29 min.
Module 04C – Sourcing Data (Consolidating Excel Data)12 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)23 min.
Module 05C – Changing Pivot Table Aggregations (Calculated Fields)16 min.
Module 06A – Slicing and Filtering (Filtering with Classic Controls)6 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)6 min.
Module 07A – Building Pivot Based Dashboards (Conditional Formatting on Pivots)9 min.
Module 07B – Building Pivot Based Dashboards (Keeping Pivots in Sync)7 min.
Module 07C – Building Pivot Based Dashboards (Tricks for Extracting Key Info)15 min.
Module 07D – Building Pivot Based Dashboards (Working with Pivot Charts)17 min.
Module 08A – Data Refresh & Security (Driving Pivot Table Refresh)14 min.
Module 08B – Data Refresh & Security (How Secure is Your Data)8 min.
There are no reviews yet.
You must be <a href="https://wislibrary.net/my-account/">logged in</a> to post a review.