Raja Kumar Microsoft Excel and Power BI, Data Analyst
No reviews yet

👋 Hello, I am Raja Kumar!

I am an Excel Expert with 7+ years of experience working in top MNCs as a Workforce Management Analyst. I have spent years using Excel to turn messy data into clear, useful insights — and now, I want to help you learn how to do the same.

I teach Excel from Basic to Advanced level in a simple and easy-to-understand way. Whether you are a beginner or want to upgrade your skills, I will guide you step-by-step with practical examples and real-time exercises.

You will learn everything from basic formulas, formatting, and data cleaning to advanced tools like Pivot Tables, Power Query, Dashboards, and Excel VBA automation. I also teach how to create professional reports and templates that save time and make your work easier.

My goal is to make learning Excel simple, useful, and enjoyable for everyone.

If you want to build confidence in Excel and use it smartly for work or study, I would be happy to help you learn.

Let’s make Excel easy together! 💻✨

Subjects

  • Excel Advanced Beginner-Expert

  • Excel Dashboard Reporting Beginner-Expert

  • Excel for Analysis Beginner-Intermediate

  • Excel data cleaning and formatting Beginner-Expert

  • Excel Business Intelligence Beginner-Expert

Experience

  • Data Analyst (Jan, 2025–Present) at Teleperformance at hyderabad
    As a Data Analyst, the role focuses on using Excel and Power BI to collect, analyze, and visualize data for decision-making. In Excel, responsibilities include cleaning and organizing datasets, using advanced formulas (like VLOOKUP, INDEX-MATCH, and SUMIFS), creating pivot tables and charts, and automating reports with macros and Power Query. Excel is also used to validate data accuracy and perform detailed performance or trend analysis.
    With Power BI, the role involves connecting data from multiple sources, building data models using DAX formulas, and designing interactive dashboards and visual reports. The analyst ensures reports are automated, accurate, and aligned with business KPIs. Power BI dashboards are shared with stakeholders for real-time insights into performance and trends.
    Overall, the Data Analyst uses Excel for in-depth data manipulation and Power BI for dynamic, visual reporting—turning raw data into actionable insights that support strategic and operational decisions.
  • Associate, Real Time Analyst (Mar, 2023–Jan, 2025) at Amazon-Concentrix Daksh Services India Pvt. Ltd.
    The core responsibility involves tracking call volumes, agent availability, queue performance, and overall service levels using detailed Excel-based dashboards. Excel is used extensively to capture real-time data, apply formulas such as VLOOKUP, INDEX-MATCH, and IF statements, and visually highlight performance trends using conditional formatting. This allows for quick identification of any deviation from Service Level Agreements (SLAs) and helps ensure that service levels are maintained throughout the day.

    A significant part of the role includes creating and maintaining daily, weekly, and monthly reports that summarize key operational metrics such as Average Handle Time (AHT), occupancy, adherence, and shrinkage. These reports are often automated through Excel macros, pivot tables, and Power Query, ensuring efficiency and accuracy while reducing manual effort. These reports serve as essential performance summaries for management and other stakeholders.

    In addition to routine reporting, the RTA is responsible for analyzing historical and real-time data to identify performance patterns, forecast future workloads, and provide actionable insights. Excel tools such as pivot tables, charts, and slicers are used to visualize these trends and communicate findings clearly. This analysis helps in identifying areas for improvement, such as agent productivity or staffing gaps.

    The Real-Time Analyst also plays a key role in workforce forecasting and scheduling support. Using Excel-based models, the analyst helps in predicting call volumes, aligning agent schedules, and maintaining adherence to planned shifts. This ensures that resources are optimally utilized, and operational efficiency is maximized.

    Ensuring data accuracy and consistency is another crucial part of the job. The RTA must validate data across multiple sources and use Excel’s data validation tools to minimize errors. Reports are often cross-checked to ensure reliability before sharing with stakeholders.

    The RTA is also expected to perform root cause analysis on performance deviations. For example, if service levels drop or Average Handle Time increases, the analyst uses Excel-based data breakdowns to determine possible causes, such as agent absenteeism, unexpected call spikes, or system issues.

    Moreover, automation plays a key role in enhancing productivity. The analyst may build Excel macros or use Power Query and Power Pivot to automate repetitive reporting tasks, link multiple datasets, and create dynamic dashboards that update automatically. This not only saves time but also enables faster decision-making by providing near real-time insights.

    Communication is another vital aspect of the role. The Real-Time Analyst must keep stakeholders informed by sharing Excel reports, dashboards, or summary sheets throughout the day. These updates help operational leaders make timely adjustments to staffing, call routing, or priorities based on the live data.

    Finally, the RTA is often required to handle ad-hoc reporting and analysis requests. This involves quickly gathering and interpreting data in Excel to respond to urgent management inquiries, operational escalations, or performance reviews.

Education

  • Maven Analytics Power query for Business Analytics (Aug, 2025–Oct, 2025) from Udemy Certificate
  • Maven Analytics Microsoft PowerBI for Business Intelligence & Analytics (Mar, 2025–Jun, 2025) from Udemy Certificate
  • Microsoft Excel VBA & Macros (Jan, 2025–Sep, 2025) from Udemy Certificate
  • Maven Analytics Advanced Excel Formula & Formula (Dec, 2024–Jul, 2025) from Udemy Certificate
  • Bachelor of Science (Physics Hons) (Jan, 2021–May, 2024) from RADHA GOVIND UNIVERSITY RAMGARH–scored 72%

Fee details

    ₹250–500/hour (US$2.63–5.26/hour)

    For Basic Excel-Rs 250 Starting Hourly
    For Advanced Excel-Rs 300 Starting Hourly
    For Power BI Basic- Rs 350 Starting Hourly
    For Power BI Advanced- Rs 350 Starting Hourly

Reviews

No reviews yet. Be the first one to review this tutor.

© 2016 - 2026 TeacherOn. All rights reserved