IMPLEMENTING SALES DECISION SUPPORT SYSTEM USING DATA MART BASED ON OLAP, KPI, AND DATA MINING APPROACHES

Organizations and companies endeavour to expand their resources, margin of profit, and a robust management system. Managers seek tools that adapt the organizational data into information to support their strategic decisions to enhance the organization in terms of performance and profit. A challenging issue helps managers and analysts in making accurate departmental decisions on the basis of the analytical results. A large amount of historical data can be converted into information to support short and long-term strategic decisions. The decision support system (DSS) is one of the essential tools that can handle these data to provide analytical results that help in making the right decisions. This study presents a framework for designing and implementing sales. The framework module explains the DSS implementation. First, the framework establishes data pre-processing. Second, the framework extracts, transforms, and loads from the level of operational data from a data warehouse. Third, building sales cube and knowledge-driven sales is supported on the basis of three data mining approaches (decision tree, clustering, and neural network). The basic elements of the DSS (key performance indicator (KPIs), reports, and knowledge-driven sales supporter) are implemented in the next stage. Finally, the web interface is performed to provide access for sales managers. DSS used data mart on the basis of online analytical processing and KPI as fundamental tools. The design and implementation of a data mart utilize an SQL server database management system and SQL server data tools. The adopted source data were sales data of two years (2017 and 2018) of Basra Governorate. The proposed knowledge-driven sales DSS assists in decision-making Such a system may assist managers in evolving new insights and strategies. The proposed technique, including the OLAP operation, presents the analytical results in addition to the KPIs that provide the indicators when a critical situation affects the overall profit or performance.