Microsoft Office PowerPivot for Excel 2013

PowerPivot, a powerful data analysis tool, has been a part of Microsoft Office since its inception. With the release of Excel 2013, PowerPivot became even more robust and user-friendly. In this article, we'll explore how to enable PowerPivot in Excel 2013 and discuss some key differences between PowerPivot and Power BI.

Enabling PowerPivot

To enable PowerPivot in Excel 2013, follow these steps: Right-click on the PowerPivotExcelClientAddIn.NativeEntry.1 folder and select Delete. Then, expand the HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Addins registry key and locate the PowerPivot add-in. You can also enable PowerPivot by clicking on the 'File' menu in Excel 2013 and selecting 'Options,' then navigating to the 'Add-ins' tab.

Licensing Model

Microsoft's decision to change the licensing model for PowerPivot has raised some eyebrows among users. The company claims that this move is intended to separate PowerPivot from Power BI, but many users are left wondering if they'll be able to use PowerPivot with their existing version of Excel.

The reality is that not all versions of Excel include PowerPivot. For example, Office Small Business Premium, which runs at $12.50 a month, does not come with PowerPivot. On the other hand, Office 365 ProPlus, which costs $12 a month, includes Power Pivot.

PowerPivot vs. Power BI

One of the key differences between PowerPivot and Power BI is their data modeling capabilities. While Excel received some visualizations from Power BI, it did not inherit all of its data modeling capabilities. Power BI's diagram shows the directionality of relationships through arrows, whereas Power Pivot's diagram does not.

Another significant difference is that even when Power View is available in Excel 2016, it is turned off by default. The reason for this is that Power View's interactive visual experience is now available in Power BI Desktop.

In conclusion, PowerPivot remains a powerful tool for data analysis in Excel 2013. While the licensing model may be confusing, it's clear that Microsoft is trying to separate PowerPivot from Power BI. By understanding the differences between these two tools and how they can be used together, users can make informed decisions about their data analysis needs.

* PowerPivot is a powerful data analysis tool included in Excel 2013.

* To enable PowerPivot, right-click on the PowerPivotExcelClientAddIn.NativeEntry.1 folder and select Delete.

* The licensing model for PowerPivot has changed, with some versions of Excel not including PowerPivot.

* PowerPivot and Power BI have different data modeling capabilities.

* Power View is turned off by default in Excel 2016, but can be enabled through registry edits.

Microsoft office powerpivot for excel 2013