Slide 1

Slide 2 Confidential Agenda sparesFinder introduction Key Issues Master data harmonisation Cleansing process Item Management & Governance Governance Issues and Process Key components of data quality / governance / MDM Slide 3 Confidential Company profile Slide 4 Confidential Customers Slide 5 Confidential Beyond data cleaning Slide 6 Confidential Key issues for our customers Slide 7 Confidential Unconsolidated data or systems Data Complexity Direct Cost of Data Group Data governance Benefits and Availability Slide 8 Confidential Content quality is fundamental Highly functional systems Basic systems Poor content quality Accurate, available master data 1.Clean 2. Govern Slide 9 Confidential Before you start.. Slide 10 Confidential Noun- Modifier & Attribute Review Noun- Modifier & Attribute Review Text Scanning and Keyword Identification Text Scanning and Keyword Identification Gap Assessment & Prioritization Gap Assessment & Prioritization Dictionary Acceptance Dictionary Acceptance Data Standards Cycle Data Standards Cycle OEM / Vendor Relationship Settings OEM / Vendor Relationship Settings Classification Mapping as required Classification Mapping as required Batches of Noun/ Modifiers Legacy Data Clean data to client systems Data life cycle process Data Improvement Cycle Quality Control & Approval Classify, Normalize & Enrich Gatekeeper Configuration & Integration Cleansed Data Acceptance QueryResolution Ongoing Data Quality Maintenance Slide 11 Confidential Control vs. Efficiency Slide 12 Confidential Control decisions Slide 13 Confidential Cost vs. speed, quality and scope Slide 14 Confidential Scoping decisions Slide 15 Confidential Do you need a data quality tool? Research from 2007 by Ventana (http://www.ventanaresearch.com/http://www.ventanaresearch.com/ Slide 16 Confidential Software tool demands Slide 17 Confidential Software and content Base Module User Admin, Dictionary, Catalogue, Interfaces Base Module User Admin, Dictionary, Catalogue, Interfaces Insight Report Insight Report Masterpiece Clean Masterpiece Clean VPI Search VPI Search Gatekeeper Govern Gatekeeper Govern Content sparesFinder Dictionary or Customers own taxonomy OEM Catalogues Content sparesFinder Dictionary or Customers own taxonomy OEM Catalogues Slide 18 Confidential Content Supporting services Insight Report Insight Report Masterpiece Clean Masterpiece Clean VPI Search VPI Search Gatekeeper Govern Gatekeeper Govern Base Module User Admin, Dictionary, Catalogue, Interfaces Base Module User Admin, Dictionary, Catalogue, Interfaces Professional Services Dictionary Creation Systems integration Training (for all modules) Professional Services Dictionary Creation Systems integration Training (for all modules) Professional Services Data cleansing Project Management Data Extract and Load Professional Services Data cleansing Project Management Data Extract and Load Professional Services Change management Virtual store creation with key vendors Transaction support Professional Services Change management Virtual store creation with key vendors Transaction support Professional Services Data Governance process design Ongoing specialist product advice and support Professional Services Data Governance process design Ongoing specialist product advice and support Professional Services Consultancy to drive inventory reduction, supplier rationalisation and strategic sourcing programmes. Professional Services Consultancy to drive inventory reduction, supplier rationalisation and strategic sourcing programmes. Slide 19 Confidential Foundations Slide 20 Confidential Detailed taxonomy Slide 21 Classification mapping Slide 22 Multi Language Slide 23 Confidential Detail, help and classification Slide 24 Confidential Leveraging catalogues Slide 25 Confidential Manufacturer Name / Part Number Part Manufacturer (Brand ) Part Number Part Manufacturer (Brand ) Part Number Alternate Brand Part Number Alternate Brand Part Number Alternate (e.g. wrong colour) Parent Company Parent Company Other Brands Part Number Other Brands Part Number Competitor Brand Part Number Competitor Brand Part Number Functional Equivalent OEM Part Number OEM Part Number Distributor Part Number Distributor Part Number OEM Part Number OEM Part Number Distributor Part Number Distributor Part Number Suppliers Old part number and other aliases, drawing number, supersessions Old part number and other aliases, drawing number, supersessions Primary Supplier Primary Supplier Alternate Supplier Alternate Supplier Slide 26 Confidential Equipment / Catalogue Specific Equipments / BOMs Catalogue Master Catalogue Master System Specific SAP Client 1: Material No XX Client 1: Material No XY Client 2: Material No ZZ Part Number SAP Client 1: Material No XX Client 1: Material No XY Client 2: Material No ZZ Part Number Maximo DB 1: Item No AAC Maximo DB 1: Item No AAC Higher Assembly 3 of Component 8 of Geography Specific Equipment Locations TAG 1-1-3 TAG 2-6-9 Equipment Locations TAG 1-1-3 TAG 2-6-9 Slide 27 Confidential Single source of data Slide 28 Confidential Masterpiece Core Legacy Data Clean Data Creating data quality Slide 29 Confidential Data Cleansing Slide 30 Confidential Masterpiece Core Clean Data New Item Spares MDM ERP Data Models Multi ERP Syndication Data Governance Organisation Slide 31 Confidential ERP Attribute Management Slide 32 Confidential Corporate ERP Structures Slide 33 Confidential Adding a new item Slide 34 Confidential Checking functional matches Slide 35 Confidential Prioritising and tracking requests Slide 36 Confidential Organization, policies and procedures, authorizations and controls in place to manage data on a long-term basis Metrics to measure and monitor the efficiency and effectiveness of key business processes Processes to maintain item master and keep classification codes and standards evergreen Operating model enhancements to drive better data quality while retaining business intimacy Policy changes around item master creation, updates, deletions and approvals Service levels and turnaround time agreement Defined communication channels for requests Request and Approval processes item add, change, delete Notification to other data maintenance owners (BOM, Sales Pricing, etc.) for further item use or processing. Item availability notification process Centralized vs. Centrally Managed vs. De-centralized vs. Outsourced Reporting relationships Roles and Responsibilities Item creation/update cycle time Percentage of shipments on hold % of item master maintenance errors More than software Slide 37 Confidential Without sparesFinders tools we could never have achieved the savings that we have on a global scale. They combine ease of use with a high degree of sophistication, and reflect the deep level of MRO knowledge within the company. Our data cleansing project has resulted in far more efficient buying processes, higher levels of internal stock transfer, and significantly reduced duplication John Vezey, BAT Global Spares Team. Without sparesFinders tools we could never have achieved the savings that we have on a global scale. They combine ease of use with a high degree of sophistication, and reflect the deep level of MRO knowledge within the company. Our data cleansing project has resulted in far more efficient buying processes, higher levels of internal stock transfer, and significantly reduced duplication John Vezey, BAT Global Spares Team. Thank You