General Introduction

- Project Overview: 

This document briefly describes the new architecture for finalizing the existing solution of Robustify energy optimization (Dataiku solution in Production).
The idea is:

    • to create an interface to automate data gathering from already existing tools, in order to ensure that requestors are autonomous and do not need to wait for manual action;
    • to ensure the optimization and implementation of best configuration possible; 
    • to review the Data Model and ensure the least possible level of dependencies. 

There are some changes that need to be made as part of this project:

    • Create a centralized Data repository (Single source of the truth).
    • Talend (Data Integration processes from Data Sources to the Data Lake).
    • Build all the dashboards in Tableau.
    • Build an user friendly front end application.
    • Create a centralized historical Data repository (used for analysis and comparison).

Support & Evolutions



Responsible & contact points:

  •       Application Owner - Sebastien Goeuriot
  •       Delivery Manager -  Simon Bourguignon
  •       Product Owner -  Alba Carrero/ Gaëtan Frenoy


Information are updated within LeanIX: https://solvay.leanix.net/solvayprod/factsheet/Application/a87361bc-7b65-4a89-b1f0-c0466fc460dd


Historical participants:

  •       Data Scientist - Eldiias Dzhamankulov and Gael Richard
  •       Data Engineer  - Anon Kasemvilas
  •       Tableau Dev - Daniel Bernal ; replaced by Maxime Marboeuf
  •       Incidents, enhancements or Change Request Process - GCP Team & Data Platform


Planning

  • Pending Tasks


https://drive.google.com/file/d/1tGrNPqMb7Gkry4dJWZSNNtOEZx3O6sacF9Rl_FHyEZo/view


  • Robustify Wiki Page


https://wiki.solvay.com/display/BDA/Robustify

  • Web App Links


Dev

https://app-robustify.dev.gcp.cloud.solvay.com

Test

https://app-robustify.test.gcp.cloud.solvay.com

Pre-prod

https://app-robustify.qa.gcp.cloud.solvay.com

Prod

https://energy-optimizers.solvay.com




  • Google BigQuery Links


Dev

https://console.cloud.google.com/bigquery?project=prj-data-robustify-dev

Test

https://console.cloud.google.com/bigquery?project=prj-data-robustify-test

Prod

https://console.cloud.google.com/bigquery?project=prj-data-robustify-prod&ws=!1m0

Pre-prod

https://console.cloud.google.com/bigquery?project=prj-data-robustify-ppd&ws=!1m0







  • Initiative Brief 


https://drive.google.com/file/d/1mI1VBevp3y_5eYY6uqOmRJ8cXlhVSoaFn5Wx99qM_cE/view

  • Robustify Architecture


https://drive.google.com/file/d/1aIJhjyGT9q9A61f8Dmwu5a5U37im5I9DhcPOoUF9Q5Q/view

  • Project EPICs / Requirements


https://drive.google.com/file/d/1lqea2vjIwzLhFOZfVvfeDqQ0g9GgzxHe1k0BSavCdPg/view

https://drive.google.com/drive/folders/1jB7fZ7_tI2SAcb9qQlOm1Rf8n9u9ri8i

  • High Level Design

     
  • Low Level Design


  • Web App UAT


https://docs.google.com/spreadsheets/d/1IZIPU9BJfvwmPCKzWxhnTpcfIGpCqtvR77_AOu4Z9QE/edit#gid=0


  • Project Costs


https://drive.google.com/file/d/1nb_IdPhWvirTzT7o97xJ2O6OAcBARtx6u7GfbTkue2g/view


  • Ceremonies Documentation


Kick off https://drive.google.com/file/d/1KqkHtxqGrUAbGxRKWBJUbaY_CgtEZU2Kbm2gw_ix_HI/view

Steering Committee #1

https://docs.google.com/presentation/d/1q30Hr-zpmdoMVlIfS6E-bIg8haJ-eYt8cmGzzOLkWp0/edit#slide=id.g27ef8dcb1b8_0_0

Steering Committee #2

https://drive.google.com/file/d/1kaNI6rNjd91V8qmLFAqxSEVzJpBlhtXry3GRSacyLAI/view

Steering Committee #3

https://docs.google.com/presentation/d/1WOfPkaCyjfzsojAl_nJW2lf5dmE53170kAq2GSdvQes/edit#slide=id.g27ef8dcb1b8_0_0



DS_APP_Robustify.Torrelavega_inputs -->
DM.V_FACT_TORRELAVEGA_inputs -->
DM.V_FACT_TORRELAVEGA_inputs_enr -->
DM.V_FACT_TORRELAVEGA_queue -->
DPL.V_FACT_TORRELAVEGA_queue




  • No labels