20% fewer complaints thanks to data-driven maintenance reports

Otis

  • Customer case
  • Data projects
  • Data Engineering
  • Data Science
elevator
Otis logo
Reimer-business-manager
Reimer van de Pol
Business Manager
3 min
23 Nov 2023

An essential part of Otis's business operations is the maintenance of their elevators. To time this effectively and proactively inform customers about the status of their elevator, Otis wanted to implement continuous monitoring. They saw great potential in predictive maintenance and remote maintenance.

Otis elevators are equipped with a large number of sensors that measure, among other things, whether the doors close properly and which alarm codes are sent. They also collect statistics such as the number of kilometers an elevator travels per month and how often the doors reopen. Otis asked us to develop a data model that generates a 'health value' for each elevator, indicating how well the elevator is functioning.

Approach

We initiated the development of the data model based on Otis's existing on-premise infrastructure.

  • We combined sensor, alarm, and statistical data, ensuring data usability by cleaning up everything. The various types of data had varying definitions, values, and units. Using Python code, we transformed everything into monthly data and aligned the definitions.
  • Subsequently, we programmed the data model based on time series. The model compares the current values of an elevator with its past and with the values of other elevators.
  • Detected deviations are automatically converted into a numerical value we call the 'health value.' These health values are calculated for both individual components and the elevator as a whole.
  • Based on the health values, elevators are marked as 'green' or 'yellow' using a threshold. 'Green' elevators are functioning properly, while a 'yellow' score may indicate the need for maintenance.
  • The health values are checked by a Remote Engineer, who then instructs the maintenance technician with specific actions. The qualitative feedback from the Remote Engineer and the maintenance technicians, along with our analyses, is used to improve the model.

Although our model functioned as Otis desired, the next step in the process was to automate the data model and migrate it to the cloud. We restructured the data model within Azure using Databricks and PySpark. Data input and export were facilitated through Azure Data Factory pipelines, and stored within Storage Accounts managed by Otis. The model's output was returned via this pathway to the central database of Otis Netherlands, where it is accessible to the Remote Engineer.

Result

Twice a month, Otis receives an overview of the health values per elevator. This allows Otis to track which elevators may require maintenance. Customers receive an automatic maintenance report monthly, and Otis technicians address this during the next scheduled service. Due to this new approach, customer complaints have decreased by 20%.

The data model is operational, and the surrounding process is fully automated. Otis can now independently work with it and is not reliant on our expertise for the model's functioning.

Future

Otis elevators incorporate even more sensors and alarms than previously utilised. With this data, we can further enhance the model. Additionally, we aim to explore which components have more or less influence on the elevator's status. We will achieve this by incorporating scores, influenced by technician feedback, into the various types of data within the model.

Want to know more?

Reimer will be happy to talk to you about what we can do for you and your organisation as a data partner.

Receive data insights, use cases and behind-the-scenes peeks once a month?


Sign up for our email list and stay 'up to data':

You might find this interesting too

potatoes

Valuable insights from Microsoft Dynamics 365

Agrico is a cooperative of potato growers. They cultivate potatoes for various purposes such as consumption and planting future crops. These potatoes are exported worldwide through various subsidiaries. All logistical and operational data is stored in their ERP system, Microsoft Dynamics 365. Due to the complexity of this system with its many features, the data is not suitable for direct use in reporting. Agrico asked us to help make their ERP data understandable and develop clear reports.

Read more
dutch highway

Reliable reporting using robust Python code

The National Road Traffic Data Portal (NDW) is a valuable resource for municipalities, provinces, and the national government to gain insight into traffic flows and improve infrastructure efficiency.

Read more
business managers having a conversation

Insight into the complete sales funnel thanks to a data warehouse with dbt

Our consultants log the assignments they take on for our clients in our ERP system AFAS. In our CRM system HubSpot, we can see all the information relevant before signing a collaboration agreement. When we close a deal, all the information from HubSpot automatically transfers to AFAS. So, HubSpot is mainly used for the process before entering a collaboration, while AFAS is used for the subsequent phase. To tighten our people's planning and improve our financial forecasts, we decided to set up a data warehouse to integrate data from both data sources.

Read more
woman shopping online

A standardised way of processing data using dbt

One of the largest online shops in the Netherlands wanted to develop a standardised way of data processing within one of its data teams. All data was stored in the scalable cloud data warehouse Google BigQuery. Large amounts of data were available within this platform regarding orders, products, marketing, returns, customer cases and partners.

Read more
valk exclusief

Setting up a future-proof data infrastructure

Valk Exclusief is a chain of 4-star+ hotels with 43 hotels in the Netherlands. The hotel chain wants to offer guests a personal experience, both in the hotel and online.

Read more

A fully automated data import pipeline

Stichting Donateursbelangen aims to strengthen trust between donors and charities. They believe that that trust is based on collecting money honestly, openly, transparently and respectfully. At the same time effectively using the raised donation funds to make an impact. To further this goal, Stichting Donateursbelangen wants to share information about charities with donors through their own search engine.

Read more
data platform

A scalable data platform in Azure

TM Forum, an alliance of over 850 global companies, engaged our company as a data partner to identify and solve data-related challenges.

Read more
garden

Determining the location of gardens using Data Science

Residential investor Vesteda is working on a new website. If an available rental home has a garden, the location of the garden must be listed on the webpage of that home. This information was not yet available in the database. We were instructed to determine the location of the garden based on the coordinates of the homes.

Read more