Using PowerPivot to build a simple analysis model

A PivotTable report is a flexible tool through which users can easily generate the reports they need. Both for professional IT users and for users of the business unit, they are familiar with the tool for Excel and are quite "well versed" in the way PowerPivot is used.

The data source for a traditional PivotTable report can be either an Excel worksheet or an analysis of the cubes in a service in two main ways. Relative to the former because the data is stored in Excel worksheet, so the business operators are easy to get started, very suitable for small-scale data statistical analysis. The latter analysis of the services of the cube this way, because the data is aggregated in a special way in a unique file system, so it is suitable for large-scale data analysis, the disadvantage is that the development of the analysis service for it is relatively high, only by the IT staff to complete, So a requirement for a business person often waits a long time to get a response.

So, can a business operator have a high-performance data that analyzes a slightly larger size? PowerPivot is a program offered by Microsoft. In this scheme, the data is loaded directly into memory, and after some optimization, it ensures a high performance through the statistics of the pivot table.

First, in the version prior to Excel 2013, this tool needs to be downloaded separately. If you do not have Office 2013, then I recommend that your version not be less than 2010, in this version of the PowerPivot version of the evolution.

Download Address:

http://www.microsoft.com/en-us/download/details.aspx?id=29074

Download needs to be aware of the language version of Excel and the 32-bit version or 64-bit version.

Another area to note is that this is the second version of Povittable for Excel 2010, and there is a previous version that is missing some of the features in Microsoft's current tutorials and the introduction to this article. So if you have previously installed PowerPivot, make sure that this version is correct.

After you have installed it, you can see one more item in the Ribbon menu when you open Excel:

Before using this tool, you need to prepare the data. You can use data directly from an Excel worksheet, or you can use data from other data sources, such as SQL Server.

This assumes that a sales department's data is already in the IT department's data warehouse, and the sales analyst simply imports the relevant data into the PowerPivot and then builds its own analysis model with a simple setup.

Clicking the PowerPoint Window in the PowerPivot tab opens the PowerPivot tool:

Assuming that the IT department has granted access to a partial response table for the Data Warehouse system of the Sales Analysis Department, what the analyst needs to do is to import the corresponding table into the PivotTable tool.

Click From Database in the toolbar above: