Power Pivot primarily uses Data Analysis Expressions (DAX) as its expression language, although the model can be queried via Multidimensional Expressions (MDX) in a row set expression. This allows Excel to act as a self-service business intelligence (BI) platform, implementing professional expression languages to query the model and calculate advanced measures. This allows a user to build a ROLAP model in Power Pivot, and use pivot tables to explore the model once it is built.
Power Pivot extends a local instance of Microsoft Analysis Services tabular that is embedded directly into an Excel Workbook. It is available as an add-in in Excel 2010, 2013 in separate downloads, and as an add-in included with the Excel 2016 program.
Power Pivot, formerly known as PowerPivot (without spacing), is a feature of Microsoft Excel, a computer software spreadsheet. Microsoft SQL Server 2012 - Power Pivot for Microsoft Excel 2010 - Service Pack 2
0 kommentar(er)
