We take pride in delivering quality solutions...

Data Analytics

National Autobody Retail Chain’s Analytics Platform

What was the problem?

Our client is one of the largest autobody and mechanical repair shops in the nation.  Their retail stores and regional managers were in need of a consolidated reporting and analytics platforms to better understand overall corporate performance, compliance adherence and training programs for their technicians.

How we helped?

The One Six team assisted the client with defining the set of KPIs across each level in the corporate hierarchy.  We worked with the CTO and COO to standardize measurement criteria so they can evaluate their performance against insurance carrier standards for the services they provide.  Interactive dashboards and reports were built allowing for on-demand analysis.

What were some of the tools used?

The Data Warehouse was built in the cloud using Snowflake as the underlying database technology operating in an AWS cloud. Tableau Desktop and Tableau Online were leveraged to create compelling data visualizations to support corporate leadership, regional and retail managers in their decision making.

What were the results?

All levels of the management team down to an individual retail location were now able to consistently view their teams performance and quickly identify areas where action was required.  Compliance reporting with respect to insurance carrier metrics was available online in an easy to use dashboard with the capability to drill into as much detail as required. Corporate training was also able to leverage the reporting to identify what training programs needed to be completed and by which employees.