Role of a Data Analyst
Types of Analytics (Descriptive, Diagnostic, Predictive, Prescriptive)
Data Analytics Lifecycle
Business Problems vs Data Problems
Key Metrics & KPIs
Introduction to Data-Driven Decision Making
Excel Interface & Shortcuts
Data Cleaning & Formatting
Formulas & Functions (VLOOKUP/XLOOKUP, IF, COUNT, SUMIFS)
Pivot Tables & Pivot Charts
Conditional Formatting
Data Validation
Excel Dashboards
Project: Sales / Business Dashboard in Excel
Database Basics
SQL Syntax & Queries
Filtering, Sorting & Aggregation
Joins (INNER, LEFT, RIGHT, FULL)
Subqueries & CTEs
Window Functions
Performance Optimization Basics
Project: Analytical Queries on Business Data
Descriptive Statistics
Probability Concepts
Data Distributions
Hypothesis Testing
Correlation & Regression Basics
A/B Testing Concepts
Business Use Cases of Statistics
Python Basics for Analysts
NumPy Fundamentals
Pandas for Data Manipulation
Data Cleaning & Wrangling
Handling Missing & Duplicate Data
Exploratory Data Analysis (EDA)
Project: Data Analysis with Python
Principles of Data Visualization
Charts & Graph Selection
Data Storytelling
Visualization using Python (Matplotlib, Seaborn)
Interactive Visuals Basics
Best Practices & Design Standards
Introduction to BI Tools
Power BI / Tableau Interface
Data Modeling
Measures & Calculated Fields
DAX / Tableau Calculations
Interactive Dashboards
Project: BI Dashboard Development
Data Quality Dimensions
Data Profiling
Outlier Detection
Data Transformation Techniques
Handling Large Datasets
Data Validation Rules
Complex Joins & Nested Queries
Window Functions (Advanced)
Time-Series Analysis in SQL
Analytical Case Studies
Query Optimization for Analytics
Sales Analytics
Marketing Analytics
Finance & Revenue Analysis
Customer & Product Analytics
Operations Analytics
KPI Design & Reporting
End-to-End Data Analysis Project
Business Problem Understanding
Data Cleaning & Analysis
Dashboard Creation
Insight Presentation
Stakeholder Reporting
Data Analyst Resume Building
Portfolio & GitHub Setup
SQL Interview Questions
Excel & BI Interview Prep
Case Study Interviews
Mock Interviews
Industry Best Practices