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.
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!
Terms and Definitions Summary
Pages and modules
Frequent questions
Source of data and technical dimensions
Glossary of terms and acronyms
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.