05-Unit5 - Business Intelligence and Tools Unit 5 Unit 5...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Business Intelligence and Tools Unit 5 Sikkim Manipal University Page No. 107 Unit 5 Implementing and Maintaining a Data Warehouse Environment Structure 5.1 Introduction Objectives 5.2 Approaches in Implementing a Data Warehouse 5.2.1 Top Down Approach 5.2.2 Bottom Up Approach 5.2.3 A Combined Approach Self Assessment Question(s) (SAQs) 5.3 Visual Warehouse 5.3.1 The Architecture of Visual Warehouse Self Assessment Question(s) (SAQs) 5.4 Measuring the Data Warehouse Results 5.5 DW Tools in Use 5.5.1 Data Modeling Tools 5.5.2 ETL and Metadata Creation Tools 5.5.3 Data Analysis and Report Generation Tools 5.5.4 Commercial Tools Self Assessment Question(s) (SAQs) 5.6 Summary 5.7 Terminal Questions (TQs) 5.8 Multiple Choice Questions (MCQs) 5.9 Answers to SAQs, TQs, and MCQs 5.9.1 Answers to Self Assessment Questions (SAQs) 5.9.2 Answers to Terminal Questions (TQs) 5.9.3 Answers to Multiple Choice Questions (MCQs) 5.1 Introduction After the selection of an appropriate architecture, the data warehouse has to be implemented and maintained effectively so as to meet the objectives set. These implementation methods include the top down approach and bottom
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Business Intelligence and Tools Unit 5 Sikkim Manipal University Page No. 108 up approach. The project managers of the BI projects are expected to monitor the performance of the data warehouse on a continuum basis to ensure that the data warehouse is successful in providing the best possible assistance to the decision-making processes of the organization. Also, the current unit makes an attempt to make the reader aware of the data warehousing tools available in the present market. Objectives: The objectives of the Unit are to make you understand: The approaches involved in implementing a data warehouse The architecture of a visual data warehouse Measuring the data warehouse results Critical success factors of BI systems Various data warehousing tools available in the market 5.2 Approaches in Implementing a Data Warehouse The approaches that are in practice in implementing a data warehouse include Top down approach Bottom up approach A combination of both A project manager can adopt any of these approaches as these implementation choices offer flexibility in determining the criteria that are important in any particular implementation. Here, the choice of an implementation approach is influenced by various factors such as the current infrastructure, availability and affordability of the resources, the type of architecture chosen, the scope of the implementation, and return-on- investment requirements. 5.2.1 Top Down Approach The top-down approach views the data warehouse (refer Fig 5.1) as the mainstay of the entire analytic environment. The data warehouse holds
Image of page 2