Date of Award
Spring 6-1-2008
Document Type
Thesis
Degree Name
Master of Science in Information Systems (MSIS)
First Advisor
Stephen Krebsbach
Second Advisor
Ronghua Shan
Third Advisor
Mark Moran
Abstract
Project Definition: To develop reports that will empower the costumers of GLOBEX XBoard Company, enable all business groups to make better and faster decisions by supplying all XBoard Business Groups with consistent, accurate, timely and complete transactional business intelligence information and help them in making correct analysis for their sales. Project Scope: i. Informatica Power Center based data extraction, transformation, and loading process. ii. Data extracted from source systems are aggregated into an Oracle RDBMS based "Data Mart", a central repository that connects data from disparate source systems allowing a way that will allow it to be used on an aggregate basis. iii. 111. Aggregated and connected data from the Data Mart will be made available to business users through a Business Objects reporting application that allows for predefined and dynamic accessing of stored data. Significance of the Problems: GLOBEX XBoard Company is the direct sales portal to end-user customers through channels such as the Internet, contact centers, and retail stores. Properly managing all aspects of this diverse business is exciting, challenging and data intensive. Operating in an environment where annual transactions number in the hundreds of thousands requires XBoard to be a data-driven organization. Being data-driven requires the availability of large quantities of accurate data and the ability for extensive data analysis. Given the current systems and business environment, data must be gathered from a large number of disparate sources and manually assembled into reports. Solution: CLEARVU project is launched to create a world-class reporting environment that will enable business groups to make better and faster decisions by supplying all XBoard business groups with consistent, accurate, timely and complete transactional business intelligence information.
Recommended Citation
Gudidevuni, Govardhan Goud, "Development of Report and Sales/Inventory/Purchasing Data Mart" (2008). Masters Theses & Doctoral Dissertations. 156.
https://scholar.dsu.edu/theses/156
Comments
dsu-th-197