Skip to main contentSkip to navigation

Projects

Used Car Market Competition Analysis for Multiple Used-Car Business Ventures

By Syed Ahmed Basharat Ali.

Scraped used-car listings and built an interactive Tableau dashboard on pricing, models, mileage and regional trends.

Tableau dashboard of 84,012 used-car listings in Pakistan by year, city, manufacturer, model and transmission

Challenge

The task was to analyze used-vehicle market trends from scraped listings, focusing on pricing and features, for multiple used-car business ventures.

Approach

  • Scraped used-car data from online sources with Selenium, collecting model, price, mileage and specifications.
  • Cleaned and explored the data to find patterns.
  • Built an interactive dashboard so the trends and distributions could be explored directly.

Results

  • A dashboard covering 84,012 car listings, with an average mileage of 85,537 km.
  • Views of price distributions, popular models, the relationship between mileage and price, and regional variation.

Technologies

Python (Selenium, pandas, NumPy), SQL, Tableau.

Impact

Gave the ventures a shared, explorable view of the used-car market to inform buying and selling decisions.