20130123 ontwikkeling-1545-bol-com-menno-vis
-
Upload
webwinkelvakdag -
Category
Documents
-
view
860 -
download
1
description
Transcript of 20130123 ontwikkeling-1545-bol-com-menno-vis
![Page 1: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/1.jpg)
Sterke groei van bol.com mogelijk gemaakt door
Master Data Management (MDM)
Menno VisManager IT
Software Development
![Page 3: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/3.jpg)
bol.com• Since 30 March, 1999• Now over 3.4 million
active customers • 17.5 million products in
2011• NL & B• One of the most popular
stores• Many prices awarded • Ahold
![Page 4: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/4.jpg)
Sometime early 2010…
– The completeness and correctness of our product data had to be improved
– The time and effort required to add content information from new suppliers should be decreased
– A need for a stable and robust platform
– A need for flexible and scalable processes and tools
![Page 5: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/5.jpg)
2010 New Catalogue Project
Start working with…
![Page 6: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/6.jpg)
Objectives of NCA
• Scalability (to be able to manage >25M products)
• Improve onboarding suppliers
• Enhance content data quality by advanced technology
• Provide (much) more functionality needed on short or long term
• Higher level of automation
![Page 7: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/7.jpg)
High amounts complexity10M+ (growing to 25M)
Average no. of attributes per product: 250+ (and max 1000)
100+ automated supplier connections
50+ users
10+ product groups
![Page 8: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/8.jpg)
TalendETL
STEPProduct & Content
POSOffersysteem
Pricing & availability
DHPCDatahub
WSPWebshop
Supplier A
Supplier B
Supplier C
Supplier D
![Page 9: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/9.jpg)
STEP is key component
![Page 10: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/10.jpg)
MDM for bol.com
STEP 5.2Import Mgr / Data
Quality
MMP / Manual
Activities
Exports to Other
Systems
![Page 11: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/11.jpg)
Characteristics of [email protected]
• STEP (by Stibo Systems) is the content system for bol.com
• Most content is provided by many suppliers in a fixed format. This is loaded automatically into STEP as supplier data.
• The supplier data is automatically translated and transformed into – for bol.com – relevant information: bol.com content.• Match; Make; Promote
• Bol.com content can/will also be enhanced manually. Wizards are created to support this.
• The bol.com content is hence the 'best' content (“Master Data”)
![Page 12: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/12.jpg)
12
Many Suppliers
Import Mgr / Data Quality
Retrieve Data (via FTP)
Process Data (via Talend)
STEP Import Manager
STEP Data Quality Module
Supplier Product Info; ready for MMP
![Page 13: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/13.jpg)
Match and Make first step of MMP
Match & Make
Step 1
Promote Approve
MMP is required to transform supplier data into bol.com content.
• The process starts with Match & Make
![Page 14: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/14.jpg)
Promotion is the second step of MMP
Match & Make Promote Approve
Step 1 Step 2
• The process starts with Match & Make• Afterwards the promotion process is initiated
![Page 15: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/15.jpg)
Match, Make & Promote in 3 sub steps
Match & Make Promote Approve
Step 1 Step 2 Step 3
• The process starts with Match & Make• Afterwards the promotion process is initiated• It ends up with an approval of the object(s)
Now we have the ‘golden bol.com product’ (Master Data)
![Page 16: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/16.jpg)
Manual activities•Next to the automated processes we can also enhance the data manually.
• Splitting and merging wizards have been developed to support all business rules
![Page 17: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/17.jpg)
Results
• Time reduced for adding a new product category
• Time reduced for adding (new) automated supplier content
• Increased fulfillment rates • Less order cancellations • Improvements to bol.com Plaza
(marketplace) made possible
![Page 18: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/18.jpg)
The future
• We are finishing the implementation of STEP MDM for all other remaining product groups
• We will work on templates, standards and other tools to automate product information management further
• We will continue to grow the STEP MDM solution and enhance the data model further.
• bol.com will continue to invest in the relationship with Stibo Systems in order to have our requirements included in new releases of STEP MDM
![Page 19: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/19.jpg)
ConclusionThe MDM journey doesn’t stop.
Growth leads to new challenges.
STEP by Stibo Systems will help us to make this journey.
![Page 20: 20130123 ontwikkeling-1545-bol-com-menno-vis](https://reader035.fdocument.pub/reader035/viewer/2022062615/548697bab479590f0d8b51f4/html5/thumbnails/20.jpg)
Thank you