How ERNI Uses Data to Generate Value

Five practical case studies

Data on its own is meaningless. What matters is how the data you collect is analysed and evaluated, and which of your business processes and products can be improved through data.

ERNI helps many customers that are leaders in their industries. The most pervasive data trend that can be observed across all sectors is the collection of data focused on value (smart data), rather than sheer volume. You can sometimes stumble upon something meaningful or discover an occasional gem by drilling down into unstructured, large sets of data. However, some of the most successful data projects we’ve participated in do the exact opposite.

Data science initiatives can cover a very broad spectrum. At the lower end of expectations, you can simply aim to improve your processes in order to introduce fact-based and informed decision making to fuzzy areas. On the higher end of data science initiatives, you can kick-start major product innovations, introduce new business models and even venture into unchartered business territories and new industries (but ERNI makes sure you have a scalable and sustainable solution).

This article showcases some of the recent data projects we’ve worked on. For newcomers to data science, this is a useful starting point that will help you navigate the possibilities of data analysis or AI and cognitive services. For seasoned data practitioners, we aim to introduce expertise and inspire new ideas and projects and foster discussion.

Whatever your background, look at the value generation process as a whole and understand your data from the perspective of business processes and value chain management. This way, you’ll make sure every data point you collect actually matters. 

Prediction of air quality based on traffic

1. Prediction of Air Quality Based on Traffic

ERNI was asked to use current road traffic information in order to provide a weather station with predictions about air quality (particulate matter PM10).

The biggest issue was collecting up-to-date traffic data from a reliable source. Our team evaluated numerous approaches on how to separate road traffic from secondary data (e.g., delays, traffic jams or historic counts).

The information collected was combined to generate a local traffic rating. In order to establish a model that could predict air quality, we used tools such as Microsoft Azure Machine Learning and Google TensorFlow, along with pandas and Python.

Results: As a pilot study, this model accurately predicts air quality in a vicinity of 10 km and our cloud-hosted predictor facilitates simple integration into the weather station’s software or alternative applications.

Smart use of data

2. Operating 10 000 instruments around the world through smart use of data

Our customer sells analytic instruments to laboratories all over the world. Its customers expect no less than minimal downtime, proactive maintenance, flexible support and robust data security. Maintaining and operating close to 10 000 instruments worldwide is a highly demanding task for this customer. We assisted in building a state-of-the-art infrastructure for predictive maintenance and operational excellence.

 

1. Standardisation

In the beginning, we captured and standardised all worldwide maintenance processes to the widest extent possible.

 

2. Requirements engineering

The standardisation allowed us to derive concise requirements for a data collection platform that aggregates and centrally stores valuable data from instruments located all over the world.

 

3. Pilots

Several pilot studies on predictive maintenance were carried out to determine the most beneficial scenarios that would guarantee operational excellence and simplify our customers’ maintenance processes. A machine learning and artificial intelligence platform is being established as the next step. The platform will allow prompt local analysis of instruments and enable central processing using the complete data set.

predicting failures

3. Predicting failures in Semiconductor Manufacturing

The next customer is a global manufacturer of semiconductors. Its product, chips, are sent out in reels of 5 000 – 10 000 pieces, and if there are too many faulty pieces per production lot, the whole reel is rejected by the buyer. That can be a big issue for the manufacturer as the cost of the raw material is very high and the margin is low. On top of that, rejections are bad for a company’s reputation.

Error detection in semiconductor manufacturing is based on simple statistics. Our customer gave us the task of inspecting the results of the final tests carried out on individual chips to detect the lots/ reels with a high probability of rejection.

We began with a thorough analysis of available literature and with an assessment of data quality. The tight deadline meant we distributed the analysis among three international teams and synchronised them in an iterative and agile manner. Every week, they were to exchange problems and findings.

The teams made use of the different analytic tools and approaches. Some of the tools applied were Microsoft Azure Machine Learning Studio, Scala and Apache Spark, RapidMiner, KNIME and Dataiku. On the algorithmic side, we used simple statistics, k-means clustering, artificial neural networks, tree ensembles for classification and different types of anomaly detectors.

When the analysis was finished, we suggested to the customer a predictor for failing lots based on tree ensembles and a 1-SVM (one-class support vector machine) for anomaly detection. The predictor includes expert feedback and updates itself based on new data.

The following steps will include industrialisation and integration of the classifier and anomaly detector into the manufacturing engineering system, as well as using a more sophisticated analysis from earlier production steps for the detection of issues; this should be applied not only during the final test but also much earlier in production. Ultimately, this approach will reduce costs and save resources needed for testing.

performance optimisation for an IoT system

4. Performance Optimisation for an IoT System

