Overview

Link to the dashboard (production)

Technical documentation (SCo users)

Technical documentation (ECo users)

Starting guide (SCo users)

Starting guide (ECo users)

Training video (SCo users)

Training video (ECo users)

General Qlik Training

Authorization & Rights

Ask for your access using the Access form    

See the list of approvers at the bottom of the page in the section Access Management

Target Users

  • Executive Leadership Team
  • LT teams from GBUs
  • Executive Key Account Managers (eKAM)
  • Other Sales GBU teams

General Description

Dashboard Overview:

The CRM Quality Dashboard is a Qlik Sense-based dashboard that offers business intelligence over the quality of service the company is offering to customer to enable actionable insights. It is composed by multiple sheets or pages as per below:

Data Flow Overview:

  1. SalesForce Core: Sales force data for all business units except for Specialty Polymers and Composite Materials 
  2. SalesForce iCareE: Sales force data for Specialty Polymers and Composite Materials
  3. ETL: Handled directly in Qlik Sense, the same queries are leveraged (copied) precisely from QlikView
  4. Google Sheets: see next slide
  5. BW: see next slide
  6. App Layer Data: This is where the data is prepared and modeled to be used by Qlik sheets
  7. Presentation Layer: The dashboards that are visible to users, where new sheets and amendments are created
  8. Data model: Data in assembly in Star schema (see diagram below):


Access management

If Requester is requesting access to GBU data for: Aroma Performance,
Then approvers are: Evita MARKUS and Simon Delens

If Requester is requesting access to GBU data for: Technology Solutions
Then approver is: Evita MARKUS

If Requester is requesting access to GBU data for: Coatis
Then approvers are: Nathalia COSTA and Rafael ROCHA DE SALLES

If Requester is requesting access to GBU data for: Composite Materials
Then approvers are: Natacha PRENEN and Rebecca RENNESTRAUM

If Requester is requesting access to GBU data for: Novecare
Then approvers are: Mildred ESTRADA, Eduardo SCAVONE, Pam ACCARDI, Aude TREPIER

If Requester is requesting access to GBU data for: Oil & Gas
Then approvers are: Tim Wiggins and Eddie BUNGE

If Requester is requesting access to GBU data for: Peroxides
Then approvers are: Diego RIZZO and Catalin CAPATINA

If Requester is requesting access to GBU data for: Silica
Then approvers are: Perrine GILLOT and Amel GHERBIA

If Requester is requesting access to GBU data for: Soda Ash & Derivatives
Then approvers are: Patrick ROUMEGOUX, Nicoletta VENTRE, Andrew PURCELL

If Requester is requesting access to GBU data for: Specialty Polymers
Then approvers are: Andrew FLANAGAN and James FLOCK

If Requester is requesting access to GBU data for: Special Chem
Then approver is: Eckart Nerge

If Requester is requesting access to GBU data for: All Solvay GBUs
Then approvers are: Eckart Nerge copy Donia Rachdi

If Requester is requesting access to GBU data for: All Syensqo GBUs
Then approvers are: Rogerio Dias and Vicente Berghofer




Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))