SSF Imported Auto Parts LLC is the leading North American warehouse distributor of OEM and aftermarket automotive parts for European vehicles.
SSF’s Business Intelligence team recently embarked on the journey of developing and deploying Qlik Sense as an end-to-end enterprise solution to replace scattered data sources, and were tasked with creating short and long-term goals to navigate the business impact of COVID-19.
Due to the global pandemic and resulting lockdowns, industries across the globe came grinding to a halt in March 2020. Short-term, SSF needed to maximize sales and protect profit margins while long-term, the organization needed a tool-box of analytics and data views, allowing the company to quickly make fact-based, data-driven decisions.
These actionable insights would result in changes to SSF’s sales, purchasing, pricing and operational strategies which reversed much of the declines brought on as a result of the global pandemic.
The following case study documents the methodologies used by the SSF BI team in conjunction with Qlik Sense to navigate one of the most challenging business environments in modern history.
SSF Imported Auto Parts LLC – 45 years of serving the nation’s auto repair industry
Check engine light illuminated on your dash? Squealing brakes? Know your car is due for service soon? It is probably time to head to your local automotive repair workshop, the core of SSF’s warehouse distribution network.
If the service advisor mentioned they were ordering parts to complete the repair, in many cases, the genuine original equipment or aftermarket parts were coming from one of nine SSF warehouse locations, which offer multiple same-day deliveries, as well as overnight shipping – directly to the workshop.
Founded in 1976, SSF Imported Auto Parts LLC (SSF) is based in South San Francisco, California and serves the $880 billion automotive industry. SSF specializes in European carlines and offers a full program of genuine, OEM and aftermarket auto parts to customers nationwide.
COVID-19 lockdowns force the entire automotive industry to pump the brakes
In early 2020, COVID-19 began making news across the world and changing the way we live, work and travel. From manufacturing constraints due to social distancing requirements, logistic delays caused by container shortages and port congestion, to an immediate drop in consumer driving habits, the automotive industry was flipped upside down. By the middle of March 2020, passenger miles driven, a rough estimate of demand for the auto repair industry, were down 50% and the economy had entered a recession.
As with many companies across the world, business at SSF Imported Auto Parts experienced a steep decline, however, the precise underlying causes were unclear. SSF could see that demand was down, but to formulate an effective response they needed to be able to identify why it was down and which segments of the business were most affected.
With lockdowns causing difficulty across the economy, SSF Imported Auto Parts CEO Thomas Beer tasked Chris Kahler and Ryan Lessig, the companies Business Intelligence and Strategic Projects team, with generating critical insights to answer those questions.
Access to integrated, company-wide data is the foundation of successful analysis
Chris and Ryan used the Qlik Sense Data Analytics and Integration Platform on their fact finding mission. The BI team was already in the process of developing a large suite of Qlik Sense applications to replace legacy analytic tools and scattered data sources. The SSF Qlik Sense environment consists of internal and external data sources – IBM AS400, Oracle NetSuite, IHS Markit, and Elite Extra, to name a few.
Ryan considers the ability to integrate different sources into a comprehensive set of data key to the value proposition Qlik offers:
“Prior to integrating Qlik as a company-wide BI platform, everyone was looking at their own individual reports. With Qlik, we’ve be able to tie dozens of data sets, spanning across all departments, and begun breaking down silos within the organization. This gives us an incredible level of transparency that we can utilize to understand all aspects of our business – and before many data sets were not accessible to all users or the data was outdated by the time you received it.” – Ryan Lessig
Planning for success: What gets measured gets done
In the world of analytics and business intelligence, a measure is a quantitative calculation used to represent data in a visualization -- and finding the most relevant measure to track is the crucial first step of any analysis. While there are standard measures such as sales or profit margin, advanced analytics requires a broader knowledge of the business and the many different factors that can affect a seemingly simple measure like sales.
For example, following Chris’ intuition that a spike in the number of orders the company was processing was increasing while sales revenue was declining, they created a measure to analyze invoices with only a single item purchased. The trend was clear: a major spike in single-line invoices occurred right as the COVID-19 lockdowns took effect, indicating that only critical car repairs were being performed by the workshop. Another insight from this measure implied workshops were potentially price shopping for the absolute best price and / or unable to upsell customers on routine maintenance items.
Leveraging Qlik, Chris and Ryan continued their analysis creating multiple order-focused measures which allowed them to dissect the business and bring to the surface data-driven conclusions that they could present to Mr. Beer, CEO. Combing these new measures with time-series visualizations such as line charts, bar charts and bullet charts, the user can then see how these trends changed over time.
Digging Deeper into The Data with The Right Dimensions
To drill down into the measures to create meaningful insights, dimensions – qualitative information – from tens of millions of rows of raw data was combined from multiple data sets. Categorizing this information in dimensions allowed the team to make sense of what they would be looking at, without being overwhelmed by the massive quantities of data.
Leveraging a Qlik Sense feature called transformations, they combined millions of product and pricing records together to create groupings of products based on their average sell price. Comparing sales at different price levels before and after the lockdowns took effect, Chris and Ryan were able to achieve a second key insight regarding product price in comparisons to sales growth or decline.
“Ryan and I [Chris] have hit our stride. My diverse understanding of the automotive aftermarket, from the days in my family-owned workshop to tenure at parts manufacturers and distributors – I have a broad perspective of the automotive industry as a whole. In combination with Ryan’s product management and data science background, we have developed a unique ability to bring raw data to life and analyze current business trends – allowing for the creation of actionable insights backed by fact-based solutions.” - Chris Kahler
Using Qlik to enhance raw data with new measures, dimensions and transformations – combined with the power of data visualizations, Chris and Ryan were able to combine all the pieces needed to create a data supported and informed business case.