Power BI Insights

This project showcases a data dashboard built in Power BI and is presented by us (as consultants). We analyzed a Kaggle dataset, delivered business insights, and reflected on the strategic direction of an automobile company.

Insights Derived

• Seasonal Trends: Sales peaked in Nov-Dec (2018-2019), alluding to seasonal buying behaviour ¹.

• Top Performing Product: Classic cars led sales, specifically in the US market. We recommended expanding into electric vehicles for diversification ².

• Quality Control Issues: Shipment sheet revealed that there are long-term waiting patterns on orders, could theoretically threaten customer trust.

What I learned

This project wasn’t just technical, as it tested my ability to translate data into decisions. I didn’t just visualise trends, I helped craft recommendations based on real business logic. That makes me valuable in a business setting: not just what I know, but how I can apply it.

The Power BI Dashboard

This dashboard was designed for an automobile company navigating Q3. Due to Power BI Desktop’s Windows-only limitation, the dashboard is shared below as a PDF, with a .pbix version available for download.

Download the dashboard!

Corresponding slide deck

Download the group slide deck!

Footnotes

1. Speaks about cars and its connection to seasonal buying behaviours

2. Electric vehicles in the market