Improving the Data Management: ETL Implementation on Data Warehouse at Indonesian Vehicle Insurance Industry

Jansen Wiratama; Michael Abhinaya Bagioyuwono

doi:10.46729/ijstm.v4i5.936

Jansen Wiratama Universitas Multimedia Nusantara
Michael Abhinaya Bagioyuwono Universitas Multimedia Nusantara

DOI: https://doi.org/10.46729/ijstm.v4i5.936

Keywords: Data Warehouse, ETL, Mondrian, Star Schema, Vehicle Insurance

Abstract

Unknowingly, risk is an essential part of an individual's life. Every day individuals have the potential to be threatened by possibilities that can produce something that has fatal social, human, and financial consequences. Insurance can help individuals to relieve the financial burden caused by unwanted things by transferring individual losses to insurance companies. This transfer of losses will distinguish individuals from possible bankruptcy and financial security. Automotive insurance is a liability for loss or damage to motorized vehicles. This time we will take the example of an insurance company specializing in automotive insurance, namely Top Gear Insurance (TGI). This company uses customer data storage using an ordinary manual database that does not yet use a data warehouse system. This ordinary manual database makes it difficult for TGI to retrieve data for reprocessing and makes data inaccessible from anywhere, asynchronous, concise, and inefficient. There is a solution to the TGI problem of creating a data warehouse with a star schema approach for storing and processing data. The data warehouse is likely to make the data within the company more accessible, efficient, simple, and understandable so that TGI can develop its business through data analysis from the data it already has. Datawarehouse has many business advantages, such as increasing Business Intelligence, data quality and consistency, saving time, and supporting historical data analysis and queries. The data warehouse consists of datamart, OLTP, OLAP, and Star Schema. Using Mondrian as a visualization showed that TGI can get information about customer data, policies, and claims easily, quickly, and concisely. That can also help TGI create customer profiles and targeted marketing and company evaluation based on the visualization provided.

Downloads

Download data is not yet available.

References

[1] E. Grant, “The Social and Economic Value of Insurance,” Geneva Assoc., 2012.
[2] A. Gepp, J. H. Wilson, K. Kumar, and S. Bhattacharya, “A Comparative Analysis of Decision Trees Vis-`a-vis Other Computational Data Mining Techniques in Automotive Insurance Fraud Detection,” J. Data Sci., vol. 10, no. 3, pp. 537–561, 2021, doi: 10.6339/jds.201207_10(3).0010.
[3] S. S. Weedige, H. Ouyang, Y. Gao, and Y. Liu, “Decision making in personal insurance: Impact of insurance literacy,” Sustain., vol. 11, no. 23, pp. 1–24, 2019, doi: 10.3390/su11236795.
[4] I. Purnama Batubara and R. Syahriza, “Analisis Klaim Asuransi Kendaraan Bermotor pada Pt Asuransi Jasindo Kantor Cabang Medan,” J. Soc. Res., vol. 1, no. 9, pp. 1026–1031, 2022, doi: 10.55324/josr.v1i9.62.
[5] Purwanto, “Pembaruan Definisi Asuransi dalam Sistem Hukum di Indonesia (Insurance Definition Renewal in Law System in Indonesia),” Risal. Huk. Fak. Huk. Risal. Huk. Unmul, vol. 2, no. 2, pp. 87–93, 2006, [Online]. Available: https://webcache.googleusercontent.com/search?q=cache:UulmGj3VXHAJ:https://e-journal.fh.unmul.ac.id/index.php/risalah/article/download/130/80/+&cd=11&hl=id&ct=clnk&gl=id
[6] T. Riasanow, L. Jäntgen, S. Hermes, M. Böhm, and H. Krcmar, “Core, intertwined, and ecosystem-specific clusters in platform ecosystems: analyzing similarities in the digital transformation of the automotive, blockchain, financial, insurance and IIoT industry,” Electron. Mark., vol. 31, no. 1, pp. 89–104, 2021, doi: 10.1007/s12525-020-00407-6.
[7] N. Nizamuddin and A. Abugabah, “Blockchain for automotive: An insight towards the IPFS blockchain-based auto insurance sector,” Int. J. Electr. Comput. Eng., vol. 11, no. 3, pp. 2443–2456, 2021, doi: 10.11591/ijece.v11i3.pp2443-2456.
[8] B. Aadil, L. Kzaz, A. Ait Wakrime, and A. Sekkaki, “Linking context to data warehouse design,” Int. J. Adv. Comput. Sci. Appl., vol. 10, no. 1, pp. 11–20, 2019, doi: 10.14569/IJACSA.2019.0100102.
[9] M. AlMeghari, S. Taha, H. Elmahdy, and X. Shen, “A proposed authentication and group-key distribution model for data warehouse signature, DWS framework,” Egypt. Informatics J., vol. 22, no. 3, pp. 245–255, 2021, doi: 10.1016/j.eij.2020.09.002.
[10] E. Saddad, A. El-Bastawissy, H. M. O. Mokhtar, and M. Hazman, “Lake data warehouse architecture for big data solutions,” Int. J. Adv. Comput. Sci. Appl., vol. 11, no. 8, pp. 417–424, 2020, doi: 10.14569/IJACSA.2020.0110854.
[11] J. Siahaan, W. Wella, and R. I. Desanti, “Apakah Youtuber Indonesia Kena Bully Netizen?,” Ultim. InfoSys J. Ilmu Sist. Inf., vol. 11, no. 2, pp. 130–134, 2020, doi: 10.31937/si.v11i2.1764.
[12] A. Vatresia, A. Johar, F. P. Utama, and S. Iryani, “Automated Data Integration of Biodiversity with OLAP and OLTP,” Sisforma, vol. 7, no. 2, pp. 80–89, 2020, doi: 10.24167/sisforma.v7i2.2817.
[13] S. M. F. Ali and R. Wrembel, “From conceptual design to performance optimization of ETL workflows: current state of research and open problems,” VLDB J., vol. 26, no. 6, pp. 777–801, 2017, doi: 10.1007/s00778-017-0477-2.
[14] I. Zaelani, “Implementasi Data Mart Terhadap Sistem Penjualan Pada Perusahaan Bidang Distributor Di Pt. Eigen Trimathema,” J. Penelit. Mhs. Tek. dan Ilmu Komput., vol. 1, no. 2, pp. 95–103, 2021, doi: 10.34010/jupiter.v1i2.7309.
[15] M. M. Amin, A. Sutrisman, and Y. Dwitayanti, “Development of Star-Schema Model for Lecturer Performance in Research Activities,” Int. J. Adv. Comput. Sci. Appl., vol. 12, no. 9, pp. 74–80, 2021, doi: 10.14569/IJACSA.2021.0120909.
[16] W. Suharso, A. Fardiansa, Y. Munarko, and H. Wibowo, “Implementasi Star Schema Pada Studi Kasus Perpustakaan Berskala Universitas,” SINTECH (Science Inf. Technol. J., vol. 4, no. 1, pp. 1–11, 2021, doi: 10.31598/sintechjournal.v4i1.446.