- Data Engineering
- Business Intelligence
- Data Science
Automotive Market Intelligence Platform
What should this dealership buy next, why, and at what target price?
A market research platform that combines a dealership's historical sales, profitability and inventory with local demand, competition and pricing to recommend which vehicles to acquire next and at what target price.
- Python
- SQL
- API ingestion
- Data processing
- Dashboard
01
Project overview
- What it does
- A decision tool for dealerships that turns internal performance data and the local market into a ranked acquisition list with target prices.
- Why I built it
- Inventory acquisition is usually driven by gut feel and auction habits. The data to do better exists — it's just scattered.
- What it solves
- Dealers can't easily see how their own sales and margins line up against what the local market is demanding and what competitors are stocking.
- Who it's for
- Used-car managers, dealership buyers and owners making acquisition decisions.
02
The problem
Given this dealership's historical sales, profitability, current inventory, local market demand, competition, pricing and acquisition budget — what should it buy next, why, and at what target price? Answering that requires joining internal records with external market data that arrives through APIs in inconsistent shapes.
03
The solution
Python pipelines pull market data from external APIs and combine it with the dealership's own sales and inventory records. The data is processed and stored in SQL, where analytics on local demand, competitive inventory and pricing feed a dashboard that presents purchasing opportunities with the reasoning behind each recommendation.
04
Architecture & workflow
- STEP 01
Sources
Dealer sales, inventory, market APIs
- STEP 02
Ingestion
API pulls and file loads
- Python
- STEP 03
Processing
Normalize vehicles, prices, regions
- STEP 04
Storage
Modeled tables
- SQL
- STEP 05
Analytics
Demand, competition, pricing gaps
- STEP 06
Dashboard
Buy list with target prices
05
Technology stack
Languages
- Python
- SQL
Data Engineering
- API ingestion
- Data processing
Visualization
- Dashboard
06
Project demonstration
07
Key features
Buy-next recommendations
Ranks acquisition opportunities against the dealer's budget.
Local demand signals
Shows what the surrounding market is actually moving.
Competitive inventory
Maps what nearby competitors are stocking and at what price.
Target pricing
Suggests a target acquisition price, not just a vehicle.