Stellar & Toyota

A data analytics case study

Toyota NZ is a subsidiary of Toyota Motor Corporation, Japan and in 2013 celebrated 26 years of vehicle market leadership in NZ. Toyota sells new Toyota and Lexus vehicles as well as used vehicles, parts and service.

Locations Key operations are at the National Customer Centre in Palmerston North, Vehicle Operations in Thames and a Port of Entry facility and Corporate Sales Office in Auckland.
Staff 240
Dealers 33
Website toyota.co.nz

stellar + microsoft

Toyota-Logo


The challenge

Selling 25% of all cars and light trucks in New Zealand, Toyota has dominated the market for decades. But even market leaders need to continue improving, and Toyota realised that its future success depended on developing a deeper understanding of its customers and markets.

When they looked “under the bonnet” of their legacy BI systems, however, Toyota found that its people were still manually building and maintaining spreadsheets. Information wasn’t always accurate or up to date, it was often hard to audit, and it was kept in “silos” which obscured the big picture. Stellar was asked to bring a strategic enterprise focus to BI, to help Toyota overcome a series of poorly executed BI initiatives, and to ensure that the company had:

  • access to accurate data in real time across multiple sections of the business at separate locations
  • insight into ‘big picture’ trends for planning, plus specific data sets by region, dealership or individual customers

The solution

Stellar used their Microsoft BI experience and support from Microsoft’s local solution specialists to demonstrate how an enterprise BI solution could use Toyota’s existing Microsoft platform and retain familiar tools such as Excel. Then, Stellar’s BI experts analysed Toyota’s core reporting processes, designed and implemented the technical platform, established development standards and processes, and built the solution components.

The system extracts data from five core operational systems (including JDE ERP and Simplicity CRM) and external data feeds (e.g. NZTA vehicle registration files) using a structured SSIS ETL framework that draws on the Microsoft Project REAL best-practice architecture.

By using the Microsoft BI platform, Stellar was able to design SharePoint dashboards that resemble Excel charts and tables. This has permitted incremental, low impact release cycles to transition users onto the enterprise BI platform with minimal training and disruption. Now, everyone from the CEO to warehouse stock pickers gets daily updates, providing a level of business insight previously unimaginable.

“Stellar provided a total package solution which included often overlooked but vital requirements such as proper data governance and training. They are clearly best in breed and helped us fully benefit from our investment in Microsoft BI technologies.”

Mark Young, Corporate GM for Toyota NZ

Toyota’s BI Solution

An enterprise data warehouse and reporting solution using:

Integration of finance, sales, vehicle management, parts inventory and customer relationship management systems, as well as external industry data, into a “single source of truth”.

The benefits

  • Enhanced customer experience.
  • Disseminating and understanding information.
  • Self-service reporting.
  • Building competitive advantage.
  • Accountability through “visibility”.
  • Reducing manual manipulation of information.
  • Saving time and money.

Download Case Study as a PDF

CLICK HERE