Designing A Data Warehousing Modelto Support Forecasting and Decision Making for Sales

Abstract

It's difficult to make a decision, without enough information because the databases in the branches of Sales department of National Paints factoryare not integrated for management of Information and decisions making. So for this reason we prepared a study on designing of data warehouse model to support forecasting and decision making of paint sales. The main objective of this research is to collect those data in one repository. Data warehouse is responsible for consistency of information. The aim of data warehousing is to organize the gathering data and store it in single repository. Data warehousing solve the problem and provide technology which enables the user or decision maker to process the data in short time. With the help of data warehousing, manager extract the Knowledge in real time and it helps the manager in the decision making process.The research used SQL Server Data Tool that contains SQL Server Integration Services (SSIS) due to consistency and integrating data. Also, it used SQL Server Analysis Services (SSAS) to analyze data and build a dimensionalmodel. Manager canunderstand the data easily by used cubesof dimensional model. Also, manager can drill down or up by adding or removing attributes from their analyses with excellent performance. Moreover, the researcher explored data by using Time Series Algorithm and prediction of the quantity during the first quarter will be in January and February between 1-50 products only, whereas its increase to 101 products in begins of March. As well as, the researcher used SQL Server Reporting Services (SSRS) to review reports after analysis to answer to questions of manager and support him to make decisions.