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

Compare with Current View Page History

« Previous Version 47 Next »

Overview

Link to the dashboard

Onboarding video

Starting guide

General Description

Customer 360 Dashboard has been engineered to provide a full and comprehensive view on external sales, by Customer (corporate group). 

A new concept of direct / indirect sales has been introduced for each Customer at Corporate Group level. For a given Corporate Group : 

  1. Direct Sales : when SoldTo Group = Corporate Group code
  2. Indirect Sales : when ShipTo KA = Corporate Group code (and SoldTo Group <> Corporate Group Code). 

=>Each Customer we want to see in the drop down list needs to be added in the dashboard configuration file, otherwise Corporate Group / SoldTo / ShipTo will only be accessible using the search bar, and direct / indirect sales split can't be performed.


Authorization & Rights

Ask for your access using the Access form   
See the list of approvers in the Access Management section at the bottom of the page
FinancialCustomer Experience & InteractionOpportunitiesSegmentationService Levels

  • Revenue
  • Volume
  • ICM 
  • Orderbook
  • Forecast
  • Budget
  • Opportunities
  • Payment Terms
  • Overdues
  • DSO / Best DSO

  • OTIF
  • NPS
  • Complaints
  • Contact Relationship Matrix and Interactions

  • Weighted / Unweighted expected revenue
  • # of opportunities
  • Weighed revenue at stake
  • Top opportunities
  • Details of opportunities + links to SFDC

  • Split of sales by GBU segment
  • Split of sales by Corporate segment
  • Segment evolution between 2 periods

  • Deviation to Service Levels granted by GBU segment (VS target and charged fees)
  • Top used deviation reasons
  • Names of the KPIs
  • Deviators history
  • SCRs for Specialty Polymers


Dimensions

Sales Report (Sales, OB, Budget, MTP, forecast)

Overdues (star)

OTIF (green star)

