In the introductory section, I showed you how to build this pivot table with power, pivot quickly
and without a single formula written, but I still haven't told you what power pivot is.
Power Pivot is part of what Microsoft calls cell service business intelligence.
It's an analytics cube that gets built and handled entirely with an excel by you bringing a limited
version of SQL Server Analytics components directly to your fingertips with no SQL knowledge required.
Power Pivot was originally released as a separate add on that with the release of Office 365 was only
included with select business subscription tiers.
In 2019, Microsoft bowed to pressure and made power pivot available to all business subscriptions.
And so, as of roughly June 2019, all Business Excel installations have access to the full suite of
power.
Pivot features, power pivots, analytics Cube is called the Excel data model and pivot tables that
reference this data model.
As shown here are the primary method of extracting the information that is held within.
Looking at the data connection for our pivot table, we can see the this workbook data model where in
the data model resides.
Working with the power pivot is primarily about defining and structuring the data model in such a way
as to make pivot tables and pivot charts flow effortlessly.
So what are some of the tools at our disposal?
The tool we used in the introduction was the relationships.
Ed will see many different ways to define these relationships through this course, but this one can
be found on the pivot table, analyze dynamic reben as well as on the data Rebin.
Up next is the power of its specific ribbon here you have access to the data model measures, KPIs and
settings, along with commands for adding tables directly to the data model and detecting relationships
in the existing workbook.
If your cell does not have this ribbon, do not fret, simply go to the data tab and click on the data
model button here.
If this is the first time you've done this, Excel ask you if you want to install the analytics adn
simply press.
Yes.
And you'll have your power pivot ribbon show up there after.
When you do press this button, the power pivot, for example, window will launch with its own ribbons
and interface.
There are two primary views within power.
Pivot, the data view and the diagram for you.
Initially, we're looking at the data view, which has our tables listed along the bottom that we can
flip through like Excel worksheets.
And if we look at our home tab of the ribbon and choose diagram for you, we get a high level picture
for how our data is mapped together.
The power private home tab is primarily for importing data, but it also includes some filter, sort
and view commands as well.
The design tab allows for some customization of our model, including relationships, function definitions
and data management.
We'll go through these in more detail later as well.
The advanced Drebin gets into a series of more complex features that go beyond the scope of this course
so we won't get into them.
In a nutshell, Power Pivot is a localized data analytics cube that's encapsulated it with an excel.
In our next lesson, we'll dive in and learn about data relationships conceptually, how to define them
and then use them with an Excel data model.