Analyzing eCommerce Business Performance with SQL

This project will analyze business performance for an eCommerce company, taking into account several business metrics, namely customer growth, product quality, and payment types.

Investigate Business Hotel using Data Visualization

In this project, we will go deeper into the business in the hospitality sector. The focus we are aiming for is to find out how our customers behave in making hotel bookings, and their relationship to the level of cancellation of hotel bookings.

Predict Clicked Ads Customer Classification by using Machine Learning

This project aims to determine the effectiveness of an advertisement in a company. The result obtained is that the Random Forest model used in the simulation will increase the company's profit almost 3 times from the profit previously obtained.

Capstone Project DQLab x Kominfo

This project uses Python tools and streamlit (to display an interactive dashboard). It discusses the relationship between the duration of reading books, the duration of using social media, and the percentage of active social media users.

Airline Customer Value Analysis

This project aims to group customers based on customer values in the dataset features. The results obtained are that customers are grouped into 4 clusters with 2 clusters being medium passengers, 1 cluster being new passengers, and 1 cluster being loyal passengers.

Predict Customer Personality to boost marketing campaign by using Machine Learning

This project aims to group customers based on customer behavior. The results obtained are grouping based on 3 clusters with the number of PCA components used are 3 components. If we use this grouping, we still have a potential GMV (Gross Merchandise Value) of IDR 1.08 billion.

Digital User Churn Dashboard - VIX Final Task Business Intelligence Analyst Bank Muamalat

This final task aims to make a sales dashboard with ms. excel. What can be suggested is to increase sales, by increasing product campaigns, especially in the months of school holidays and selling products in pairs (Ex: Buy Three Get One).

Final Task Project-Based Virtual Intern ID/X Partners x Rakamin Academy

There are 4 important points in this final task: 1) Restore Database (Database Source), 2) Create Fact & Dimension Tables (Database Warehouse), 3) Create an ETL Process, 4) Create a Store Procedure

Using SAPR Model for Solution of Social Poverty Problem Due to Covid-19 in Makassar City

This project is group-based and aims to find solutions to the social problems of poverty. The model simulation results show that the parameters in the form of business funding assistance from the government can reduce the poverty rate due to Covid-19 in Makassar.

Product Packaging

This project aims to create an innovative package. The task of this project is to identify which products, if packaged, have a selling value so they can increase revenue and maintain customer relationships to make them more loyal.

Estimating and Forecasting Covid-19 Cases in Sulawesi Island using Generalized Space-time Autoregressive Integrated Moving Average Model

The model used is the development of a spatio-temporal model involving distance and time, namely Generalized Space Time Autoregressive. From the results, it was found that the Covid-19 case could only be accurately predicted in a short time.

Time Series Analysis: Seasonal and Non-Seasonal Arima Models

This project is a project with my supervisor. There are 6 cases of forecasting using the ARIMA model using Indonesian. Three of them are seasonal models and the others are non-seasonal models.

E-Commerce Shipping Data

This project focuses on minimizing customers whose products are not late arriving but are predicted to arrive late. The model used for drawing business insights and business decisions is a logistic regression model. There are two important features, namely Discount_offered and Weight_in_gms.

Final Task Project-Based Virtual Intern Data Scientist Kalbe Nutritionals x Rakamin Academy

There are 4 important points that will be explained in this project, namely: 1. Dbeaver Connection with PostgreSQL 2. Tableau Public Create Dashboard 3. Machine Learning Regression (Time Series) 4. Machine Learning Clustering