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

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

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

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

Analyse the customer purchase behaviour to optimize inventory cost

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

Data-driven analysis and recommendations for optimizing sales, inventory, and customer experience at 99 Market Mall using business data management techniques.

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

This project delivers an end-to-end procurement spend and performance analysis dashboard built in Power BI to support data-driven decision-making for finance, procurement, and senior leadership teams. The dashboard integrates budget and order data to provide a single, reliable view of spend performance and supplier risk.

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.

Statistical analysis project utilizing ANOVA and Pareto analysis techniques to identify manufacturing defect trends and support quality improvement initiatives.

🧹 Advanced academic Linux system optimization tool — Bloom filter dedup, Shannon entropy, linear regression, Pareto analysis, 18 modules, multi-language

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

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

Python implementation of Simulated Annealing for VLSI floorplanning using Normalized Polish Expression, slicing floorplans, cooling-rate experiments, and Matplotlib visualizations.

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.

Six Sigma Yellow Belt project applying the DMAIC methodology to optimize customer interaction handling time by eliminating process inefficiencies, standardizing workflows and improving operational efficiency.

Retail analytics project featuring advanced SQL analysis, cohort modeling, customer segmentation, retention tracking, Pareto analysis, and interactive Power BI reporting on the Contoso Retail dataset.