{"id":{"repo_id":"csusb","oai_identifier":"oai:scholarworks.lib.csusb.edu:etd-project-4645"},"canonical_url":"https://search.ndltd.org/etd/csusb/oai:scholarworks.lib.csusb.edu:etd-project-4645","repository":{"repo_id":"csusb","name":"CSUniversity San Bernardino","base_url":"https://scholarworks.lib.csusb.edu/do/oai/"},"display":{"title":"Developing data mart using extraction, transformation and loading","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.","abstract_html":"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&#x27;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.","abstract_has_math":false,"creators":["Lakshmanan, Senthil Murugan"],"institution":null,"degree_name":"Master of Science in Computer Science","degree_level":"Project","degree_discipline":"School of Computer Science and Engineering","degree_department":null,"school":null,"contributors":["Yu, Tong Lai","Turner, David","Gomez, Ernesto"],"advisors":[],"committee_chairs":[],"committee_members":[],"year":null,"date_issued":"","date_published":null,"updated_at":"2026-11-19T08:07:58Z","subjects":["Data warehousing","OLAP technology","Knowledge management","Decision support systems","Management information systems","Electronic data processing Distributed processing","OLAP technology."],"languages":[],"rights":[],"rights_urls":[],"identifier_entries":[],"person_identifier_entries":[]},"links":{"outbound_url":"https://scholarworks.lib.csusb.edu/etd-project/3561","outbound_label":"Repository record","outbound_source":"dc:identifier","record_url":"https://scholarworks.lib.csusb.edu/etd-project/3561","record_label":"Repository record","record_kind":"record","record_source":"dc:identifier","download_url":null,"download_label":null,"download_source":null,"access_status":null,"embargo_until":null,"access_note":null},"source_record":{"url":"https://scholarworks.lib.csusb.edu/do/oai/?verb=GetRecord&metadataPrefix=oai_etdms&identifier=oai%3Ascholarworks.lib.csusb.edu%3Aetd-project-4645","prefix":"oai_etdms"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor","label":"Contributor","values":["Yu, Tong Lai","Turner, David","Gomez, Ernesto"]},{"key":"dc:creator","label":"Author","values":["Lakshmanan, Senthil Murugan"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date.created","label":"Dc Date Created","values":["2008-01-01T08:00:00Z"]},{"key":"thesis:degree_discipline","label":"Discipline","values":["School of Computer Science and Engineering"]},{"key":"thesis:degree_level","label":"Degree Level","values":["Project"]},{"key":"thesis:degree_name","label":"Degree Name","values":["Master of Science in Computer Science"]}]},{"id":"subjects_keywords","label":"Subjects and Keywords","entries":[{"key":"dc:subject","label":"Dc Subject","values":["Data warehousing","OLAP technology","Knowledge management","Decision support systems","Management information systems","Electronic data processing Distributed processing","OLAP technology."]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["https://scholarworks.lib.csusb.edu/etd-project/3561"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description.abstract","label":"Abstract","values":["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."]},{"key":"dc:title","label":"Title","values":["Developing data mart using extraction, transformation and loading"]}]}],"canonical_facts":{"dc:contributor":["Yu, Tong Lai","Turner, David","Gomez, Ernesto"],"dc:creator":["Lakshmanan, Senthil Murugan"],"dc:date.created":["2008-01-01T08:00:00Z"],"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."],"dc:identifier":["https://scholarworks.lib.csusb.edu/etd-project/3561"],"dc:subject":["Data warehousing","OLAP technology","Knowledge management","Decision support systems","Management information systems","Electronic data processing Distributed processing","OLAP technology."],"dc:title":["Developing data mart using extraction, transformation and loading"],"thesis:degree_discipline":["School of Computer Science and Engineering"],"thesis:degree_level":["Project"],"thesis:degree_name":["Master of Science in Computer Science"]},"updated_at":"2026-11-19T08:07:58Z"}