To create an OLAP report for an SQL Server 2012 database,we can build a PivotTable in:
A)Microsoft Access 2013.
B)Microsoft Word 2013.
C)Microsoft Visio 2013.
D)Microsoft Excel 2013.
E)Microsoft PowerPoint 2013.

Question

Quizplus · Accepted Answer

Microsoft Excel 2013 is the best choice for creating an OLAP report for an SQL Server 2012 database as it allows building PivotTables which are specifically designed for analyzing and presenting multidimensional data. Other Microsoft applications may have some data analysis features, but Excel offers the most comprehensive set of tools for creating OLAP reports.

To Create an OLAP Report for an SQL Server 2012