Types of Data
Data Analytics Process
Role of Data Analyst
Business Intelligence Basics
Data Analytics Life Cycle
Excel Interface & Shortcuts
Data Cleaning Techniques
Sorting & Filtering
Conditional Formatting
Pivot Tables & Pivot Charts
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
IF, Nested IF, COUNTIF, SUMIF
Data Validation
Dashboard Creation
Charts & Graphs
Introduction to Databases
DBMS & RDBMS Concepts
SQL Commands
SELECT Statement
WHERE Clause
ORDER BY & GROUP BY
Aggregate Functions
JOINs (INNER, LEFT, RIGHT, FULL)
Subqueries
Views & Indexes
SQL Projects
Python Basics
Variables & Data Types
Operators & Decision Making
Loops & Functions
Lists, Tuples, Dictionaries
NumPy Basics
Pandas for Data Analysis
Data Cleaning using Python
Data Visualization
File Handling
Introduction to Power BI
Power BI Interface
Data Import & Transformation
Power Query Editor
Data Modeling
DAX Functions
Interactive Dashboards
KPI Reports
Charts & Visualizations
Publishing Reports
Mean, Median, Mode
Standard Deviation
Probability Basics
Correlation & Regression
Hypothesis Testing
Data Distribution
Sampling Techniques
