Data mart for decision support system: a case study at Petron Fuel International Sdn Bhd / Norzareena Zahari

In organisation, manager plays an important function in decision making. As the volume of data evolved and the methods of analyzing have improved, therefore organisation have been integrating data more firmly into decision making process. Manager need to know about the sales person performance and h...

Full description

Saved in:

Bibliographic Details
Main Author:	Zahari, Norzareena
Format:	Thesis
Language:	English
Published:	2015
Subjects:	Management information systems Decision support systems Enterprise resource planning Data mining
Online Access:	https://ir.uitm.edu.my/id/eprint/64847/1/64847.pdf
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-uitm-ir.64847
record_format	uketd_dc
spelling	my-uitm-ir.648472023-04-19T03:15:07Z Data mart for decision support system: a case study at Petron Fuel International Sdn Bhd / Norzareena Zahari 2015 Zahari, Norzareena Management information systems. Decision support systems. Enterprise resource planning Data mining In organisation, manager plays an important function in decision making. As the volume of data evolved and the methods of analyzing have improved, therefore organisation have been integrating data more firmly into decision making process. Manager need to know about the sales person performance and how to gain rapid insight into fast-growth products, and services. Therefore a Decision Support System (DSS) play important roles for manager as a decision maker in organisation. To answer question that arise from user information needs, a data mart was create to distill the relevant information to targeted DSS users. This project presents the design of data mart for sales analysis using dimensional modeling techniques. The designed data mart was implemented from current tools in Commercial Vehicle Sales (CVS). Appropriate data mart dimensions and fact were modeled in order to ease data analysis and queries. Data models based on dimensional modeling (snowflakes) are provided and discussed. This project also intended to design and develop data mart in order to assists in decision making process. One of the most use DSS interface in organisation are Microsoft's Excel. Microsoft Excel do provides the ability to generate a output like examples pie chart, bar charts and many more function. The capability of Mircosoft Excel as a DSS for organisation is become slower as the data getting growth over a time. This results to an error for the some of the require output and automatically affected in decision making process. Throughout an analysis of current tools that being used by the manager in Commercial Vehicles Sales team (CVS) of Petron Fuel International, found out that Microsoft Excel as DSS interface was produce a non-accuracy on the monthly basis reports. Through this project, the problems from current tools for CVS have been pointed out and the recommendations have been analysed based on the development design review. 2015 Thesis https://ir.uitm.edu.my/id/eprint/64847/ https://ir.uitm.edu.my/id/eprint/64847/1/64847.pdf text en public masters Universiti Teknologi MARA (UiTM) Faculty of Computer and Mathematical Sciences Dharmarajan, Nalini
institution	Universiti Teknologi MARA
collection	UiTM Institutional Repository
language	English
advisor	Dharmarajan, Nalini
topic	Management information systems Decision support systems Enterprise resource planning Data mining
spellingShingle	Management information systems Decision support systems Enterprise resource planning Data mining Zahari, Norzareena Data mart for decision support system: a case study at Petron Fuel International Sdn Bhd / Norzareena Zahari
description	In organisation, manager plays an important function in decision making. As the volume of data evolved and the methods of analyzing have improved, therefore organisation have been integrating data more firmly into decision making process. Manager need to know about the sales person performance and how to gain rapid insight into fast-growth products, and services. Therefore a Decision Support System (DSS) play important roles for manager as a decision maker in organisation. To answer question that arise from user information needs, a data mart was create to distill the relevant information to targeted DSS users. This project presents the design of data mart for sales analysis using dimensional modeling techniques. The designed data mart was implemented from current tools in Commercial Vehicle Sales (CVS). Appropriate data mart dimensions and fact were modeled in order to ease data analysis and queries. Data models based on dimensional modeling (snowflakes) are provided and discussed. This project also intended to design and develop data mart in order to assists in decision making process. One of the most use DSS interface in organisation are Microsoft's Excel. Microsoft Excel do provides the ability to generate a output like examples pie chart, bar charts and many more function. The capability of Mircosoft Excel as a DSS for organisation is become slower as the data getting growth over a time. This results to an error for the some of the require output and automatically affected in decision making process. Throughout an analysis of current tools that being used by the manager in Commercial Vehicles Sales team (CVS) of Petron Fuel International, found out that Microsoft Excel as DSS interface was produce a non-accuracy on the monthly basis reports. Through this project, the problems from current tools for CVS have been pointed out and the recommendations have been analysed based on the development design review.
format	Thesis
qualification_level	Master's degree
author	Zahari, Norzareena
author_facet	Zahari, Norzareena
author_sort	Zahari, Norzareena
title	Data mart for decision support system: a case study at Petron Fuel International Sdn Bhd / Norzareena Zahari
title_short	Data mart for decision support system: a case study at Petron Fuel International Sdn Bhd / Norzareena Zahari
title_full	Data mart for decision support system: a case study at Petron Fuel International Sdn Bhd / Norzareena Zahari
title_fullStr	Data mart for decision support system: a case study at Petron Fuel International Sdn Bhd / Norzareena Zahari
title_full_unstemmed	Data mart for decision support system: a case study at Petron Fuel International Sdn Bhd / Norzareena Zahari
title_sort	data mart for decision support system: a case study at petron fuel international sdn bhd / norzareena zahari
granting_institution	Universiti Teknologi MARA (UiTM)
granting_department	Faculty of Computer and Mathematical Sciences
publishDate	2015
url	https://ir.uitm.edu.my/id/eprint/64847/1/64847.pdf
_version_	1783735520440877056

Data mart for decision support system: a case study at Petron Fuel International Sdn Bhd / Norzareena Zahari

Similar Items