Excel & Power BI for Data Analytics and Business Intelligence Course by Sonali Kamalapurkar

This Excel and Power BI online training course is designed for learners who want to build practical skills in data analytics and business intelligence using industry-relevant tools. Conducted by Sonali Kamalapurkar, the course focuses on helping students understand how data is organized, analyzed, visualized, and presented for decision-making. The program covers Microsoft Excel, Power BI, and includes a bonus introduction to basic statistics, making it suitable for beginners as well as working professionals who want to strengthen their analytical foundation. Classes are conducted fully online, allowing flexible and convenient learning.

What Students Will Learn

Microsoft Excel for Data Analysis

• Understanding Excel interface and worksheets

• Data entry, formatting, and data cleaning techniques

• Use of formulas and functions for analysis

• Logical, text, and lookup functions

• Sorting, filtering, and data validation

• Pivot tables and pivot charts for data summarization

• Creating professional reports and dashboards in Excel

Power BI – Business Intelligence Tool

• Introduction to Power BI and BI concepts

• Importing data from Excel and other sources

• Data transformation and modeling basics

• Creating relationships between tables

• Building interactive dashboards and reports

• Visualizations such as charts, tables, slicers, and cards

• Understanding Power BI reports for business insights

Basic Statistics (Bonus Module)

• Introduction to statistics for data analysis

• Measures of central tendency (mean, median, mode)

• Basic understanding of data distribution

• Practical relevance of statistics in Excel and Power BI analysis

Teaching Method

• Mode: Online live classes

• Tool-based, hands-on teaching approach

• Step-by-step explanation of concepts

• Live demonstrations using Excel and Power BI

• Regular doubt-clearing during and after sessions

• Flexible pace adjusted to learner convenience

• Practical examples to explain real-world data scenarios

Why This Tutor

Sonali Kamalapurkar focuses on clarity-driven and application-oriented teaching, ensuring learners understand not just the tools, but also how and why they are used in data analytics. The course is structured to support beginners while gradually introducing more analytical thinking, making it accessible to learners from non-technical backgrounds as well.

Benefits / Outcomes

• Strong working knowledge of MS Excel for data analysis

• Ability to create interactive dashboards using Power BI

• Better understanding of data-driven decision-making

• Improved confidence in handling datasets

• Foundational statistical knowledge to support analytics work

• Practical skills useful for academics, office work, and entry-level analytics roles