Module 1: Advanced Excel

• Excel Interface & Shortcuts

• Basic Formulas (SUM, IF, VLOOKUP, XLOOKUP)

• Pivot Table & Pivot Chart

• Conditional Formatting

• Data Cleaning Techniques

• Dashboard in Excel

• MIS Report Creation

Module 2: SQL (Microsoft SQL Server)

• Database & Table Creation

• SELECT, WHERE, GROUP BY, ORDER BY

• JOIN (Inner, Left)

• Aggregate Functions

• Subquery Basics

• Sales Database Practice

Module 3: Python for Data Analysis

• Python Basics

• Data Types & Variables

• Lists & Dictionary

• Pandas Introduction

• Data Cleaning using Pandas

• GroupBy & Filtering

• Basic Visualization (Matplotlib)

• CSV & Excel File Handling

Module 4: Power BI

• Data Import (Excel, SQL)

• Power Query (Data Cleaning)

• Data Modeling

• DAX Basics

• Measures & Calculated Columns

• Charts & Visuals

• Slicers & Filters

• Interactive Dashboard

• Report Publishing

Module 5: Integration & Projects

• Sales Analysis Dashboard

• Student Performance Report

• HR Analytics Report

• E-commerce Analysis