Price Prediction & Market Insights
Analytics toolkit that accurately estimates car market values and displays competitor inventory details.
In this project, I developed a set of analytical tools that help auto dealers accurately estimate the prices of cars they buy or sell, get insights about their competitors’ inventory, calculate depreciation, and find cars listed below market value.
What did I do in this project?
- Established an ethical and conscious way to scrape publicly available listing data (no copyrighted or personal information was scraped, throttled crawler requests) in the Finnish Automotive Market
- Created a data structure that allows classifying and grouping listings per Make, Model, Trim, Model Year, Auto Retailer, Branch, and Sub-Branch
- Built a linear regression model to define the relationship for each model generation between mileage, model year, and package (or certain keywords in the description)
- Built a dashboard to visualize the results and allow users to search for specific information with ease
Key Capabilities
- Inventory Intelligence — Volume (quantity and €), make/model/trim/year distribution, average age, price, and mileage per branch
- Price Prediction — Accurate estimated market price based on regression modeling
- Depreciation Calculator — Per make, model, and trim
- Best Deals Finder — Cars listed below calculated market value
Demo
The system was built on Google Looker Studio (formerly Google Data Studio), retrieving around 27K individual listings. The data is a snapshot from February 2022 and is not current. Reports are originally designed for web and are not mobile optimized.