har data management

Australia

Data Management

….or, how to manage that big hairy beast called Master Data

http://www.gs1.org/�

© 2008 GS1

Australia

26

Session agenda

• What is Data Management

• How good is your Data Management and Master Data?

• The impact of poor data in the supply chain

• The technical solution

• Success Criteria for good Data Management

• Final Thoughts

• Close / Questions

© 2008 GS1

Australia

27

What is Data Management?

• Definitions of Data management on the Web: • Data management comprises all the disciplines related to managing

data as a valuable resource.en.wikipedia.org/wiki/Data_management

• Controlling, protecting, and facilitating access to data in order to provide information consumers with timely access to the data they need. The functions provided by a database management system.www.information-management.com/glossary/d.html

• Definitions of product data management on the Web: • Product data management (PDM) is the business function often

within product lifecycle management that is responsible for the creation, management and publication of product data.en.wikipedia.org/wiki/Product_data_management

http://www.google.com.au/url?q=http://en.wikipedia.org/wiki/Data_management&sa=X&ei=vHhsTOi7OM3McJ3AuVw&ved=0CBAQpAMoAA&usg=AFQjCNGt4zClsRmLCanIrIjk-fw6d37nLw�

http://www.information-management.com/glossary/d.html�

http://www.google.com.au/url?q=http://en.wikipedia.org/wiki/Product_data_management&sa=X&ei=O3lsTLa6G87XcYXK2VU&ved=0CAoQpAMoAA&usg=AFQjCNHpnWRsTDa11OeHuXP9jn5JlM7yJw�

© 2008 GS1

Australia

28

How good is your Data Management and Master Data?

• Have you ever thought about how poor master management and data can impact your business?

• Poor Master Data has a direct link with the following:• Excessive amounts of claims• Payments held up• Constant queries on customer orders• Product returns• Lost sales• Lack of stock control• Order reconciliation taking too long• Sales staff spending too much time doing paperwork• Master data control is spread around the business

© 2008 GS1

Australia

29

• Data Crunch report – Prepared by GS1 UK – Oct 2009

The impact of poor data in the UK Grocery Sector – UK Study findings in the Grocery sector

© 2008 GS1

Australia

30


UK findings (cont)

© 2008 GS1

Australia

31


UK findings (cont)

© 2008 GS1

Australia

32

What is Poor Data costing the UK Grocery Sector?

•Excerpt from the UK Data Crunch Report Executive Summary:

• We calculate that over the next five years UK retailers and suppliers will experience over £700 million profit erosion and £300 million in lost sales. These are conservative estimates based on the combination of process inefficiencies, duplications and workarounds across the retailer and supplier’s supply chains, together with administrative shrinkage and shelf stockouts that inaccurate data causes.

© 2008 GS1

Australia

33

GTIN, GLN, GPC code

Marketing: Brand, Sub-brand, Variant, Description

–long, short

Functional: Orderable, Despatch or Invoice,

Hierarchy Level

Physical: Product Dimensions, Weights (Net

and Gross)

Environmental & Dangerous Goods

Tax: GST (yes/no), Rate (Aus or NZ)

Dates: Effective, Start Availability, End Availability, First

Order, etc

Warranty: Description, Duration, Type (km or

month)Logistics: Order Multiples, Min Order qty, Pallet Details,

etc

Pricing: (trading partner specific) National, State, Direct to Store, DC etc,

Effective Date, End Date

Who uses your data?

© 2008 GS1

Australia

34

GTIN, GLN, GPC code


–long, short


Hierarchy Level


and Gross)




Order, etc



etc



Who uses your data?

Marketing

© 2008 GS1

Australia

35

GTIN, GLN, GPC code


–long, short


Hierarchy Level


and Gross)




Order, etc



etc



Who uses your data?

Marketing

Purchasing

© 2008 GS1

Australia

36

GTIN, GLN, GPC code


–long, short


Hierarchy Level


and Gross)




Order, etc



etc



Who uses your data?

Marketing

Purchasing

Warehouse, Transport

© 2008 GS1

Australia

37

GTIN, GLN, GPC code


–long, short


Hierarchy Level


and Gross)




Order, etc



etc



Who uses your data?

Marketing

Purchasing


Planning, Forecasting

© 2008 GS1

Australia

38

GTIN, GLN, GPC code


–long, short


Hierarchy Level


and Gross)




Order, etc



etc



Who uses your data?

Marketing

Purchasing



Costing

© 2008 GS1

Australia

39

GTIN, GLN, GPC code


–long, short


Hierarchy Level


and Gross)




Order, etc



etc



Who uses your data?

Marketing

Purchasing



CostingPurchasing

© 2008 GS1

Australia

40

GTIN, GLN, GPC code


–long, short


Hierarchy Level


and Gross)




Order, etc



etc



Who uses your data?

Marketing

Purchasing



CostingPurchasing

All depts

© 2008 GS1

Australia

41

GTIN, GLN, GPC code


–long, short


Hierarchy Level


and Gross)




Order, etc



etc



Who uses your data?

Marketing

Purchasing



CostingPurchasing

All depts

Warehouse

© 2008 GS1

Australia

42

Impact of Poor data and processes within the Supply Chain

Supplier Buyer

© 2008 GS1

Australia

43


1. Product Info sent

Errors in transposition

2. Product Info entered

Errors in TranslationErrors in Delivery / Transmission

Fax/ Mail/File transferIncorrectItem #sPricesDescQty

Supplier Buyer

