Exam 13: Business Intelligence and Data Warehouses

The BI architecture is composed of data,people,processes,technology,and the management of such components.

To tie a KPI to the strategic master plan of an organization,a KPI will be compared to a desired goal within a specific time frame.

A characteristic of operational data is ____.

MDM's main goal is to provide a partial and segmented definition of all data within an organization.

A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.

Describe the use of SQL in relation to ROLAP.

Multidimensional data analysis techniques include advanced computational functions.

When you ____________________ data,you are aggregating the data to a higher level.

In a star schema,attributes are often used to search,filter,or classify ____.

From the data analyst's point of view,decision support data differ from operational data in three main areas: time span,granularity,and ____.

In practice,_________________________ provides a well-orchestrated framework for the management of data that works across all levels of the organization.

The ____ contains business data extracted from the operational database and from external data sources.

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

Data warehouses usually have one fact table.

____________________ 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.

The ____________________ hierarchy provides the capability to perform drill-down and roll-up searches in a data warehouse.

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

What is one of the main characteristics of OLAP systems?

Fact and dimension tables are related by ____ keys.

Periodicity,usually expressed as current year only,previous years,or all years,provides information about the time span of the data stored in the table.