Data Warehouse
Business Intelligence
- Definition
- Data warehouses are central repositories of integrated data from one or more disparate sources. They store current and historical data in one single place that are used for creating analytical reports for workers throughout the enterprise.
How does it work?
ETL is used to integrate data sources into the data warehouse. From there, the data is moved to specialized databases. A data mart is a simple form of a data warehouse that is focused on a single subject (or functional area), hence they draw data from a limited number of sources such as sales, finance or marketing.
Examples
- Business Intelligence (BI)
When should you use it?
- If you need a single common data model for all data of interest regardless of the data's source