Article Per Year (5 Year)
p-Index From 2019 - 2024
0.23
P-Index
This Author published in this journals
All Journal International Journal Of Science, Technology & Management (IJSTM)
Abhinaya Bagioyuwono, Michael
Unknown Affiliation
Aerospace Engineering Agriculture, Biological Sciences & Forestry Automotive Engineering Biochemistry, Genetics & Molecular Biology Chemical Engineering, Chemistry & Bioengineering Chemistry Civil Engineering, Building, Construction & Architecture Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Earth & Planetary Sciences Education Electrical & Electronics Engineering Energy Engineering Industrial & Manufacturing Engineering Mechanical Engineering Transportation

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : International Journal Of Science, Technology

 1 
Improving the Data Management: ETL Implementation on Data Warehouse at Indonesian Vehicle Insurance Industry Wiratama, Jansen; Abhinaya Bagioyuwono, Michael
International Journal of Science, Technology & Management Vol. 4 No. 5 (2023): September 2023
Publisher : Publisher Cv. Inara

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.46729/ijstm.v4i5.936

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.
Co-Authors Wiratama, Jansen