Data Warehouse Overview$$Part $2$

All business aspects can benefit from the added insights provided by business intelligence and data$-$driven decision management is a way for businesses to gain a competitive advantage. This activity provides an overview of common terms used related to data warehousing.

The goal of this activity is for you to identify terms associated with business intelligence and data warehousing.

Instructions: Match each term to its correct definition.

Data lake Data mart Data cleansing and scrubbing Information cube Dirty data Extraction, transformation and loading $($ETL$)$

Match each of the options above to the items below.

A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete data

No answer

The common term for the representation of multidimensional data

No answer

A process that extracts data from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse

No answer

Erroneous or flawed data

No answer

Contains a subset of data warehouse data

No answer

A storage repository that holds a vast amount of raw data in its original format until the business needs it

No answer