top of page
Screenshot_2025-09-04-14-21-44-777_com.google.android.apps_edited.jpg

About

With a background in Applied Statistics and Computing,

I specialize in transforming complex data into clear, actionable insights through analysis and visualization. Experienced across business, and health domains, I leverage tools such as Excel,

Power BI, SQL, Python, SPSS, and machine learning to drive evidence based decisions and deliver impactful, accessible data solutions.

Hello, I’m Ilham Akbar 👋
A Data Analyst and Visualization Specialist

focused on data analysis, interactive visualizations, and delivering insightful stories to support informed decision making

Education

image.png

UNIVERSITY OF STATE SEMARANG

2022-2025

image.png

MYSKILL

2025

Applied Statistics and Computing

3.5 / 4

Associate Degree in Applied Statistics and Computing, Specialized in data analysis and visualize, statistical modeling, and machine learning, with a final project on static and dynamic panel regression (SYS-GMM) analyzing healthcare impacts on under-five mortality.

Fullstack Data Analyst Bootcamp

Data Analytics Bootcamp with hands-on training in Mic Excel, SQL, Python, and data visualization tools.

Worked on mini tasks, case studies, and a final capstone project involving end to end data analysis from database querying and data cleaning to visualization and interactive dashboards. Gained practical experience in building portfolio.

Experience

image.png

Data Analyst Intern
(SDK Division)

90 / 100

SEMARANG CITY HEALTH DEPARTMENT

2024

Semarang City Health Office,

Health Resources (SDK) Division (Jul–Sep 2024).
Contributed to the Analyst Unit by conducting data preprocessing, exploration, and advanced analysis (spatial, regression, classification) to support evidence-based decision-making in public health.

Delivered insights through visualization, including projects on user sentiment and satisfaction analysis for a health app, and disease distribution mapping in Semarang City.

Several findings were further developed into papers and journal articles.

Tools & Certifications

image.png
image.png
google-docs.png
google-looker-seeklogo.png
63c2e4c9c4baad4ce22bf9ef.png
WhatsApp Image 2025-10-02 at 21.38.09.jpeg
image.png
WhatsApp Image 2025-10-02 at 22.00.51.jpeg
WhatsApp Image 2025-10-02 at 21.42.16.jpeg
WhatsApp Image 2025-10-02 at 21.42.38.jpeg
image.png
WhatsApp Image 2025-10-02 at 21.41.58.jpeg
WhatsApp Image 2025-10-02 at 21.41.58(1).jpeg
WhatsApp Image 2025-10-02 at 21.46.15.jpeg
WhatsApp Image 2025-10-02 at 21.46.16.jpeg
WhatsApp Image 2025-10-02 at 21.46.15(2).jpeg
WhatsApp Image 2025-10-02 at 21.46.16(2).jpeg

Project

This section showcases a variety of projects ranging from data analysis and visualization to interactive dashboards. Each project reflects a hands on approach in transforming raw data into meaningful insights, whether through SQL queries, machine learning models, or business intelligence tools. Most of these works are published on GitHub, highlighting both technical skills and the ability to communicate results effectively through clear visualizations and dashboards.

Data Exploration & Analytics

creative-concept-business-development-control-color-bar-chart-up-arrow-gold-coins-darts_11
Business Insight With SQL

Extracted key insights using SQL, covering sales trends, profitability, customer segmentation (RFM), and shipping performance.

image.png
image.png
3d-render-student-graduation-education-school_107791-15854.avif
​Academic Performance:
SVM & Logit Classification

Explored student performance prediction with Logistic Regression and SVM, uncover the most reliable model for education insights.

63c2e4c9c4baad4ce22bf9ef.png
image.png
1150.jpg
Business Insight: FMD Clustering

Segmented customers with FMD (Frequency, Monetary, Diversity) using

K-Means and DBSCAN, evaluated by Silhouette Score and Davies-Bouldin Index.

63c2e4c9c4baad4ce22bf9ef.png
image.png
still-life-business-roles-with-various-pawns.jpg
Health Segmentation Clustering

Applied K-Means and DBSCAN on NHANES data to segment health profiles by age, BMI, glucose, and insulin, evaluated with clustering metrics and external validation.

63c2e4c9c4baad4ce22bf9ef.png
image.png

Data Visualization & Dashboard

coffeehouse2.jpg
Coffee Shop Dashboard

Developed an interactive BI dashboard to analyze coffee shop sales, customer purchases, product distribution, and management insights on stock and feedback.

image.png
image.png
3d-online-shopping-via-computer-260nw-2124646253_edited.jpg
E Commerce Dashboard

​Developed an interactive BI dashboard to analyze e-commerce revenue, customer churn, payment preferences, product categories, and operational insights on transactions and returns.

image.png
image.png
bottom of page