The Archive

Case Studies

I build pipelines that scale and dashboards people actually use. Here are five times I turned messy data into clear answers.

Executive Overview Anomaly & Risk Monitor Customer Intelligence Geographic Performance
Engineering · BI

Retail Revenue & Anomaly Detection

Processed over 800,000 records through a custom star schema. I built an anomaly detection layer that cut false alerts by 85%, feeding a Power BI dashboard that tracks revenue exactly.

MySQL Power BI Python DAX
IPL Overview Team Performance Players Performance Match Flow
Analytics · SQL

Performance Forecasting Model

Analyzed 145 datasets to see what actually drives team performance. The dashboard tracks batting trends and boundary patterns so coaches can build strategies based on data, not just gut feeling.

SQL Python Power BI
Football Striker Segmentation
Machine Learning · Python

Football Striker Segmentation

Used K-Means clustering on 500 elite players to find out what really leads to goals. I built custom contribution scores and a classification model to predict how a player will perform on the pitch.

Scikit-learn Python Seaborn
Sales Data KPI Dashboard Sales Data YoY Comparison Sales Data Tooltip View
Analytics · BI

Year-Over-Year Sales Analytics

A dashboard comparing 2023 against 2024. I generated synthetic data with Python to map out year-over-year growth, customer habits, and city-level trends in Power BI.

Pandas Faker Power BI
Geospatial Real Estate Valuation
Analytics · Tableau

Geospatial Real Estate Valuation

Turned messy King County housing records into an interactive map. It filters valuations by condition and build year to show exactly how much location changes the price.

Excel Tableau