1
00:00:00,390 --> 00:00:05,460
In the introductory section, I showed you how to build this pivot table with power, pivot quickly

2
00:00:05,460 --> 00:00:09,960
and without a single formula written, but I still haven't told you what power pivot is.

3
00:00:10,470 --> 00:00:14,640
Power Pivot is part of what Microsoft calls cell service business intelligence.

4
00:00:15,070 --> 00:00:21,060
It's an analytics cube that gets built and handled entirely with an excel by you bringing a limited

5
00:00:21,060 --> 00:00:26,490
version of SQL Server Analytics components directly to your fingertips with no SQL knowledge required.

6
00:00:27,210 --> 00:00:33,360
Power Pivot was originally released as a separate add on that with the release of Office 365 was only

7
00:00:33,360 --> 00:00:35,880
included with select business subscription tiers.

8
00:00:36,270 --> 00:00:41,760
In 2019, Microsoft bowed to pressure and made power pivot available to all business subscriptions.

9
00:00:41,760 --> 00:00:47,790
And so, as of roughly June 2019, all Business Excel installations have access to the full suite of

10
00:00:47,790 --> 00:00:48,090
power.

11
00:00:48,090 --> 00:00:54,180
Pivot features, power pivots, analytics Cube is called the Excel data model and pivot tables that

12
00:00:54,180 --> 00:00:55,620
reference this data model.

13
00:00:55,620 --> 00:01:00,420
As shown here are the primary method of extracting the information that is held within.

14
00:01:00,810 --> 00:01:06,210
Looking at the data connection for our pivot table, we can see the this workbook data model where in

15
00:01:06,210 --> 00:01:07,530
the data model resides.

16
00:01:08,310 --> 00:01:13,410
Working with the power pivot is primarily about defining and structuring the data model in such a way

17
00:01:13,650 --> 00:01:16,850
as to make pivot tables and pivot charts flow effortlessly.

18
00:01:17,880 --> 00:01:20,130
So what are some of the tools at our disposal?

19
00:01:20,730 --> 00:01:23,400
The tool we used in the introduction was the relationships.

20
00:01:23,400 --> 00:01:28,620
Ed will see many different ways to define these relationships through this course, but this one can

21
00:01:28,620 --> 00:01:33,510
be found on the pivot table, analyze dynamic reben as well as on the data Rebin.

22
00:01:34,610 --> 00:01:41,390
Up next is the power of its specific ribbon here you have access to the data model measures, KPIs and

23
00:01:41,390 --> 00:01:46,550
settings, along with commands for adding tables directly to the data model and detecting relationships

24
00:01:46,550 --> 00:01:47,780
in the existing workbook.

25
00:01:49,130 --> 00:01:54,530
If your cell does not have this ribbon, do not fret, simply go to the data tab and click on the data

26
00:01:54,530 --> 00:01:55,510
model button here.

27
00:01:56,180 --> 00:02:01,460
If this is the first time you've done this, Excel ask you if you want to install the analytics adn

28
00:02:01,910 --> 00:02:02,660
simply press.

29
00:02:02,660 --> 00:02:03,080
Yes.

30
00:02:03,290 --> 00:02:06,020
And you'll have your power pivot ribbon show up there after.

31
00:02:07,020 --> 00:02:11,700
When you do press this button, the power pivot, for example, window will launch with its own ribbons

32
00:02:11,700 --> 00:02:12,440
and interface.

33
00:02:12,930 --> 00:02:14,760
There are two primary views within power.

34
00:02:14,760 --> 00:02:17,520
Pivot, the data view and the diagram for you.

35
00:02:17,910 --> 00:02:22,740
Initially, we're looking at the data view, which has our tables listed along the bottom that we can

36
00:02:22,740 --> 00:02:24,480
flip through like Excel worksheets.

37
00:02:25,110 --> 00:02:30,390
And if we look at our home tab of the ribbon and choose diagram for you, we get a high level picture

38
00:02:30,390 --> 00:02:32,520
for how our data is mapped together.

39
00:02:33,720 --> 00:02:39,600
The power private home tab is primarily for importing data, but it also includes some filter, sort

40
00:02:39,780 --> 00:02:41,260
and view commands as well.

41
00:02:42,270 --> 00:02:47,970
The design tab allows for some customization of our model, including relationships, function definitions

42
00:02:47,970 --> 00:02:48,920
and data management.

43
00:02:49,380 --> 00:02:51,810
We'll go through these in more detail later as well.

44
00:02:52,230 --> 00:02:57,030
The advanced Drebin gets into a series of more complex features that go beyond the scope of this course

45
00:02:57,030 --> 00:02:58,260
so we won't get into them.

46
00:02:58,770 --> 00:03:04,670
In a nutshell, Power Pivot is a localized data analytics cube that's encapsulated it with an excel.

47
00:03:05,280 --> 00:03:11,160
In our next lesson, we'll dive in and learn about data relationships conceptually, how to define them

48
00:03:11,160 --> 00:03:13,470
and then use them with an Excel data model.