BI Project

Disposable tableware company wants to set up a system business intelligence in the form of a data mart (a mini data warehouse) to observe its sales activity at the different distribution locations of his articles and that in several cities. These distribution locations are informed by their brand, their type (depending on their surface), their address (postal code and city), their department, their region. Sales are reported according to a period that breaks down into months, quarters and years. Sales are observed by the number of items by type, and turnover. The relational schema of the basis of source data: - Article (Code_Article (primary), Nom_Article, Catégorie_Article,Prix) - Transaction (Code_Transaction (primary), Nom_Article_Nom_Magasin, Date, Quantité_vendue) - Magasin (Code_Magasin (primary), Nom_Magasin, Région_Magasin, Ville_Magasin) Multidimensional modeling relates to the extraction of fact tables and dimensions from the source data. In order to prepare the fact table, it is necessary determine which metrics are the data elements to be analyzed. Then, we must determine the dimensions that represent the axes of analysis. In our case, the dimension tables and the fact table are shown in the diagram: - Dim_Article (Id_Dim_Aritcle (primary),Code_Article, Nom_Article, Catégorie_Article) - Dim_Magasin (Id_Dim_Magasin (primary),Code_Magasin, Nom_Magasin, Région_Magasin, Ville_Magasin) - Dim_Periode (Id_Dim_Periode (primary), Date,jours,Mois,Trimestre,Année) - Fait (#Id_Dim_Periode, #Id_Dim_Article,#Id_Dim_Magasin, Chiffre_Affaire) ****** Required Tasks ****** Star modeling, ETL, DatawareHouse, OLAP, Dashboard. The project will deal with a problem in different fields such as health, economy,…. - Create the structure of the source and target data in Mysql. - Fill in the source data with a management application. - Automatic warehouse supply using the ETL tool. - Analyze data in the form of graphs with visualization tools. This Project is URGENT and needs to be delivered in 6 hours, Please do not send proposal if you are not Ready to start immediately.