Exam 13: Business Intelligence and Data Warehouses

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

Data _____ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.

is a term used to describe 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 used to support business decision making.

What is data visualization? Name different techniques of data visualization.

Business intelligence (BI) architecture is composed of data, people, processes, technology, and the management of such components.

_____ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of cells in the cube.

_____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

_____ makes a copy of a table and places it in a different location to improve access time.

_____ are numeric measurements (values) that represent a specific business aspect or activity.

The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed columns, including the last one.

What is the difference between decision support data and operational data from the point of view of data analyst?

Explain the concept of data analytics. What are the various tools of data analytics?

The reliance on as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.

_____ use web-based technologies to present key business performance indicators or information in a single integrated view, generally using graphics in a clear, concise, and easy to understand manner.

Fact and dimension tables are related by keys.

is a read-only database optimized for data analysis and query processing.

A star schema is designed to optimize data query operations rather than data update operations.

are in charge of presenting data to the end user in a variety of ways.

extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.

_____ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.