Question

Resource: Appendix A

Riordan Manufacturing has now grown into an international company with operations around the world. The Director of Planning and Development believes the department has outgrown the database you created and thinks they need a full-fledged business intelligence system. He would like a system that allows him to better manage the strategic and tactical aspects of the department.

Your task is to develop a proposal that outlines the conversion of the existing sales database into a business intelligences system. You are to present the current database application and your proposed conversion solution to executive management. You must develop a PowerPoint® presentation that explains your proposal. In addition, you must write a 350- to 700-word executive summary of your proposal for the meeting.

Discuss the following in your proposed solution:

How the current database might be converted to a business intelligence system
The needed business intelligence components
Definition of the elements of a data warehouse
How the business would use a data warehouse
Compare and contrast the differences and similarities of the different decision support architecture styles
A recommended data support architecture
Recommended additional data to capture
Kinds of tools the business might use for data analysis
Description of the required steps to implement a data warehouse

Include the following elements in your assignment:

Final project database
An 8- to 12-slide PowerPoint® presentation of the proposal

A 350- to 700-word executive summary of the proposal