R-Analysis: Identifying high value customers and low value of customers using RFM modelling

YouTube Shorts & TikTok Trends 2025 — EDA tutorial: creators/hashtags insights, platform & country breakdowns, Pareto effect, and trend lifecycle patterns.

An interactive Excel dashboard analysing sales performance across stores, warehouses, and time periods using transactional sales data.

Analyse the customer purchase behaviour to optimize inventory cost

Built a SaaS analytics project using SQL and Python where I reconstructed customer lifecycle from snapshot data and analyzed key metrics like MRR, churn, cohort retention, ARPU, and LTV. I found that revenue growth was driven by customer acquisition rather than pricing, as ARPU declined over time while MRR increased

End-to-end SQL project analyzing e-commerce sales, product performance, and customer behavior

Analyzing Fater company's diaper market potential and enhancing revenue estimation for Naples stores: A Socio-Demographic, Territorial, and Points of Interest Perspective

PostgreSQL retail revenue and customer analytics using CTEs, window functions, and Pareto analysis

A comprehensive SQL analytics project solving real-world e-commerce business problems. Covers advanced concepts like cohort analysis, Pareto (80/20) revenue distribution, anomaly detection, and inventory optimization using SQL (CTEs, window functions, subqueries). Focused on deriving actionable business insights from structured datasets.

CRM segment analysis focused on action priority, Pareto validation, and customer decision-making.

BSc thesis: energy and performance profiling of lightweight object detection models for autonomous vehicle perception. RAPL measurement scripts, raw results, and analysis.

"An operational dashboard designed to track production efficiency, analyze repeat fail rates, and identify bottlenecks in repair processes using Pareto analysis."

Customer segmentation using abc analysis.

Interactive profitability & margin performance dashboard for Nassau Candy Distributor. Features Pareto analysis, sales forecasting, regional insights, and what-if scenario modeling using Streamlit and Plotly.

Multi-branch retail analytics dashboard built with SQL (Star Schema) and Power BI — inventory rotation, Pareto analysis, branch performance and KPI tracking.

Sistem web untuk analisis Pareto penjualan obat di apotek. Dibangun dengan PHP dan MySQL, dilengkapi fitur manajemen data obat, laporan dinamis, dan ekspor Excel

The primary objective of this project was to conduct a break-even analysis for the product's first year. The business team needed to understand at what point the product would begin generating profits after covering all associated costs.

Customer segmentation using RFM analysis on 779K transactions — identifying 11 lifecycle segments from 5,878 UK wholesale customers with interactive Looker Studio dashboard

This project aims to help Meesho identify and prioritize the key reasons behind customer complaints using Pareto analysis. By focusing on the top complaint categories contributing to the majority of issues, Meesho can take targeted actions to improve customer satisfaction and optimize operations.

Customer revenue, segmentation, Pareto and platform performance analysis using SQL, Python and Tableau.