Business Intelligence: A Managerial Perspective on Analytics(3rd Edition) INTELLIGENCE A Managerial Perspective on Analytics Chapter 2: RAMESH SHAL EFRAUTI RRAN Data Warehousing
Chapter 2: Data Warehousing Business Intelligence: A Managerial Perspective on Analytics (3rd Edition)
Learning objectives Understand the basic definitions and concepts of data warehouses Learn different types of data warehousing architectures; their comparative advantages and disadvantages Describe the processes used in developing and managing data warehouses Explain data warehousing operations Continued.) Copynight@ 2014 Pearson Education, Inc Slide 2-2
Copyright © 2014 Pearson Education, Inc. Slide 2- 2 Learning Objectives ▪ Understand the basic definitions and concepts of data warehouses ▪ Learn different types of data warehousing architectures; their comparative advantages and disadvantages ▪ Describe the processes used in developing and managing data warehouses ▪ Explain data warehousing operations (Continued…)
Learning Objectives Explain the role of data warehouses in decision support Explain data integration and the extraction, transformation, and load(ETL processes Describe real-time(ak a. right-time and/or active)data warehousing Understand data warehouse administration and security issues Copynight@ 2014 Pearson Education, Inc Slide 2-3
Copyright © 2014 Pearson Education, Inc. Slide 2- 3 Learning Objectives ▪ Explain the role of data warehouses in decision support ▪ Explain data integration and the extraction, transformation, and load (ETL) processes ▪ Describe real-time (a.k.a. right-time and/or active) data warehousing ▪ Understand data warehouse administration and security issues
Opening Vignette Isle of Capri Casinos Is Winning with Enterprise Data Warehouse Company background Problem description Proposed solution Results Answer discuss the case questions Copynight@ 2014 Pearson Education, Inc Slide 2-4
Copyright © 2014 Pearson Education, Inc. Slide 2- 4 Opening Vignette… Isle of Capri Casinos Is Winning with Enterprise Data Warehouse ▪ Company background ▪ Problem description ▪ Proposed solution ▪ Results ▪ Answer & discuss the case questions
Questions for the Opening Vignette 1. Why is it important for Isle to have an EDW? 2. What were the business challenges or opportunities that ? Isle was facing 3. What was the process Isle followed to realize EDW? Comment on the potential challenges Isle might have had going through the process of EDW development 4. What were the benefits of implementing an EDW at Isle? Can you think of other potential benefits that were not listed in the case? 5. Why do you think large enterprises like Isle in the gaming industry can succeed without having a capable data warehouse/business intelligence infrastructure? Copynight@ 2014 Pearson Education, Inc Slide 2-5
Copyright © 2014 Pearson Education, Inc. Slide 2- 5 Questions for the Opening Vignette 1. Why is it important for Isle to have an EDW? 2. What were the business challenges or opportunities that Isle was facing? 3. What was the process Isle followed to realize EDW? Comment on the potential challenges Isle might have had going through the process of EDW development. 4. What were the benefits of implementing an EDW at Isle? Can you think of other potential benefits that were not listed in the case? 5. Why do you think large enterprises like Isle in the gaming industry can succeed without having a capable data warehouse/business intelligence infrastructure?