Module 1: Fundamentals of Data Analytics

• Introduction to Data Analytics
• What is Data Analysis?
• Types of Data Analytics
• Data Analyst Roles & Responsibilities
• Data Collection and Data Processing
• Data Cleaning and Data Preparation
• Data Analysis Life Cycle
• Introduction to Business Intelligence

Module 2: MS Excel & Advanced Excel

• Introduction to MS Excel
• Workbook and Worksheet Management
• Data Entry and Formatting
• Basic Mathematical Functions
• Logical Functions (IF, AND, OR)
• Text and Date Functions
• VLOOKUP, HLOOKUP and XLOOKUP
• INDEX and MATCH Functions
• SUMIF, COUNTIF and AVERAGEIF
• Sorting and Filtering
• Conditional Formatting
• Data Validation
• Pivot Tables and Pivot Charts
• Advanced Excel Dashboard
• Data Analysis Using Excel

Module 3: SQL & Database Management

• Introduction to Database Management
• Introduction to SQL
• Database and Table Creation
• Data Types and Constraints
• SELECT, INSERT, UPDATE and DELETE
• WHERE, ORDER BY and GROUP BY
• Aggregate Functions
• DISTINCT and BETWEEN
• JOINS (INNER, LEFT, RIGHT, FULL)
• Subqueries
• Primary Key and Foreign Key
• SQL Views
• Practical Database Projects

Module 4: Python Programming

• Introduction to Python
• Installation and Setup
• Variables and Data Types
• Operators and Expressions
• Conditional Statements
• Loops (For and While)
• Functions
• Lists, Tuples, Sets and Dictionaries
• String Operations
• File Handling
• Exception Handling
• Introduction to NumPy
• Introduction to Pandas
• Data Analysis Using Python

Module 5: Data Cleaning & Data Processing

• Introduction to Data Cleaning
• Handling Missing Values
• Removing Duplicate Records
• Data Transformation
• Data Formatting
• Data Filtering and Sorting
• Data Merging and Joining
• Data Manipulation Using Pandas
• Data Quality Checking

Module 6: Statistics for Data Analytics

• Introduction to Statistics
• Types of Data
• Mean, Median and Mode
• Percentage and Ratio
• Probability
• Variance and Standard Deviation
• Correlation and Regression
• Sampling Techniques
• Hypothesis Testing Basics
• Data Interpretation

Module 7: Power BI & Data Visualization

• Introduction to Power BI
• Power BI Desktop Installation
• Connecting Different Data Sources
• Importing Excel and SQL Data
• Power Query Editor
• Data Transformation
• Data Modelling
• Relationships Between Tables
• DAX Functions
• Calculated Columns and Measures
• Charts, Graphs and Maps
• Interactive Reports
• Dashboard Development
• Publishing and Sharing Reports

Module 8: Tableau

• Introduction to Tableau
• Connecting Data Sources
• Dimensions and Measures
• Charts and Graphs
• Filters and Sorting
• Calculated Fields
• Data Visualization Techniques
• Interactive Dashboards
• Reports and Story Creation

Module 9: Practical Training & Live Projects

• Sales Data Analysis Project
• Student Performance Analysis
• Employee Attendance Analysis
• Customer Data Analysis
• Financial Data Analysis
• Business Performance Dashboard
• Excel-Based MIS Reporting
• SQL Database Analysis
• Python Data Analysis Project
• Power BI Dashboard Project

Module 10: Interview & Career Preparation

• Resume Preparation
• Data Analyst Interview Questions
• Practical Test Preparation
• Portfolio Development
• Communication Skills
• Job Search Techniques
• Industry-Based Case Studies