ComplaintsOpportunitiesService Levels
  • Customer (direct indicators) = Corporate Sold-To Group(green star)
  • Customer (indirect indicators) = Ship-To KA (excl. what is counted as direct based on Corp. Sold-To Group
  • For overdues (star), assumption is made that Customer = Payer Group
  • Customer = Corporate Sold-To Group
  • No "indirect" indicators
  • Customer (direct indicators) = Corporate Sold-To Group
  • No "indirect" indicators
  • Customer (direct indicators) = Corporate Sold-To Group
  • No "indirect" indicators
  • Year (star)(green star)
  • Quarter (star)(green star)
  • Month Year (star)(green star)
  • Year 
  • Quarter 
  • Month Year
  • Opport. Close date
  • Opport. Forecast Y
  • Opport. Target First Delivery date
  • Month Year
  • GBU (star)(green star)
  • Grp of Act. (star)(green star)
  • Activity
  • Company (PRS)
  • Plant
  • Sales Rep
  • GBU
  • GBU
  • Grp. of Act.
  • Opport. Owner
  • GBU
  • Grp. of Act.
  • Plant
  • Plant Zone
  • Manuf. Plant
  • Market Cluster
  • Team Cluster
  • Customer (see upper)
  • SoldTo Group
  • SoldTo
  • ShipTo Group(green star)
  • ShipTo(green star)
  • ShipTo KA
  • Region (shipTo)
  • Country (shipTo)
  • Group Segment
  • GBU Segment
  • Only Overdues : (star) Payer and Payer Group (PRS)
  • Customer (see upper)
  • Corporate Group
  • ShipTo
  • Customer (see upper)
  • Corporate Group
  • OEM Corporate Group
  • Account
  • Region
  • Region (ShipTo) ?
  • Sold-To Group
  • Sold-To
  • Group Segment
  • GBU Segment
  • Product Hier.
  • GBU Prod. Fam.
  • Product (lvl4)
  • Material (lvl5)
  • Market
  • Segment
  • Application 
  • End-use

  • Product (lvl4)
  • Market
  • Segment
  • Application 
  • End-use

  • GBU dimensions (Sales Only) : 
    • AERO Market 
    • AERO Program
    • AERO Specification



  • Consolidated (Y/N)
  • Restated scope
  • Data scope(green star)
  • Data source(green star)
  • Source System
  • Justified (Y/N)
  • Motive
  • Severity
  • Internal Complaint (Y/N)
  • Opport. ID
  • Opport. Name
  • Opport. Active Status
  • Opport. Business Type
  • Stage Group
  • Stage
  • Opportunity Visibility
  • Data Source
  • Service Level 


Period of Analysis

Financials

Sales : from Y-4 to Y (YTD)
Orderbook : from M to M+6 (M+2 in the graphs, M+6 in report)
Budget / MTP / Forecast  : from M to M+12, more if the GBUs load more (max. 5 years)

Cust. Exp & Interactions

OTIF : Y and Y-1
NPS : depends on the NPS campaigns entered in the flat file. No filter on dashboard side.
CCR / Complaints : from Y-2 to Y
Contact Relationship Matrix and Interactions : from Y-2 to Y

OpportunitiesNo limit. The forecast years depends on each opportunity (from -∞ to +∞).
SegmentationBased on the sales : from Y-4 to Y (YTD). Warning : segmentation dimension is not updated before 2019. It becomes accurate starting 2019.
Service LevelsBased on the sales : from Y-4 to Y (YTD). Warning : the service level data starts in 2020 only.

Currencies, units and exchange rate

FinancialCustomer Experience & InteractionOpportunitiesSegmentationService Levels
  • EUR
  • USD

N/A (No revenue)

  • EUR
  • USD
  • EUR
  • USD

Fees in k€

CAR3 (past)
CAR4 (future)

N/A (No revenue)TBCCAR3 (based on sales)N/A (No revenue)
  • T
  • k Lb
  • Sh. T
N/A (No volume)
  • T
  • k Lb
  • Sh. T
  • T
  • k Lb
  • Sh. T
N/A (No volume)


Refresh frequencies and sources

FinancialCustomer Experience & InteractionOpportunitiesSegmentationService Levels
  • Daily for current month and previous month 
  • Weekly (in the Week-end) for earlier data
  • Daily for CCR, OTIF, Contact Matrix and Interactions
  • Manually at each NPS campaign (yearly) for NPS
  • Daily
  • Daily for current month and previous month 
  • Weekly (in the Week-end) for earlier data
  • Daily

All data from BW

  • BW for CCR (Orderlines), OTIF
  • SFDC (Core / iCare) for CCR (complaints) and Matrix and Interactions 
  • Flat file for NPS
  • SFDC (Core / iCare)
All data from BW (based on sales)Services Levels defined in SAP and tracked in BW 


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: Coatis
Then approvers are: Nathalia COSTA and Rafael ROCHA DE SALLES

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: Mildred ESTRADA, Eduardo SCAVONE, Pam ACCARDI, Aude TREPIER

If Requester is requesting access to GBU data for: Oil & Gas
Then approvers are: Tim Wiggins and Eddie BUNGE

If Requester is requesting access to GBU data for: Peroxides
Then approvers are: Diego RIZZO and Catalin CAPATINA

If Requester is requesting access to GBU data for: Silica
Then approvers are: Perrine GILLOT and Amel GHERBIA

If Requester is requesting access to GBU data for: Soda Ash & Derivatives
Then approvers are: Patrick ROUMEGOUX, Nicoletta VENTRE, Andrew PURCELL

If Requester is requesting access to GBU data for: Specialty Polymers
Then approvers are: Andrew FLANAGAN and James FLOCK

If Requester is requesting access to GBU data for: Special Chem
Then approver is: Eckart Nerge

If Requester is requesting access to GBU data for: All Solvay GBUs
Then approvers are: Eckart Nerge copy Donia Rachdi

If Requester is requesting access to GBU data for: All Syensqo GBUs
Then approvers are: Rogerio Dias copy Donia Rachdi



Further Improvements: 

WO0000000632900

We have pulled 5 years of historical data for following GBUs and went to production on DEC 19th 2024.

CH = Special Chem, SI = Silica, SD =  Soda Ash, CT= Coatis, PE =  Peroxides


Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels