Stage 12 to 3 weeks
Spreadsheets & Excel
- Formulas & functions
- Pivot tables
- Charts & visualization
- Data cleaning in Excel
- VLOOKUP / INDEX-MATCH
Data Analysis
Turn raw numbers into decisions that actually matter.
Medium4 to 6 monthsanalyze
Progress
Your Progress0%
Overview
Data analysts collect, clean, and interpret data to help organizations make informed decisions. You work with spreadsheets, SQL, Python, and visualization tools to find patterns and tell stories with data.
Who is this for?
- ✓ Students starting from zero who want structure
- ✓ Self-taught learners who need a clear path
- ✓ Career switchers ready to commit consistently
What can you build?
- Business dashboards
- Sales performance reports
- Customer behavior analyses
- Financial forecasting models
Jobs you can get
Data AnalystBusiness Intelligence AnalystReporting AnalystOperations Analyst
Salary range: $45,000 to $100,000/year
Roadmap
Follow each stage in order. Mark stages complete as you finish them.
- Stage 24 to 5 weeks
SQL Fundamentals
- SELECT, WHERE, ORDER BY
- Aggregations: COUNT, SUM, AVG
- JOINs: INNER, LEFT, RIGHT
- Subqueries and CTEs
- Window functions
- Stage 35 to 6 weeks
Python for Data
- Pandas: data manipulation
- NumPy: numerical operations
- Matplotlib & Seaborn
- Handling missing data
- Merging and reshaping data
- Stage 43 to 4 weeks
BI & Visualization Tools
- Power BI fundamentals
- Tableau Public
- Google Looker Studio
- Dashboard design principles
- Stage 52 to 3 weeks
Statistics Basics
- Mean, median, mode
- Standard deviation
- Correlation vs causation
- Basic hypothesis testing
Resources
Excel Full Course
FREEMaster Excel for data analysis, formulas, pivot tables, charts, power query.
www.youtube.com/watch?v=Vl0H-qTclOg
SQL Full Course
FREEComplete SQL covering everything from SELECT to window functions.
www.youtube.com/watch?v=HXV3zeQKqGY
SQLZoo
FREEInteractive SQL practice. The best place to drill queries until they feel natural.
sqlzoo.net
Select Star SQL
FREEInteractive SQL book. Best way to learn SQL for real analytical queries.
selectstarsql.com
Pandas Full Course
FREELearn Python Pandas, loading, cleaning, transforming, and analyzing data.
www.youtube.com/watch?v=vmEHCJofslg
Kaggle Learn
FREEFree micro-courses on Python, Pandas, SQL, and data viz. Highly practical.
www.kaggle.com/learn
Kaggle Notebook Example
FREEExplore Kaggle getting started notebooks and see data analysis done by experts.
www.kaggle.com/learn-forum
Kaggle Datasets
FREEThousands of free datasets to practice on. Download and analyze anything.
www.kaggle.com/datasets
Power BI Full Course
FREEComplete Power BI course, connect data and build interactive reports.
www.youtube.com/watch?v=TmhQCQr_DCA
Khan Academy Statistics
FREEComplete free course on statistics and probability, from basics to hypothesis testing, with practice exercises.
www.khanacademy.org/math/statistics-probability
StatQuest Statistics
FREEYouTube channel covering statistics fundamentals with clear, visual explanations. Mean, variance, p-values, and more.
statquest.org/video_index.html
Projects
beginner
#01
Sales Dashboard
Analyze a sales dataset and build an interactive dashboard with KPIs.
#02
SQL Dataset Analysis
Download a Kaggle dataset, write 15+ SQL queries, and document insights.
intermediate
#01
Student Performance Analysis
Analyze academic dataset with Pandas: trends, outliers, correlations.
#02
Financial Report Dashboard
Build a Tableau Public dashboard from a financial CSV dataset.
AI Guide
What AI helps with
- ✓ Writing SQL queries from plain English
- ✓ Explaining dataset columns
- ✓ Suggesting chart types
- ✓ Writing Pandas cleaning scripts
- ✓ Interpreting statistical results
What AI cannot replace
- ✗ Interpreting business context it does not know
- ✗ Replacing statistical understanding
- ✗ Making business decisions, that is your job
Recommended Tools
ChatGPT Code Interpreter
Upload CSVs and ask AI to analyze and chart them
Julius AI
Dedicated data analysis AI with chart generation
Claude
SQL generation, Pandas scripts, insight interpretation
Sample Prompts
Write a SQL query that finds the top 10 customers by total order value in the past 6 months, grouped by region. Schema: orders(id, customer_id, amount, date, region).I have a Pandas DataFrame with a "date" column stored as strings in dd/mm/yyyy format. Write code to convert it to datetime, extract month and year, and create a monthly sales summary by product category.Career Path
Data AnalystBusiness Intelligence AnalystReporting AnalystOperations Analyst
$45,000 to $100,000/year
Domain knowledge multiplies your value. A data analyst who understands finance, healthcare, or logistics is far more valuable than one who only knows SQL.