Car Sales Overview
Car Sales Overview
Embedded Files
For this project I decided to use a car sales database in order to create both a report and a dashboard.
This dataset is a great example of how useful is Kaggle for practicing data analysis, in fact the dataset seems to have been created by Vasu Avasthi specifically for training.
Despite it claims to contain data from all over the world, it actually contains data from a few car dealers in USA and their customers. To be fair there's a lot of information inside the database, not only about the cars but also about sellers and buyers too so it's perfect for a detailed report and a specific dashboard about favourite car features.
In this case I used MySQL for cleaning and analyzing the dataset and Tableau for visualizations (and some analysis too). I made use of RMarkdown for writing the report that you can find here.
The analysis can be divided into 3 main stages:
1) Create a general picture of the car sales;
2) Delve deeper into customer characteristics, paying particular attention to differences and trends;
3) Focus attention on car dealers.
This time I didn't limit the analysis to reach a precise goal and that's why we have so much information. It gets more interesting and definitely useful to create a dashboard analyzing car features only.
Car_sales_overview_2.pptxDetailed Report
Detailed Report
Page updated
Google Sites
Report abuse