✅ MODULE 1: Data Analytics Fundamentals (Week 1)

Topics

• What is Data Analytics?
• Data Analyst vs Data Scientist vs BI Analyst
• Data lifecycle (Collect → Clean → Analyze → Visualize)
• Types of data (Structured / Unstructured)
• KPI, Metrics, Business objectives
• Analytics use cases (Education, Retail, Marketing)

Practical

• Dataset overview & business questions identify

✅ Mini Task: KPI list for a business (sales/institute)

✅ MODULE 2: Excel for Data Analytics (Week 2–4)

Excel Basics + Productivity

• Excel Interface
• Shortcuts, formatting, tables
• Sorting, filtering, validation
• Data protection & sheet management

Data Cleaning in Excel

• Removing duplicates
• TRIM, CLEAN
• Text to Columns
• Find & Replace
• Conditional formatting

Excel Functions (Core for Analyst)

• Math: SUM, AVERAGE, MIN, MAX
• Logical: IF, IFS, AND, OR
• Lookup: VLOOKUP, XLOOKUP
• Advanced lookup: INDEX + MATCH
• Conditional: SUMIF, COUNTIF, AVERAGEIF
• Text: LEFT, RIGHT, MID, LEN, CONCAT
• Date/Time: TODAY, NOW, DATE, MONTH, YEAR

Pivot & Reporting

• Pivot table
• Pivot charts
• Slicers
• Report formatting (professional report)

Dashboard in Excel

• KPI cards
• Dynamic charts
• Slicer-based dashboard

✅ Project 1: Excel Sales Dashboard

✅ Assignment: 50+ Excel questions

✅ MODULE 3: SQL for Data Analytics (Week 5–8)

Database Basics

• Database, tables, rows, columns
• Primary key & foreign key
• Relationships

SQL Queries (Beginner)

• SELECT, DISTINCT
• WHERE
• ORDER BY
• LIMIT
• IN, BETWEEN, LIKE

Aggregation

• COUNT, SUM, AVG, MIN, MAX
• GROUP BY
• HAVING

Joins (Most Important)

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN

Advanced SQL

• Subqueries
• CASE WHEN
• Views
• Data cleaning with SQL

✅ Project 2: Customer Purchase Analysis (SQL)

✅ Assignment: 100 SQL practice queries

✅ MODULE 4: Statistics for Data Analytics (Week 9–10)

Topics

• Data types (Nominal, Ordinal, Interval, Ratio)
• Mean, Median, Mode
• Variance, Standard deviation
• Outliers detection
• Correlation & covariance
• Probability basics
• Normal distribution concept
• Regression concept (basic)

Practical

• Summary report & interpretation

✅ Mini Project: Correlation report of dataset

✅ MODULE 5: Python for Data Analytics (Week 11–15)

Python Fundamentals

• Variables, operators
• Data types
• Lists, tuples, sets, dict
• Loops (for, while)
• Conditions (if-else)
• Functions
• File handling (CSV basics)

NumPy (Basics)

• Arrays
• Indexing & slicing
• Basic operations

Pandas (Core Analytics)

• Series & DataFrame
• Import data (CSV/Excel)
• Data cleaning
• Missing values (dropna, fillna)
• Duplicate handling
• Type conversion
• Sorting & filtering
• GroupBy
• Merge / Join
• Pivot tables
• Export report (Excel/CSV)

Visualization in Python

• Matplotlib: line, bar, histogram
• Basic chart making for reporting

✅ Project 3: Python Data Cleaning + Analysis

✅ Assignment: 30 datasets tasks

✅ MODULE 6: Power BI (Business Intelligence) (Week 16–20)

Power BI Basics

• Interface overview
• Data import (Excel/CSV)
• Data refresh

Power Query (Data Cleaning)

• Clean & transform
• Split, replace, filter rows
• Remove errors
• Change data types

Data Modeling

• Relationships
• Star schema basics
• Fact & dimension tables

DAX (Most Important)

• Measures vs calculated columns
• SUM, COUNT, AVERAGE
• CALCULATE
• FILTER
• IF
• Date/time measures basics

Visualization & Dashboard

• KPI Cards
• Bar/Line/Donut chart
• Tables & matrix
• Slicer filters
• Drill down
• Tooltip & interactions
• Professional dashboard layout

✅ Project 4: Power BI Sales + Profit Dashboard

✅ MODULE 7: Capstone Projects (Portfolio) (Week 21–23)

(Students minimum 2-3 projects banayenge)

Project Options

1. Retail Sales Analytics Dashboard
2. Student Result & Attendance Analytics
3. Expense Tracker Analytics
4. Marketing Analytics Dashboard
5. Inventory / Shop Analytics Dashboard

✅ Outputs:

• Excel Report
• SQL Query File
• Python Notebook
• Power BI Dashboard

✅ MODULE 8: Job & Interview Preparation (Week 24)

Resume + Portfolio

• Data Analyst Resume (ATS friendly)
• LinkedIn profile setup
• Portfolio making (projects show)

Interview Prep

• Excel interview Q/A
• SQL interview Q/A
• Python interview Q/A
• Power BI interview Q/A
• Case studies + mock interview

✅ Final Test + Viva

🏆 COURSE CERTIFICATION

✅ Certificate in Data Analytics & Business Intelligence

(Excel + SQL + Python + Power BI)