TeenUp E-commerce Operation Dashboard

This one is 48h technical test that I received a while ago. The goal is to build a dashboard that contains Sales, Marketing, and Delivery operations of TeenUp - a startup focusing on teenager education. I tried to make it as detailed as possible within the time that I had.

Dashboard for Logistics Business

I developed a Power BI dashboard for a logistics company, to measure their operational efficiency. The project focused on Sales & Profit, Products, and Customer Segment analysis of the store, I also tried to provide actionable insights to enhance productivity and service stability.

Amazon Consumer Behaviour with Python

This project delves into the behavioral patterns and interactions of consumers within the Amazon ecosystem. The goal is to gain comprehensive insights into customer preferences, shopping habits, and decision-making processes on Amazon.

Design a Database for an Online Banking System

I've created an Online Banking Database from the requirement of a test. It handles user accounts, transactions, and beneficiaries. The system lets users perform banking operations like balance checks, transfers, and bill payments. Check out the database I built using MySQL in the link.

Superstore Customer Segmentation using RFM Analysis

From a sample dataset of Superstore, I have categorized the customers into 11 different segments using the RFM model. I utilized SQL to manipulate data and PowerBI to visualize the segmentation distribution for better understanding. It's a fun practice for one of the most crucial tasks in business.

House Price Prediction

I developed a machine learning model to predict housing prices in California. The project involved data preprocessing, exploratory data analysis, feature engineering, and model evaluation including Linear Regression, Random Forest, XGBoost, KNN, and SVR.

Hotel Booking Analysis

In this project, I conducted a comprehensive analysis of hotel booking data to uncover key insights and trends focusing on Customer, Reservation & Cancellation, Demand, and Revenue. I utilized charts and graphs to visualize the distribution and trends of hotel booking demand.

Mushroom Classification

This is a typical classification Machine Learning project that I practiced a while ago. I built a model to predict whether a certain type of mushroom is edible or poisonous based on its features. I tried to test it with some complex classifiers. Learning ML is hard, but I've enjoyed it so far.

Personal Finance Management

I've built a simple Personal Finance Management tool using Google Spreadsheets that allows you to track your monthly income/expenses, create a budgeting plan, and compare it with the actual spending to show you how well you have managed your money. I hope this practical project can help you in life.

Cleaning Netflix Movies Dataset

This super messy dataset contains some basic information about Netflix's movies and shows, I tried my best not to break down while cleaning and formatting. You can see my best attempt in the link. It's not 100% perfect but it still looks decent and accurate enough for further analysis.

AppStore Data Analytics with SQL

This is an SQL project that covers a large amount of information on apps available on Appstore. It consists of 2 datasets "AppleStore" and "AppleStore_description". I am using sqliteonline.com to explore and analyze to find insights to answer some questions from an app developer's perspective.

Data Cleaning Test Practice

It's a Data Cleaning practice project again. This time I do a full-on complete clean dataset from a DS test that focused on formattin techniques. In this project, I am required to perform date and phone number formatting, name conversion, creating email addresses, handling duplicates, and filtering.