- PowerPivot can manage the relationships between tables of source data and replace VLOOKUPs with simplified solutions. Data from multiple sources can be sourced creating relational data models. By incorporating intelligent calculated columns, PowerPivot dashboards can efficiently present Business Intelligence.
- In both Excel and in Power Pivot you can create a Data Model which is a collection of tables with relationships. The Data Model you see in a workbook in Excel is the same Data Model you see in the Power Pivot window. Any data you import into Excel is available in Power Pivot, and vice versa.
- Power Pivot is a Data Modelling technology that allows you to manage large data sets, build extensive relationships, and create simple or complex calculations within the Excel application environment.
- PowerPivot provides additional functionality and formulas, extending the functionality of pivot tables and pivot charts using concepts and features you may or may not already be familiar with.
Highlights
- Understand which Microsoft Packages include Power Pivot
- Enable Power Pivot on your computer