Founded in 1999, Johnsons Cars has built itself up to become one of the largest independent car dealerships in the country, through being committed to providing the highest level of customer care and satisfaction in everything we do, from the supply of new and used vehicles through to servicing and repairs.

“Our business intelligence solution has undoubtedly helped us realise a greater return on the investment in all our systems. We have true transparency right across our business.”

The Challenge

Johnsons needed to bring together both financial and non financial data from multiple systems into a centralised hub for fast, easy and accurate reporting of KPIs and ROI across the business.

The Solution

Johnsons chose Tahola for their expertise in implementing business intelligence solutions in the motor industry. QlikView was the solution selected after Tahola demonstrated a number of alternatives to Johnsons. The solution pulls data from their main Kerridge rev8 (now ADP) company database and integrates with data from other systems, including an online service booking platform and the Toyota/Lexus CRM system, V8.

“We now have a wealth of information across all parts of our business, including sales, service, parts, labour and customers,” says Lesley Brown, Group Marketing and Database Manager. “We can see at a glance items such as our sales and stock performance, ageing stock, costs, after sales labour/parts sold. We can understand our customers like never before. Our lapsed customer summary enables us to drill down to analyse, for example, geography and age of vehicle. This then helps drive effective marketing strategies to retain those customers.”

With their Real Time Communications (RTC) online service booking system, Johnsons can see the full circle of customer service management — from automatically sending a 4 week advance reminder of service, right through to analysing which customers then booked in, the revenue generated on parts/ labour, and the margin per job.

In order to disseminate information throughout the organisation, Johnsons are using NPrinting, the most advanced report generation, distribution and scheduling application available for QlikView. It enables them to quickly create and modify reports, generate and filter them based on updated data and distribute them to a range of managers across the business whenever they need to. “NPrinting has really added value,” says Lesley. “It has significantly reduced the time and resource needed to get reports to the right people in our business—from Franchise Directors and Managers, to General and Service Managers as well as the Finance team. It also means that reports can be sent to more people without the need for additional QlikView licences.”

The Result

“Our managers love having this timely and easy access to our main KPIs,” continues Lesley. “They don’t have the time to scroll through reams of data themselves. Now they can quickly see where they need to focus their efforts in order to impact the performance of the business.”

From a marketing perspective, Johnsons are able to quickly and simply conduct all their market and customer segmentation within QlikView and then automatically push that data to Cheetahmail from Experian for email campaigning. The next step is to begin extracting data from Cheetahmail in order to further enhance customer understanding and insight.

“Our business intelligence solution has undoubtedly helped us realise a greater return on the investment in all our systems,” concludes Lesley. “We have true transparency right across our business.”

  • Timely/easy access to data with greater transparency
  • More time for analysis rather than data capture, saving time and money
  • Helped realise return on investment in existing systems
  • Improved reporting to customers and suppliers
  • Visualisation/trending of data

READY TO TAKE YOUR FIRST STEP…

If you are ready to start your analytics journey or would simply like to find out more about the wide variety of solutions and services Tahola offer, then contact us today to arrange a call or to book a demonstration. We can help you to understand more about which of your data really matters to you and what you should be doing to act upon it….lets start planning your analytics journey together…today….

Sales and Enquiries

For sales and enquiries on how Tahola can take your business decision making to a new level call: 01442 211122 or email: enquiries@tahola.com

Support

If you’re experiencing some difficulty or have a question regarding an existing product please call: 0845 257 8920 or email: support@tahola.com

OFFICIAL PARTNERS

Register for tips on getting the most out of your business analytics

Tahola