Toyota Logo

Codec enhances reporting precision for Toyota Financial Services Ireland, delivering increased productivity

Project at a glance

Challenge

Toyota Financial Services Ireland (TFSIR) faced the daunting task of compiling data from a multitude of disconnected sources for their reports. This cumbersome and time-consuming process was becoming increasingly difficult to manage efficiently.

Solution we designed

Codec implemented a complete end-to-end data warehouse and reporting BI solution, providing TFSIR with valuable data insights on contracts, quotes, dealer loans etc.  The implementation involved analysing data from multiple sources, integrating it into the Data Warehouse and provide Power BI Reporting.

Impact we delivered

Codec delivered this project on-time, on-budget.  The end-to-end data warehouse and reporting solution has significantly increased TFSIR’s productivity
Introduction

Centralising all data to enable informed decision making

Toyota Financial Services Ireland provides a range of flexible and affordable finance options for new cars and commercial vehicles, as well as approved used vehicles across the island of Ireland.  

However, given the nature of their business the TFSIR faced significant challenges due to a lack of robust reporting capabilities. Their teams had to manually compile reports from data spread across multiple excel spreadsheets, a laborious and time-consuming process. With over 70 reports needed daily, this approach quickly became unsustainable. To make the most accurate business decisions, TFSIR required access to historical data, daily updates, and point-in-time information. Receiving and interpreting these files every day became a tedious task, overwhelming the team members.

TFSIR recognised the need for a full migration of its core systems, emphasising the importance of maintaining existing reporting data, while also developing a comprehensive suite of new sales reports. The primary challenge was centralising all the information into a data warehouse, enabling easy and efficient report generation through PowerBI.

"In our early days, our priority was establishing our core systems to get up and running, enabling us to provide quotes for customers and dealers and, ultimately, generate revenue. However, we soon realised that robust reporting was a critical component we should have integrated from the beginning," 

Gary Mahon
IT Manager at Toyota Financial Services Ireland.
Solution

A centralised, data-driven solution with powerful BI reporting

With a proven track record of delivering similar digital transformation projects and creating dynamic shifts in operational efficiencies, TFSIR turned to Codec.  The core solution that Codec delivered included:

  • Cross-Functional Team Collaboration: Codec collaborated closely with key stakeholders within TFSIR to ensure smooth functional data flow and integration throughout the project lifecycle, fostering effective communication and alignment of objectives.
  • Data Cleansing and Transformation: Codec ensured data integrity and consistency across multiple sources before integration into the Data Warehouse, thereby enhancing the reliability and accuracy of analytical outputs.
  • Solution Architecture Design: The Codec team developed the solution architecture, starting from high-level design and progressively drilling down to detailed architecture, ensuring alignment with business objectives and technical feasibility, and facilitating a foundation for the project implementation.
  • Data Model Development: Design and implementation of data models at a low level, incorporating considerations such as security, database structure, and integration standards, to support efficient data storage and retrieval within the Data Warehouse, optimising performance and scalability.
  • Requirement Translation and Design: Codec engaged with TFSIR to understand and translate business requirements into detailed technical specifications, facilitating the creation of a design that effectively addressed their needs and requirements, ensuring customer satisfaction and alignment.
  • Power BI Dashboard Development: The development of a comprehensive set of Power BI dashboards tailored to the requirements of the financial teams allowed for insightful visualisations and analytics on contracts, quotes, dealer loans, and other relevant data points, empowering stakeholders with actionable insights for informed decision-making. 

1_opening
Results

Improved outreach

Codec prides itself on prioritising ‘doing the right thing’, investing wholeheartedly in TFSIR's success. From the outset, TFSIR had a clear vision of their goals, but partnering with Codec's IT experts unlocked even greater value. The collaboration allowed for detailed planning and the suggestion of alternatives that not only met TFSIR's original objectives, but also provided additional functionality, enhancing the overall project outcomes.

  • Richer, more valuable insights
    The business benefits have been transformative. Previously, TFSIR's sales reporting at dealerships was a labour-intensive process, requiring manual collation of data. With the new reporting systems implemented by Codec, TFSIR can now capture detailed insights such as who sold the finance, how the sale started, and the full sales cycle timeline. This shift from basic sales data to richer, more comprehensive information has been invaluable not only for TFSIR, but also for the dealerships.
  • Increased sales
    Dealerships now have visibility into their reports and can access their own dashboards, showing their weekly sales, leading salespeople, and other valuable insights. Dealers can now monitor their performance and collaborate more effectively to drive business growth.

"Working with the Codec team meant we received the attention and dedication we needed. Codec delivered on our fixed go-live date, demonstrating real flexibility and determination to help us achieve our goals. The project was delivered on time and on budget, a rare achievement for IT projects of this scale," said Gary Mahon.

"Codec didn't just blindly follow our requests; they provided consultative advice throughout the process. We quickly realised that Codec's recommendations had a far greater business impact than we anticipated. Their advice and guidance were invaluable"

Gary Mahon

IT Manager, Toyota Financial Services

next case study

Delivering an online self-service portal benefiting customers and employees in NI Water