Business Intelligence Architecture Scenarios
Knowledge-Base -> Enterprise Intelligence -> BI End-to-End
CHAPTER - BI ARCHITECTURE COMPONENTS
These are the building block of the BI architecture. All possible architecture scenarios will have some or all of these components. This chapter endeavors to de-mystify the definitions of often misused terms.
Topics
BI Data Warehouse Source System
These are the feeder systems and start point of data flow in the overall BI architecture.
Data Warehouse BI Staging Area
Staging area is the place where all transformation, cleansing and enrichment is done before data can flow further.
De-normalized DW- Data Warehouse vs. Data mart
Data Warehouse/ Data Mart form the sanitized repository of Data which can be accessed for various purposes.
OLAP Server Layer and capabilities- Why is OLAP needed?
OLAP sits between the Data Warehouse and the End-User Tool.
ODS- Operational Data Store
Operational Data Store is a centralized repository of Data put on for online operational use.
BI & Data Warehouse- End User Tools
End User tools include tools for managing reporting, analytics, Data Mining, Performance and Decision Modeling.
Business Intelligence Metadata Model
Metadata is core to BI architecture. It provides a map, a catalogue and reference on data about the business, technical and operational elements of Business Intelligence Components. It spans across Business Metadata, BI technical metadata and Source Systems Metadata.
Business Intelligence Architecture Scenarios
   

   

All Chapters in :- " BI End-to-End "+ Section



Knowledge Map