Data warehouse presentation evaluation Essay Example | Topics and Well Written Essays - 500 words

Data warehouse presentation evaluation - Essay ExampleOn the downside, a top-down approach may take longer and toll more to deploy than other approaches, especially in the initial increments. (para.8-11)Bottom-Up Approach uses the bus building 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 oneness 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 using up about two weeks developing an enterprise model in third normal for m before developing the first data mart. The first some(prenominal) data marts are also designed in third normal form but deployed using star schema physical models.Federated Appro