garima darolia

I've built analytics solutions for Lohia Corp Limited, including a multi-page Power BI manufacturing dashboard tracking 10,000+ production orders across Kanpur and Bengaluru plants. My analysis surfaced a 66.31% average production efficiency, a 69.67% target-achievement rate, and defect and delay drivers for targeted process improvement.

I use Power BI, DAX, Power Query, Excel, SQL, and Python to turn raw data into KPI dashboards, root-cause analysis, and clear recommendations. I also improved Excel workbook performance by removing bloated pivot caches and redundant columns.

Across retail and education projects, I've analysed 1,001 supermarket transactions in MySQL and 2,392 student records in Python. My student-performance regression model achieved an R² of 0.84 and identified absences as the strongest predictor of GPA decline.

I'm also comfortable presenting findings, mentoring peers through Power Query and Excel issues, and collaborating across teams. As President of Darpan Club and a Class Representative, I've led teams, coordinated communication, and managed end-to-end event logistics.