You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 24 Next »








The aim of the QlikSense Pricing dashboard is to provide users with :

  • Overview and details on Sales, Volumes, Margin (ICM) and Costs (currently historical and forecast during 2022)
  • Standardised analysis around Pricing
  • Monitoring of others Front End Module (quotes and campaign) when deployed for a specific GBUs (live for Speciality Polymers, planned for Q2 for Novecare, Others : TBC)


The primary sources for for Pricing Dashboard are :

  • BW : COPA, Orderbook, Budget
  • Salesforces : Icare & CORE (not yet live for CORE)

Details about the queries names and dimensions are available here. 


Data are refreshed daily for M and M-1, and weekly over the weekend for the full scope (2 years + current year)


Please note that this dashboard is still under project mode and will be improved during 2022. 

Currently, GBU under projects are Specialty Polymers, Novecare, Technology Solutions (business line Polymers Additives). For others GBUs data have not yet been validated by finance.



General Information:

Navigate  → Remove and split across the below

  • How to filter into the pricing dashboard? 
  • Timeline selection
  • Currencies (including FX rules)
  • Unit of measurement
  • How to create a bookmark?


Information about different pages: 

Others :

  • Use cases
  • Training → Link to training kit "discovery session" in a dedicated page
  • Data sources details / include customization made on Icare, GBU regions, ... to replace : Filters and Dimensions
  • Terms and Definitions Summary
  • Frequent questions 


This page is edited by the Pricing Transparency squad. 

If you didn't find the information you were looking for or if you have a question related to a functionality or the data in the dashboard, please contact Karim Benzakour.

Access the dashboard

The dashboard to be used is Pricing Dashboard

=> Go to the QlikSense hub 

=> Click on the  Pricing Dashboard tab


User access request :

  • For GBUs, accesses are based on your CRM (Icare or CORE) profile, mode details available here
  • For others, please raise a ticket in Service One


your profile determines what you can see - some information is not available to some profile (either data, i.e. ICM, or entire pages).


What can you find into the Pricing Dashboard?


1/ Sales and Pricing Review

Main focus : sales, volumes, margin and costs information over time

2/ Scatter plot

Main focus : Pricing Analysis (average selling price (with/without freight and duties, last price, ICM, ICM%) of several CPC (customer product combinaison)


3/ Price Volume Decomposition (SpP Only)

Main focus : Compare sales (soon margin) evolution between any 2 historical period and understand drivers of evolution : price, volume, FX...


4/ Price Execution Tracking (Icare only)

Main focus : Ability to track execution of pricing from Quote Module in Salesforce


5/ Order Book price analysis

Main focus : Analyse price of the order book vs last invoice price (monthly average).

 This page has no ambition to replace the order book page from CRM analytics 


6/ My Data Report

This page allows to create and extract customise table or pivot table


SCREENSHOT TO BE CHANGED!

  • No labels