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

Question

Quizplus · Accepted Answer

Microsoft Excel 2013 has built-in functionality to create PivotTable reports which can be used to create OLAP reports for an SQL Server 2014 database. PivotTables allow users to summarize and filter large amounts of data quickly and easily. Microsoft Access and Microsoft Visio do not have built-in functionality for creating OLAP reports, and Microsoft Word is a word processing program, not a data analysis tool.

To Create an OLAP Report for an SQL Server 2014