1
00:00:04,420 --> 00:00:09,380
And welcome to my course, introducing Power Pivot.

2
00:00:09,640 --> 00:00:11,140
I'm Phillip, and I'll be your guide.

3
00:00:11,710 --> 00:00:17,020
Whether you're new to excel or simply new to power pivot, this course will boost your ability to use,

4
00:00:17,170 --> 00:00:23,290
analyze and work with data within Excel for faster and better results, no matter what industry you

5
00:00:23,290 --> 00:00:23,770
work in.

6
00:00:24,460 --> 00:00:28,470
Have you ever needed to consolidate data into a summary from a larger data set?

7
00:00:28,840 --> 00:00:31,840
Maybe use a pivot table as the name implies?

8
00:00:31,840 --> 00:00:35,820
Power Pivot is an extension to the classic pivot table functionality.

9
00:00:36,070 --> 00:00:41,890
However, instead of working with just one table that you have to carefully craft, it can work across

10
00:00:41,890 --> 00:00:46,450
multiple tables with only a few mouse clicks and definitions set up along the way.

11
00:00:46,960 --> 00:00:52,060
We'll begin this course looking at those mouse clicks and I'll guide you through the basic data concepts

12
00:00:52,060 --> 00:00:57,490
you'll need to understand and how you'll want to set your data up to make manipulating it easy within

13
00:00:57,490 --> 00:00:58,870
the power pivot data model.

14
00:00:59,500 --> 00:01:04,210
Once you have a grasp of the data, concepts, along with an understanding of the Excel relationship

15
00:01:04,210 --> 00:01:07,510
manager will get into the power pivot data model itself.

16
00:01:08,200 --> 00:01:13,480
I'll discuss how to add and manipulate columns of data, and we'll do some preparation with data for

17
00:01:13,480 --> 00:01:14,320
pivot tables.

18
00:01:16,940 --> 00:01:22,280
These lessons will then transition into DACs, which is the formula based language behind power covid.

19
00:01:23,000 --> 00:01:28,460
I'll show you how to create custom calculated columns and then introduce you to the concept of measures

20
00:01:28,910 --> 00:01:29,720
with measures.

21
00:01:29,930 --> 00:01:35,690
We'll discuss context along with how to manage and manipulate the context before covering a handful.

22
00:01:35,840 --> 00:01:37,700
A specific case functions.

23
00:01:38,650 --> 00:01:43,690
To close out the course, I'll introduce you to custom hierarchies, give you a brief taste of some

24
00:01:43,690 --> 00:01:49,420
more advanced measures and demonstrate Parap of its key performance indicators before handing you an

25
00:01:49,420 --> 00:01:51,470
exercise to tie it all together.

26
00:01:52,750 --> 00:01:58,700
This course uses one single data set throughout it, and I constantly make additions and modifications

27
00:01:58,700 --> 00:02:04,480
to the pivot table analysis using that data for new and different informational results.

28
00:02:05,570 --> 00:02:11,030
To get the most out of this course, I advise that you watch the videos and attempt to recreate each

29
00:02:11,030 --> 00:02:16,640
step with the provided starting point for that video, by the end of the course, you'll be able to

30
00:02:16,640 --> 00:02:19,550
build pivot tables the way you always imagined they should be built.

31
00:02:20,360 --> 00:02:21,680
Thanks again for joining me.