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, Margin and Costs
- Monitoring of others Front End Module (quotes and campaign) (live for Specialty Polymers, partially at Novecare, Others: 2023)
The primary sources for Pricing Dashboard are :
- BW :
- Historical data: COPA, Orderbook, Budget
- Forward Looking Data: Manufacturing Variable Costs, Sales Forecast Revenue
- Salesforce : 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. Data are available for Specialty Co GBUs.
Currently, GBU under projects are Specialty Polymers, Novecare, Technology Solutions, Special Chem and Aroma.
Composite Materials data has not yet been validated by finance - expected in H1 2023.
General Information:
Information about different pages:
- COPY FOR UPDATE_2. Scatterplot
5. Price Execution tracking (Spp)
- 7a. Pricing Campaigns Tracking (SpP - Icare)
Others :
- Ready_Access Management Pricing Dashboard
- Use cases
- Training Toolkit
- Data sources details / include customization made on Icare, GBU regions, ...
- Terms and Definitions Summary
- Frequent questions
This page is edited by the Pricing Transparency squad (Product Owner : Melissa Bahr)