Grip's Smart Shipping Solutions through Databricks Lakehouse
Technology Category
- Analytics & Modeling - Machine Learning
- Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries
- Consumer Goods
- Transportation
Applicable Functions
- Logistics & Transportation
- Maintenance
Use Cases
- Last Mile Delivery
- Transportation Simulation
Services
- Data Science Services
About The Customer
Grip is a data-driven company that provides smart shipping solutions to e-commerce businesses shipping perishable goods across the U.S. The company processes hundreds of thousands of orders through its platform each month, serving companies that ship meal kits, frozen bread and pasta, pastries, pet food, flowers, and other perishable items. Grip's platform integrates with various data sources, including Shopify, ShipStation, different warehouse management systems, APIs for weather data, carrier pricing and delivery time tracking, and customer support systems like Zendesk and Dynamics. The company uses this data to make the most effective shipping recommendations, helping its customers reduce damage rates and shipping costs.
The Challenge
Grip, a company that serves e-commerce businesses shipping perishable goods across the U.S., processes hundreds of thousands of orders through its platform each month. The company's challenge was to process and interpret a variety of data points to make the most effective shipping recommendations. The data came from multiple sources including Shopify, ShipStation, different warehouse management systems, APIs for weather data, carrier pricing and delivery time tracking, and customer support systems like Zendesk and Dynamics. The company needed to consolidate this data to suggest the best carrier, ideal refrigerant and insulation, packaging and material, and other shipping logistics. Additionally, once a delivery was made, Grip needed to publish analytics so customers could see orders that went out, where they went, areas of the country that are bottlenecked, and areas of the country that are performing well.
The Solution
Grip adopted the Databricks Lakehouse Platform to consolidate and process its data. The platform integrates with weather providers, so forecasting is processed through the platform. It also tracks customer feedback, including previous records of shipments to a particular area of the country. Databricks allows Grip to build machine learning models and data engineering pipelines end to end, serve end users with analytics, and track internal analytics all within one platform. Grip’s pipelines are entirely orchestrated through Databricks Workflows, which makes troubleshooting easy when something goes wrong. The alerting integration is tied into the company’s teams, so they can rerun or repair run functionality before it becomes problematic to the customer. Grip also uses Databricks SQL Serverless to drive analytics, which allows it to share data with customers more regularly.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
.png)
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Airport SCADA Systems Improve Service Levels
Modern airports are one of the busiest environments on Earth and rely on process automation equipment to ensure service operators achieve their KPIs. Increasingly airport SCADA systems are being used to control all aspects of the operation and associated facilities. This is because unplanned system downtime can cost dearly, both in terms of reduced revenues and the associated loss of customer satisfaction due to inevitable travel inconvenience and disruption.
Case Study
IoT-based Fleet Intelligence Innovation
Speed to market is precious for DRVR, a rapidly growing start-up company. With a business model dependent on reliable mobile data, managers were spending their lives trying to negotiate data roaming deals with mobile network operators in different countries. And, even then, service quality was a constant concern.
Case Study
Digitize Railway with Deutsche Bahn
To reduce maintenance costs and delay-causing failures for Deutsche Bahn. They need manual measurements by a position measurement system based on custom-made MEMS sensor clusters, which allow autonomous and continuous monitoring with wireless data transmission and long battery. They were looking for data pre-processing solution in the sensor and machine learning algorithms in the cloud so as to detect critical wear.
Case Study
Cold Chain Transportation and Refrigerated Fleet Management System
1) Create a digital connected transportation solution to retrofit cold chain trailers with real-time tracking and controls. 2) Prevent multi-million dollar losses due to theft or spoilage. 3) Deliver a digital chain-of-custody solution for door to door load monitoring and security. 4) Provide a trusted multi-fleet solution in a single application with granular data and access controls.
