Shell

Customer Case Study

Shell

Shell is a recognized pioneer in oil and gas exploration and production technology and one of America’s leading oil and natural gas producers, gasoline and natural gas marketers and petrochemical manufacturers.

Vertical Use Case

  • Inventory and Supply Chain Management

Technical Use Case

  • Ingest/ETL
  • Machine Learning

The Challenges

  • Disjointed Inventory Distribution: Stocking practices are often driven by a combination of vendor recommendations, prior operational experience and “gut feeling”.
  • Limited DSS Availability: There has been limited focus directed towards incorporating historical data and doing advanced analysis to come up with decisions.
  • Lost Business Agility: This can lead to excessive or insufficient stock being held at Shell’s locations, like oil rigs which has significant business implications.

The Solution

Databricks provides Shell with a cloud-native unified analytics platform that helps with improved inventory and supply chain management:

  • Databricks Runtime: The team to dramatically improved the performance of the simulations.
  • Interactive Workspace: The data science team is able to collaborate on the data and models via the interactive workspace.
  • Cluster Management: Significant reduction in total cost of ownership by moving to the Databricks cloud solution and gains in operational efficiency.
  • Automated Workflows: Using analytic workflow automation, Shell is easily able to build reliable and fast data pipelines that allow them to predictive when to purchase parts, how long to keep them, and where to place inventory items.

 

The Results

 

  • Predictive Modeling: Scalable predictive model is developed and deployed across more than 3,000 types of materials at 50+ locations.
  • Historical Analyses: Each material model involves simulating 10,000 Markov Chain Monte Carlo iterations to capture historical distribution of issues.
  • Massive Performance Gains: With a focus on improving performance the data science team reduced the inventory analysis and prediction time to 45 minutes from 48 hours on a 50 node Apache Spark™ cluster on Databricks — a 32X performance gain.
  • Reduced Expenditures: Cost savings equivalent to millions of dollars per year.

We were able to take a tool that previously would have been fairly localised to a single region and turn that into a global product which actually is now becoming the foundation for the way our inventory analysts will now do their work.

Daniel Jeavons, General Manager
Advanced Analytics CoE, Shell