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.

Don’t miss out from category: