Versions Compared

Old Version 33

changes.mady.by.user OLAZABAL, iker

Saved on

compared with

New Version Current

changes.mady.by.user BRAHMA, Anirudha

Saved on

Key

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

Image Added

Note

The aim of the QlikSense Growth Dashboard is to provide users with:

  • Identify and understand top opportunities across the group, GBU, customer, or product
  • Monitor the Realized Sales and Realization Rate from won opportunities

  • Understand how your Devpool is evolving between 2 periods of time

  • Monitor the outlook and progression of the innovation pipeline over the years across various dimensions including stage, archetype or GPM cluster. 

The primary sources from the Growth Dashboard are:

  • Salesforce (CORE & iCARe): 
    • Opportunities 
    • Realized Sales 
    • Opportunity Line items
  • WEGO:

    • Weekly snapshots are captured from the WEGO platform and entered into the Growth Dashboard.

Data from Salesforce is refreshed daily - any change made in Salesforce will be reflected in the opportunity the day after.

Please note that the naming convention to be followed when creating and saving a bookmark is GBU_Page_Scope (i.e. SpP_PipelineEvol_SKABatteries). 


Information per page:



Other information:

  • Filters & Selections 
  • Time Selection 
  • Currencies
  • How to create a bookmark 
  • Download data

Access management sources:

  • Support Documentation 
  • Access management 
  • Data source information
  • Feature & Improvement Release

Image Removed 

Embedded Google Drive File
urlhttps://docs.google.com/presentation/d/1tRoHUR7E8knBuS1AIxV2aADQhKxLhjBpFnqE_W1qhuo/edit?usp=drivesdk
fullwidthtrue
height600

  • Executive Leadership Team
  • LT teams from GBUs
  • Market VPs
  • Commercial Excellence
  • Marketing Directors
  • Marketing / Business Development
    • Sales Directors
    Info
    iconfalse
    titleTarget Users
    • Market VPs 
    • Sales Directors 
    • Commercial Excellence 
    • Marketing Director 
    • Marketing / Business Development 

    Embedded Google Drive File
    urlhttps://drive.google.com/file/d/1pWCue4DYAAOW8T5IqTRM78Cudaz203TU/view?usp=drivesdk
    fullwidthtrue
    height600


    Info
    titleOverview

    Link to the dashboard

    Technical documentation and user guides:

    General Qlik Training

    Info
    iconfalse
    titleAuthorization & Rights
    Ask for your access using the Access form   

    Retrieve the list of approvers at the bottom of the page

    General Description

    Core Sheets in the Dashboards

    Qlik Sense-based dashboard that offers business intelligence over opportunities to enable actionable insights.

    Image Removed

    CRM Analytics Sheets in the Dashboards

    The Opportunities Analytics allows users and managers to focus on opportunities by providing trending and analysis data on the opportunities generated in Salesforce.com. There are 3 different sections: Business Analysis, Pipeline Efficiency and Pipeline Monitor. 

    Image Removed



    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 data source analysis here
    5. BW: see data source analysis here
    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 data model 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 , and 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 CAPATINAand Mark FARRALES

    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 copy Donia Rachdi