PreludeSys helped a Californian car dealer build a new application for grading pre-owned cars using SQL and Power Platform

The client is a leading California car dealer in business for over 20 years. They have a group of employees called “buyers” who are responsible for buying vehicle inventory from different car auctions. They wanted new software that would allow them to grade the quality of their buys to correct any systematic issues and create visualizations to identify trends in the source (auctions) of where they buy. The grader software had to be intuitive and easy to learn.

Business Challenge

  • Lack of tools or systems to grade the quality of car deals made by buyers from various sources, including through auctions.
  • Lack of insights for sales and inventory to identify buyer patterns.
  • Challenges in maintaining data quality due to the lack of a data-cleansing framework.

Technology / Enviroment

SQL DB, Power Apps and Power BI

Benefits

  • Simplified reporting using Power BI rectified key data quality issues.
  • Sales and inventory viewed through Power BI dashboards provided better grading insights.
  • Enabled the client to visualize the trends in the source (auction) from where they buy the cars.
  • The client can use the write-back option to input the grading data and determine the grading logic.

PreludeSys Solution

  • PreludeSys analyzed the requirements and used Power BI to implement a grading tool based on sales and inventory attributes.
  • Built Power BI dashboards to visualize sales and inventory trends.
  • Performed data preparation and cleaning using Power Query to generate better reporting insights.
  • PreludeSys embedded Power Apps in the Power BI report to provide an easy interface for data entry.