And welcome to my course, introducing Power Pivot.
I'm Phillip, and I'll be your guide.
Whether you're new to excel or simply new to power pivot, this course will boost your ability to use,
analyze and work with data within Excel for faster and better results, no matter what industry you
work in.
Have you ever needed to consolidate data into a summary from a larger data set?
Maybe use a pivot table as the name implies?
Power Pivot is an extension to the classic pivot table functionality.
However, instead of working with just one table that you have to carefully craft, it can work across
multiple tables with only a few mouse clicks and definitions set up along the way.
We'll begin this course looking at those mouse clicks and I'll guide you through the basic data concepts
you'll need to understand and how you'll want to set your data up to make manipulating it easy within
the power pivot data model.
Once you have a grasp of the data, concepts, along with an understanding of the Excel relationship
manager will get into the power pivot data model itself.
I'll discuss how to add and manipulate columns of data, and we'll do some preparation with data for
pivot tables.
These lessons will then transition into DACs, which is the formula based language behind power covid.
I'll show you how to create custom calculated columns and then introduce you to the concept of measures
with measures.
We'll discuss context along with how to manage and manipulate the context before covering a handful.
A specific case functions.
To close out the course, I'll introduce you to custom hierarchies, give you a brief taste of some
more advanced measures and demonstrate Parap of its key performance indicators before handing you an
exercise to tie it all together.
This course uses one single data set throughout it, and I constantly make additions and modifications
to the pivot table analysis using that data for new and different informational results.
To get the most out of this course, I advise that you watch the videos and attempt to recreate each
step with the provided starting point for that video, by the end of the course, you'll be able to
build pivot tables the way you always imagined they should be built.
Thanks again for joining me.