The Role of Data Visualization and Analytics of Highway Accidents


  • Jirapon SUNKPHO Thammasat University AI Center, College of Innovation, Thammasat University, Bangkok 10200, Thailand
  • Warit WIPULANUSAT Logistics and Business Analytics Center of Excellence, Faculty of Engineering and Technology, Walailak University, Nakhon Si Thammarat 80160, Thailand



Visualization, Data analytics, Business intelligence, Accidents, Thailand


Thailand has been ranked as one of the most dangerous countries in terms of death from road accidents, representing ineffective road safety policies. The crucial mission of the Thai government is to provide safety and reduce accidents for road users on the highway system. This paper aims to explore the potential of using Business Intelligence (BI) in accident analysis. The availability of open accident data provides an opportunity for the BI, which can provide an advanced platform for conducting data visualization and analytics in both spatial and temporal dimensions in order to illustrate when and where the accidents occur. The accident data and provincial data were combined by using the Talend Data Integration tool. The combined data was then loaded into a MySQL database for data visualization using Tableau. The dashboard was designed and created by using Tableau as an analytical visualization tool to provide insights into highway accidents. This system is advised to be adopted by the Thai government, which can be used for data visualization and analytics to provide a mechanism to formulate strategy options and formulate appropriate contingency plans to improve the accident situation.


Download data is not yet available.


Metrics Loading ...


World Health Organization. Global Status Report on Road Safety 2015. Geneva, Switzerland, 2015.

J Burton. Countries with the most car accidents, Available at, accessed 2018.

W Wipulanusat and J Sunkpho. A Mobile platform for roadway incident documentation: A case study of intercity motorways. The Eastern Asia society for transportation studies volum 7. In: Proceedings of the 8th Eastern Asia society for transportation studies, Surabunya, Indonesia. 2009, p. 362.

B Chaichannawatik, K Kanitpong and T Limanond. Departure time choice (DTC) behavior for intercity travel during a long-holiday in Bangkok, Thailand. J. Adv. Transport. 2019; 2019, 1-11.

M Seesen, P Siviroj, R Sapbamrer and S Morarit. High blood alcohol concentration associated with traumatic brain injury among traffic injury patients during New Year festivals in Thailand. Traffic Inj. Prev. 2019; 20, 115-21.

W Wipulanusat, J Sunkpho, A Jotisankasa, S Chayanan and P Sangsuwan. The implementation of business process reengineering: A case study of roadway incident data management. Eng. J. 2013; 9, 1-10.

MJ Islam, A Sharma and H Rajan. A Cyberinfrastructure for big data transportation engineering. J. Big Data Anal. Transport. 2019; 1, 83-94.

Y Adu-Gyamfi. PU-enabled visual analytics framework for big transportation datasets. J. Big Data Anal. Transport. 2019; 1, 147-59.

VH Trieu. Getting value from Business Intelligence systems: A review and research agenda. Decis. Support Syst. 2017; 93, 111-24.

E Rubin and A Rubin. The impact of Business Intelligence systems on stock return volatility. Inform. Manag. 2013; 50, 67-75.

J Reinschmidt and A Francoise. Business Intelligence Certification Guide. IBM, California, 2000.

CM Olszak and E Ziemba. Critical success factors for implementing business intelligence systems in small and medium enterprises on the example of upper Silesia, Poland. Interdiscipl. J. Inform. Knowl. Manag. 2012; 7, 129-50.

JK Simandl, AJ Graettinger, RK Smith, S Jones and TE Barnett. Making use of big data to Eealuate the effectiveness of selective law enforcement in reducing crashes. Transport. Res. Rec. 2016; 2584, 8-15.

S Jomnonkwao, S Uttra and V Ratanavaraha. Forecasting road traffic deaths in Thailand: Applications of time-series, curve estimation, multiple linear regression, and path analysis models. Sustainability 2020; 12, 395-412.

X Fan, B He and P Brézillon. Context-aware big data analytics and visualization for city-wide traffic accidents. Volume LNCS 10257. In: Proceedings of the 10th International and Interdisciplinary Conference on Modeling and Using Context, Paris, France, 2017, 395-405.

K Kanitpong, P Jiwattanakulpaisarn and W Yaktawong. Speed management strategies and drivers' attitudes in Thailand. IATSS Res. 2013; 37, 39-48.

H Jaldell, P Lebnak and A Amornpetchsathaporn. Time is money, but how much? The monetary value of response time for Thai ambulance emergency services. Value Health 2014; 17, 555-60.

J Kumphong, T Satiennam and W Satiennam. The determinants of motorcyclists helmet use: Urban arterial road in Khon Kaen City, Thailand. J. Saf. Res. 2018; 67, 93-7.

P Jiwattanakulpaisarn, K Kanitpong, S Ponboon, N Boontob, P Aniwattakulchai and S Samranjit. Does law enforcement awareness affect motorcycle helmet use? Evidence from urban cities in Thailand. Glob. Health Promot. 2013; 20, 14-24.

P Woratanarat, A Ingsathit, P Chatchaipan and P Suriyawongpaisal. Safety riding program and motorcycle-related injuries in Thailand. Accid. Anal. Prev. 2013; 58, 115-21.




How to Cite

SUNKPHO, J. ., & WIPULANUSAT, W. . (2020). The Role of Data Visualization and Analytics of Highway Accidents. Walailak Journal of Science and Technology (WJST), 17(12), 1379–1389.