The Development of Data Warehouse from Payment Point Services of IT Business Solution Provider
The goals of the research is to develop a data warehouse loaded from operational database of payment point service in IT business solution provider. The development scope is data analysis using Online Analytical Processing (OLAP) tools for identifying the trends of transaction and agent registration...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Bina Nusantara University
2017-12-01
|
| Series: | ComTech |
| Subjects: | |
| Online Access: | https://journal.binus.ac.id/index.php/comtech/article/view/4032 |
| _version_ | 1797715222419472384 |
|---|---|
| author | Kornelius Irfandhi |
| author_facet | Kornelius Irfandhi |
| author_sort | Kornelius Irfandhi |
| collection | DOAJ |
| description | The goals of the research is to develop a data warehouse loaded from operational database of payment point service in IT business solution provider. The development scope is data analysis using Online Analytical Processing (OLAP) tools for identifying the trends of transaction and agent registration, and create reports and dashboards. The data warehouse was developed with Kimball method as known as the nine-step design methodology. The data and requirement were collected by observation and interview with Chief Technology Officer (CTO). The data warehouse was analyzed by OLAP tool provided by Pentaho Business Analytics software with additional plugin Pivot4J. The obtained results are the trends of transaction
and agent registration between 2014 and 2015. It can be concluded that developed data warehouse can be used as ananalysis tool to know the trends information. |
| first_indexed | 2024-03-12T08:03:43Z |
| format | Article |
| id | doaj.art-3b03e56f2f5a4707bb20cddf4a523f9d |
| institution | Directory Open Access Journal |
| issn | 2087-1244 2476-907X |
| language | English |
| last_indexed | 2024-03-12T08:03:43Z |
| publishDate | 2017-12-01 |
| publisher | Bina Nusantara University |
| record_format | Article |
| series | ComTech |
| spelling | doaj.art-3b03e56f2f5a4707bb20cddf4a523f9d2023-09-02T19:40:06ZengBina Nusantara UniversityComTech2087-12442476-907X2017-12-018419120310.21512/comtech.v8i4.40323227The Development of Data Warehouse from Payment Point Services of IT Business Solution ProviderKornelius Irfandhi0Bina Nusantara UniversityThe goals of the research is to develop a data warehouse loaded from operational database of payment point service in IT business solution provider. The development scope is data analysis using Online Analytical Processing (OLAP) tools for identifying the trends of transaction and agent registration, and create reports and dashboards. The data warehouse was developed with Kimball method as known as the nine-step design methodology. The data and requirement were collected by observation and interview with Chief Technology Officer (CTO). The data warehouse was analyzed by OLAP tool provided by Pentaho Business Analytics software with additional plugin Pivot4J. The obtained results are the trends of transaction and agent registration between 2014 and 2015. It can be concluded that developed data warehouse can be used as ananalysis tool to know the trends information.https://journal.binus.ac.id/index.php/comtech/article/view/4032data warehouse, trend of transaction, agent registration, payment point |
| spellingShingle | Kornelius Irfandhi The Development of Data Warehouse from Payment Point Services of IT Business Solution Provider ComTech data warehouse, trend of transaction, agent registration, payment point |
| title | The Development of Data Warehouse from Payment Point Services of IT Business Solution Provider |
| title_full | The Development of Data Warehouse from Payment Point Services of IT Business Solution Provider |
| title_fullStr | The Development of Data Warehouse from Payment Point Services of IT Business Solution Provider |
| title_full_unstemmed | The Development of Data Warehouse from Payment Point Services of IT Business Solution Provider |
| title_short | The Development of Data Warehouse from Payment Point Services of IT Business Solution Provider |
| title_sort | development of data warehouse from payment point services of it business solution provider |
| topic | data warehouse, trend of transaction, agent registration, payment point |
| url | https://journal.binus.ac.id/index.php/comtech/article/view/4032 |
| work_keys_str_mv | AT korneliusirfandhi thedevelopmentofdatawarehousefrompaymentpointservicesofitbusinesssolutionprovider AT korneliusirfandhi developmentofdatawarehousefrompaymentpointservicesofitbusinesssolutionprovider |