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
   Components of Execution Scorecard Performance Scorecard vs. Execution Scorecard  

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

Two tier Data Warehouse Architecture- Independent Data Marts

This is the next step of evolution before we get onto a Data warehouse

This is the next evolution state for an enterprise. This involves a Data Mart OR set of Independent Data Marts sitting on top of a single OR multiple staging databases. Data Mart is evolved as a quick solution to a business need. This results in Individual businesses and system owners creating their own data mart to meet their specific needs. Data-Mart does not work in isolation and it needs a staging database to get the data and OLAP tools to analyze the data contained in the data-mart. This leads to various variants of this topology.

NOTE- ‘Staging Database” for production reporting and transaction level queries can be different from the ‘Staging Database’ used for Data Warehouse/Data Marts .

The variants for Two Tier BI architecture are as follows:

The Single Staging and Single Data Mart

This is most basic variant. A single staging is created, which undergoes the standard Extraction and Transformation process. The data from this staging is loaded into a data mart. The Extraction and Transformation is fairly limited as we are looking at the select tables and ETL operations relevant only for the given data mart and it's purpose. Therefore, this doesn't have the concept of standard Dimensions and Measures. It may not always have Dimensional Model, IF the purpose of the Data Mart does not require too much of ad-hoc querying and the volume is also limited. For example a Data Mart made to analyze the reserves to fine-tune the reserve allocations at the end of every month, may not use Dimensional Model. This is because the use of this data mart is low volume, number of users is fairly limited and the type of analysis is predictable to certain extent.

Multiple Staging and Multiple Data Marts

This typically is the next stage of evolution, and most common one in the large enterprises. Once a business owner showcases the advantage of the a Data Mart, there is a lot of demand for creating new Data-Marts. Technology mostly does not get time to work out an overall strategy to have a common staging database to service all these Data Marts. This leads to individual Staging Areas getting created, which mostly serves one (sometimes more than one) Data Mart.

While the upside of this set-up is the quickest spread of Data-Marts and their business relevance, there are many risky downsides

  • Individual staging databases may end-up extracting the same information multiple times from the same source system. This leads to increase in the end of day Extraction load and time window.
  • If there is not a common control, the Transformation/Cleansing process may end-up having inconsistent data across the data-marts. This leads to lack of confidence.
  • Loss of control and inefficient use of resources.

Single Staging and Multiple Data Marts

This is the most ideal set-up in the given topology. This includes a common staging database, which provides loaded data into multiple independent Data-Marts. Lets see at how we reach this situation:

  • The start-point is the previous scenario (multiple Staging Areas and multiple Data Marts). As the downsides of this scenario come into play, a decision is made to have a common Staging Area.
    A common Staging Area is created quickly. All the information from the source systems is picked up as is.
  • The rest of the processes (which used to happen in the individual Staging Areas) are replicated in the common Staging Area as is. Thereafter, the Transformation/Loading processes and data sets follow the same isolated path as they used to do in Individual Staging Areas. Till this point, the Extraction load on sourcing systems is taken care of.
  • As the time passes, the Transformation processes happening in isolated fashion for individual data marts (within the common Staging Area) are rationalized. Therefore one may end-up with a common table of transformed & cleansed Customer data.
  • However, the output Data Sets for Loading into the data-marts may still be different. Therefore you will have two different Customer datasets created to be loaded into different data marts.

 

 

   Components of Execution Scorecard Performance Scorecard vs. Execution Scorecard  
 
 
All Topics in: "Business Intelligence Architecture Scenarios" Chapter
 One tier business intelligence with Staging area →  Two tier Data Warehouse Architecture- Independent Data Marts →  Two tier Data Warehouse Architecture- Staging and Data Warehouse →  Three Tier Data Warehouse + Data Mart BI Architecture →  Mixed Data Access Business Intelligence Architecture →  Business Intelligence Metadata Architecture centralized distributed Scenarios → 
 
 
More on BI Architecture Scenarios
One tier Data Warehouse
Two tier DW Architecture- Staging and DW
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 Campaign SWOT analysis
Sales productivity
Variable Sales Cost
Sales Compensation Analysis
Sales Compensation Management
Read more...
  Customer Relationship Management
Customer Value and Profitability-Overview
Customer Value and Profitability Tips and Actions
Customer Service and Support - Strategic Role
Customer-Centric product-service management
Customer Value and Profitability Data Management
Read more...
  Human Resources & Leadership
Setting Strategic Intent and Alignment
Fostering Innovation
Roles and Level based Competency Segregation
Give feedback closer to the observation
What is Leadership?
Read more...
 
 
Business Performance & Planning
Internal Info Assessment Report
Scorecards need manual finish
Strategy Blueprint Information Gathering
Strategy Map Objectives Measures and Initiatives
External Info Assessment Report
Read more...
  Business Intelligence & Data Quality
BI need not wait for legacy conversion
Data Mapping and Assessment
Data Mart Fact Table Grain Matrix in DW
What is Data Warehouse?
Three Tier Data Warehouse
Read more...
  IT Vendors & Tools Management
Collaboration and Administration Support
Data Quality Tools Wizards
enterprise Reporting Server connectivity
Technical Customization Evaluation
Vendor future plans Strategic fit
Read more...