Implementation of OLAP (On-Line Analytical Processing) on car parts sale of Mercedes Benz (Case study: PT. Mass Sarana Motorama)

摘要

PT. Mass Sarana Motorama is a company that is engaged in the commercial, which is the provider of Mercedes Benz auto parts. In the course of its business, PT. Mass Sarana Motorama is currently using OLTP systems experience some problems. Disadvantages are contained in the OLTP system PT. Mass Sarana Motorama is the lack of applications that can process their sales data into a usable information for decision making. In addition, PT. Mass Sarana Motorama also requires an application that is able to perform data analysis of various categories of sales and sales data show that can be viewed by year, month, and day. In the absence of such an application is made the company difficult to analyze their sales. Based on the above constraints, to support the business activities of PT. Mass Sarana Motorama to be more effective and efficient, it takes an OLAP applications (On-Line Analytical Processing) to suit the needs of PT. Mass Sarana Motorama. Development of OLAP applications (On-Line Analytical Processing) is designed by using UML (Unified Modeling Language) and comprising the steps of prototyping method listen to the customer (user needs analysis), build and revise mock-ups, and customer test drives mock-up. Making these applications using Delphi programming language with Borland Delphi 6 Personal applications, ContourCubeX as OLAP library and XAMPP as a database application. With the output or end result of the application of OLAP (On-Line Analytical Processing) in the form of sales figures which can be viewed by the categories of sales, can help continuity and facilitate enterprise business process analyzes sales data in the future.