Create a 2 page essay paper that discusses Data warehouse presentation evaluation.
Download file to see previous pages…
On the downside, a top-down approach may take longer and cost more to deploy than other approaches, especially in the initial increments. (para.8-11)
Bottom-Up Approach uses the bus structure that contains all the common elements that are used by data marts such as conformed dimensions, measures etc defined for the enterprise as a whole. The major benefit of a Bottom-Up Approach is user-friendly, flexible data structure using dimensional, star schema models. It also delivers value rapidly. One problem is that it requires organizations to enforce the use of standard dimensions and facts to ensure integration and deliver a single version of the truth. (Eckerson para.12-18)
Hybrid Approach aims to harness the speed and user orientation of the Bottom-Up Approach to the integration of the Top-Down Approach. By Eckerson (para.19-25), Hybrid Approach recommends spending about two weeks developing an enterprise model in third normal form before developing the first data mart. The first several data marts are also designed in third normal form but deployed using star schema physical models.