📉 Predictive Analytics · Retail
Customer Churn Analysis & Prediction
Analyzed 6,418 customer records with a 27% overall churn rate. Built a Power BI dashboard using DAX & Power Query, authored SQL segmentation queries, and trained a Random Forest classifier to flag at-risk customers.
⚠ Month-to-Month customers: 46.5% churn — directly drove retention strategy
6,418 records
1,732 churned
Random Forest
⚡ EV Analytics · Sustainability
EV Charge & Range Analysis Dashboard
Internship flagship project. Built an end-to-end EDA pipeline on 30,000+ charging records, identifying battery efficiency patterns. Deployed 3 interactive Tableau dashboards tracking 8+ KPIs for executive stakeholders.
✓ Reduced stakeholder reporting time by 60% · >95% data accuracy
30,000+ records
240-hr internship
3 dashboards
🏥 Healthcare · Operations
Hospital ER Analysis Dashboard
Interactive Power BI dashboard over 9,200+ patient records with real-time filtering by department, shift, and demographic. Authored 12+ SQL queries using joins, subqueries & aggregations to extract 7 operational KPIs.
→ 3 depts drove 70% of peak-hour bottlenecks — scheduling optimization projected –20% wait time
9,200+ patients
12+ SQL queries
7 KPIs
🍕 Sales Analytics · Retail
Pizza Sales Analysis Dashboard
Analyzed 21,000+ orders across $817K in revenue. Built a multi-tab Excel KPI dashboard using Pivot Tables, slicers & dynamic charts — consolidating 6 sales metrics into a single executive-ready view.
📌 Peak: Fri–Sat 6–9 PM · Top 3 categories = 62% of total revenue
21,000+ orders
$817K revenue
6 KPIs