Course Outline Ch 2
CHAPTER 2: DATA WAREHOUSING Objectives: After completing this chapter, you should be able to: 1. Understand the basic definitions and concepts of data warehouses 2. Understand data warehousing architectures 3. Describe the processes used in developing and managing data warehouses 4. Explain data warehousing operations 5. Explain the role of data warehouses in decision support 6. Explain data integration and the extraction, transformation, and load (ETL) processes 7. Describe real-time (active) data warehousing 8. Understand data warehouse administration and security issues CHAPTER OVERVIEW Data warehousing is at the foundation of most BI. This is the data warehousing chapter of the book. Later chapters will use it as they discuss DW applications such as business analytics and data mining. I.
OPENING VIGNETTE: DIRECTV THRIVES WITH ACTIVE DATA WAREHOUSING, PAGE 30
Problem? The company’s IT system could not handle the high data volume from customer calls along with the rapidly changing market conditions. Solution? Developed a real-time, integrated active DW solution from Teradata and GoldenGate. Results? Huge business benefits such as reduced churn rate and better managed call centers with real-time data for decision making.
What can we learn from this vignette? 1. It illustrates the strategic value of implementing an active DW, along with its supporting BI methods. 2. The key lesson here is that a real-time, enterprise-level active DW combined with a strategy for its use in decision support can result in significant benefits (financial and otherwise) for an organization. Answer Questions for the Opening Vignette 1-5 on page 31. 1. 2. 3. Why is it important for DirecTV to have an active data warehouse? What were the challenges DirecTV faced on its way to having an integrated active data warehouse? Identify the major differences between a traditional data warehouse and an active data warehouse, such as the one implemented at DirecTV. What strategic advantage can
OPENING VIGNETTE: DIRECTV THRIVES WITH ACTIVE DATA WAREHOUSING, PAGE 30
Problem? The company’s IT system could not handle the high data volume from customer calls along with the rapidly changing market conditions. Solution? Developed a real-time, integrated active DW solution from Teradata and GoldenGate. Results? Huge business benefits such as reduced churn rate and better managed call centers with real-time data for decision making.
What can we learn from this vignette? 1. It illustrates the strategic value of implementing an active DW, along with its supporting BI methods. 2. The key lesson here is that a real-time, enterprise-level active DW combined with a strategy for its use in decision support can result in significant benefits (financial and otherwise) for an organization. Answer Questions for the Opening Vignette 1-5 on page 31. 1. 2. 3. Why is it important for DirecTV to have an active data warehouse? What were the challenges DirecTV faced on its way to having an integrated active data warehouse? Identify the major differences between a traditional data warehouse and an active data warehouse, such as the one implemented at DirecTV. What strategic advantage can