A Fortune 500 company was struggling to analyze its SAP HANA cleared invoice data. The spend metadata such as PO description, Material Code, GL Code was loosely filled in the system due to which it was very challenging to identify the category spend. Supplier names had multiple duplicates and parent child mapping was missing. They wanted to classify the spend in accurate buckets to derive a successful sourcing strategy.
KEY CHALLENGES
Limited Visibility – Who are the key suppliers? What is the geographic spend?
Poor Classification – Spend data lacked classification to map CAPEX & MRO items.
Supplier Grouping – Multiple names of supplier exists across the spend data.
Multiple Languages – PO Descriptions are in multiple languages.
Multiple Sources – Spend data comes from two sources, i.e. SAP ECC & SAP HANA.
High Volume of Data – 4.1 million rows of spend data cannot be analysed in excel.
Need for Advanced BI – Solving above challenges requires advanced BI solution
APPROACH
Procurement Taxonomy – Defining broad sub level taxonomy for CAPEX & MRO.
PO Description Classification – Sub level classification by reading PO Descriptions.
Stakeholder Inputs – Inputs from client stakeholders to incorporate existing knowledge.
Visualizations Storyline – Defining visuals which lay the roadmap for effective story telling.
Category Dashboards – One-page summary of category spend across region and suppliers.
Supplier Dashboards – One-page summary of historic supplier spend.
Refresh & Maintenance – Future data refresh with high level of automation.