Microsoft has introduced PowerPivot to give power to business power users. We have decided to create PowerPivot Tutorial using Excel 2013 (very similar in 2010) to help you create your models and get most of your data!
Important: PowerPivot model we teach is a local version. For enterprise level solution you should create a model in SQL Server 2012 using SSAS Tabular Model which often is created on top of a data warehouse, but don't worry you still have local power to expand it if you need to which is one of the biggest advantages of using PowerPivot (no more waiting!)
-
Excel 2013 Preview Download and Install - In order to follow this tutorial we recommend using PowerPivot with Excel 2013 but 2010 will work in most cases and we will make notes when there is something different that we are aware of. In this tutorial we show how to download and Install Excel 2013 Preview (not released yet)
-
Enable PowerPivot Add-In - If you have Installed Excel it is time to enable it and this tutorial shows you how to do that.
-
Import Data from SQL Server 2012 - We start creating the model by importing data from several simple tables and views from our SQL Server 2012 data warehouse
-
Create Relationships
-
Now that we have data from multiple tables it is time to create relationships between tables.
-
How to use PowerPivot in Excel 2013 - Here you will learn how to use PowerPivot model in Excel 2013 Preview using PivotTable.
-
Hide columns and Unhide - Making user navigation easy to use is critical and in this article we show how to hide Foreign Keys and columns that are not useful for users.
-
Changing default measure aggregation - This blog post shows how to change default aggregation which usually results in SUM to a different one and in this case we will change to Average without losing flexibility of changing aggregations on the fly
Not so much related:
PowerPiovot old menu look and feel
Take care
Katie & Emil
