Bottom Up Approach

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download Bottom Up Approach as PDF --


Bottom-Up Approach

The advantages of this approach are:

  • Faster and easier implementation of manageable piece
  • Favorable return on investment and proof of concept
  • Less risk of failure
  • Inherently incremental; can schedule important data marts first
  • Allows project team to learn and grow

The disadvantages are:

  • Each data mart has its own narrow view of data
  • Permeates redundant data in every data mart
  • Perpetuates inconsistent and irreconcilable data
  • Proliferates unmanageable interfaces

In this bottom-up approach, you build your departmental data marts one by one. You would set a priority scheme to determine which data marts you must build first. The most severe drawback of this approach is data fragmentation. Each independent data mart will be blind to the overall requirements of the entire organization.

Courtesy: Data Warehouse Fundamentals – Paulraj Ponniah

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

Your email address will not be published. Required fields are marked *


*