BUSINESS INTELLIGENCE FOR EVALUATION E-VOUCHER AIRLINE REPORT

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