p&g frankfurt big data lab 2018 data challenges · personal data - business use p&g support...
TRANSCRIPT
![Page 1: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/1.jpg)
Personal Data - Business Use
P&G – FRANKFURT BIG DATA LAB2018 DATA CHALLENGES
“Smart Logistics, Smart Supply Chain”
Norbert Wielens, DACH IT Leader
![Page 2: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/2.jpg)
Personal Data - Business Use
2018 DATA CHALLENGE – P&G CHALLENGES
Agenda:
• Who are we ? (Kristina)
• Prediction of Future Product Demand (Torben)
• Frankfurt Retail Landscape transformation (Roland)
• Data Analysis at P&G (Roland)
• Q&A
![Page 3: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/3.jpg)
Personal Data - Business Use
P&G SUPPORT TEAM
Send an email to [email protected] incl.• P&G Challenge Topic 1 or 2• Names• Question(s) / Request(s)• Proposed date for f2f meeting: Thu 14:00 – 16:00 or Fri 10:00 – 12:00• Your contact details, e.g. email address(es)
HOW TO CONTACT US ?
Dittmar Brinkmann Kristina Bulle
Jochen Famulla Torben Schäfer
Roland Toth Norbert Wielens
![Page 4: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/4.jpg)
Personal Data - Business Use
CHALLENGE 1: PREDICTION OF FUTURE PRODUCT DEMAND
This Photo by Unknown Author is licensed under CC BY-NC-SA
Torben Schäfer – Market Intelligence Leader
![Page 5: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/5.jpg)
Personal Data - Business Use
SELF-LEARNING ALGORITHMS IN FMCG
Offtake Analysis
Automatic Ordering Process
Optimized Inventory
Management
Allocation of products
Supply Chain Analytics
...
![Page 6: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/6.jpg)
Personal Data - Business Use
- 0.5 week
Retailer Order
SIMPLIFIED SUPPLY CHAIN TIMINGS
- 7 weeks -2 till -1 week
Material Supplier
P&G Plant P&G DC
Retailer
ShopDC
Shipment
+4 weeks
![Page 7: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/7.jpg)
Personal Data - Business Use
PROMOTION VOLATILITY
0
50.000
100.000
150.000
200.000
250.000
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49 51
Promo
Shelf
![Page 8: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/8.jpg)
Personal Data - Business Use
- 0.5 week- 6 weeks- 9 weeks
Shipment
Customer Order Process
CUSTOMER ORDER PROCESS VS. SUPPLY CHAIN TIMELINE
Sales: initial top line volume planning
Feature in store
First volume communication 0rder placement
on-going volume adjustment
driven e.g. sales offtake, inventory levels
+4 weeks
Order at Packaging Material Supplier
- 7 weeks
Production at P&G plant
P&G Distributíon Centre
-2 till -1 week
![Page 9: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/9.jpg)
Personal Data - Business Use
THE CHALLENGE: HOW CAN WE LEVERAGE HISTORICAL DATA AND
(SELF-IMPROVING) ALGORITHMS TO BETTER PREDICT FUTURE PRODUCT DEMAND?
• What are the relevant variables, e.g. past sales, promotions, seasonality, weather info, fashion trend … ?
• How to make the algorithm self-learning ?
![Page 10: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/10.jpg)
Personal Data - Business Use
AVAILABLE DATA FOR CHALLENGE
P&G DC Cust. DCDelivery date
CategoryProduct P&G
Order QtyDelivQty
Scaled value
P&G DC 5 Cust. DC 3 1/2/2015 A A.57 408 408 0.3
P&G DC 5 Cust. DC 3 1/2/2015 A A.25 2040 2040 1.6
P&G DC 1 Cust. DC 1 1/2/2015 C C.1 3456 3456 0.8
P&G DC 1 Cust. DC 1 1/2/2015 D D.1 7200 7200 15.1
P&G DC 1 Cust. DC 1 1/2/2015 C C.2 216 216 3.6
P&G DC 1 Cust. DC 1 1/2/2015 C C.3 4032 4032 0.7
P&G DC 1 Cust. DC 1 1/2/2015 F F.1 17820 0 2.1
Three years of data, with >150.000 data points with the following input:
![Page 11: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/11.jpg)
Personal Data - Business Use
ANY QUESTIONS?
![Page 12: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/12.jpg)
Personal Data - Business Use
CHALLENGE 2: FRANKFURT RETAIL LANDSCAPE TRANSFORMATION
![Page 13: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/13.jpg)
Personal Data - Business Use
CURRENT FRANKFURT DEMOGRAPHICS
500+ features for Frankfurt neighborhoods (~250 households each):• population density
• age groups
• purchasing power
• unemployment
• consumers type
• ethnicity
• religion
• buildings
• industry employment
• consumer behavior
• shopping behavior
![Page 14: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/14.jpg)
Personal Data - Business Use
CURRENT FRANKFURT RETAIL LANDSCAPE
Store locations (all supermarket, drug,
discounter etc. chains) + trading areas
![Page 15: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/15.jpg)
Personal Data - Business Use
THE CHALLENGE: HOW SHOULD THE RETAIL LANDSCAPE TRANSFORM ITSELF TO BETTER
SERVE CONSUMER DEMAND IN FRANKFURT?
• Are shopper needs currently being met?
• How should offline and online shopping offerings evolve to meet the ever-changing shopper demands?
![Page 16: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/16.jpg)
Personal Data - Business Use
DATA & ANALYTICS AT P&G
![Page 17: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/17.jpg)
Personal Data - Business Use
Goethe University Frankfurt
April 27th 2018
![Page 18: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/18.jpg)
Personal Data - Business Use
IT
IT IS A CORE OF P&G BUSINESS
R&D
Product Supply
Brand ManagementSales
Finance
Manufacturing
![Page 19: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/19.jpg)
Personal Data - Business Use
IT Skills
Infrastructure
Skills
IT Foundational Skills:IT Project Management, IT Operations & Enterprise Architecture
Application &
Integration Skills
IT Security &
Risk SkillsData & Analytics
Skills
![Page 20: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/20.jpg)
Personal Data - Business Use
Market data
Data & Analytics
Shopper data
Sales data from stores
Digital consumer data
Supply chain data
![Page 21: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/21.jpg)
Personal Data - Business Use
THE CORE OF EACH ANALYSIS IS THE BALANCE OF BUSINESS UNDERSTANDING & TECHNICAL MASTERY
Data analyst role
Activator
Trusted Advisor
Storyteller Researcher
Data Hacker
Business-savvy
Coder
(Big) Data Analyst skills
Technical-master
“Great talk, but do we need an IT analyst?”
business understanding technical mastery
“Cool analysis but… what does it mean?”
![Page 22: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/22.jpg)
Personal Data - Business Use
Q&A
![Page 23: P&G FRANKFURT BIG DATA LAB 2018 DATA CHALLENGES · Personal Data - Business Use P&G SUPPORT TEAM Send an email to pg2018challenge.im@pg.com incl. •P&G Challenge Topic 1 or 2 •Names](https://reader034.vdocuments.us/reader034/viewer/2022042404/5f1887c226546d28861b060b/html5/thumbnails/23.jpg)
Personal Data - Business Use
THANKS SO MUCH FOR YOUR INTEREST AND ENGAGEMENT !!
HAVE FUN WITH OUR CHALLENGES !!
WE ARE LOOKING FORWARD TO WORKING WITH YOU !!