Tata Power EV Charging Station Analytics
Analyzed more than 114,000 EV charging sessions across Bangalore stations using Excel PivotTables. Built analytics covering usage, utilization, customer behavior, and financials; analyzed 8,000 customers by income tier; calculated ROI, CAPEX, EBITDA, and payback period; and identified total network revenue of Rs. 4.97 crore.
Myntra E-Commerce Data Analysis
Cleaned a raw product dataset by removing duplicates, standardizing discount formats, and filling missing values using category averages. Built dynamic lookup solutions with VLOOKUP, XLOOKUP, INDEX/MATCH, and nested XLOOKUP, and answered 11 business questions.
Amazon Brazil E-Commerce Sales & Customer Analytics
Used MySQL and SQL to analyze sales, customers, sellers, products, payments, reviews, and delivery performance. Developed queries using joins, aggregations, subqueries, CTEs, and window functions across 14 real-world analytical use cases involving sales, CRM, logistics, seller performance, customer satisfaction, and demand forecasting.