This post is about Project Automotive Market Share Dashboard in South Sulawesi - Indonesia.
The Objectives
- Provide C-Levels with the market share dashboard to support decision making based on data.
- Quick understand about the market condition (trends) in automotive sector.
Tools used
- Power BI
- Microsoft Excel
Data Source
The data is coming from several One-stop Administration Services (SAMSAT) Office in South Sulawesi Area.
What to Improve?
There are a lot to improve in this project such as:
- Excel limitations of handling big data (over 1 million rows). We tackle this by using new file excel
Improvement: we could use database or big data such as google big query to store the data.