Germany eBay Car Sales [Onyx Badge - Problem solver]

My analysis focuses on four key metrics:

• Average Ad Price: This metric aims to determine the average listing price of the vehicles.
• Average Ad Duration: This metric measures the average time it takes for a listing/ad to be sold or removed by the user. It provides insights into the velocity of vehicle sales.
• Total Ads: This metric represents the total number of advertisements or listings in the dataset. It provides an overview of the volume of vehicle listings available for analysis.
• Ads Share: This metric quantifies the share of ads for each brand and model of vehicles. It helps identify the distribution of advertisements across different brands and models within the dataset.

My aim is to gain insights into the trends and patterns within the dataset by examining these metrics.

1. The Overview page provides information about these metrics and details based on different categories and breakdowns.
2. The Categorical view page provides information about car brands/models and categorizes them into four quarters to identify popular and unpopular brands and models.

Insights:

• 92% of listings are for petrol and diesel vehicles, while electric and hybrid vehicles combined only contribute 0.2%.
• Petrol (Benzin) vehicles have lower pricing and a quicker selling rate.
• Electric and hybrid vehicles have higher listing prices and longer ad durations.
• Buyers prefer newly registered vehicles, valuing their perceived higher quality, suggesting a preference for newer models or better features.
• Condition matters more to buyers than mileage when choosing a vehicle. Prices decrease as mileage increases, reflecting buyer preference for less used cars.
• Volkswagen has the highest ad share, almost 21%. The top 5 brands make up almost 61% of ad listings.
• Limousine, Kleinwagen, and Kombi type vehicles contribute to 70% of vehicle ads.