2015
2:36 hours
1 – Opening Intro
2 – Power Pivot for the Excel User – Introduction
3 – Installing Power Pivot
4 – Import data from access
5 – import data from custom query
6 – import data from excel
7 – Importing text files
8 – Saving your Power Pivot file
9 – Section 1 review
11 – Working with tables
12 – relationships
13 – Calculated Columns
14 – Insert Pivot Table
15 – Insert Pivot Charts
16 – Slicers
17 – Section 2 review
18 – understand measures
19 – Creating Measures
20 – Section 3 review
21 – DAX an introduction
22 – x functions and countrows
23 – Related and Related table
24 – Filer and Distinct
25 – Calculate function
26 – Section 4 review
27 – Time intelligence 1
28 – Time intelligence 2
29 – time intelligence 3
30 – Closing lecture