Until end June 2023 - QlikView dashboard <link> - Note : QlikView interface will be decommissioned in Dec 2023
From July 2023 Migration to Tableau dashboard <link>





Carolina Camacho / Laure-Breteau Laurent
Antoine Frangieh 
Donia Rachdi

General Description 

The main objective of this dashboard is to give Solvay’s Supply Chain family a tool with key performance indicators that help pilot supply chain activities and based on aligned definitions. 
Commercial KPIPlanning KPILogistics KPIProcurement
  • OTIF
  • Leadtime
  • Order processing
  • Customer Service : orders details

  • Forecast Accuracy                            

  • Inventory (definition of inventory dashboard)

  • CO2 Emissions
  • Transport Cost, Volumes
  • Loading Time
  • Haulier On Time Delivery and Shipment
  • Inventory Volumes (BW)
Procurement rates

Detailed KPI Pages

KPI dimensions


Source of data

  • In Bi4, data are only available for PAX/Pepol GBUs.
  • In BW (WCAP, TIERS, OBAS,), data are only available for SAP companies.
  • In BFC, data are available for all the consolidated companies, including the non SAP companies.
Update
Daily reload of the current and previous month + weekly full reload (current + previous year)
Period
Current + previous 2 year
Archives
note: every year on Dec 31st, an archive is created and displayed in the access point. Data in this archive is frozen so new evolutions and corrections won't be available in this application.
Previous KPI , definitions held <GSCD Archives>
Units
  • Weight: Net Weight = weight of active materials sold
  • Gross Weight = weight of all materials (active or not) and the packaging
  • Currency: EUR / USD
  • Conversion rules:
    • Transportation Costs (Query TIERS): conversion from a local currency to EUR or USD is based on the exchange rate managed by Finance. For each cost, the rate considered is the one of its reference month. The reference month of a transportation cost is :
      • the actual completion month
      • the planned completion month if the actual completion month is not available
      • the shipment creation date if the planned completion month is also not available 
    • Inventory Values in Finance (BFC) : conversion from a local currency to EUR is based on the exchange rate managed by Finance. For each inventory value, the rate considered is the one of the inventory month.
For USD, we don’t have all the exchange rates because it's not the official currency at Solvay (EUR).
So for the following countries: Argentina, Bulgaria, Egypt, Mexico, New Zealand and Switzerland, when selecting USD, the unit will not be USD but the local currency.
  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers
To get access to the Global Supply Chain Dashboard, raise a ticket on Service One (Corporate dashboard).
All the accesses must be validated by:
GBU specific Contacts or Supply Chain Excellence 
  • Alsachimie : Marielle Lorusso
  • Aroma Performance : Marie PEREIRA
  • Coatis/Fibras : Marcia TOKUDA
  • Composite Materials : Ihab Elia (*China users: access must be denied for Composite Materials)
  • Novecare : Jose Pablo Leyva
  • Oil&Gas : Mark Dahlinger
  • Performance Polyamide : Emmanuel Hatt
  • Peroxides : Benoît HORNYAK
  • Polytechnyl : Damien RAMOS
  • Silica : Philippe DELORO
  • Soda Ash : Fabien PIRET
  • Special Chem : Anne VANESSE
  • Specialty Polymers : Beth BOUCHETTE
  • Technology Solutions : Louise MARDLING
  • All GBUs access: Laure BRETEAU-LAURENT