Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Warehouse (GOALS (must make an organization's information easily…
Data Warehouse
-
-
-
ARCHITECTURE
SOURCE SYSTEMS
The source systems of a data warehouse can be legacy data sources, ERP’s, simple flat files to complex SAP sources, or COBOL sources or other data sources like RDBMS, AS/400, web application data, etc.
STAGING AREA
The staging area is a place where you hold temporary tables on the data warehouse server. We basically need a staging area to hold the data and perform data cleansing and merging, before loading the data into the warehouse.
-
DATA STORES
Operational Data store, Data Warehouse, Data Marts
ANALYTICS
Analytics is defined as the extensive use of data, statistical and quantitative analyses, explanatory and predictive modeling, and fact-based management to drive decision making.
DEFINE
is a powerful database model that significantly enhances the user’s ability to quickly analyze large, multidimensional data sets
is a collection of integrated, subject oriented databases designed to support the decision support function where each unit of data is relevant to some moment of time
-
-
CONTRAST
Data Warehousing
is a way of storing data and creating information through leveraging data marts. Data marts are segments or categories of information and/or data that are grouped together to provide insights into that segment or category
-