AI & Data
FreeSpreadsheets for Data Analysis
Turn messy spreadsheet data into clean tables, summaries, and charts using Excel and Google Sheets.
Beginner · 13 lessons · 7 hours · English + Urdu
AI & Data
Data Analyst Roadmap
Turn raw data into decisions with spreadsheets, SQL, Python and dashboards.
16 weeks at ~2 hours/day · Beginner · 7 skills · Free
In short
A data analyst turns raw numbers — sales, users, operations — into answers a business can act on. This roadmap teaches the analyst's toolkit in order: spreadsheets first, then SQL, then Python for data, then dashboards and storytelling with data, in about 16 weeks at two hours a day, using real-style datasets throughout.
Who this roadmap is for
- Beginners who like working with numbers and want a data career
- Office/admin staff who want to move into analyst roles
- Students preparing for data internships
Prerequisites
- No programming experience needed
- Comfortable with basic school maths and a computer
- About 2 hours a day for practice
Your week-by-week plan
Weeks 1–4
Spreadsheets like an analyst
- Formulas, pivot tables and lookups
- Cleaning messy data
- Charts that answer questions
Project: Analyse a messy sales dataset end-to-end
Weeks 5–8
SQL for data
- SELECT, WHERE, JOIN and GROUP BY
- Answering business questions with queries
- Working with a real database
Project: Ten business questions answered in SQL
Weeks 9–12
Python for data analysis
- pandas for cleaning and analysis
- Faster, repeatable analysis
- Better charts with Python
Project: A complete analysis notebook
Weeks 13–16
Dashboards & storytelling
- Building clear dashboards
- Presenting findings, not just numbers
- Portfolio and interview practice
Project: An interactive dashboard with a written report
Courses in this roadmap
AI & Data
FreeSQL & Data Visualization
Ask questions of real databases with SQL, then turn the answers into clear dashboards and charts.
Intermediate · 12 lessons · 9 hours · English
Projects you will build
- Sales dataset analysis in spreadsheets
- SQL business-questions portfolio
- Python analysis notebook
- Interactive dashboard + report
Skills you will gain
- Spreadsheets (Excel / Sheets)
- Data Cleaning
- SQL
- Python for Data (pandas)
- Data Visualisation
- Dashboards
- Data Storytelling
Frequently asked questions
Do data analysts need to know programming?
They need some. Spreadsheets and SQL cover much of daily analyst work, and Python makes you faster and opens better roles. This roadmap introduces them in that order, so nothing feels like a jump.
How is a data analyst different from a data scientist?
Analysts focus on understanding what happened and what a business should do next, using data from existing systems. Data scientists build predictive models and need deeper statistics and ML. Analyst is the common entry point into data careers.
Which tool should I learn first: Excel or SQL?
Spreadsheets first — they teach you how data is structured and cleaned, and every company uses them. SQL comes right after, in weeks 5–8, once data thinking is in place.
What will my portfolio look like after this roadmap?
Four finished pieces: a spreadsheet analysis, a set of answered SQL business questions, a Python analysis notebook, and an interactive dashboard with a short report — exactly what hiring managers ask to see.
Related roadmaps
- Python + AI/ML Beginner Roadmap — Learn Python from zero and take your first steps into AI and machine learning.