1 AIT Asian Institute of Technology

Business intelligence for an automobile equipment company : a case study of FOG automotive

AuthorMattellini, Jonathan
Call NumberAIT RSPR no.IM-15-02
Subject(s)Data mining
Business intelligence

NoteA research study submitted in partial fulfillment of the requirements for the degree of Master of Science in Information Management, School of Engineering and Technology
PublisherAsian Institute of Technology
Series StatementResearch studies project report ; no. IM-15-02
AbstractOne of the biggest wealth of a firm is its data. But most of the time, this data is scattered, unstructured and heterogeneous. The question is how to analyze all this data, in reasonable time.Decision makers need to have important facts well presented in order to take the good decision. This is what Business Intelligence (BI) answers.The main objective of this research study is to develop a BI system to help FOGAutomotive. In details, this studyhas analyzed the need of BI for FOG and then designed and implemented a BI system using Excel and Visual Basic. The resulting system is explained with areview of all its features: instructions, data mining, data analysis and data reporting. 4 sheetsshow data in understandable and usable ways, using a color-scaled mapof France. Each sheet displayscritical information such asturnover per France’s department andtime-period. This study has been conducted with the company’s feedback.This study also presentsa detailed view of Business Intelligence and keys points to create a BI system for small and medium enterprises(SME). The outcome resultsof a system which is now used by the company.As for future work, it is recommended that the company may consider building data warehouse to take better advantages of BI system.
Year2015
Corresponding Series Added EntryAsian Institute of Technology. Research studies project report ; no. IM-15-02
TypeResearch Study Project Report (RSPR)
SchoolSchool of Engineering and Technology (SET)
DepartmentDepartment of Information and Communications Technologies (DICT)
Academic Program/FoSInformation Management (IM)
Chairperson(s)Vatcharaporn Esichaikul;
Examination Committee(s)Guha, Sumanta;Dailey, Matthew;
Scholarship Donor(s)Telecom SudParis, France - AIT;
DegreeResearch Studies Project Report (M. Sc.) - Asian Institute of Technology, 2015


Usage Metrics
View Detail0
Read PDF0
Download PDF0