MIS 535 Course Project Proposal Srilakshmi
Development of a Data Warehouse for the ABC Corporation
Srilakshmi Avireneni
Managerial Applications of Information Technology – IS535 (ON)
DeVry University, Keller Graduate School of Management
May 13, 2015
Development of a Data Warehouse for the ABC Corporation
Proposal
Topic
This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.
Problem
The business problem to be solved is how to build the reporting process by eliminating manually intensive reporting, providing accurate information in a timely manner and building the foundation (Robust Data Warehouse) for a fully integrated global reporting environment.
Approach
The goal is to build a Data Warehouse to provide a central repository for content related
Srilakshmi Avireneni
Managerial Applications of Information Technology – IS535 (ON)
DeVry University, Keller Graduate School of Management
May 13, 2015
Development of a Data Warehouse for the ABC Corporation
Proposal
Topic
This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.
Problem
The business problem to be solved is how to build the reporting process by eliminating manually intensive reporting, providing accurate information in a timely manner and building the foundation (Robust Data Warehouse) for a fully integrated global reporting environment.
Approach
The goal is to build a Data Warehouse to provide a central repository for content related