Scribd
Upload
125 views3 pages

Data Analytics 3 Month Roadmap

The document outlines a 3-month roadmap for data analytics training targeting a salary of 10-15 LPA. It includes a structured schedule covering Excel, SQL, Python, and data visualization, with practice days and review sessions integrated. The final month focuses on project work and mock interview preparation to solidify skills and readiness for job applications.

Uploaded by

Divyanshu Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
125 views3 pages

Data Analytics 3 Month Roadmap

The document outlines a 3-month roadmap for data analytics training targeting a salary of 10-15 LPA. It includes a structured schedule covering Excel, SQL, Python, and data visualization, with practice days and review sessions integrated. The final month focuses on project work and mock interview preparation to solidify skills and readiness for job applications.

Uploaded by

Divyanshu Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

3-Month Data Analytics Roadmap (10-15 LPA Target)

Month 1: Excel + SQL Basics


Day 1: Excel: VLOOKUP, HLOOKUP (2 hrs)

-> Formula syntax, exact & approximate match

Day 2: Excel: INDEX, MATCH (2 hrs)

-> Lookup using INDEX-MATCH combo

Day 3: Excel: IF, Nested IF (1.5 hrs)

-> Logical formulas

Day 4: Excel: Pivot Tables basics (2 hrs)

-> Creating, filtering, summarizing data

Day 5: Excel: Data validation, Conditional formatting (1.5 hrs)

-> Restrict data input, highlight data

Day 6: SQL: SELECT, WHERE (2 hrs)

-> Basic queries, filtering data

Day 7: SQL: ORDER BY, DISTINCT (1.5 hrs)

-> Sorting and unique values

Day 8: SQL: Aggregate functions (SUM, COUNT, AVG) (2 hrs)

-> Calculations on data

Day 9: SQL: GROUP BY, HAVING (2 hrs)

-> Grouping and filtering groups

Day 10: SQL: JOIN basics (INNER JOIN) (2 hrs)

-> Combining tables

Day 11: SQL: LEFT JOIN, RIGHT JOIN (2 hrs)

-> Outer joins

Day 12: SQL: Subqueries basics (2 hrs)


-> Nested queries

Day 13: Practice day: Excel + SQL mini mock (3 hrs)

-> Solve questions combining Excel & SQL

Day 14: Review + catch-up (2 hrs)

-> Revise weak areas

Month 2: Advanced SQL + Python Basics


Day 15: SQL: Window functions basics (2 hrs)

-> ROW_NUMBER(), RANK(), etc.

Day 16: SQL: Advanced JOINs, CTEs (2 hrs)

-> Complex queries

Day 17: SQL: Performance tuning basics (1.5 hrs)

-> Indexes, explain plans

Day 18: Python: Basics (variables, data types, loops) (2 hrs)

-> Syntax, simple scripts

Day 19: Python: Functions, modules (2 hrs)

-> Code reuse, organization

Day 20: Python: File I/O, exceptions (1.5 hrs)

-> Reading/writing files, handling errors

Day 21: Python: Pandas basics (2 hrs)

-> DataFrames, reading CSV/Excel

Day 22: Python: Data cleaning basics (2 hrs)

-> Handling missing data, filtering rows

Day 23: Python: Grouping and aggregation with pandas (2 hrs)

-> GroupBy, pivot tables

Day 24: Practice day: SQL + Python mini project (3 hrs)


-> Small data analysis project

Day 25: Review + catch-up (2 hrs)

-> Revise weak areas

Month 3: Visualization + Projects


Day 26: Data Visualization: Matplotlib basics (2 hrs)

-> Plotting charts

Day 27: Data Visualization: Seaborn basics (2 hrs)

-> Statistical plots

Day 28: Dashboard basics (Excel or Python) (2 hrs)

-> Interactive visuals

Day 29: Mini project: End-to-end analysis (3 hrs)

-> Real-world data analysis

Day 30: Mock interview questions practice (3 hrs)

-> Excel + SQL + Python

Day 31: Days 31-60: Repeat cycle (3 hrs/day)

-> Projects + Interview Prep

You might also like