Page History

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

Embedded Google Drive File

url	https://docs.google.com/presentation/d/1tRoHUR7E8knBuS1AIxV2aADQhKxLhjBpFnqE_W1qhuo/edit?usp=drivesdk
fullwidth	true
height	600

Info

icon	false
title	Target Users

Market VPs
Sales Directors
Commercial Excellence
Marketing Director
Marketing / Business Development

Info

title	Overview

Link to the dashboard

Technical documentation and user guides:

Syensqo

General Qlik Training

Info

icon	false
title	Authorization & 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

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

Page tree

Versions Compared

Old Version 35

New Version Current

Key

Ask for your access using the Access form