Titre : | Implementation of a Decision Support System for Total’s Marine Lubricants Filial | Type de document : | projet fin études | Auteurs : | Errais Hasnae, Auteur | Langues : | Anglais (eng) | Catégories : | Ingénierie de web et Informatique mobile
| Mots-clĂ©s : | Decision Support System, Data warehouse, TPMA (Third-party maintenance application), Extraction Transformation and Loading (ETL), Reporting, Data-driven company. | Index. dĂ©cimale : | 1927/18 | RĂ©sumĂ© : | My Graduation Project, carried out within CGI technologies and solutions group, is a part of TPMA (Third-party maintenance application) process for Total and more specifically in BI division. It aims to create a decision support system for Total’s marine lubricants filial.
To manage this department, Total applied an innovative method: putting into service to web applications. The first is an external one for real sales, you can find it under the name of “Total lubmarine” in the web. It’s where customers can order and buy lubricants products. The second is an internal application where Total’s manager can enter expected sales values to calculate a future price offers with theoretical benefits. It is called “PRICATO” that stands for “Price Offer Calculator”.
My team has already built a data warehouse for Lubmarine data. My mission was to implement an SAP solution for Pricato’s data via the Extraction, Transformation, and Loading (ETL) process to enable reporting. The reason behind is to compare the results of each universe and verify if the expectation was in conformity with reality. Otherwise, It is critical and a fast intervention should take a place. The system purpose, thus, is to turn Pricato’s data into information and enable Total to be a data-driven company
In order to implement a data warehouse for decision support to Pricato we started by studying the existing context to define customer needs. After that, we planned data transformations, we discussed how to move data from the source into the data warehouse structure. Then, we constructed a conceptual data model determining the subjects that will be expressed as fact tables and the dimensions that will relate to the facts. Afterward, we designed data load process to use in this project and we implemented the solution. Finally, we ran some tests to ensure the application efficiency.
|
Implementation of a Decision Support System for Total’s Marine Lubricants Filial [projet fin études] / Errais Hasnae, Auteur . - [s.d.]. Langues : Anglais ( eng) Catégories : | Ingénierie de web et Informatique mobile
| Mots-clĂ©s : | Decision Support System, Data warehouse, TPMA (Third-party maintenance application), Extraction Transformation and Loading (ETL), Reporting, Data-driven company. | Index. dĂ©cimale : | 1927/18 | RĂ©sumĂ© : | My Graduation Project, carried out within CGI technologies and solutions group, is a part of TPMA (Third-party maintenance application) process for Total and more specifically in BI division. It aims to create a decision support system for Total’s marine lubricants filial.
To manage this department, Total applied an innovative method: putting into service to web applications. The first is an external one for real sales, you can find it under the name of “Total lubmarine” in the web. It’s where customers can order and buy lubricants products. The second is an internal application where Total’s manager can enter expected sales values to calculate a future price offers with theoretical benefits. It is called “PRICATO” that stands for “Price Offer Calculator”.
My team has already built a data warehouse for Lubmarine data. My mission was to implement an SAP solution for Pricato’s data via the Extraction, Transformation, and Loading (ETL) process to enable reporting. The reason behind is to compare the results of each universe and verify if the expectation was in conformity with reality. Otherwise, It is critical and a fast intervention should take a place. The system purpose, thus, is to turn Pricato’s data into information and enable Total to be a data-driven company
In order to implement a data warehouse for decision support to Pricato we started by studying the existing context to define customer needs. After that, we planned data transformations, we discussed how to move data from the source into the data warehouse structure. Then, we constructed a conceptual data model determining the subjects that will be expressed as fact tables and the dimensions that will relate to the facts. Afterward, we designed data load process to use in this project and we implemented the solution. Finally, we ran some tests to ensure the application efficiency.
|
|