Completed
) Summary
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Data Analysis Fundamentals - PivotTables, Power Query & Data Model
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Sort
- 3 ) Sorting one column
- 4 ) Sorting multiple columns
- 5 ) Sorting Mixed Data
- 6 ) Filter feature
- 7 ) Filter Drop-down Arrows to see Unique List
- 8 ) Filter Different Data Types
- 9 ) Filter to Extract Records
- 10 ) OR Logical Test (OR Criteria) Discussion
- 11 ) AND Logical Test (AND Criteria) Discussion
- 12 ) BETWEEN and NOT Criteria
- 13 ) PivotTable. Discussion of Crosstabulated tables and PivotTables as “Calculations with Criteria”, both AND Criteria and OR Criteria.
- 14 ) PivotTable Basics: 1) Drag and Drop Field Names to add criteria to PivotTable, 2) Cross Tabulated Table, 3) Layout Formatting, 4) Number Formatting
- 15 ) Adding Slicers
- 16 ) Creating a Custom Style for a PivotTable
- 17 ) Name PivotTable
- 18 ) Create PivotTable using “Summarize Values By”, which allows us to change the Aggregate Functions like: SUM, COUNT, AVERAGE.
- 19 ) Group Dates by Month and Year
- 20 ) Create PivotTable using “Show Values As” to calculate “% of Column Total”.
- 21 ) Hide items in Slicer
- 22 ) Connect Multiple Slicers to Multiple PivotTables.
- 23 ) Sort in PivotTable.
- 24 ) Create multiple PivotTables with a single click using “Show Report Filter Pages”
- 25 ) Why we need Power Query and Power Pivot Data Model
- 26 ) Introduction to Power Query (Get & Transform)
- 27 ) Power Query Example 1: Clean and Transform Data Table, Create PivotTable Based on Power Query Update, 3) Add new data to table and Refresh to update Query and PivotTable
- 28 ) Power Query to Unpivot a Crosstabulated Table into a Proper Data Set.
- 29 ) Introduction to Power Pivot and the Data Model
- 30 ) Power Query to import multiple Text File tables with over one million records combine them into a single Table. We will use the “From File, From Folder” option.
- 31 ) Load the million records in Power Query into the Power Pivot Data Model.
- 32 ) Add an Excel Table into the Power Pivot Data Model
- 33 ) Update Power Query
- 34 ) Build a relationship between tables in the Power Pivot Data Model.
- 35 ) Build PivotTable from Millions of Records from Two Tables
- 36 ) Add new Text File to Folder and Update PivotTable.
- 37 ) Summary
