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 - Ana Rocha
  •       Product Manager - Alessandro Mainardi 
  •       Delivery Manager -  Simon Bourguignon
  •       Product Owner -  Alba Carrero/ Gaëtan Frenoy
  •       Project Manager - Rui Ferraz; replaced by Nicholas Foster
  •       Data Scientist - Eldiias Dzhamankulov and Gael Richard
  •       Data Architect  - Nikolaos Vardouniotis; replaced by Sebastien Ladouce
  •       Tableau Dev - Daniel Bernal; replaced by Maxime Marboeuf
  •       Data Engineer - Nikola Trajkovic; replaced by Anon Kasemvilas
  •       Incidents, enhancements or Change Request Process - Alexander Henry     Tejasukmana


Planning

  • Pending Tasks


https://docs.google.com/spreadsheets/d/1zQokrB3ZEHPXC4kaKGhRF0pAjSrXwEUpuieWlQxaIAY/edit#gid=1079749465


  • 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://docs.google.com/document/d/1QE3bZPrqcsqTMhL7ssSjogn4EDgJSAEnPyfNc-DvcOI/edit

  • Robustify Architecture


https://docs.google.com/presentation/d/1LtZpWydj5gmCfxkhRYrmXKI-nC2nwQNDbrY2cW3gEhQ/edit#slide=id.g93ec4672fa_8_1752

  • Project EPICs / Requirements


https://docs.google.com/presentation/d/18b2SJK3gEbsXlflxbnA3_2uoo1gdkDd1gJaHR8Oc1Jo/edit#slide=id.g25bf9c4f3f1_0_0

https://drive.google.com/drive/u/0/folders/1IUZRQTVjGnnRs6tmyQf4GQ9Bmjrqz7SU

  • High Level Design

     
  • Low Level Design


  • Web App UAT


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


  • Project Costs


https://docs.google.com/spreadsheets/d/19cQDPGB9lvyOYdoa6lurZ-MVk8EhMh0T4z0ZQPYKPdM/edit#gid=1113818323


  • Ceremonies Documentation


Kick off https://docs.google.com/presentation/d/1tCrzyUx9Zoy4_jkkuNGVTNVCyH_FH73JBFWKnqRUMI0/edit#slide=id.g28d867342c2_0_0

Steering Committee #1

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

Steering Committee #2

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

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