When the Power Pivot add-on is enabled, the Power Pivot tab in the ribbon is available, as shown in the following image.įrom the Power Pivot ribbon tab, select Manage from the Data Model section. The underlying modeling technology found in Power Pivot is also found in the Power BI Designer, which is part of the Power BI service offered from Microsoft.

Power Pivot is available as an add-in for Excel, which you can enable by following a few simple steps. The following links and information can get you going with Power Pivot, including how to enable Power Query in Excel, how to get started using Power Pivot, then tutorials, and community connections. Power Pivot is one of three data analysis tools available in Excel: With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations, all in a high-performance environment, and all within the familiar experience of Excel. Power Pivot is a data modeling technology that lets you create data models, establish relationships, and create calculations.

Microsoft uninstall office tool