PreludeSys improves sales and inventory visibility for a leading US-based automotive dealer with Power BI

About the client

The client is one of the largest automotive dealers in the western United States, specializing in buying and selling used cars. The company’s core business involves purchasing and reselling vehicles from local auctions. The client maintains a large inventory of cars purchased from auctions throughout the United States.


Client requirement
  • The client needed a comprehensive system to assess the condition and grade of used vehicles, regardless of where they were acquired.  
  • Their older system was inadequate, and inconsistencies in data availability made it difficult to track buyer patterns and make informed decisions about sales and inventory.  
  • Additionally, the client wanted to establish robust access controls and cleansing techniques to ensure the accuracy and security of their data.  
Solution
  • PreludeSys leveraged Power BI’s robust capabilities to implement a grading tool tailored to their sales and inventory-specific attributes.  
  • We utilized Power Query for data preparation and cleansing, further enhancing their reporting insights.  
  • Using the Power Apps integration, we created an easy-to-navigate interface within the report for seamless data entry.  
Benefits
  • Eliminate data quality issues and simplify reporting.  
  • Gain insights into buyer patterns and improve sales and inventory visibility.  
  • Visualize trends at the source (auction) where cars are purchased.  
  • Input grading data and determine logic using the write-back option.  
  • Simplify data entry with Power Apps.  
Technology
  • Azure SQL DB
  • Power Apps
  • Power BI