Data Warehousing Fundamentals To answer the assignment questions, you have to refer to the textbooks. If you would like to use outside references, you could use just one to two references. DO NOT use direct quote, but paraphrasing is ok. The main idea is to show me your thought and understanding. The assignment from this textbook: ISBN-13: 978-0-470-46207-2 Title: Data Warehousing Fundamentals for IT Professionals Authors: Ponniah, Paulraj Publisher: 2011 by John Wiley Edition: 2nd edition ASSIGNMENT-3 Data Warehousing Text Read Chapters 11 “ 15, 18 Data Warehousing Text Exercise #2 pg. 279 Assume you are in the insurance business. Find two examples of type 2 slowly changing dimensions in that business. As an analyst on the project, write the specifications for applying the type 2 changes to the data warehouse with regard to the two examples. Exercise #5 pg. 314 You are the staging area expert on the project team for a large toy manufacturer. Discuss the four modes of applying data to the data warehouse. Select the modes you want to use for your data warehouse and explain the reasons for your selection. Exercise #2 pg. 337 Assume that you are the data quality expert on the data warehouse project team for a large financial institution with many legacy systems dating back to the 1970’s. Review the types of data quality problems you are likely to have and make suggestions on how to deal with those. Exercise #2 Page 372 Compare the usage and value of information in the data warehouse with those in operational systems. Explain the major differences. Discuss and give examples. Exercise #2 Page 405 As a senior analyst on the project team of a publishing company exploring the options for a data warehouse, make a case for OLAP. Describe the merits of OLAP and how it will be essential in your environment. Exercise #2 Page 487 Prepare an outline for a standards manual for your data warehouse. Consider all types of objects and their naming conventions. Indicate why standards are important. Produce a detailed table of contents. Data Warehousing Text Read Chapters 16, 17, 19, 20 Data Warehousing Text Exercise #5 Page 427 As the web specialist on the project team, prepare a document highlighting the major considerations for Web-enabling your data warehouse. Just list the considerations, not the implementation techniques. Exercise #5 Page 460 In your project you are responsible for analyzing the requirements and selecting a toolset for data mining. Make a list of the criteria you will use for the toolset selection. Briefly explain why each criterion is necessary. Exercise #4 Page 509 What are the considerations for deploying the data warehouse in stages? Under what circumstances is staged deployment recommended? Describe how you will plan to determine the stages. Exercise #2 Page 525 You are specifically assigned to improve the query performance in your data warehouse deployed about six months ago. How will you plan for the assignment? What are the types of statistics you will need? Create a plan.