Implementation of Data Flow, Predictive Model, and Data Visualization in Corbion Process Analysis System

Corbion Group Netherlands B.V. is a company specialized in food ingredients such as lactic acid which involves fermentation process. Thus, a system was created to monitor on real-time fermentation process in order to gain insight and control of the process. This system is called Corbion Process Anal...

Full description

Bibliographic Details
Main Author: Sie Ivan Hinman Siehoyono
Format: Article
Language:English
Published: Petra Christian University 2021-08-01
Series:JIRAE (International Journal of Industrial Research and Applied Engineering)
Subjects:
Online Access:http://jirae.petra.ac.id/index.php/jirae/article/view/19381
_version_ 1818471619876618240
author Sie Ivan Hinman Siehoyono
author_facet Sie Ivan Hinman Siehoyono
author_sort Sie Ivan Hinman Siehoyono
collection DOAJ
description Corbion Group Netherlands B.V. is a company specialized in food ingredients such as lactic acid which involves fermentation process. Thus, a system was created to monitor on real-time fermentation process in order to gain insight and control of the process. This system is called Corbion Process Analysis System, or CorPAS. CorPAS covers many projects in Corbion, and in general, it extracts data from flat files, then transforms and loads the data into Power BI for data visualization. The data extraction still needs to be manually done by the users by opening the databases and copy all the data into flat files. CorPAS 2.0. was initiated to improve the previous system and add a new feature. Automated data extraction was successfully implemented with data transformation and visualization, alongside with implementation of a new feature, such as data science predictive modeling. The solution was built with R language and data visualization tool such as Power BI.
first_indexed 2024-04-14T03:53:49Z
format Article
id doaj.art-d6b8cd894bb14ce1a4b98d17d56413c0
institution Directory Open Access Journal
issn 2407-7259
language English
last_indexed 2024-04-14T03:53:49Z
publishDate 2021-08-01
publisher Petra Christian University
record_format Article
series JIRAE (International Journal of Industrial Research and Applied Engineering)
spelling doaj.art-d6b8cd894bb14ce1a4b98d17d56413c02022-12-22T02:13:53ZengPetra Christian UniversityJIRAE (International Journal of Industrial Research and Applied Engineering)2407-72592021-08-015171310.9744/jirae.5.1.7-1318710Implementation of Data Flow, Predictive Model, and Data Visualization in Corbion Process Analysis SystemSie Ivan Hinman Siehoyono0Petra Christian UniversityCorbion Group Netherlands B.V. is a company specialized in food ingredients such as lactic acid which involves fermentation process. Thus, a system was created to monitor on real-time fermentation process in order to gain insight and control of the process. This system is called Corbion Process Analysis System, or CorPAS. CorPAS covers many projects in Corbion, and in general, it extracts data from flat files, then transforms and loads the data into Power BI for data visualization. The data extraction still needs to be manually done by the users by opening the databases and copy all the data into flat files. CorPAS 2.0. was initiated to improve the previous system and add a new feature. Automated data extraction was successfully implemented with data transformation and visualization, alongside with implementation of a new feature, such as data science predictive modeling. The solution was built with R language and data visualization tool such as Power BI.http://jirae.petra.ac.id/index.php/jirae/article/view/19381extract, translate, loaddata visualizationdata science predictive model
spellingShingle Sie Ivan Hinman Siehoyono
Implementation of Data Flow, Predictive Model, and Data Visualization in Corbion Process Analysis System
JIRAE (International Journal of Industrial Research and Applied Engineering)
extract, translate, load
data visualization
data science predictive model
title Implementation of Data Flow, Predictive Model, and Data Visualization in Corbion Process Analysis System
title_full Implementation of Data Flow, Predictive Model, and Data Visualization in Corbion Process Analysis System
title_fullStr Implementation of Data Flow, Predictive Model, and Data Visualization in Corbion Process Analysis System
title_full_unstemmed Implementation of Data Flow, Predictive Model, and Data Visualization in Corbion Process Analysis System
title_short Implementation of Data Flow, Predictive Model, and Data Visualization in Corbion Process Analysis System
title_sort implementation of data flow predictive model and data visualization in corbion process analysis system
topic extract, translate, load
data visualization
data science predictive model
url http://jirae.petra.ac.id/index.php/jirae/article/view/19381
work_keys_str_mv AT sieivanhinmansiehoyono implementationofdataflowpredictivemodelanddatavisualizationincorbionprocessanalysissystem