Exam 3: Descriptive Analytics II: Business Intelligence and Data Warehousing

Briefly describe four major components of the data warehousing process.

With key performance indicators,driver KPIs have a significant effect on outcome KPIs,but the reverse is not necessarily true.

Six Sigma rests on a simple performance improvement model known as DMAIC.What are the steps involved?

Data warehouses provide direct and indirect benefits to organizations.Which of the following is an indirect benefit of data warehouses?

More data,coming in faster and requiring immediate conversion into decisions,means that organizations are confronting the need for real-time data warehousing (RDW).How would you define real-time data warehousing?

________ is an evolving tool space that promises real-time data integration from a variety of sources,such as relational databases,Web services,and multidimensional databases.

The three main types of data warehouses are data marts,operational ________,and enterprise data warehouses.

________ describe the structure and meaning of the data,contributing to their effective use.

The ________ Model,also known as the data mart approach,is a "plan big,build small" approach.A data mart is a subject-oriented or department-oriented data warehouse.It is a scaled-down version of a data warehouse that focuses on the requests of a specific department,such as marketing or sales.

One way an operational data store differs from a data warehouse is the recency of their data.