Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

General Introduction

- Project Overview: 

This document briefly describes the new architecture for the purchasing Dashboard built in Tableau.
The idea is:

    • to create a dashboard displaying the main KPIs analyzed by the purchasing and procurement team
    • 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.

Stakeholders


Table of Contents


Responsible & contact points:

  •       Application Owner - Sylvie Severini
  •       Delivery Manager -  Donia Rachidi
  •       Project Manager - Vitaly
  •       Data Architect  - Joao Fonseca
  •       Tableau Dev - Maxime Marboeuf
  •       Data Engineer - Virgil Lissassi ; replaced by Matteo Menghetti
  • Google BigQuery Links


Dev

https://console.cloud.google.com/bigquery?project=prj-dashb-rational-dev

Test

https://console.cloud.google.com/bigquery?project=prj-dashb-rational-test

Prod

https://console.cloud.google.com/bigquery?project=prj-dashb-rational-prod

Pre-prod

https://console.cloud.google.com/bigquery?project=prj-dashb-rational-pre-prod



  • Mapping file

Google Drive Live Link
urlhttps://
docs
drive.google.com/
spreadsheets
file/d/
1DkU4n8SOl4B-dNbZ4SeZ_LhUd7tp_lLpMuwm4pbL6TY/edit?hl=en&forcehl=1#gid=309163240
13CObtNaqNbeLvuPD2aAq48mKjZSbFrzvqt6U9PZJNzs/view

  • Robustify Architecture


Google Drive Live Link
urlhttps://docs.google.com/presentation/d/1LtZpWydj5gmCfxkhRYrmXKI-nC2nwQNDbrY2cW3gEhQ/edit#slide=id.g93ec4672fa_8_1752

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

  • Project EPICs / Requirements