Automotive Parts Retailer EDW Design & Implementation
The client operates in a fiercely competitive industry and environment. For 75 years, they have been a leader in the automotive aftermarket industry in parts availability, price, and customer service. Its mission is to provide vehicle owners and enthusiasts with the products and knowledge that fulfill their needs at the right price.
Their growth plan and operational goals were hampered by an inability to access key data elements scattered in multiple silos and turn that information into insight.
As a result of the engagement, the client has a clear understanding and adherence to best practices vis-à-vis their ETL architecture and design. They also have a high-level view of the future work involved in creating a data warehouse. This project uncovered data inaccuracies that were corrected and demonstrated the importance of data governance.
RCG was able to guide the client in demonstrating the types of reports that could be generated and helped drive the understanding that could be gained from sales scorecards and dashboards. Another clear benefit realized through this project was an increase in productivity gained from standardized data use.
This client sells automotive parts, accessories, batteries and maintenance items and gives customers access to thousands of parts that are available on a same-day or overnight basis.
With a strong commitment to growth, they are keenly focused on four key goals: raising sales productivity, expanding operating margins, generating strong free cash flow and increasing return on invested capital. The opportunity presented was to ensure the creation of an ETL architecture and design that would both meet the tight deadlines of their immediate effort and provide a strong foundation for future phases of the data warehouse project.
The client was looking to:
- Accelerate business growth— for making better, faster decisions to improve business performance, speed time to market and increase competitive advantage.
- Lower costs— for managing information more efficiently throughout its lifecycle and eliminate inaccurate, untimely information.
- Mitigate risks—by assuring compliance with regulatory mandates while reducing the costs associated with inaccurate, untimely information.
Meeting & Exceeding Goals Required Significant Change
The technical environment represented challenges to meet those goals because it became increasingly difficult to get the data required by the business managers to forecast effectively. The intent was to provide an independent best practices review of the work performed. RCG wanted to ensure the creation of an ETL architecture and design that would meet both the tight deadlines of their immediate effort and provide a strong foundation for future phases of the data warehouse project. Simply stated, the business recognized that there were knowledge and communication gaps that needed to be bridged.
The company was working in silos and there was not an adequate system of control or standardization present. With a vast number of databases and spreadsheets that production reporting was done from, this represented a unique challenge to address. With all these parts and vendor relationships to manage, our client was looking for more efficiency and integration of data from one source system of record. It also needed to ensure data quality, integrity and reliability in order to update data daily and near-real-time when possible.
RCG competed with several big-name companies and was selected on the basis of its superior technical response and best price. RCG was entrusted with Design Architecture, Detailed Design, Construction, and System Integration.
In order to achieve their business goals, RCG was chosen to design and integrate the financial and operational data for effective forecasting from data trends. Meanwhile, ensuring that the data was better managed, controlled, accessible and secure was critical. Good architecture and strong design are keys to any successful data warehouse implementation. With the accumulated experience of hundreds of data warehouse and Business Intelligence projects, the RCG team had exactly the right skills and expertise needed to design and implement this clients’ data warehouse solution build.
RCG’s Architectural Approach started with our clients’ business drivers and business needs. As with similar projects this project was delivered incrementally, with each sequential phase providing additional value to our client. This allowed them to realize the benefits quickly, as they reduced their payback period.