BI Project

Fullført Lagt ut 3 år siden Betales ved levering
Fullført 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.

Microsoft SQL Server MySQL Data Analytics ETL Power BI

Prosjekt-ID: #28970889

Om prosjektet

7 bud Eksternt prosjekt Aktiv 3 år siden

Tildelt til:

mayajohnson519

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

£250 GBP på 1 dag
(0 omtaler)
0.0

7 frilansere byr i gjennomsnitt £492 for denne jobben

asin1987

Dear Employer, I am a BI modelling expert, ready to start and will deliver in next 6 days. Kindly message me to discuss more. Kindly check my previous reviews here for your kind consideration: https://www.freelancer.c Mer

£750 GBP på 6 dager
(9 Omtaler)
4.9
millennialrave

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

£1000 GBP på 1 dag
(4 Omtaler)
2.6
wanjihiamichael1

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

£250 GBP på 4 dager
(0 Omtaler)
0.0