Roadmaps/Data Analyst & Scientist
Data Science100% Free Resources 8โ€“10 Weeks

Data Analyst & Scientist Study Guide

Transform raw data into business intelligence using SQL, Python, Pandas, and exploratory data visualization.

SQLPythonPandas & NumPyTableauStatistics

Step-by-Step Curriculum

Follow each phase in order. Complete the hands-on project before moving to the next.

1

SQL Mastery for Analytics

Aggregations, Window functions, CTEs, Joins, and query optimization on millions of records.

Build to Master: E-Commerce Customer Cohort Retention Analysis

Write complex SQL queries calculating monthly cohort retention, churn rate, and customer lifetime value (LTV).

GitHub Portfolio Deliverables:
SQL scripts with CTEs & window functions
Executive dashboard visualization
Data story report
2

Python Data Wrangling & EDA

Pandas, NumPy, Seaborn, Matplotlib, and statistical hypotheses testing.

Build to Master: Real Estate Market Price Prediction & Insights

Clean messy tabular data, perform exploratory data analysis, and uncover key pricing drivers.

GitHub Portfolio Deliverables:
Jupyter notebook with visual charts
Handling missing values and outliers
Presentation slide deck

Jobs Requiring These Skills

Active opportunities on Role Nest that look for the skills in this roadmap.

View All Jobs โ†’
GitLab

Senior Backend Engineer (Python), Agent Developer: Flow Components

Competitive Market Compensation (Official) โ€ข REMOTE
EBSCO

Product Manager - AI Exchange

Competitive Market Compensation (Official) โ€ข REMOTE