ResearchBib Share Your Research, Maximize Your Social Impacts
Sign for Notice Everyday Sign up >> Login


Journal: International Journal of Mechanical Engineering and Technology(IJMET) (Vol.10, No. 2)

Publication Date:

Authors : ; ;

Page : 213-220

Keywords : Business Intelligence; Data Warehouse; ETL; Reporting; Pentaho System.;

Source : Downloadexternal Find it from : Google Scholarexternal


As the airline company in Indonesia which is the one of domestic leading airlines, Sriwijya Air has been created the electronic voucher called e-voucher Sriwijaya Air for loyal customers. The e-voucher is used as a flight ticket payment instead of cash payment to buy a ticket. The e-voucher consists of some attributes such as destination, flown date, and flight class. Particularly, a marketing manager needs to review the utilization of e-voucher when a ticket has been approved in every year. The proposed solution is to redeploy existing OLTP database into data warehouse. The data warehouse already developed using nine-step Kimball's methodology. All data will be analyzed using OLAP to present a report in a visual form such as dashboard. Furthermore, airlines company can produce an analysis report using business intelligence

Last modified: 2019-05-27 14:21:02