Click here to close now.

SYS-CON MEDIA Authors: Carmen Gonzalez, Liz McMillan, Pat Romanski, AppDynamics Blog, Roger Strukhoff

Blog Feed Post

Tesco uses data for more than just loyalty cards

Tesco. Poster-child of the data-driven retail experience, thanks to its loyalty card and early work with DunnHumby. But Tom Hebbert didn’t talk about that. Instead, he focused on their supply chain work.

Rough notes from the session follow.

Big Data projects deliver huge returns at Tesco; improving promotions to ensure 30% fewer gaps on shelves, predicting the weather and behaviour to deliver £6million less food wastage in the summer, £50million less stock in warehouses, optimising store operations to give £30million less wastage.

Tesco – 2,979 stores, 30,000+ products in a big store, 23 depots in the UK, 50million cases delivered into stores each week, 16million of which contain perishable foodstuffs.

Weather

A ten degree rise in temperature means 300% more barbeque meat. 45% more lettuce. 50% more coleslaw, 25% fewer sprouts.

But weather is not straightforward, and it is very localised. It also has different effects dependent upon the day of the week, and the location. A city-centre store will see an uplift in sandwiches (to eat outside) on a warm weekday… and almost no effect at all on a warm weekend.

And basic facts around temperature, sunshine etc don’t tell the whole story. A 16 degree sunny Saturday in late April will cause a spike. Exactly the same figures a couple of weeks later will not, as people have had their first BBQ of the season already… Complicated stuff.

Tesco gets weather forecasts three times per day, and updates the store forecast for 18million items three times per day. Data is freely and immediately stored with suppliers using a web-based system called TescoConnect.

Depot Stockholding

Largest depots hold around 12,000 products from 700 suppliers. Regional depots hold over 5,000 products from over 200 suppliers. Different suppliers deliver stock with different lead times and at different rates and volumes.

Some suppliers can supply in hours, others in days… or weeks.

Economic order quantities… cost of ordering decreases as order volumes rise. Textbook way to manage and order stock. But… Tesco and its suppliers are really dealing with a single item. They order lots of different things from Nestle, with different variables at play. Understand the range of products you’re interested in, and group/order/hold accordingly.

Tesco runs a full simulation of all their stores and all their depots. They can play back exactly how stock moved historically, and optimise for future situations. They do it in Matlab, running on desktops ??? Takes 3 days to run the simulation. Largely responsible for freeing up £50million in working capital.

Reducing waste in stores

Tesco sells half a billion reduced-price products every year, as they approach sell-by dates. In fresh food, 3% of volume must be reduced as it reaches sell-by dates.

Some products are more price elastic than others, and Tesco models to understand exactly when and by how much they need to reduce in order to ensure stock shifts. Cream cakes show the biggest sales uplift with the smallest price drop, so psychology important too.

Project delivered £30million ‘in pure profit’ by discounting prices more intelligently – not going for a big price cut too early.

Image of a Tesco store by Flickr user Gordon Joly.

Read the original blog entry...

More Stories By Paul Miller

Paul Miller works at the interface between the worlds of Cloud Computing and the Semantic Web, providing the insights that enable you to exploit the next wave as we approach the World Wide Database.

He blogs at www.cloudofdata.com.

