Excel Power Pivot Add-Ins Introduction-How to Use Power Pivot

In this video, you will learn:
How to
1. Excel power pivot add-ins introduction-How to use power pivot
2. How to add excel Power Pivot add-ins
Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. It can handle large volumes of data (millions of rows) from various sources and all of this within a single Excel file.

Power Pivot is basically a SQL Server Analysis Services engine made available using an in-memory process that runs directly within Excel. It is commonly referred to as an Internal Data Model. The most effective way to interact with the Internal Data Model is to use the Power Pivot Ribbon interface.

Once the Power Pivot add-in is installed and available, you can create a Data Model, which is a collection of tables with relationships. Any data you import into Excel or already have in Excel, once added to the data model is available in the Power Pivot window. The Power Pivot Ribbon gives you additional functions over and above the standard Excel Data tab.

The Power Pivot add-in is available in Excel 2010, and is native in Excel 2013 and 2016. However, only the following versions of Excel 2016 support the ‘Power Query’ functionality:

Excel 2016 – Office 365 ProPlus
Excel 2016 – Office 365 E3
Excel 2016 – Office 365 E4 andE5
To give you a feel for where Power Pivot fits in when using Excel for data analysis or visualization, let’s first have a quick look at how Power Pivot fits into the overall Business Intelligence process and how it works with the other BI tools in Excel.

Power Pivot acts as a data model, this means that the first step is to import some data. Unless it is already in your Excel sheet you will need a tool or connector to connect to different types of data sources and fetch your data. This can be a complex subject depending on your data source and is beyond the scope of this article.

After fetching the data, you will probably need to do some cleaning and transformation on it. Both these functions in Excel are carried out by another add-in called Power Query (in Excel 2010 and 2013) / Get & Transform (in Excel 2013).

The final step is creating the Power Pivot data model. This is where we create relationships between different data tables.

You can create simple measures or Key Performance Indicators (KPIs) in Power Pivot.

Finally, once you have all of the required metrics calculated, you can summarize the information in your Power Pivot data model using Pivot Tables and/or Pivot Charts. The combination of multiple Pivot Tables / Pivot Charts with slicers can be used to create a Dashboard.

……………………………………………………………………………………………………………………….
Share this video:    • Excel Power Pivot Add-Ins Introduction-How...  

For more simple and easy to follow How-to videos,

Click the Link Below to subscribe:
   / @learnexcelwitht  


#powerPivot #excelpowerpivot #office365 #exceldatamodel

LearnexcelwithT