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

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkPrivacy policy