(7) Business Intelligence

Question 1

Data visualization

Answer 1

Abstracting data to provide information in a visual format that enhances the user’s ability to effectively comprehend the meaning of the data.

Question 2

Drill down

Answer 2

To decompress data into more atomic components-that is, data at lower levels of aggregation. This approach is used primarily in a decision support system to focus on specific geographic areas, business types, and so on.

Question 3

Cube cache

Answer 3

In multidimensional OLAP, the shared, reserved memory area where data cubes are held. Using this assists in speeding up data access.

Question 4

Decision support system (DSS)

Answer 4

An arrangement of computerized tools used to assist managerial decision making within a business.

Question 5

Data warehouse

Answer 5

An integrated, subject-oriented, time-variant, nonvolatile collection of data in a specialized database that stores historical and aggregated data in a format that provides support for decision making.

Question 6

Extraction, transformation, and loading (ETL)

Answer 6

In a data warehousing environment, the integrated processes of getting data from original sources into the data warehouse. ETL includes retrieving data from original data sources (extraction), manipulating the data into an appropriate form (transformation), and storing the data in the data warehouse (loading).

Question 7

Dashboards

Answer 7

In business intelligence, a web-based system that presents key business performance indicators or information in a single, integrated view with clear and concise graphics.

Question 8

Data mart

Answer 8

A small, single-subject data warehouse subset that provides decision support to a small group of people.

Question 9

Dimension table’s

Answer 9

In a data warehouse, table’s used to search, filter, or classify facts within a star schema.

Question 10

Data cube

Answer 10

The multidimensional data structure used to store and manipulate data in a multidimensional DBMS. The location of each data value in this is based on its X-, y-, and z- axes. These are static, meaning they must be created before they are used, so they cannot be created by an ad hoc.

Question 11

Business intelligence (BI)

Answer 11

A comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making.

Question 12

Governance

Answer 12

In business intelligence, the methods for controlling and monitoring business health and promoting consistent decision making.

Question 13

Key Performance Indicators (KPI)

Answer 13

In business intelligence, quantifiable numeric or scale-based measurements that assess a company’s effectiveness or success in reaching strategic and operational goals. Examples are product turnover, sales by promotion, sales by employee, and earnings per share.

Question 14

Master data management (MDM)

Answer 14

In business intelligence, a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

Question 15

Multidimensional database management systems (MDBMS’s)

Answer 15

A database management system that uses proprietary techniques to store data in matrix like arrays of n dimensions known as cubes.

Question 16

Multidimensional online analytical processing (MOLAP)

Answer 16

An extension of online analytical processing to multidimensional database management systems.

Question 17

Portals

Answer 17

In terms of business intelligence, a unified, single point of entry for information distribution.

Question 18

Relational online analytical processing (ROLAP)

Answer 18

Analytical processing functions that use relational databases and familiar relational query tools to store and analyze multidimensional data.

Question 19

Roll up

Answer 19

(1) To aggregate data into summarized components, that is, higher levels of aggregation. (2) In SQL, an OLAP extension used with the GROUP BY clause to aggregate data by different dimensions. Rolling up the data is the exact opposite of drilling down the data.

Question 20

Slice and dice

Answer 20

The ability to focus on slices of a data cube (drill down or roll up) to perform a more detailed analysis.

Question 21

Scarcity

Answer 21

In multidimensional data analysis, a measurement of the data density held in the data cube.

Question 22

Very large databases (VLDB’s)

Answer 22

Database that contains huge amounts of data.