BI Project
£250-750 GBP
Betales ved levering
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.
Prosjekt-ID: #28970889
Om prosjektet
Tildelt til:
MASTERS IN MATHEMATICS, EXPERT IN ABOVE NAMED SKILLS, DEAR EMPLOYER, After KEENLY reading your description and being in a possession of all CLEARLY STATED REQUIRED SKILLS as this is my area of PROFESSIONAL SPECIALISATI Mer
7 frilansere byr i gjennomsnitt £492 for denne jobben
Hi I have read your description very well, I think I can do your job very perfectly.(I have a team so we can complete your project for 6hours) I can provide better work than you expected, I have already done a lot of w Mer
MASTERS SOFTWARE ARCHITECTURE EXPERT IN DATA ANALYTICS HELLO, I have read the instructions keenly and understood your specifications for the task. I have over 7 years’ experience in this field and have adverse experi Mer