Abstract:
This research aims to develop a BI system for data display formats, for data views, easy data analysis and easy-to-understand overview. The purpose of the project is to help smoking treatment. For this project, the research used data of Fah Sai Clinic Project from the year of 2015 to 2017, in which total number of 34,851 patients participated. The data contained information about patients, hospital and follow-up treatment separated by a period of 3 months and 6 months. The attribute data were selected from the dataset; data cleansing was carried out and then the coordinate location of each hospital was collected for plotting location on map. After that, the data were entered for the development of BI. Dashboards were designed, which consisted of 8 dimensions, and all 8 dimensions were considered to create a storyboard which could help the project manager see and easily understand information, assist in the planning and help to decide project planning fast and effectively. The assessment was carried out to evaluate the project, and the result showed the overall rating ranged from 3.75 to 4.75 out of total assessment score 5. The results of this research can be used to build several aspects; for example, if information on drug prices is available in the future, another dimension "Budget" can be added to the developed dashboard