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.

 

Data Warehousing Text Business Intelligence Text

€¢ Chapters 5 €“ 10 €¢ Chapter 3 €“ Including Case Study at end

 

1-

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

 

 

Data Warehousing Textbook:

 

Exercise #2 pg. 120

 

You are the vice president of marketing for a nation-wide appliance manufacturer with three production plants. Describe any three different ways you will tend to analyze your sales. What are the business dimensions for your analysis?

 

Exercise #4 pg. 137-138

 

You are the manager for the data warehouse project at a retail chain with stores all across the country and users in every store. How will you ensure that all the details necessary to decide on the DBMS are gathered during the requirements phase? Write a memo to the Senior Analyst directly responsible to coordinate the requirements definition phase.

 

Exercise #2 pg 161

 

You have recently been promoted to administrator for the data warehouse of a nationwide automobile insurance company. You are asked to prepare a checklist for selecting a proper vendor tool to help you with the data warehouse administration. Make a list of the functions in the management and control component of your data warehouse architecture. Use this list to derive the tool-selection checklist.

 

Exercise #5 pg. 221

 

As the data acquisition specialist, what types of metadata can help you? Choose one of the data acquisition processes and explain the role of metadata in that process.

 

Exercise #5 pg. 248

 

What is a factless fact table? Design a simple STAR schema with a factless fact table to track patients in a hospital by diagnostic procedures and time.

 

 

2-

ISBN-13: 978-0-13-610066-9

Title: Business Intelligence: A Managerial Approach

 

 

 

Business Intelligence Textbook:

 

Question 6-page 127

 

What can businesses learn from a government initiative like the CPR?