Full syllabus

Beginner

Excel & Google Sheets Basics

  1. Cells, Formulas & Core Functions
  2. Lookups & Pivot Tables
  3. Cleaning Data & Basic Charts

Statistics Basics for Analysts

  1. Descriptive Statistics
  2. Distributions, Sampling & Correlation

SQL Basics

  1. Databases, Tables & Your First Query
  2. Aggregations, GROUP BY & HAVING

Intermediate

SQL Intermediate: Joins, Subqueries & Window Functions

  1. Joins
  2. Subqueries, CTEs & CASE
  3. Window Functions

Python Basics & pandas

  1. Python Basics
  2. pandas DataFrames
  3. Cleaning, groupby & Merging in pandas

Visualisation & BI Tools

  1. Visualisation Principles
  2. Power BI, Tableau & Looker Studio

Advanced

Business Metrics, Storytelling & Dashboards

  1. Business Metrics & KPIs
  2. A/B Testing Basics
  3. Data Storytelling & Dashboard Design

Practice & Interview Prep

  1. SQL Interview Rounds
  2. Case & Guesstimate Questions
  3. Building an Analyst Portfolio