The increasing connectedness of devices drives a manufacturer of ventilation systems to extend its proprietary bus system for its embedded actuators with Cloud access. The new system suffers from bad control performance and disturbances on the bus, which are neither reproducible nor able to be analysed.

The ERNI solution collects and evaluates (Python) 1 Mio. system values and bus telegrams for 20 systems daily. The data is filtered, reduced and stored in a time-series database (InfluxDB). Grafana is used as a flexible, powerful and user-friendly tool to visualise and correlate data as well as to define KPIs and set up alarms.

ERNI supported our customer in detecting error patterns and analysing suspicious trends. Ultimately, the bus performance could, in certain situations, be increased tenfold, the control algorithms became predictable and stable, and 90% of the known bus disturbances were eliminated.

Business Value Prediction

5. Business-Value Prediction

Our customer connects sellers and buyers of SMEs. In order to optimise its portfolio and marketing investments, it wants to predict the value and popularity of any given company.

ERNI carefully selected significant data from its complex database and cleaned and simplified historic data. The team used a model based on the Microsoft Azure Machine Learning platform to predict time-to-sale and selling price.

The results are visualised and integrated into a mobile app. This lean and easy-to-use app significantly helps the customer evaluate an offer quickly.

News from ERNI

In our newsroom, you find all our articles, blogs and series entries in one place.
Work in the innovation sphere gives me the chance to develop myself 23.05.2018.
Newsroom

Work in the innovation sphere gives me the chance to develop myself

Interns at ERNI series: Isabelle Rüthemann

>
I have greatly improved my vision and understanding of programming 22.05.2018.
Newsroom

I have greatly improved my vision and understanding of programming

Interns at ERNI series: Adrian Chiorean

>
ERNI gives us a space for our own dreams 11.05.2018.
Newsroom

ERNI gives us a space for our own dreams

Interns at ERNI series: Viera Maronová

>
How we have changed our visual language 09.05.2018.
Newsroom

How we have changed our visual language

A cyclist full of energy, a passionate painter,...

>
Stricter regulations on personal data even outside of health records GDPR 03.05.2018.
Newsroom

Stricter regulations on personal data even outside of health records GDPR

 The upcoming EU General Data Protection R...

>
ERNI and IoT projects 30.04.2018.
Newsroom

ERNI and IoT projects

Many of our customers’ data projects are subset...

>
Why it is important to work during your studies 27.04.2018.
Newsroom

Why it is important to work during your studies

Interns at ERNI series: Nikoleta Žišková

>
How ERNI Uses Data to Generate Value 24.04.2018.
Newsroom

How ERNI Uses Data to Generate Value

Five practical case studies

>
> All News

ERNI Schweiz

Casinoplatz 2

3011 Bern

Phone: +41 58 268 12 00

Email: [email protected]

ask

ERNI Suisse

Bâtiment L

Route des Acacias 43

1227 Geneva

Phone: +41 58 268 11 03

Email: [email protected]

ask

ERNI Suisse

Voie du Chariot 3

1003 Lausanne

Phone: +41 58 268 11 03

Email: [email protected]

ask

ERNI Schweiz

Geschäftshaus Airgate

Thurgauerstrasse 40

8050 Zürich

Phone: +41 58 268 12 00

Email: [email protected]

ask

ERNI Deutschland

Bettinastrasse 30

60325 Frankfurt am Main

Phone: +49 69 97 46 12 75

Email: [email protected]

ask

ERNI Deutschland

Design Offices München – Arnulfpark

Luise-Ullrich-Str. 20

80636 München

Phone: +49 89 55 06 28 208

Email: [email protected]

ask

ERNI España

Edificio El Triangle

Plaça Catalunya 1-4, 3º planta, Módulo A y B

08002 Barcelona

Phone: +34 93 667 77 76

Email: [email protected]

ask

ERNI España

Calle Alcalá 61

3rd floor

28014 Madrid

Phone: +34 91 794 46 06

Email: [email protected]

ask

ERNI Slovakia

Ševčenkova 34

851 01 Bratislava

Phone: +421 2 32 55 37 37

Email: [email protected]

ask

ERNI Philippines

9th Floor, 500 Shaw Zentrum Building

500 Shaw Boulevard

Mandaluyong City, Philippines 1555

Phone: +63 2 531 59 82

Email: [email protected]

ask

ERNI Singapore

3 Temasek Avenue

Centennial Tower #34-10

Singapore 039190

Phone: +65 9161 9863

Email: [email protected]

ask

ERNI Romania

Calea Dorobantilor no. 98-100

3rd floor, in Olimpia Business Center

400609 Cluj-Napoca

Phone: +40 744 319 228

Email: [email protected]

ask
comment
better ask
ERNI