Course description

Course Modules / Syllabus:

1. Introduction to Data Analytics

• What is Data Analysis?

• Types of Data (Structured vs Unstructured)

• Data Analyst vs Data Scientist vs Data Engineer

2. Microsoft Excel for Data Analysis

• Basic to Advanced Excel Functions

• VLOOKUP, HLOOKUP, INDEX-MATCH

• Pivot Tables & Charts

• Dashboards

3. Statistics & Data Interpretation

• Descriptive Statistics

• Probability & Distribution

• Hypothesis Testing

• Correlation & Regression

4. SQL for Data Extraction

• Basics of SQL (MySQL/PostgreSQL)

• SELECT, WHERE, GROUP BY, JOINS

• Creating & Managing Databases

• Real-life SQL Projects

5. Data Visualization with Power BI / Tableau

• Connecting Data Sources

• Creating Interactive Dashboards

• Slicers, Filters, DAX Functions

• Publishing Reports Online

6. Python for Data Analysis (Optional/Advanced)

• Python Basics

• Pandas, NumPy

• Matplotlib & Seaborn for visualization

• Data Cleaning & Exploration

7. Capstone Project & Interview Preparation

• Real-world datasets (sales, finance, HR, marketing)

• Build and present your analysis project

• Resume building, mock interviews, job portal training

What will i learn?