-
Introduction to Pivots – Creating Pivots
12:13
-
Subtotals, Layouts, Selecting fields to Color – Pivot Features – Deep Dive
08:55
-
More Features – Insert Blank Lines, Item Labels, Grand Totals
16:30
-
Sorting the Pivot Fields
10:34
-
Identify the fields to be Sorted
05:21
-
Date Group – Must know feature for dashboards
21:39
-
GetPivotData function – Not many of us know this. Very Useful
13:08
-
Calculate the Contributions on Process level, Sub Levels – Incredible Pivots
30:29
-
More Contribution Percentages – Deep dive
09:15
-
Calculate Difference between previous and next Fields and much more
08:13
-
Ranking – Asc or Dsc order – Hidden Pivot feature
06:53
-
Slicers in Pivots- Let us take a deep dive into it
41:03
-
Sorting in SLICERS
02:46
-
Amazing Features of SLICERS – hide or show unwanted Fields
07:04
-
Remove Slicer field if no data available – Just loving it
03:57
-
Design the way you want – SLICER Colors Customizations – My favorite
03:57
-
Report Connection – Linking or de-linking of Slicer with Pivots – Must know
11:51
-
Create Pivot Charts – For Dashboards
36:30
-
Dashboard Making – Let us Begin
37:02
-
Finishing the Dashboard
29:30
-
Assignment Solutions – Refer to assignment text file for questions
05:41
-
Assignment Discussion Continue
14:13
-
Assignments Continues
15:20
-
Assignments – More questions
18:31
-
More exercises – Let us solve more questions
10:22
-
Exercises still continues
14:43
-
More practice More power in data analytics
12:56