Category Archives: Power Pivot

Power Pivot is a business intelligence tool that can be used in Excel. It allows you to create tables and then connect these tables to a data model. It is an alternative to a classic database. There are tables on the individual sheets in Excel, which you connect via foreign keys and thereby create a data model. Using Power Pivot makes sense in certain cases when you don’t work with tables of large size and complexity and you don’t own any other tool at the same time.

💡 Note: Power Pivot used to be a separate add-in that had to be installed manually in Excel. Today, however, it’s fully integrated directly into Excel (starting with version 2016 and later, or in Microsoft 365) as part of the Data Model feature.

Some articles or functions described in this category may therefore refer to older versions of Excel and may behave differently or appear under different names in newer versions.

Don’t miss out from category:

Power Query, Power Pivot and Power BI – What’s the Difference?

By | 1. 12. 2019
0 Comment
Power Query, Power Pivot a Power BI

Best way to understanding of the differences between individual Power BI tools is to realize that every tool has some role in the whole processing of the final report. In standard MS Business intelligence we have tools by which we ensure data transformations (SSIS), processing of data model with data storage in relation structure (SQL… Read More »

Getting Started with Power Pivot – Data Modeling in Excel

By | 26. 11. 2019
0 Comment
Power pivot model

Powerpivot is an excel add-in enabling data modeling and analysis in familiar Excel environment which is certainly an advantage. Import big amounts of data through Power Query and connect them to each other using PowerPivot One of the upsides of power pivot is possibility to connect multiple data sources into one excel. It even do… Read More »