Deployment of a rapid and holistic reporting system, leveraging the automation of multiple data sources through the Tableau data analytics platform.

Automotive

digitalization of dealer reporting  

Client
BMW Group

Project
GPM Genesis Analytics 

Deployment of a rapid and holistic reporting system, leveraging the automation of multiple data sources through the Tableau data analytics platform. 

get in touch

challenges

Due to continuously-occurring data quality problems and delays in the delivery of reports, our customer wanted to mitigate this issue. Data were scattered, huge Excel files did not open in an appropriate time, manual report-building was a time-intensive task and the missing single point of truth for dealer reporting were some of the challenges our client had to face.

approach in detail

1

Data integration of complex (un)-structured data assets

With our strong data integration skills for processing (un)-structured data assets, we developed an architecture which integrates dealer related data sources into the Advanced Analytics data ecosystem. This enabled the availability of dealer data.

2

Data cleansing and assurance of data quality

We set up a three-layer data preparation architecture in order to prepare and integrate all relevant data sources properly and at the right quality.

3

Creation of highly dynamic KPI dashboards and visualizations

We created highly dynamic dashboards using our strong coding expertise in R and SQL in combination with powerful visualization skills in Tableau.

4

Preparation of data assets for future advanced analytics usage

Keeping advanced analytics in mind throughout the whole project, we ensured that the data assets are ready for further analytics tasks.

dashboard

Fig. 1:

Dynamic dashboard

created impact

Automation and continuously available reporting through Tableau empowered the dealers to optimize their sales steering by area managers in the German market.

1

tool replaces 188 Excel worksheets by using Tableau

94%

time reduction in the monthly reporting generation process

110K EUR

cost savings per year

rpc_Data_Analytics

explore our data analytics expertise