Skip to content
Case Study

Streamlining Insights:

Steele Auto’s Data Transformation Across 58 Dealerships with Infostrux

katie-moum-l0GRQpXwgPk-unsplash-1
Clear-path_Icon-2

About the client

Steele Auto Group is one of Canada's most diversified automobile dealership groups, with 58 dealerships selling 29 brands and an employee base of over 2,300. Steele is the biggest dealership group in Atlantic Canada. They plan to expand further into Atlantic Canada and the United States, furthering their commitment to Canadian customers and welcoming new customers in the USA. 

Key Outcome

Data from 58 dealerships, coming from various sources is now amalgamated into a Snowflake data warehouse that makes the data available to prepare a consolidated income statement.

ed-259-xcrI6CPkkJs-unsplash-1

What was their key challenge?

Steele Auto Group needed to consolidate data from 58 dealerships each running its own tech stack made up of niche, industry-specific tools.  Finding a consulting firm with the willingness and expertise required to ingest and model data from so many different data sources would be critical to their success. 

How Infostrux helped

Using our Day-Zero with Snowflake approach, we analyzed the client's objectives. We planned the project to provide clear and open communication while taking a decidedly nimble approach that would respond to changing needs as the client learned about the technology.

Subsequently, our Zero-To-Dashboard offering accelerated the customer's path to demonstrating value with Snowflake and dbt.

Infostrux helped the customer design and implement an operational infrastructure that scaled their data ingestion and transformation processes.

As part of this engagement, Infostrux provided Steele Auto Group with the knowledge to continue to maintain and operate the data pipeline and data warehouse after hand-off. 

SAG - Extraction Pipeline - Data extraction pipeline (1)

How Infostrux helped

Using our Day-Zero with Snowflake approach, we analyzed the client's objectives.

We planned the project to provide clear and open communication while taking a decidedly nimble approach that would respond to changing needs as the client learned about the technology.

Subsequently, our Zero-To-Dashboard offering accelerated the customer's path to demonstrating value with Snowflake and dbt.

Infostrux helped the customer design and implement an operational infrastructure that scaled their data ingestion and transformation processes.

As part of this engagement, Infostrux provided Steele Auto Group with the knowledge to continue to maintain and operate the data pipeline and data warehouse after hand-off. 

SAG - Extraction Pipeline - Data extraction pipeline (1)

Achieved Goals

  • Data from 58 dealerships in 43 MS SQL Server databases consolidated into a single data warehouse.

  • A robust data pipeline that refreshes and transforms data daily.

  • A data model that presents coherent data to PowerBI for reporting.
Jeremy Adamson_Quote Picture-1
Jeremy Adamson - VP Business Intelligence

"The flexible delivery was great. Other consultancies hyper-define scope and try to change-request you to death. We pivoted a few times in this engagement, and I really appreciated that.”

Are you ready to leap forward with your data?

No matter where you are in your data cloud journey or what industry you come from, our team of experts is ready to embed themselves into your existing structure, pinpoint the value in your data, and help you achieve your business goals.

True innovation with your data awaits. Are you ready?