Ryhn

I built an end-to-end product recommendation system by extracting product data directly from the MySQL database, cleaning and preparing the dataset, engineering text features, and applying TF-IDF with Cosine Similarity to measure item similarity. The final recommendation engine generates JSON outputs and is fully integrated into the PHP product detail page, enabling the website to automatically display similar products in real time.

View Portfolio

Pizza Sales Performance Analysis Dashboard I developed an interactive dashboard to analyze the overall sales performance of a pizza business. The project covers the complete analytical workflow, including data cleaning, data transformation, exploratory data analysis, and visualization design. I cleaned the raw dataset by handling missing values, fixing inconsistent categories, converting data types, and preparing the data for analysis. The cleaned data was then used to generate key performance indicators (KPIs) such as Total Revenue, Total Orders, and Average Order Value (AOV). The dashboard provides multiple analytical views, including: Pizza Category Distribution: A pie chart showing the proportion of orders by category (Classic, Chicken, Supreme, Veggie). Top 10 Best-Selling Pizzas: A bar chart highlighting pizzas with the highest order quantities. Monthly Revenue Trend: A line chart illustrating the revenue flow throughout the year. Revenue by Pizza Category & Size: A horizontal bar chart showing category-level revenue breakdown by pizza sizes (S, M, L, XL, XXL). Through this project, I identified trends such as the dominance of Classic pizzas, seasonal shifts in revenue, and the most profitable categories. This dashboard demonstrates my ability to process data end-to-end and turn raw information into visually appealing and actionable insights for business decision-making.

View Portfolio

E-Commerce Sales Data Analysis Project I conducted a comprehensive data analysis project focused on e-commerce sales performance. The workflow included data collection, data cleaning, exploratory data analysis (EDA), feature engineering, and insight generation. I cleaned inconsistent values, handled missing data, removed duplicates, standardized formats, and prepared the dataset for deeper analysis. Using Python (Pandas, NumPy, Matplotlib) and SQL, I analyzed customer behavior, product categories, sales trends, and pricing patterns. I created data visualizations to highlight key metrics such as revenue trends, top-selling products, average purchase value, and category performance. The project concluded with a summary report containing actionable insights, including recommendations for improving product performance, optimizing pricing strategy, and identifying high-value customer segments. This project demonstrates my ability to work end-to-end on real e-commerce datasets and present findings clearly to stakeholders.

View Portfolio

I developed a web-based platform for ordering custom photo editing services in vexel art style using the CodeIgniter 3 framework. The website allows users to register, log in, select a service, upload their photo, add special notes, make a payment, and view the final edited result. The platform consists of two roles: admin and user. The admin panel includes CRUD features to manage service categories, design templates, orders, payments, and user data. On the user side, clients can place orders, upload proof of payment, track progress, view final results, and request revisions. Key Features: Service order form with file upload Admin dashboard with full CRUD functionality Automated order & payment status management Responsive and user-friendly design Tech Stack: CodeIgniter , PHP, MySQL, Bootstrap

View Portfolio