PowerPivot helps you to deal with large volumes of data without resorting to the use of a Database. Ross Hughes shows you how to use PowerPivot to manage large volumes of data (Up to 1 million+ rows) with ease. You will learn about Data Modelling, DAX formulas, Measures and KPIs.
Course Curriculum
(Click for details)
MODULE 1: Getting Started With Power Pivot
Lesson 1.1 Introduction to Power Pivot Lesson 1.2 Data Model Familiarisation Lesson 1.3 Data Modelling Concepts Lesson 1.4 Introduction to Data Types
MODULE 2: Loading Data
Lesson 2.1 Loading data with PowerQuery Lesson 2.2 Loading Data from Excel tables Lesson 2.3 Introduction to using with Pivot Tables Lesson 2.4 Other data load options Lesson 2.5 Loading Data from an external database
MODULE 3: Pivot Tables And Refresh
Lesson 3.1 More on Pivot Tables Lesson 3.2 Pivot Tables and Relationships Lesson 3.3 Introduction to Refreshing Data Lesson 3.4 Refreshing Data via Connections Lesson 3.5 Refreshing Data from an external database
MODULE 4: Introduction To Measures
Lesson 4.1 Calculated Columns Lesson 4.2 Introduction to measures Lesson 4.3 Adding explicit measures with Autosum Lesson 4.4 Adding implicit measures Lesson 4.5 Adding explicit measures in Power Pivot menu
MODULE 5: Hierarchies And Related Columns
Lesson 5.1 Introduction Lesson 5.2 Adding a hierarchy Lesson 5.3 Using hierarchies in a Pivot Table Lesson 5.4 Drill paths Lesson 5.5 Introduction to Related Columns Lesson 5.6 Related Columns in a hierarchy Lesson 5.7 Best practices with hierarchies Lesson 5.8 Editing hierarchies
MODULE 6: Deeper Into DAX
Lesson 6.1 DAX Syntax and Operators Lesson 6.2 Some Useful DAX Functions part 1 Lesson 6.3 Some Useful DAX Functions part 2 Lesson 6.4 Some Useful DAX Functions part 3 Lesson 6.5 Introduction to Iterator Functions Lesson 6.6 Expressions in Iterator Functions Lesson 6.7 Table functions in Iterator Functions (RELATEDTABLE) Lesson 6.8 Table functions in Iterator Functions (TOPN) Lesson 6.9 Other Iterator Functions Lesson 6.10 Introduction to Context Lesson 6.11 Examples of Context Lesson 6.12 Filter Context in Pivot Tables Lesson 6.13 Introduction to Filter Functions Lesson 6.14 Example of a Filter Function Lesson 6.15 Using Filters in a Filter Function Lesson 6.16 Using the ALL Filter Function Lesson 6.17 Using the ALLSELECTED Filter Function Lesson 6.18 Introduction to Parent-Child Functions Lesson 6.19 Using Parent-Child Functions Lesson 6.20 Using Parent-Child Functions for a Hierarchy Lesson 6.21 Time Intelligence Functions Part 1 Lesson 6.22 Time Intelligence Functions Part 2 Lesson 6.23 Time Intelligence Functions Part 3 Lesson 6.24 Time Intelligence Functions Part 4
