Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATABASE AND DATA WAREHOUSE - Coggle Diagram
DATABASE AND DATA WAREHOUSE
DATA WAREHOUSE
a logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks
The primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes
BUSINESS INTELLIGENCE (BI)
Information that people use to support their decision-making efforts
PRINCIPLES
People
Culture
Technology
EXTRACTION, TRANSFORMATION, & LOADING (ETL)
A process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse
CUBE
Common term for the representation of multidimensional information
TYPES OF CUBE
CUBE B
Represents a slice of information displaying promotion II for all products at all stores
CUBE C
Represents a slice of information displaying promotion III for product B at store 2
CUBE A
Represents store information (the layers), product information (the rows), and promotion information (the columns)