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
Data from Salesforce is refreshed daily
Please note that the naming convention to be followed when creating and saving a bookmark is GBU_Page_Scope (i.e. SpP_PipelineEvol_SKABatteries).
Overview
General Description
Core Sheets in the Dashboards
Qlik Sense-based dashboard that offers business intelligence over opportunities to enable actionable insights.
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.
- SalesForce Core: Sales force data for all business units except for Specialty Polymers and Composite Materials
- SalesForce iCareE: Sales force data for Specialty Polymers and Composite Materials
- ETL: Handled directly in Qlik Sense, the same queries are leveraged (copied) precisely from QlikView
- Google Sheets: see data source analysis here
- BW: see data source analysis here
- App Layer Data: This is where the data is prepared and modeled to be used by Qlik sheets
- Presentation Layer: The dashboards that are visible to users, where new sheets and amendments are created
- 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: Composite Materials
Then approvers are: Natacha PRENEN and Rebecca RENNESTRAUM
If Requester is requesting access to GBU data for: Novecare
Then approvers are: Pam ACCARDI and Aude TREPIER
If Requester is requesting access to GBU data for: Oil & Gas
Then approvers are: Eddie BUNGE and Mark FARRALES
If Requester is requesting access to GBU data for: Specialty Polymers
Then approvers are: Andrew FLANAGAN and James FLOCK
Not able to find the solution? Contact SBS Support.