Data Analytics Workshop & Excel & Power BI Basics by Neha Mahajan

The Beginner Data Analytics Workshop is a 2-hour intensive online program designed for students and working professionals who want to gain a foundational understanding of data analytics. This workshop introduces participants to the core concepts of analytics and provides hands-on exposure to essential tools like Microsoft Excel and Power BI.

The session is ideal for beginners with little or no prior experience in analytics who wish to develop practical skills quickly and understand how data can drive real-world decision-making.

What Participants Will Learn

Participants will gain practical skills in key areas of data analytics, including:

• Fundamentals of Data Analytics: Understanding analytics concepts, workflows, and real-world applications

• Excel for Analytics:

  • Data cleaning and preparation

  • Pivot Tables for data summarization

  • Basic formulas and functions like VLOOKUP

  • Creating interactive Excel dashboards

• Power BI Basics:

  • Introduction to Power BI interface and features

  • Building a simple interactive dashboard

  • Understanding visual storytelling and data presentation

The workshop emphasizes hands-on exercises so participants can immediately apply what they learn.

Teaching Method

This is a fully online live workshop, combining theory, demonstration, and interactive exercises.

Features include:

• Live walkthroughs of Excel and Power BI

• Practical examples using real-world datasets

• Step-by-step guidance on dashboard creation

• Interactive Q&A for doubt clarification

• Focus on skill application rather than theory-heavy content

The concise, hands-on format ensures participants gain confidence and practical knowledge in a short time.

Why This Tutor

Neha Mahajan follows a practical, learner-focused teaching style, emphasizing hands-on exercises and real-world applications. The workshop is structured to help beginners quickly understand analytics concepts and use tools efficiently without prior experience.

Location Context

Being an online workshop, learners can participate from any city or region, making it accessible and convenient for students and professionals alike.

Benefits / Outcomes

By the end of this workshop, participants will be able to:

• Understand the fundamentals of data analytics and its applications

• Clean and manipulate data using Excel

• Summarize and visualize data using Pivot Tables and basic formulas

• Build a simple interactive dashboard in Power BI

• Gain confidence to explore further analytics learning and tools

This workshop serves as a foundation for future learning in data analytics, business intelligence, and reporting roles.