3-week Data Analyst Roadmap (with SQL focus)
🎯 Goal: By Day 21, you will be able to:
● Write complex SQL queries
● Analyze and visualize data
● Create reports and dashboards
● Work with real-world datasets
● Be job-ready for an entry-level data analyst role
Week Focus Area Topics Covered
SELECT, WHERE, ORDER BY,
Week 1 SQL Basics + Excel for Data
basic formulas
Week 2 Intermediate SQL + Joins GROUP BY, JOINs, subqueries
Window functions, CTEs, Case
Week 3 Advanced SQL + Real Data
statements
🧠 Week 1: SQL Basics + Excel for Data
Day 1-2:
● What is SQL & RDBMS
● SELECT, FROM, WHERE, FILTERING, SORTING, ORDER BY
● Operators: =, >, <, BETWEEN, IN, LIKE
Day 3-4:
● ORDER BY, LIMIT
● Aliases, DISTINCT
● Practice: Filter and sort sample data
Day 5-6:
● Excel basics: Formulas, sorting, filtering
● Functions: VLOOKUP, IF, COUNTIF, SUMIF,XLOOKUP,INDEX+MATCH
Day 7:
● Project: Basic Excel dashboard (sales, students, etc.)
● Recap Quiz (SQL + Excel)
,🧠 Week 2: Intermediate SQL + Joins
Day 8-9:
● GROUP BY, HAVING
● PROPER(),UPPER(),LOWER(),Remove Duplicates,TRIM(),CLEAN(),Text to
Columns,Data Validation,Find & Replace
● Aggregates: COUNT(), SUM(), AVG(), MIN(),MAX()
Day 10-11:
● INNER JOIN, LEFT JOIN, RIGHT JOIN. FULL OUTER JOIN (if supported)
● Practice combining multiple tables
Day 12:
● Nested Queries (Subqueries)
● Practice: Analyze orders/customers dataset
🧠 Week 3: Advanced SQL + Real-World Data
Day 13-14:
● UNION, CASE, RANK,EXCEPT / MINUS, INTERSECT (May not be supported in all
DBs) and CTE
Day 15-16:
● NOT,IS NOT NULL,IF NULL, COALESCE
● Data cleaning with SQL
Day 17-18:
● Window functions:LEAD(), LAG()
● DELETE, FIND AND REPLACE
Day 19, 20 & 21:
● Recap & Quiz
● Assignment: Use advanced queries on large dataset
● Mini Project: Sales or ecommerce database analysis
● Assignment: Write queries to find top products, customers, revenue by region
,🧰 Tools Needed:
● MySQL / PostgreSQL (free)
● Excel / Google Sheets
● Notion/Google Docs (to take notes and track progress)
📅 Day 1: Introduction to SQL + Basic SELECT & WHERE
✅ Objectives:
● Understand what SQL is and how it's used.
● Learn to retrieve data using SELECT, FROM, and WHERE.
● Practice writing basic queries.
🔍 What is SQL?
SQL (Structured Query Language) is used to communicate with databases. It allows you to:
● Extract specific data from large datasets
● Filter, sort, and summarize data
● Combine data from different tables
● Perform calculations, aggregations, and more
💡 SQL is essential for Data Analysts, BI Developers, and Data Scientists.
🧱 SQL Syntax Basics
▶️ 1. SELECT Statement
Used to retrieve data from a table.
SELECT column1, column2
FROM table_name;
, ▶️ 2. WHERE Clause
Filters rows based on a condition.
SELECT column1, column2
FROM table_name
WHERE condition;
🧪 Example Table: employees
id name department salary
1 Riya Sales 40000
2 Arjun HR 35000
3 Meena Sales 42000
4 Ravi IT 50000
5 Priya HR 36000
🎯 Goal: By Day 21, you will be able to:
● Write complex SQL queries
● Analyze and visualize data
● Create reports and dashboards
● Work with real-world datasets
● Be job-ready for an entry-level data analyst role
Week Focus Area Topics Covered
SELECT, WHERE, ORDER BY,
Week 1 SQL Basics + Excel for Data
basic formulas
Week 2 Intermediate SQL + Joins GROUP BY, JOINs, subqueries
Window functions, CTEs, Case
Week 3 Advanced SQL + Real Data
statements
🧠 Week 1: SQL Basics + Excel for Data
Day 1-2:
● What is SQL & RDBMS
● SELECT, FROM, WHERE, FILTERING, SORTING, ORDER BY
● Operators: =, >, <, BETWEEN, IN, LIKE
Day 3-4:
● ORDER BY, LIMIT
● Aliases, DISTINCT
● Practice: Filter and sort sample data
Day 5-6:
● Excel basics: Formulas, sorting, filtering
● Functions: VLOOKUP, IF, COUNTIF, SUMIF,XLOOKUP,INDEX+MATCH
Day 7:
● Project: Basic Excel dashboard (sales, students, etc.)
● Recap Quiz (SQL + Excel)
,🧠 Week 2: Intermediate SQL + Joins
Day 8-9:
● GROUP BY, HAVING
● PROPER(),UPPER(),LOWER(),Remove Duplicates,TRIM(),CLEAN(),Text to
Columns,Data Validation,Find & Replace
● Aggregates: COUNT(), SUM(), AVG(), MIN(),MAX()
Day 10-11:
● INNER JOIN, LEFT JOIN, RIGHT JOIN. FULL OUTER JOIN (if supported)
● Practice combining multiple tables
Day 12:
● Nested Queries (Subqueries)
● Practice: Analyze orders/customers dataset
🧠 Week 3: Advanced SQL + Real-World Data
Day 13-14:
● UNION, CASE, RANK,EXCEPT / MINUS, INTERSECT (May not be supported in all
DBs) and CTE
Day 15-16:
● NOT,IS NOT NULL,IF NULL, COALESCE
● Data cleaning with SQL
Day 17-18:
● Window functions:LEAD(), LAG()
● DELETE, FIND AND REPLACE
Day 19, 20 & 21:
● Recap & Quiz
● Assignment: Use advanced queries on large dataset
● Mini Project: Sales or ecommerce database analysis
● Assignment: Write queries to find top products, customers, revenue by region
,🧰 Tools Needed:
● MySQL / PostgreSQL (free)
● Excel / Google Sheets
● Notion/Google Docs (to take notes and track progress)
📅 Day 1: Introduction to SQL + Basic SELECT & WHERE
✅ Objectives:
● Understand what SQL is and how it's used.
● Learn to retrieve data using SELECT, FROM, and WHERE.
● Practice writing basic queries.
🔍 What is SQL?
SQL (Structured Query Language) is used to communicate with databases. It allows you to:
● Extract specific data from large datasets
● Filter, sort, and summarize data
● Combine data from different tables
● Perform calculations, aggregations, and more
💡 SQL is essential for Data Analysts, BI Developers, and Data Scientists.
🧱 SQL Syntax Basics
▶️ 1. SELECT Statement
Used to retrieve data from a table.
SELECT column1, column2
FROM table_name;
, ▶️ 2. WHERE Clause
Filters rows based on a condition.
SELECT column1, column2
FROM table_name
WHERE condition;
🧪 Example Table: employees
id name department salary
1 Riya Sales 40000
2 Arjun HR 35000
3 Meena Sales 42000
4 Ravi IT 50000
5 Priya HR 36000
