Module 1: Excel

Topics Covered:

Introduction to Excel

Basic & Advanced Excel Formulas

Creating Professional Reports

Module 2: SQL

Topics Covered:

Introduction to Data and Databases

SQL Categories (DDL)

SQL Statements (DML & DCL)

SQL Variants (CRUD Operations)

Filtering and Sorting Data

Aggregate Functions and Joins

Subqueries and Views

Query Optimization Basics

Hands-on SQL Practice with Business Data

Module 3: Introduction to Data Analytics

Topics Covered:

What is Data Analytics?

Types of Data & Analytics

Analytics Lifecycle Overview

Real-world Applications & Use Cases

Basic Statistics for Data Analytics

Module 4: Data Collection & Cleaning

Topics Covered:

Understanding Data Sources

Web Scraping Fundamentals

No-Code Data Cleaning Methods

Handling Missing Data & Duplicates

Data Preparation using Excel

Module 5: Python for Analytics

Topics Covered:

Python Basics for Data Analysis

Data Structures: Lists, Dictionaries, Tuples

Introduction to NumPy

Data Manipulation with Pandas

Exploratory Data Analysis (EDA)

Data Cleaning using Pandas

Mini Project in Python

Module 6: Data Visualization

Topics Covered:

Fundamentals of Data Visualization

Principles of Designing Effective Dashboards

Creating Graphs using Matplotlib & Seaborn

Module 7: Tableau

Topics Covered:

Introduction to Tableau

Working with Groups, Sets, Parameters & Filters

Building Interactive Dashboards

Module 8: Power BI

Topics Covered:

Introduction to Power BI

Data Loading & Data Modeling

Data Cleaning with Power Query

Visualizations & Dashboard Building

Power BI Service & Publishing Workflows

Module 9: Statistical Analysis

Topics Covered:

Descriptive Statistics

Probability Concepts