If you don’t use Excel for business intelligence (BI) purposes, you may not be familiar with Power Pivot.
According to Microsoft, Power Pivot is…
“…an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.”
Power Pivot is part of Excel BI features that will enable you to handle big data analytics. It’s also known as DAX or Data Analysis Expression Engine.
Until now, Excel for Mac still doesn’t have any Power Pivot functionality.
You can still open files that contain pivot tables with source data based on the Excel Data Model. But there will be no filters available.