Prototipe data warehouse penjualan produk bakosurtanal

Abstract

Speeding up reporting process and obtaining strategic information based on a multidimensional analysis query can be done by building OLAP applications integrated with data warehouse. Development of data warehouse Bakosurtanal product sales data and web-based OLAP applications has been done using Palo. Palo is one of the OLAP server with multidimensional data storage model (MOLAP). Mondrian is an OLAP server with relational data storage model (ROLAP) This research aims to develop a data warehouse and wab-based OLAP using Mondrian 3.1.6. This research designs the data warehouse using star scheme and OLAP development. This research produces a web-based OLAP cube consisting of one data cube: sales of products and four dimensions: time, type of data, qualification, and scale. Users can interact with the following facilities: 1) Selecting dimensions to display the information at the level needed, 2) Displaying information in the form of bar charts, stacked bar, line charts, line charts, stacked area, and pie charts 3) Exporting files into Microsoft Excel format. Users can explore this application using OLAP operations including roll-up, drill-down, slice, dice, etc.