1
00:00:00,780 --> 00:00:06,600
Congratulations on completing this course, part of it is simple to jump into, but it can be very difficult

2
00:00:06,600 --> 00:00:07,260
to master.

3
00:00:08,860 --> 00:00:13,720
Think back to the beginning of this course, in one of the first videos about relationships, we were

4
00:00:13,720 --> 00:00:20,740
able to create an entire infrastructure to replace Summers, averages, counties and a dozen other functions

5
00:00:20,950 --> 00:00:22,640
without writing a single formula.

6
00:00:23,440 --> 00:00:27,640
From there, we had to learn a little bit about data structuring and we had to learn DACs.

7
00:00:27,790 --> 00:00:34,230
And then we had to look at and understand how to interpret context as it related to pivot tables.

8
00:00:35,050 --> 00:00:40,060
But as you work with this, it'll become second nature to identify the qualitative parts of the data,

9
00:00:40,060 --> 00:00:45,250
to split out and to look at the context and understand how to construct measures that you need.

10
00:00:46,350 --> 00:00:53,010
On its own power, it has a fairly restrictive set of uses, however, it can tie into many, many different

11
00:00:53,010 --> 00:00:55,830
features, both inside and outside of Excel.

12
00:00:56,920 --> 00:01:02,740
The DAX language that drives Power Pivot is the same formula language that's used within the visualization

13
00:01:02,740 --> 00:01:04,300
aspects of power by.

14
00:01:05,930 --> 00:01:13,250
You can use exile's power to help you learn and test your measures as you get more comfortable with

15
00:01:13,250 --> 00:01:18,230
context before you work in the more visually oriented confines of power by.

16
00:01:19,480 --> 00:01:24,130
Similarly, while Power Pivot does allow you to import directly from different tools.

17
00:01:25,420 --> 00:01:31,870
The primary reason I didn't cover that in this course is that it pairs so nicely with power query power

18
00:01:31,870 --> 00:01:37,810
query is the data extraction transformation and loading system that's used both in Excel and power by

19
00:01:37,810 --> 00:01:39,940
for accessing external data sets.

20
00:01:40,980 --> 00:01:46,860
In Excel, you can either load it directly into the data model or you can load it into a table and look

21
00:01:46,860 --> 00:01:47,700
at it outside.

22
00:01:49,440 --> 00:01:56,190
If you find yourself manipulating data frequently for this type of table analysis or you need to integrate

23
00:01:56,190 --> 00:02:01,860
with multiple different data sources, you should definitely look to power query as your next destination.

24
00:02:02,750 --> 00:02:07,790
If you're a data consumer and you want to build better, more dynamic and frankly, much better looking

25
00:02:07,790 --> 00:02:11,840
visuals than what Excel can allow, power buy should be your next stop.

26
00:02:13,290 --> 00:02:15,700
Thank you again so much for taking this course.

27
00:02:15,720 --> 00:02:20,760
I hope you found it helpful and I hope you'll consider looking at some of my other courses in the future.

28
00:02:22,010 --> 00:02:23,240
Thanks and good luck.

29
00:02:32,760 --> 00:02:33,070
And.
