Skip to content
View pushpendraptkr's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report pushpendraptkr

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
pushpendraptkr/README.md

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


πŸ“ˆ 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


πŸ“Š 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


🎯 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


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

Pinned Loading

  1. excel-service-operations-dashboard excel-service-operations-dashboard Public

    Interactive Service Operations Dashboard built in Microsoft Excel using Pivot Tables, Pivot Charts, Slicers, Timeline, and KPI Cards.

    1

  2. cement-sales-dashboard-excel cement-sales-dashboard-excel Public

    Excel-based sales analytics dashboard for monitoring revenue, volume, product performance, and regional sales trends.

    1