Open Access. Powered by Scholars. Published by Universities.®

Business Commons

Open Access. Powered by Scholars. Published by Universities.®

PDF

California State University, San Bernardino

Management Information Systems

Theses Digitization Project

Management information systems

Articles 1 - 1 of 1

Full-Text Articles in Business

Developing Data Mart Using Extraction, Transformation And Loading, Senthil Murugan Lakshmanan Jan 2008

Developing Data Mart Using Extraction, Transformation And Loading, Senthil Murugan Lakshmanan

Theses Digitization Project

This project is organized to develop the sales data mart for the purpose of reporting data. Data warehouses support online analytical processing applications by gathering the data from various kinds of source information in a multidimensional format. Developing this strategic information can be done with the ETL, which means Extract, Transform and Loading. ETL functions reshape the relevant data from source systems into useful information to be stored in the data warehouse or data marts. The successful deployment of the sales data mart allowed the creation of a user interface that permits users to make strategic decisions. The reports can …