© 2008 GS1

Australia

44







Supplier Buyer

3. Purchase Order

© 2008 GS1

Australia

45







Supplier Buyer

3. Purchase Order

4. Query Order Errors

© 2008 GS1

Australia

46







Supplier Buyer

3. Purchase Order

5. Adjusted Purchase Order


© 2008 GS1

Australia

47







Supplier Buyer6. Despatch Advice

3. Purchase Order



© 2008 GS1

Australia

48








3. Purchase Order

7. Goods Delivered + Invoice



© 2008 GS1

Australia

49








3. Purchase Order




8. Query Delivery Errors / Claim for credit

© 2008 GS1

Australia

50








3. Purchase Order





9. Return Incorrect Goods

© 2008 GS1

Australia

51








3. Purchase Order






10. Adjusted Delivery

© 2008 GS1

Australia

52








3. Purchase Order




11. Delayed Settlement



10. Adjusted Delivery

© 2008 GS1

Australia

53

Impact on Supply Chain with improved processes and data

Supplier

© 2008 GS1

Australia

54

1. PopulatesVendor GS1net

Catalogue


Supplier

© 2008 GS1

Australia

55


Catalogue

Buyer

2. Auto Updates


Supplier

© 2008 GS1

Australia

56


Catalogue

Buyer

2. Auto Updates

3. Purchase Order – Accurate & error free


Supplier

© 2008 GS1

Australia

57


Catalogue

Buyer

2. Auto Updates


4. Dispatch Advice / ASN – SSCC link to PO & GTINs


Supplier

© 2008 GS1

Australia

59


Catalogue

Buyer

2. Auto Updates



5. Physical Goods Flow – Marked with SSCC

6. Remittance Advice & Settlement


Supplier

© 2008 GS1

Australia

60

Supply Chains today

If data and processes are so bad, how is it that we do get products ordered, delivered and then paid?

Well, we throw people at the problem. We put them in accounts payable, receivable, customer service. We create new roles in Sales, Marketing, IT. We reward people for constant fire-fighting, and pride ourselves on our ability to adapt to change and our flexibility.Not only that, we employ people to update and manage your data as well.

© 2008 GS1

Australia

61

The technical solution – GS1net

• To assist organisations in sharing their product information with their trading partners, GS1 developed a solution called GS1net based on a set of rules and built on the GS1 Standards

• GS1net is the data synchronisation solution for Australia and New Zealand

• GS1net lets you enter, validate, store and maintain all your product, pricing and other related trade information in a single location

• You can then easily share this global standards-based information with the trading partners you work with, across all industry sectors, and even globally.

© 2008 GS1

Australia

62

What is Data Synchronisation?

•The continuous and automated exchange of standardised itemmaster data within and between organisations

© 2008 GS1

Australia

63

GS1net localRegistry

GS1net - Overview

Auto Updates TradingPartner A

Auto Updates TradingPartner B

Auto Updates TradingPartner C

GS1net Data Pool

GS1net D

ata Validation

Data Uploads

Vendor B Data Uploads

Vendor C Data Uploads

Vendor D Data Uploads

Vendor A

Search & Download Search & Download

GlobalRegistry

© 2008 GS1

Australia

65

GS1net Status as at 15th Aug 2010

• 1441 companies currently participating– 56 Buyers– 19 Search & Download– 1366 Suppliers / Manufacturers

• 340K+ Supplier Maintained GTINs

• 1106 Suppliers have loaded data in GS1net

• ~850 Suppliers are GS1net Ready ™

• ~500 Suppliers are GS1net Live ™

© 2008 GS1

Australia

70

GS1net in the Community

• Grocery• Coles – 477 Suppliers• Metcash – 179 Suppliers• Woolworths – beginning early 2011• Foodstuffs (NZ) - 45

• Hardware• Mitre 10 NZ – 42 Suppliers• Mitre 10 – Building M2M interface• John Danks & Son – 2 suppliers• ITM (NZ) – 2

• Health – 92 Suppliers• Office Products – Pilot completed• Consumer Electronics – Pilot planned early 2011

© 2008 GS1

Australia

71

The key to successful Data Synchronisation?

• Identify and appoint a Champion in your organisation to drive your data synchronisation project today and into the future

• Clearly defined your business processes for managing your master data

• Have the disciplines in place to follow the defined business process

• Understanding the uses and impacts that data can have on your trading relationships

© 2008 GS1

Australia

72

• Gain some internal support and appoint a champion

• Review your existing data management processes

• Get involved, learn about what you’re getting your business involved in

• Talk to others who have implemented data synchronisation

• Work out how much having quality data synchronised with your trading partners is worth to you

• Implement a Data Quality programme, not a Data Sync project

Where to from here?

© 2008 GS1

Australia

73

GS1net has gained the support of the Hardware GS1 Action Group, however don’t just focus on the tool, you need to review how you manage your data to ensure you maintain a

sustainable process

Final Thoughts

© 2008 GS1

Australia

74

Data Management and Synchronisation challenges current paradigms regarding data ownership

Final Thoughts

Questions?


Contact DetailsJohn SzaboIndustry ManagerGS1 AustraliaUnit 100/45 Gilby RoadMt Waverley VIC 3149T + 61 3 9550 3483M 0419 338 842W [email protected]


http://www.gs1au.org/�

mailto:[email protected]�

har data management

Documents

definitions of data

poor master data

product data management

publication of product

impact of poor data

inaccurate data causes

paperwork master data

poor master management