Course Syllabus
What is Data Analytics?
Types of Analytics (Descriptive, Diagnostic, Predictive, Prescriptive)
Applications of Data Analytics
Data Analytics Lifecycle
Data Collection & Sources
Data Cleaning & Preprocessing
Data Wrangling (Python/Pandas/Excel)
Exploratory Data Analysis (EDA)
Excel for Data Analytics
SQL for Data Analysis (Joins, Aggregations, Window Functions)
Python (NumPy, Pandas, Matplotlib, Seaborn)
Power BI / Tableau Basics
Descriptive Statistics
Probability Distributions
Hypothesis Testing
Correlation & Regression Analysis
Principles of Data Visualization
Charts & Graphs in Excel / Python
Interactive Dashboards (Power BI / Tableau)
Storytelling with Data
Introduction to Machine Learning for Analytics
Clustering & Classification Basics
Predictive Modeling
Case Studies
Sales & Marketing Analytics Project
Customer Segmentation Analysis
Financial Data Analysis
End-to-End Data Analytics Capstone