Congratulations on completing this course, part of it is simple to jump into, but it can be very difficult
to master.
Think back to the beginning of this course, in one of the first videos about relationships, we were
able to create an entire infrastructure to replace Summers, averages, counties and a dozen other functions
without writing a single formula.
From there, we had to learn a little bit about data structuring and we had to learn DACs.
And then we had to look at and understand how to interpret context as it related to pivot tables.
But as you work with this, it'll become second nature to identify the qualitative parts of the data,
to split out and to look at the context and understand how to construct measures that you need.
On its own power, it has a fairly restrictive set of uses, however, it can tie into many, many different
features, both inside and outside of Excel.
The DAX language that drives Power Pivot is the same formula language that's used within the visualization
aspects of power by.
You can use exile's power to help you learn and test your measures as you get more comfortable with
context before you work in the more visually oriented confines of power by.
Similarly, while Power Pivot does allow you to import directly from different tools.
The primary reason I didn't cover that in this course is that it pairs so nicely with power query power
query is the data extraction transformation and loading system that's used both in Excel and power by
for accessing external data sets.
In Excel, you can either load it directly into the data model or you can load it into a table and look
at it outside.
If you find yourself manipulating data frequently for this type of table analysis or you need to integrate
with multiple different data sources, you should definitely look to power query as your next destination.
If you're a data consumer and you want to build better, more dynamic and frankly, much better looking
visuals than what Excel can allow, power buy should be your next stop.
Thank you again so much for taking this course.
I hope you found it helpful and I hope you'll consider looking at some of my other courses in the future.
Thanks and good luck.
And.