You are the data design specialist on the data warehouse project team for a Automobile manufacturing company. The marketing VP is complaining about the poor response by IT in providing strategic information.
• Draft a proposal to him explaining the reasons for the problems and why a data warehouse would be the only viable solution.
• Prepare a detailed requirement analysis report for the sales analysis of the organization.
• Prepare a project task list to include all the detailed tasks needed for data extraction and transformation.
• Determine the metrics or facts and the business dimensions. Prepare an information package diagram.
• Design a STAR schema to track the production quantities. Production quantities are normally analyzed along the business dimensions of product, time, parts used, production facility, and production run.
• State your assumptions. 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. If your data warehouse gets input from several legacy systems on multiple platforms, and also regular feeds from two external sources, how will you organize your data staging area?
• Describe the data repositories you will have for data staging. Now the management has decided to provide the power users with OLAP facilities.
• How will you alter the information delivery component of your data warehouse architecture? Make realistic assumptions and proceed.

Task:
Based on the course literature and lecture material list these problems, placing special emphasis on the categories below Write about the
▪ the nature of the organisation information retrieval methodologies
▪ the systems environment in the organisation
▪ the availability and quality of data in the organisation

Out of the list of problems pick what you consider to be the 5 most important, rank them in order of importance and motivate why you believe them to be so important
Refer back to your original, exhaustive list of problems and identify those that you believe can be alleviated, or partially solved, by the introduction of a data warehouse in the organisation. Specify how you believe the data warehouse can be used to tackle these problems.

Task
If your data warehouse gets input from several legacy systems on multiple platforms, and also regular feeds from two external sources, how will you organize your data staging area? Describe the data repositories you will have for data staging. Now the management has decided to provide the power users with OLAP facilities. How will you alter the information delivery component of your data warehouse architecture? Make realistic assumptions and proceed.