Optimization Online Analytical Processing (OLAP) Data Sales Door Case Study CV Adilia Lestari

Sales transaction data in the sales division related to sales data goods so large and many that require large storage media and difficult to process these data for the preparation of reports used by management for decision making. Online Analitycal Processing (OLAP) is a method of approach to present the answers to the demand for a rapidly dimensional analysis process, ie the design of applications and technologies that can collect, store, manipulate a multidimensional data for analyst purposes. OLAP is part of a more global category of business thinking, which also summarizes the relationship between reporting and data mining. Use of this prototype helps executive informations system in generating monthly goods sales report that is 0,022259399998 sec, sales report top 10 that is 0,0223899998998 second, sales report down 10 that is 0,0210279999301 second, report sales by province that is 0,0399869999535 second, report Sales by district are 0.0133039000143 seconds. So it can help generate reports faster sales data and compliance report generated from the resulting prototype has in common with the existing report format so that the prototype is right in generating the report. OLAP technology can facilitate stakeholders in making decisions based on existing transactional data because OLAP will display data from various sides or multidimens.