Power Pivot

PowerPivot Course – myOnlineTraininghub 

Syllabus

1.     Introduction

a.     What is PowerPivot

b.     Demonstration of How it Works

c.     Limitations

2.     Installing Power Pivot

a.     Versions & Installations

b.     Tour of PowerPivot Window

3.     Getting your data into Power Pivot

a.     Preparing your data

b.     Excel Tables

c.     Importing data from ACCESS

d.     Importing data from linked Excel Tables

e.     Importing data from External Excel files

f.      Importing a Text file

g.     Copying & pasting data

h.     Importing from other sources

i.      Date/Calendar Table

j.      Automate Date Tables

4.     Power Pivot Window

a.     Date Formats

b.     Sheets & Columns

c.     Editing & Adding data

d.     Table Properties

e.     Filtering & Sorting

5.     Calculated Columns

a.     Referencing Columns

b.     Using Functions

c.     Referencing another Calculated Column

d.     RELATED function

e.     Aggregation functions

f.      Formula Errors

g.     Recap & Rules

6.     Relationships

a.     Introduction & Rules

b.     Defining Relationships

c.     AutoDetect Relationships

d.     Editing Relationships

e.     Multiple Relationships

f.      Working in Diagram View

g.     Ideal Data Structure

h.     Optimizing Data Structure

7.     Pivot Tables

a.     Inserting a PivotTable

b.     Filters and Slicers

c.     Sorting Options

d.     Sorting & Grouping Dates

e.     Show Value As

f.      Formatting PivotTables

g.     Chart & Table Combos

h.     Flattened PivotTable

i.      Arranging and Formatting Slicers

j.      GETPIVOTDATA

8.     Measures

a.     Implicit Measures

b.     Explicit Measures

c.     Context in DAX Formulas

d.     DAX Functions and Operators

e.     Overriding Context Rules

f.      Referencing Measures

g.     Measure Portability

h.     Understanding & Validating Measures

i.      Finding, Editing & Deleting Measures

j.      Interpreting Errors

9.     Must know DAX functions

a.     Expressions

b.     CALCULATE

c.     COUNTROWS

d.     FILTER

e.     DISTINCTCOUNT

f.      ALL

g.     ALLEXCEPT

h.     ALLSELECTED

i.      X FUNCTIONS

10.  Time Intelligence functions

a.     DAX functions

b.     PREVIOUSYEAR & NEXTYEAR

c.     DATESYTD & TOTALYTD

d.     DATESBETWEEN

e.     FIRSTDATE & LASTDATE

f.      CLOSING/OPENINGBALANCE

g.     DATEADD

h.     PARALLELPERIOD

i.      % Year on Year & Error Handling

11.  Power Pivot Tools

a.     Named Sets

b.     Perspectives and Hide from Client Tool

c.     Hierarchies

d.     Named Sets vs. Perspectives vs. Hierarchies

12.  CUBE functions

a.     Introduction to CUBE functions

b.     Writing CUBE functions

c. CUBESET & CUBERANKEDMEMBER