SOFTWARE FOR INTEGRATING DATA FOR PRODUCT SALES ANALYSIS

Today, many sales companies have multiple sales branches. These companies usually
already have some application to support their activity. Each transaction that happens
every day has been recorded for sales report purposes. However, the use of sales
transaction data that is still distributes at many places not yet optimum. Unification of
data from many places that not handle rightly can cause mistaken in sales report and
make management take wrong decision.
To solve this problem, a system that can integrate distributed transaction data to a new
database, data mart, is needed. Data integration process can be done by Extraction-
Transform dan Load (ETL) mechanism with Relational Online Analytical Processing
(ROLAP) approach. ROLAP technology can provide data for analysis in form of
multidimensional database (containing dimension dan fact table).
Tools which used to implement development of this system are Pentaho. It is because;
Pentaho is one of Business Intelligence (BI) platform which is integrating a set of BI
components. Component which supporting analysis processes are Kettle, Mondrian, and
JPivot.
The development of this system can solve the lack capabilities at the system that running
by providing the data integration function, making sales report, and sales analysis
features.