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. 

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

service-data-analytics

explore our data analytics expertise

let’s get in touch

expert
Dr. Horst-Florian Jaeck is partner at rpc – The Retail Performance Company and heads the Data Analytics division.
Dr. Horst-Florian Jaeck
Partner
about
Dr. Horst-Florian Jaeck leads the data analytics division at rpc. He has several years of consulting experience in various management functions with a focus on customer experience management and big data analytics.
news
what is the value of customer relations?Read more...
data analytics in sales and marketingRead more...
understand your customers worldwide with text miningRead more...
contact
We use cookies to ensure you get the best experience on our website. Privacy Policy.