Data Analysis in Business Intelligence for Mathematical Prediction of Online Sale

Business-intelligence is an effective means of improving the decision making within an organization applied to profit making private companies. The online purchase and trading data available on website can be a key reference to analyze for the decision making in small scale business. The electronics product market is more volatile in nature and is having frequent variation. Such behavior of product variation has increases the risk of over inventory towards the dealers. The effective analysis of behavior of the product sale over the year can be set as a foundation for decision making. The recent BI tools are used to analyze the data to develop the report generation of the sale. These reports are studied to develop the thumb rules with respect to the variation of sale. Such thumb rule is designed to use as a knowledge base in developing a mathematical model for the predictions of sales behavior of electronics products. The Prestashop based sales module is used along with the BI tool Pentaho for the development of sales report in this paper. The MATLAB is used to develop the mathematical prediction.