This project was developed as part of my final assignment for analyzing car sales and profits for SwiftAuto Traders, a chain of car dealerships. As a data scientist, my role was to explore historical data, generate insights, and present visualizations using Microsoft Excel and IBM Cognos Analytics / Google Looker Studio to help regional managers make data-driven decisions.
Objective: To explore historical trends in car sales and profits using Excel.
Tasks:
- Bar Chart: Quantity Sold by Dealer ID (sorted).
- Line Chart: Profit by Date and Model.
- Column Chart: Profit by Year and Dealer ID.
- Line Chart: Sum of Profits for Hudson model cars by Dealer ID.
- File saved as:
CarSalesByModelEnd.xlsx
Objective: To present insights on sales and service performance using a dashboard/report format.
- KPIs:
- Profit (formatted to 1 decimal place in millions USD)
- Quantity Sold
- Average Quantity Sold
- Visuals:
- Bar Chart: Quantity Sold by Model
- Column Chart: Profit by Dealer ID (ascending order)
-
Visuals:
- Column Chart: Number of Recalls per Model
- Treemap: Customer Sentiment (Positive, Neutral, Negative)
- Line and Column Chart: Quantity Sold vs. Profit per Month
- Heatmap / Pivot Heatmap: Number of Recalls by Model and Affected System
-
Exported as PDF:
SwiftAuto.pdf
- Microsoft Excel
- IBM Cognos Analytics / Google Looker Studio
- GitHub for version control and submission
This project used a modified version of a dataset from the IBM Accelerator Catalog. The original terms of use can be found here:
🔗 IBM Developer Terms of Use
Note: Only the dataset provided with the assignment was used, not the full dataset from the catalog.
Simrah Ayan Fathima
Data Science Final Project - SwiftAuto Traders Car Sales Analysis