Building Making It Happen
Building Making It Happen
  Sign-in         Register
    
Ask a question Listing Page
Data Warehouse- Big Bang or Incremental
Should one for a big bang or incremental strategy for a data warehouse. If one does not go for a big bang, then how does one make possible to integrate multiple data marts at a later stage?
 
This page of 'Ask a question' is linked to:  Data Warehousing, BI business intelligence end-to-end view,


Incremental approach is the best strategy. This is less to do with technology & infrastructure but more with the stamina in business to define and think through on what they need and why they need. This also gives the learning experience to the team, as every data warehouse project is little different. This will also test management's culture & capability to use the data warehouse information. The conventional steps are to create a set of data marts first. While creating the data marts, do try (as much as possible) to create standard set of dimensions and measures across the data-marts. After few data-marts are created and the readiness of organization improves, one can go for creating a data warehouse. This is called Bottom-Up Data Warehouse approach.

When we say Incremental Strategy, it does not indicate another extreme. There has to be some level critical mass for a data-mart. A data-warehouse initiative should analysis all the business requirements of that function. For example in sales management function, one should analysis sales revenue, sales profitability, sales campaign, sales compensation, sales channel and sales process, before short listing the themes one is focusing on. You may not immediatly build data-marts on all these areas in a function, but you should analyze them before you start your dimensional modeling. Data Mart initiative at a functional level should also not be too narrow, as it puts a significant constraints on future growth.

These are been some views of creating a large enterprise level data warehouse, and then create data-marts as per the requirements of a function. The Data Warehouse in this case is typically normalized. This is called Top down data warehouse technique. Unless we have a very stable and mature organization, we should go for Bottom-up approach. It may be worthwhile to refer to Integration Strategies for Stand-Alone BI environments.

   Access more details on this page   

Quick Feedback- Was this information helpful ?
Relevant Links to this page
Expert's Answers → Entry criteria to start DW project → Expert's Answers → Online data feed to Data Warehouse. → Expert's Answers → Dimensional model vs Relational model → Expert's Answers → Interview sequence for DW business requirements → Expert's Answers → Pre-configured reports- Do they work? → Expert's Answers → Business Intelligence vs Business Performance → Expert's Answers → Integrating Data Marts to Data Warehouse → Expert's Answers → EAI vs Data Warehouse → Expert's Answers → Operational Data Store vs Data Warehouse → Expert's Answers → Source of Enterprise Reporting → Expert's Answers → Data Warehouse Source System approach → Expert's Answers → ROI of Data Warehouse → Expert's Answers → Partial Customer Information → Expert's Answers → Source system re-writing in parallel to Data Warehouse → Expert's Answers → Alignment between Source Systems and Data Warehouse → Expert's Answers → Maximizing usage of Data Warehouse → Expert's Answers → Simultaneous launch of source system and Data Warehouse → Expert's Answers → Security Matrix of a Data Warehouse → Expert's Answers → ETL phase taking too long → Expert's Answers → Should Data Warehouse wait for Meta-Data initiative → Expert's Answers → Mismatch in Source vs Data Warehouse reporting. → Expert's Answers → Data Warehouse vs Data Mart vs Data Mining → 
 
Back
Featured Pages
Data Warehouse Performance Management
Data Warehouse Source Systems
Add extra buffer for ETL phase
Dimensional non Strict Hierarchy

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
Data Mining Techniques- Predictive Modeling
Articulate better for better BI decisioning
Data Mining Techniques- Propensity Modeling
Metadata Objective and purpose- Why Metadata