Dashboarding at CLEPA

Dashboarding at CLEPA

Analytics & Optimisation

User Experience

The client

CLEPA is the voice of European automotive suppliers. They represent over 3.000 companies, which employ 5.000.000 employees. By conducting extensive research, CLEPA helps shaping the decision-making process of EU institutions and UN authorities to achieve safe, smart and sustainable mobility. With plenty of different studies and data to communicate, we were excited to help visualize CLEPA’s insights into dynamic data dashboards.

The goal

The goal of this project was to communicate CLEPA’s story and corresponding research data in a clear and visual way to their audiences. From policy makers to internal CLEPA members, the different scenarios and figures on the employment impact of transitions in the automotive sector should be understandable when looking at the dashboards. Additionally, another objective was to make the data in the dashboards dynamic and interactive, with the opportunity to see both positive and negative scenarios.

The goal of this project was to communicate CLEPA’s story and corresponding research data in a clear and visual way to their audiences. From policy makers to internal CLEPA members, the different scenarios and figures on the employment impact of transitions in the automotive sector should be understandable when looking at the dashboards. Additionally, another objective was to make the data in the dashboards dynamic and interactive, with the opportunity to see both positive and negative scenarios.

The goal of this project was to communicate CLEPA’s story and corresponding research data in a clear and visual way to their audiences. From policy makers to internal CLEPA members, the different scenarios and figures on the employment impact of transitions in the automotive sector should be understandable when looking at the dashboards. Additionally, another objective was to make the data in the dashboards dynamic and interactive, with the opportunity to see both positive and negative scenarios.

What we did

Workshop to align business and user needs

Data reporting using Google Data Studio

Visualization of multiple icons and graphic elements

Our approach

At the start of the project, we received a wide variety of data and information to familiarize with the topic and goals of CLEPA. To structure this information and make sure we were on the same page, we did a workshop to align business and user needs for the dashboards. Questions that were answered during this session included:

  • Who are the consumers of the data?

  • What insights are the users expect to get from the data?

  • When are the data visualizations a success?

The input of this alignment meeting provided the information we needed to kick-off the project. We got the ball rolling by creating the first design proposals for the dashboards, while also analyzing and cleaning the data to connect it to Google Data Studio (the tool we used to create the dashboards). Pairing a designer and data analyst to work in parallel, really elevated the dashboards from the very start. We soon had a ‘prototype’ in Data Studio to share that we could further develop.

The first proposed designs were based on analysis of the CLEPA website, documents we received previously and the input from the workshop. Each design featured a different presentation and visual style. After some feedback, we were able to determine the dashboards’ look & feel. A combination of graphical elements was discussed, with a focus on storytelling to guide the user through the data and the message it supports.

Next to the designs was the processing of the data. From the start of the project, the goal was to establish a dynamic data setup that allows CLEPA to simply adjust or add any data to the dashboards. As we were working with research data and studies, the most solid way to connect to Data Studio was by using Google Sheets. We made sure every tab is built as a template to easily update any data or scenarios. Updating data in Google Sheets = data available in the Data Studio dashboards. This makes showing the latest data in the dashboards easy to maintain. In addition, we applied interactions and filters to certain graphs in the dashboard, so users can engage and dig deeper into the data.

The input of this alignment meeting provided the information we needed to kick-off the project. We got the ball rolling by creating the first design proposals for the dashboards, while also analyzing and cleaning the data to connect it to Google Data Studio (the tool we used to create the dashboards). Pairing a designer and data analyst to work in parallel, really elevated the dashboards from the very start. We soon had a ‘prototype’ in Data Studio to share that we could further develop.

The first proposed designs were based on analysis of the CLEPA website, documents we received previously and the input from the workshop. Each design featured a different presentation and visual style. After some feedback, we were able to determine the dashboards’ look & feel. A combination of graphical elements was discussed, with a focus on storytelling to guide the user through the data and the message it supports.

Next to the designs was the processing of the data. From the start of the project, the goal was to establish a dynamic data setup that allows CLEPA to simply adjust or add any data to the dashboards. As we were working with research data and studies, the most solid way to connect to Data Studio was by using Google Sheets. We made sure every tab is built as a template to easily update any data or scenarios. Updating data in Google Sheets = data available in the Data Studio dashboards. This makes showing the latest data in the dashboards easy to maintain. In addition, we applied interactions and filters to certain graphs in the dashboard, so users can engage and dig deeper into the data.

After weekly feedback sessions with CLEPA, we reached the end of the assembly line. Together we watched our dashboard develop from a rather simple data overview of the impact on production employment, to an interactive multi-page dashboard that highlights various aspects of the transitions in the automotive supply sector. By using graphical elements as a canvas to present data upon, we achieved a visually attractive data dashboard that allows to update and display data dynamically. It helped to make CLEPA’s research data insightful and visualize their story about the employment impact in the automotive sector in a new and interactive way.

After weekly feedback sessions with CLEPA, we reached the end of the assembly line. Together we watched our dashboard develop from a rather simple data overview of the impact on production employment, to an interactive multi-page dashboard that highlights various aspects of the transitions in the automotive supply sector. By using graphical elements as a canvas to present data upon, we achieved a visually attractive data dashboard that allows to update and display data dynamically. It helped to make CLEPA’s research data insightful and visualize their story about the employment impact in the automotive sector in a new and interactive way.

The results

Clear and insightful data visualizations

Visual dashboard design

Dynamic data dashboard setup

Some of our other cases

Sibelga

Bridging the gap between Analytics and UX Research at Sibelga

Sibelga

Bridging the gap between Analytics and UX Research at Sibelga

Sibelga

Bridging the gap between Analytics and UX Research at Sibelga

MCC

Premium e-commerce experience for MCC Label

MCC

Premium e-commerce experience for MCC Label

MCC

Premium e-commerce experience for MCC Label