Power Pivot

The data that you work on in the Power Pivot window is stored in an analytical database inside the Excel workbook along with all updates, queries, and engine loads. Since data is present in Excel itself, it is readily available to different features like pivot tables and pivot charts that increase the interactivity of data. Moreover, Power Pivot can support up to 4 Gigabytes of data in memory.

Following are some of the features of Power Pivot:

1. While importing, the data from different sources should be filtered, and columns and tables should be renamed.

2. You can create using Tabbed pagesA page that contains different tabs; each tab has its own title and its own content depending upon the type and logic of the application. in the Power Pivot window.

3. You can create relationships using the diagram view or create a relationships box.

4. Perform calculation using Data Analysis expression language (DAX)Provides a specialized syntax for querying Analysis Services tabular model. DAX is not a programming language. DAX is primarily a formula language and a query language. formulas.

5. You may define Hierarchies to be applied everywhere in the notebook.

6. You can create Key Performance indicatorsA measurable value that demonstrates how effectively a company is achieving key business objectives. (KPIs).

For more information, click here.