05Data Analysis
Motorized Vehicle Sales Analysis
Car sales analysis in Indonesia (Gaikindo data) using SQL and Python.
Architecture
Analyzing Indonesian car-sales data (Gaikindo) with SQL and Python to surface market trends.
Gaikindo DataCar sales
SQL AnalysisAggregation
Python AnalysisTrends & segments
InsightsMarket report
Overview
An analysis of motorized vehicle (car) sales in Indonesia using Gaikindo data, completed as the Tetris Batch 3 capstone.
I used SQL and Python to explore sales trends and segment performance across the Indonesian market.
Highlights
- Gaikindo car sales dataset
- SQL + Python analysis of market trends
Context
Tetris Batch 3 capstone
Tech stack
SQLPythonPandas
More projects
View all →03Data Analysis
Airbnb Singapore Analysis
Merged 3 datasets via SQL, then cleaned and ran EDA on price, reviews, neighbourhood, host, and room type.
SQLPythonPandasEDA
04Data Analysis
Credit Risk Modeling
EDA plus five models (XGBoost, ANN, Random Forest, Decision Tree, SVM) with a Streamlit prediction app.
PythonXGBoostANNRandom Forest+3
14Data Engineering
SMILE Platform (UNDP for Kemenkes)
National immunization logistics system in production across all of Indonesia — streaming CDC + batch analytics platform.
AWS RDSDebeziumKafkaRisingWave+7