Data Analysis
Learn Python, Excel, Data Analysis, Power BI, and real-world project implementation.
Module 1
Introduction to Data Analysis
- Data Analysis Fundamentals
- Data Analysis Lifecycle
- Types of Data and Data Sources
- Data Cleaning and Preprocessing
- Industry Applications and Career Roles
Module 2
Microsoft Excel
- Excel Formulas and Functions
- Sorting, Filtering, and Data Cleaning
- Lookup Functions: VLOOKUP, XLOOKUP, INDEX-MATCH
- PivotTables and PivotCharts
- Interactive Excel Dashboards
Module 3
SQL for Data Analysis
- Database Fundamentals and MySQL
- SELECT, WHERE, ORDER BY, GROUP BY
- Aggregate Functions and CASE Statements
- Joins, Subqueries, and CTEs
- Business Data Queries and Reporting
Module 4
Python for Data Analysis
- Python Programming Fundamentals
- NumPy Arrays and Operations
- Pandas Series and DataFrames
- CSV, Excel, and JSON Handling
- Data Filtering, Grouping, and Merging
- Missing Values and Data Cleaning
Module 5
Statistics, EDA & Data Visualization
- Mean, Median, Mode, Variance, and Standard Deviation
- Exploratory Data Analysis (EDA)
- Outliers and Correlation Analysis
- Matplotlib and Seaborn
- Charts, Heatmaps, and Data Insights
Module 6
Microsoft Power BI
- Data Import and Power Query
- Data Transformation and Data Modelling
- DAX Measures and Calculated Columns
- Interactive Charts, Filters, and Slicers
- Business Intelligence Dashboards and Reporting
Module 7
Projects & Career Preparation
- Student Performance Analysis
- Sales Data Analysis
- Interactive Power BI Dashboard
- End-to-End Industry Capstone Project
- Portfolio, Resume, and Interview Preparation