Module 1: Foundations of Data Analytics

• What is Data Analytics?

• Analytics vs Data Science vs BI

• Data analytics lifecycle

• Roles and career paths in analytics

Module 2: Excel for Data Analysis

• Excel formulas, functions & pivot tables

• Data cleaning and transformation

• Charts, graphs & conditional formatting

• Using Excel for quick reporting

Module 3: SQL for Data Extraction (MySQL)

• Introduction to relational databases

• SQL queries: SELECT, WHERE, GROUP BY

• JOINs, subqueries, and aggregations

• Creating and managing tables

• Hands-on querying of real datasets

Module 4: Data Visualization with Power BI

• Power BI interface and data sources

• Data modeling with Power Query

• DAX functions for calculations

• Visualizations: bar, line, pie, maps

• Building and sharing dashboards

Module 5: Data Visualization with Tableau

• Tableau Desktop basics

• Connecting to multiple data sources

• Creating visualizations and stories

• Filters, parameters, and interactivity

• Dashboard publishing and sharing

Module 6: Real-Time Analytics Projects

• Project 1: Sales Performance Dashboard (Power BI)

• Project 2: Customer Insights Report (Tableau)

• Project 3: Data Query & Summary Analysis (SQL)

• Final presentation and business storytelling

Module 7: Career Preparation

• Resume and portfolio building

• Analytics interview Q&A

• Certification prep (Power BI/Tableau/SQL)