August 24, 2020

Auto Maker Uses Analytics to Optimize Franchise Dealer Inventory

SOLUTION overview

With the support of WIT, our client implemented a Microsoft Power BI dashboard to increase visibility into consumer demand for specific vehicle configurations.




Inventory Management


Southeast Michigan 

Power BI screen



Ranking in the top 10 of the world’s largest automakers, this company is a multinational automotive corporation that has a wide-ranging portfolio of nearly 20 automotive brands with manufacturing, design, and engineering facilities at worldwide locations.


Vehicles can be assembled in a wide variety of configurations that are tailored to the consumer's needs and desires; including cosmetic or functional packages or extra options. However, predicting purchasing behavior can be difficult, especially when tracking between the OEM assembly, to the dealership to the consumer. Key opportunities to address in this project included: 

  • Improve ability to identify and track vehicles on a dealers lot and for how many days
  • Increase visibility to which vehicle configurations are less popular and sit at a dealership longer
  • Provide data discovery analysis with past and current dealership inventory data


The WIT analytics team was able to deploy a custom Microsoft Power BI dashboard that leverages up to five years of vehicle configuration and dealership inventory data into a user-friendly data discovery tool.


This data discovery dashboard is delivering a competitive advantage with increased visibility into consumer demand for specific vehicle configurations. Key outcomes included: 

  • Enhanced existing capability to track the average days on lot for a specific vehicle configuration
  • Gained ability to analyze current and historical dealership inventory data to gain insights into poorly performing configurations
  • Enabled data-driven decision making to create vehicle configurations based on consumer demand



About WIT

WIT is an analytics and automation consulting firm with over 25 years of experience. We help our clients build solutions to maximize the value of their data and analytics assets, and automate key business processes. In partnership with elite software companies, WIT’s capabilities span a broad spectrum of business functions and industry verticals. To learn more about the work we have done for our clients, visit Our Experience page. 

Tagged: Business Analytics, Data Discovery, Data-Driven Decisions, Data Visualization, Case Studies

Newer Post Register Today for the Great Lakes Digital Transformation Summit
Older Post Data Visualization Tools Drive Significant Value - When Used

Subscribe to our Blog