This project presents a set of business intelligence dashboards created to analyze the automotive industry, using sales, sentiment, recall, and dealership data.
It was developed as the final project for the course Course 10 - BI Dashboards with IBM Cognos Analytics and Google Looker
in the IBM Data Engineering Professional Certificate.
The dashboard visualizations offer insights into customer satisfaction, vehicle recalls, model sales, and dealership performance using real-world datasets in Excel and CSV format.
The project demonstrates dashboard design, data preparation, and storytelling best practices for both business intelligence and data analytics roles.
- IBM Cognos Analytics
- Microsoft Excel / CSV files
- Data Visualization & Dashboard Design
- Exploratory Data Analysis (EDA)
- Analyze sales, sentiment, and recall data using BI dashboards.
- Design visual insights using IBM Cognos Analytics.
- Present:
- KPIs: Profit, Quantity Sold, Average Quantity Sold
- Recalls and service issues by system and model
- Customer sentiment breakdowns (positive, neutral, negative)
- Visuals: Bar Charts, Treemaps, Heatmaps, Line+Column Charts
| Filename | Description |
|---|---|
| AU_Car_Models.xlsx | Vehicle models sold in Australia |
| car_models.xlsx | Global vehicle model list |
| AU_Sentiment.csv | Sentiment analysis of Australian consumers |
| sentiment.csv | Global sentiment metrics |
| AU_Car_Recalls.xlsx | Australian vehicle recall data |
| Car_Recalls.xlsx | International vehicle recall dataset |
| AU_Daily_Sales.xlsx | Daily automotive sales in Australia |
| AU_Dealers.xlsx | Australian dealership network data |
| dealers.xlsx | Global dealer information |
| AU_Sales_By_Model.xlsx | Sales performance by model in Australia |
| sales_by_model.xlsx | Model sales data from other regions |
| AU_Bad_Sentiment.xlsx | Negative sentiment analysis - Australia |
| bad_sentiments.xlsx | Generalized bad sentiment metrics |
These files were preserved with their original names as provided in the project archive.
Automotive_Sales_Insights_Dashboard/
├── README.md # Project overview, objectives, tools, and instructions (this file)
├── data/ # Provided raw datasets in CSV and XLSX formats
│ ├── AU_Bad_Sentiment.xlsx
│ ├── AU_Car_Models.xlsx
│ ├── AU_Car_Recalls.xlsx
│ ├── AU_Daily_Sales.xlsx
│ ├── AU_Dealers.xlsx
│ ├── AU_Sales_By_Model.xlsx
│ ├── AU_Sentiment.csv
│ ├── Car_Recalls.xlsx
│ ├── bad_sentiments.xlsx
│ ├── car_models.xlsx
│ ├── dealers.xlsx
│ ├── sales_by_model.xlsx
│ └── sentiment.csv
├── dashboard/ # Final dashboard PDF export
│ └── Sales_and_Service_Dashboard.pdf
├── images/ # Screenshot images of dashboard pages
│ ├── Sales_Page.png
│ └── Service_Page.png
└── project_docs/ # Project overview and instructions
├── Final_Project_Overview.pdf
└── Lab_Instructions.pdf
The final dashboard was created using IBM Cognos Analytics and includes:
This page provides an overview of total profit, quantity sold, average quantity sold, quantity sold by model, and profit by dealer ID. It helps stakeholders monitor sales performance and identify top-selling models and dealers.
This page presents vehicle recall trends and customer sentiment, with breakdowns by model and affected system. It includes recall counts, sentiment distribution (positive, neutral, negative), and a heatmap of recalls by system and model.
This project was completed as part of the IBM Data Engineering Professional Certificate and is intended for educational use.