BUSINESS ADMINISTRATION
BUSINESS ANALYTICS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data Cube
|
|
|
Word Cloud
|
|
|
Drill-down Analysis
|
|
|
Online Analytical Processing
|
Detailed explanation-1: -Online Analytical Processing: Method used to analyze multidimensional data from many different perspectives (enables users to identify issues and opportunities and perform trend analysis).
Detailed explanation-2: -Relational OLAP (ROLAP) is OLAP that performs dynamic multidimensional analysis of data stored in a relational database.
Detailed explanation-3: -Dimensional Analysis OLAP can support aggregation of cumulative data (e.g., sums, averages, minimums, maximums) or numeric data (such as sales, number of employees, number of products produced, inventories) presented in a way that allows for interactive “drill-down, ” or successive detail analysis and exposition.
Detailed explanation-4: -Multidimensional data analysis is a method that, according to the management information demands, users observe the data from several angles of the real world and make a corresponding processing so as to get some useful information. Multidimensional data analysis cannot do without the foundation of data warehouse.
Detailed explanation-5: -Data retrieval An OLAP server returns new data to Excel every time that you change the layout of the report.