Prologis Leverages the Denodo Platform and Snowflake to Modernize and Accelerate Analytics
Customer Company Size
Large Corporate
Region
- America
- Europe
- Asia
Country
- United States
- Worldwide
Product
- Denodo Platform
- Snowflake cloud-based data warehouse
Tech Stack
- Data Virtualization
- Cloud Computing
- Data Warehousing
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Digital Expertise
Technology Category
- Infrastructure as a Service (IaaS) - Cloud Computing
- Infrastructure as a Service (IaaS) - Cloud Storage Services
- Analytics & Modeling - Real Time Analytics
Applicable Functions
- Business Operation
Use Cases
- Real-Time Location System (RTLS)
- Predictive Quality Analytics
Services
- Cloud Planning, Design & Implementation Services
- Data Science Services
About The Customer
Prologis is a global leader in logistics real estate solutions. Founded in 1983, the company has 1,600 employees in 19 countries and manages over $111 billion in assets, representing over 797 million square feet across these countries. Prologis collaborates with customers to achieve operational efficiencies, reduce environmental impacts, and improve communities. The company's vast portfolio of real estate assets generates a staggering amount of data every day, which needs to be integrated effectively for the company to operate its business.
The Challenge
Prologis, a global real estate asset management company, was struggling with its data management system. The company's data was stored in a variety of languages and dispersed across different geographical locations. The existing system was an on-premises data warehouse comprised of 27 servers supporting a series of databases, integration servers, and reporting servers. The system was becoming outdated and inefficient, with ETL scripts needing to be rewritten and re-tested whenever there was a change in the source environment. Migrations were all-day events that required the entire team, and with every test, a complete regression test of the entire stack was needed to ensure that nothing broke. Prologis wanted to modernize its data infrastructure to include cloud capabilities and introduce efficiencies that would accelerate analytics, without causing undue downtime.
The Solution
To modernize its data infrastructure, Prologis implemented a Snowflake cloud-based data warehouse alongside its existing on-premises data warehouse. Snowflake's ability to scale on demand based on the query being run and accommodate both structured and semi-structured data made it an ideal choice. To further enhance its data infrastructure, Prologis leveraged the Denodo Platform, which uses data virtualization to integrate data in real time from myriad disparate data sources without replicating data to a new consolidated repository. The Denodo Platform acts as an intelligent data-access layer between data sources and data consumers, abstracting data consumers from the complexities of access. This enabled Prologis to establish a logical data warehouse architecture that provides real-time access to data across on-premises, cloud, and other sources. The Denodo Platform's data catalog lists all available data assets in a single location, and also delivers the listed data on-demand. Using this catalog, Prologis was able to implement a higher level of diligence in data management, providing standard definitions for every column and every view, as well as detailed documentation for every object.
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.
Case Study
Leading Tools Manufacturer Transforms Operations with IoT
Stanley Black & Decker required transparency of real-time overall equipment effectiveness and line productivity to reduce production line change over time.The goal was to to improve production to schedule, reduce actual labor costs and understanding the effects of shift changes and resource shifts from line to line.
Case Study
IoT Data Analytics Case Study - Packaging Films Manufacturer
The company manufactures packaging films on made to order or configure to order basis. Every order has a different set of requirements from the product characteristics perspective and hence requires machine’s settings to be adjusted accordingly. If the film quality does not meet the required standards, the degraded quality impacts customer delivery causes customer dissatisfaction and results in lower margins. The biggest challenge was to identify the real root cause and devise a remedy for that.
Case Study
Jaguar Land Rover Speeds Order-to-Cash Cycle
At Jaguar Land Rover, vehicles physically move around the facility for testing, configuration setting, rework and rectification, leading to a longer search time to get each vehicle to its next process facility. The main goal is to minimize the vehicles' dwell time between end of line and the delivery chain which was previously a manually intensive process. Jaguar Land Rover's goal was to build on the success of an earlier RFID project and improve the efficiency of delivering vehicles to meet dealer orders.
Case Study
Improve Postal Mail and Package Delivery Company Efficiency and Service
Postal mail and package delivery company wanted to replace legacy yard management system, increase inbound and outbound yard velocity, improve priority parcel delivery time and accuracy, reduce workload and overtime, reduce driver detention and measure performance and utilization of yard resources.
Case Study
Hospital Management Solution
The Oncology Diagnosis and Treatment Center of Brasov wanted to give patients as much freedom to roam as possible, while at the same time ensuring optimal patient safety and security. The centre was in need of an adequate wireless voice communication and messaging solution that would give patients the confi dence that medical staff is always on call, and reduce stress levels of nurses and doctors when called in case of urgent need.
Case Study
Worker Tracking & Safety Monitoring in Construction
One of the main challenges facing the technology was to create a network within underground tunnels and another was to provide products that can withstand harsh working environment. The team used amplifiers to enhance bandwidth and Litum produced IP67-rated hardware that is durable for harsh working conditions.
