You can interact directly with relational databases via Excel. PowerPivot: Allows you to report on multiple data sources in a single report.

Power Query: Allows you to automatically perform data cleansing operations on internal and external data sources.PowerPivot is part of a series of Power add-ins made available with Excel in the past six years. When you install PowerPivot in Excel 2010 – it’s a free Microsoft add-in – you also have the data model. The data model seamlessly handles relational databases and related tables. Excel 2013 and Excel 2016 have built-in data models. I described this feature in the October 2015 Excel Yourself column. PivotTables are usually limited to reporting on a single table, but PowerPivot can report on multiple tables and has a new formula language that is designed to work with relational databases.Įxcel 2013 introduced a Relationships feature in the Data ribbon tab that enables PivotTables to report on multiple tables. I usually describe PowerPivot as a PivotTable on steroids (in a good way). PowerPivot takes PivotTables to another level. PivotTables are a powerful data analysis tool.

Power pivot for excel 2016