A mix of cleaning gnarly real-world data, building dashboards, and a bit of machine learning.
Indian Startup Funding Analysis
Completed
Cleaned and analyzed 3,000+ Indian startup funding deals (2015–2020) from a dataset with inconsistent city names, unstructured industry labels, and funding amounts stored as text. Built a two-page Power BI dashboard covering funding trends by year, city, and sector, plus a dedicated investor analysis page comparing deal-count vs. deal-value rankings.
Excel
Power Query
Power BI
Data Cleaning
SWIFT Choked Hubs Prioritization
Completed · Take-Home Assignment
Analyzed shipment-tracking data to define and identify "choked" courier warehouses — locations where shipments sit longer than they should before moving on. Computed per-stop dwell time and used the 75th-percentile threshold to flag warehouses for prioritized clearing, delivered as an approach write-up, SQL analysis, and a tagged output file.
PostgreSQL
SQL
JSON
Operations Analytics
Reliance Stock Market Analysis & Forecasting
Completed
Data-driven analysis of Reliance Industries using Python for data processing and Facebook Prophet for price forecasting. Interactive Power BI dashboard with NSE stock insights.
Python
Jupyter
Power BI
Prophet
HR Analytics — Employee Attrition Prediction
Completed · ~86% Accuracy
End-to-end HR analytics pipeline on IBM HR dataset (1,470 records). EDA with 8 publication-ready charts, Random Forest ML model for attrition prediction, and interactive Power BI dashboard for HR stakeholders. Top predictors: OverTime, MonthlyIncome, Age.
ML · Random Forest Classifier
Python
Scikit-learn
Power BI
Pandas
E-Commerce Customer Drop-Out Analysis
Completed
Funnel analysis on a 99K+ order, 8-table e-commerce dataset to find where customers drop out before completing a purchase. Modeled the order lifecycle in PostgreSQL, isolated the biggest leak at the Approved→Shipped stage, and found failure rates vary up to 20x across sellers — pointing to seller performance, not product category, as the key driver.
PostgreSQL
SQL
Python
Funnel Analysis
Auto Loan Securitisation Analytics
Completed
Analytics on auto loan securitisation data covering loan pool segmentation, risk profiling, and repayment trend analysis. SQL for extraction & transformation, Excel for financial modelling, Power BI for executive-ready dashboards.
SQL
Excel
Power BI
Finance
Zomato Restaurant Analysis — Cuisine, Pricing & Rating Insights
Completed
End-to-end analysis of 50,000+ Bangalore restaurants from Zomato's dataset. Data cleaned in Python (Pandas) and modeled into a two-page interactive Power BI dashboard covering cuisine popularity, city-wise pricing, and cost-vs-rating trends.
Python
Pandas
Power BI
DAX
➕
Coming Soon...
Next project in progress. Stay tuned on GitHub!
In Progress