Hi 👋, I'm Pushpendra Patkar

Reporting Analyst | Data Analyst | Excel | SQL | Power BI

I'm a Reporting & Operations Analyst with 3+ years of experience in ETL monitoring, operational reporting, dashboard development, and data analysis. I enjoy building interactive dashboards that help transform raw data into actionable business insights.

---

🚀 Skills

• 📊 Microsoft Excel
• 📈 Power BI
• 🗄️ SQL (MySQL)
• 🔄 Power Query
• 📋 MIS Reporting
• 📉 Dashboard Development
• 📑 Data Analysis
• 🎯 KPI Reporting
• 🛠️ ServiceNow
• 🐧 Linux (Basic)

---

📂 Featured Projects

📊 Excel Service Operations Dashboard

Interactive dashboard built using Microsoft Excel.

Features

• KPI Cards
• Pivot Tables & Pivot Charts
• Interactive Slicers
• Timeline Filter
• SLA Compliance Monitoring
• Team Performance Analysis
• Customer Satisfaction (CSAT)
• Escalation Rate Analysis

🔗 Repository: https://github.com/pushpendraptkr/excel-service-operations-dashboard

---

📊 Featured Projects

📌 Customer Support Operations Analytics Dashboard

Tools: Power BI, DAX, Power Query, Star Schema, Data Modeling

Built an interactive Power BI dashboard to analyze customer support operations using a Star Schema data model. The dashboard includes KPI tracking, SLA monitoring, CSAT analysis, FCR, productivity metrics, drill-through reports, dynamic titles, and interactive visualizations to support operational decision-making.

Key Features

• 📈 Executive Operations Overview
• 👨‍💼 Agent Performance Dashboard
• 🔍 Agent Drill-through Analysis
• 📊 Interactive KPI Cards
• 📌 DAX Measures
• ⭐ Star Schema Data Model
• 🎯 Business Insights

🔗 Repository: https://github.com/pushpendraptkr/customer-support-operations-dashboard

---

📈 Cement Sales Dashboard (Excel)

Business dashboard created using Excel for sales analysis.

Features

• Sales Trend Analysis
• Revenue Analysis
• State-wise Sales
• Company Performance
• Interactive Dashboard
• Pivot Tables & Charts

🔗 Repository: https://github.com/pushpendraptkr/cement-sales-dashboard-excel

---

🎯 Currently Learning

• Advanced SQL
• Power BI (DAX)
• Python for Data Analysis
• Data Engineering Fundamentals

---

📜 Certifications

• Microsoft PL-300: Power BI Data Analyst
• Tutedude Data Analytics Certification
• IBM SQL Certification
• Excel Dashboard & Reporting

---

📫 Connect With Me

• 💼 LinkedIn: https://www.linkedin.com/in/pushpendra-patkar-084757205/
• 💻 GitHub: https://github.com/pushpendraptkr

---

⭐ Thank you for visiting my profile. Feel free to explore my projects and connect with me!