A Decision-making System for The Management of Supermarkets

Abstract

In recent years, business intelligence systems have been high on the corporate priority list. In order to be attentive to their performance, and always in line with their customers’ expectations. This requires companies to have a global view of their business, identify their weaknesses and detect opportunities, by collecting and analyzing the information stored. A requirement in a rapidly changing global market. To provide company managers with access to reliable and relevant information to make strategic management decisions more intelligently and give them the ability to analyze the company’s activity. Who initiated the project to set up a decision support system that was the subject of our nal year project. We started the project by doing a bibliographic search, which was a very important phase. It allowed us to get an idea of the decision-making systems and to familiarize ourselves with the elements necessary for their implementation. At the end of this In this phase, we opted for the Kimball approach, which considers the Data Warehouse as a set of DataMarts that are consistent with each other. Its advantage is the speed of implementation of a business intelligence solution adapted to the needs described. We then carried out a complete and detailed study on the state and procedures of decision-making within the company as well as an identi cation of users and identify their needs. Through interviews, supplemented by questionnaires and observations. Based on this study and following Kimball’s approach, we have identi ed three topic-oriented DataMarts. One Datamart for the sales activity, one Datamart for the purchasing activity and another for the stock activity. The design phase began with the design of the storage area. In this section, we were able to identify all the dimensions, facts and measurements of the data warehouse as well as the multidimensional (star-shaped) schemas of each activity. Then we moved on to the design of the feed zone which consisted in extracting the data from the MySQL transactional database, using the WampServer, PowerAMC tools). These services include a rich set of integrated tasks and transformations and graphical tools that allow you to extract and Transform data from a possible source without writing a single line of code (use only a loading script). The loading of the cubes and dimensions of our DataMarts, has been done with MySQL Server and Talend which allows you to design, create and manage multidimensional structures. At this stage, the 87 Chapitre 9. Overall conclusion cubes are loaded and ready to be interrogated. We can now deploy our system, providing users with a tool that o ers a wide range of data analysis and presentation options (our webdev17 website). By setting up this platform, we were able to analyze and collect all the information necessary for decision-making and allow users to have reports, supplies and sales promotions of their activity in real time. At the end of this project, we were able to achieve the objectives we had previously de ned.