Latest Stories
How do you securely enable access to your applications in AWS without exposing any attack surfaces? The answer is usually very complicated because application environments morph over time in response to growing requirements from your employee base, your partners and your customers. In his session at 16th Cloud Expo, Haseeb Budhani, CEO and Co-founder of Soha, will share five common approaches that DevOps teams follow to secure access to applications deployed in AWS, Azure, etc., and the frict...
While DevOps most critically and famously fosters collaboration, communication, and integration through cultural change, culture is more of an output than an input. In order to actively drive cultural evolution, organizations must make substantial organizational and process changes, and adopt new technologies, to encourage a DevOps culture. Moderated by Andi Mann, panelists will discuss how to balance these three pillars of DevOps, where to focus attention (and resources), where organizations m...
SYS-CON Events announced today that CodeFutures, a leading supplier of database performance tools, has been named a “Sponsor” of SYS-CON's 16th International Cloud Expo®, which will take place on June 9–11, 2015, at the Javits Center in New York, NY. CodeFutures is an independent software vendor focused on providing tools that deliver database performance tools that increase productivity during database development and increase database performance and scalability during production.
SYS-CON Events announced today the IoT Bootcamp – Jumpstart Your IoT Strategy, being held June 9–10, 2015, in conjunction with 16th Cloud Expo and Internet of @ThingsExpo at the Javits Center in New York City. This is your chance to jumpstart your IoT strategy. Combined with real-world scenarios and use cases, the IoT Bootcamp is not just based on presentations but includes hands-on demos and walkthroughs. We will introduce you to a variety of Do-It-Yourself IoT platforms including Arduino, Ras...
Internet of Things (IoT) will be a hybrid ecosystem of diverse devices and sensors collaborating with operational and enterprise systems to create the next big application. In their session at @ThingsExpo, Bramh Gupta, founder and CEO of robomq.io, and Fred Yatzeck, principal architect leading product development at robomq.io, will discuss how choosing the right middleware and integration strategy from the get-go will enable IoT solution developers to adapt and grow with the industry, while at...
SYS-CON Events announced today that Column Technologies, a global technology solutions company, will exhibit at SYS-CON's DevOps Summit 2015 New York, which will take place June 9-11, 2015, at the Javits Center in New York City, NY. Established in 1998, Column Technologies is a leader in application performance and infrastructure management for commercial and federal markets. The company is headquartered in the United States, with a diverse and talented team of more than 350 employees around th...
The only place to be June 9-11 is Cloud Expo & @ThingsExpo 2015 East at the Javits Center in New York City. Join us there as delegates from all over the world come to listen to and engage with speakers & sponsors from the leading Cloud Computing, IoT & Big Data companies. Cloud Expo & @ThingsExpo are the leading events covering the booming market of Cloud Computing, IoT & Big Data for the enterprise. Speakers from all over the world will be hand-picked for their ability to explore the economic...
Deploying and operating cloud technology is difficult and falls outside the core competencies of most organizations. As a result, many on-premises private cloud installations falter, casting doubt on private cloud as a solution in general. Yet private clouds come with a unique set of benefits that continue to drive widespread interest. There must be a better way. This session will give participants a clear roadmap of private cloud implementation challenges and offer actionable ideas for...
Database apps on mobile devices shouldn't stop working when there's limited or no network connectivity. In his session at 16th Cloud Expo, Bradley Holt, a Developer Advocate for IBM Cloudant, will discuss how to bring data stored in a cloud database to the edge of the network (and back again), whenever an Internet connection is available. He will demonstrate techniques for replicating cloud databases with mobile devices in order to build offline-enabled mobile apps that can provide a better,...
SYS-CON Events announced today that the DevOps Institute has been named “Association Sponsor” of SYS-CON's DevOps Summit, which will take place on June 9–11, 2015, at the Javits Center in New York City, NY. The DevOps Institute provides enterprise level training and certification. Working with thought leaders from the DevOps community, the IT Service Management field and the IT training market, the DevOps Institute is setting the standard in quality for DevOps education and training.
Buzzword alert: Microservices and IoT at a DevOps conference? What could possibly go wrong? Join this panel of experts as they peel away the buzz and discuss the important architectural principles behind implementing IoT solutions for the enterprise. As remote IoT devices and sensors become increasingly intelligent, they become part of our distributed cloud environment, and we must architect and code accordingly. At the very least, you’ll have no problem filling in your buzzword bingo cards.
IoT is still a vague buzzword for many people. In his session at @ThingsExpo, Mike Kavis, Vice President & Principal Cloud Architect at Cloud Technology Partners, discussed the business value of IoT that goes far beyond the general public's perception that IoT is all about wearables and home consumer services. He also discussed how IoT is perceived by investors and how venture capitalist access this space. Other topics discussed were barriers to success, what is new, what is old, and what th...
Docker, Inc., has been included in the list of "Cool Vendors" in the April 21, 2015 report by Gartner, Inc, Cool Vendors in DevOps, 2015. In the report, Gartner notes, “As virtualization and cloud applications grow beyond being single images run on premise to being comprised of multiple tiers that can be run and scaled in a hybrid cloud, new approaches are needed to reduce complexity.” “Docker has gained great traction within the developer community for how efficient it makes the individual de...
SOA Software has changed its name to Akana. With roots in Web Services and SOA Governance, Akana has established itself as a leader in API Management and is expanding into cloud integration as an alternative to the traditional heavyweight enterprise service bus (ESB). The company recently announced that it achieved more than 90% year-over-year growth. As Akana, the company now addresses the evolution and diversification of SOA, unifying security, management, and DevOps across SOA, APIs, microser...
SYS-CON Events announced today that Creative Business Solutions will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. Creative Business Solutions is the top stocking authorized HP Renew Distributor in the U.S. Based out of Long Island, NY, Creative Business Solutions offers a one-stop shop for a diverse range of products including Proliant, Blade and Industry Standard Servers, Networking, Server Options and...