{"title":"The Development of Data Warehouse from Payment Point Services of IT Business Solution Provider","authors":"Kornelius Irfandhi","doi":"10.21512/COMTECH.V8I4.4032","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":31095,"journal":{"name":"ComTech","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2017-12-31","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"ComTech","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.21512/COMTECH.V8I4.4032","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
Abstract
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.
本研究的目标是在IT业务解决方案提供商的支付点服务操作数据库的基础上开发一个数据仓库。开发范围是使用在线分析处理(OLAP)工具进行数据分析，以确定交易和代理注册的趋势，并创建报告和仪表板。数据仓库是用Kimball方法开发的，也就是众所周知的九步设计方法。通过观察和首席技术官(CTO)的访谈收集数据和需求。使用Pentaho Business Analytics软件提供的OLAP工具和附加插件Pivot4J对数据仓库进行分析。所得结果为2014 - 2015年的交易和代理注册趋势。可以得出结论，开发的数据仓库可以作为了解趋势信息的分析工具。
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
