Skip to content
All projects
  • 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

  1. STEP 01

    Sources

    Dealer sales, inventory, market APIs

  2. STEP 02

    Ingestion

    API pulls and file loads

    • Python
  3. STEP 03

    Processing

    Normalize vehicles, prices, regions

  4. STEP 04

    Storage

    Modeled tables

    • SQL
  5. STEP 05

    Analytics

    Demand, competition, pricing gaps

  6. STEP 06

    Dashboard

    Buy list with target prices

Data flow · source to decision

05

Technology stack

Languages

  • Python
  • SQL

Data Engineering

  • API ingestion
  • Data processing

Visualization

  • Dashboard

06

Project demonstration

From a dealership profile to a ranked buy list.

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.