Data Warehouses

How do organizations use data warehouses and data marts to acquire data?

Functions of a data warehouse

Obtain data

Cleanse data

Organize and relate data

Catalog data

For a small organization, the extraction may be as simple as an Access database. Larger organizations, however, typically create and staff a group of people who manage and run a data

warehouse, which is a facility for managing an organization’s BI data.

How do organizations use data warehouses and data marts to acquire data?

Dirty data

Missing values

Inconsistent data

Data not integrated

Wrong granularity

Too fine

Not fine enough

Too much data

Too many attributes

Too many data points

How do organizations use data warehouses and data marts to acquire data?

Data Type	Data Warehouse	Data Lake
Data Structure	Structured data	Structured and unstructured data
Data Structure	Cleaned and filtered data	Raw data
Data Structure	Historical data	Historical and real-time data
Data Structure	Operational systems and purchased data	Operational systems, purchased data, smart devices, clickstreams, social media posts, images, etc.
Users	Used by business analysts	Used by data scientists