Back to search

CSUniversity San Bernardino - Retro

Developing data mart using extraction, transformation and loading

Abstract

dc:description.abstract

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 help in analyzing how the company's products are being sold, such as top ten customers and products, sales details, etc. Overall, data mart improves navigation capabilities and generally more accessible to end users.

Degree

thesis:*
Name thesis:degree_name
Master of Science in Computer Science
Level thesis:degree_level
Project
Discipline thesis:degree_discipline
School of Computer Science and Engineering

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Lakshmanan, Senthil Murugan
Contributors dc:contributor
  • Yu, Tong Lai
  • Turner, David
  • Gomez, Ernesto

Subjects

dc:subject × 7

Identifiers

dc:identifier.*
Repository record dc:identifier
https://scholarworks.lib.csusb.edu/etd-project/3561

Chain of custody

source
Harvested from
CSUniversity San Bernardino - Retro
Base URL
scholarworks.lib.csusb.edu/do/oai/
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
citation

Lakshmanan, Senthil Murugan. Developing data mart using extraction, transformation and loading. Project thesis, https://scholarworks.lib.csusb.edu/etd-project/3561