Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
   Traditional vs. Holistic View of Execution Management Organization Readiness for Execution Scorecard  

ENCYCLOPEDIA→   Enterprise Intelligence  →   -  BI End-to-End  →   -  Business Intelligence Architecture Scenarios  → 

Two tier Data Warehouse Architecture- Staging and Data Warehouse

This is the utopian scenario, where an enterprise staging is supplying data to enterprise Data Warehouse.

This is close to point of arrival in Data Management. We are talking here of a single Staging Area leading to an enterprise-wide Data Warehouse. The detail of this scenario is covered in detail in Data Warehouse Section.

This topology has also got some variants, which are covered out here. The details of setting-up a Data Warehouse are covered in a separate section. The variants are:

Data Warehouse with a limited coverage

A large organization has a lot of systems, and even the best data warehouse will not be able to cover all. Data Warehouse is a relative and not an absolute term. Please refer to difference between the Data-Warehouse/Data-Mart and their respective criteria. If there is an initiative which meets the DW criteria, it can be called a data warehouse, even if it is not covering all possible systems. Typically an organization will have its first data warehouse covering the most critical business themes. This will further expand to include more and more themes over time.

Multiple Data warehouses

If an organization is large enough and has hundreds of systems, it may end-up with multiple information delivery platform with each being a Data Warehouse in its own right. However, these Data Warehouses will not be having overlapping purposes.

 

   Traditional vs. Holistic View of Execution Management Organization Readiness for Execution Scorecard  
 
 

Was this page helpful?
 
 
More on BI Architecture Scenarios
One tier Data Warehouse
2 tier DW Architecture- Independent Data Marts
3 Tier DW -Business Intelligence Architecture
BI Mixed Data Access
BI Metadata Architecture Scenarios
BUY BI & Data Management Vendors & Tools Evaluation Kit
Read more...
BUY largest on-line Data-Quality Management Kit
Read more...
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators



Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Behavior
Sales Revenue Management
Sales force density
Sales productivity
Sales Leads Classification and prioritization
Read more...
  Customer Relationship Management
Customer Segmentation Data Management
Supply Chain for Customer Service and Support
Customer Knowledge and Organizational Knowledge
Customer Service and Support - Strategic Role
Customer Satisfaction & Retention- Data Management
Read more...
  Human Resources & Leadership
Empower Front-line Employees
Competencies Definitions
Roles and Level based Competency Segregation
What is Leadership?
Strategic Business Plan
Read more...
 
 
Business Performance & Planning
Individual goal Sheet
SWOT Assessment Report
Strategy Map to Strategic theme
Business Objectives Drill Down
Review Session should stay focused
Read more...
  Business Intelligence & Data Quality
Strategy & process in dimensional model
BI Competency Centre- Services
Metadata Repository Transformation Design
Derived Dimension Attributes Table
Data Quality Tolerance and Business-Case
Read more...
  IT Vendors & Tools Management
OLAP Architecture Cache Management
BI Tool Vendor Evaluation
Data Searching and Matching
Report Development for Enterprise Reporting
Technical Evaluation- Interoperability
Read more...