StudyNest AcademyCampus
Open Curricula & Engineering Roadmaps
Roadmaps & Cohorts/Data Analyst & Scientist
Data Science100% Free Open Curriculum 8–10 Weeks

Data Analyst & Scientist Career Guide

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

SQLPythonPandas & NumPyTableauStatistics
⚡ 8-Week Actionable Sprint Track

Interactive Sprint Milestones & DevScore

Check off weekly milestones as you build deliverables. Each checked milestone boosts your candidate DevScore (+30 XP) on StudyNest Academy.

Sprint Progress
0/24(0%)
DevScore XP
+0 XP
Week 1 Objective

Window Functions, CTEs & Aggregations

Master window functions (ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, NTILE) over partitioned data+30 XP
Deliverable: window_functions_suite.sql (6h)
Write complex multi-level Common Table Expressions (CTEs) for hierarchical organizational data+30 XP
Deliverable: recursive_cte_analysis.sql (5h)
Optimize SQL joins and aggregations on datasets with 10M+ rows using indexing and partitioning+30 XP
Deliverable: query_optimization_log.sql (5h)
Sprint completions count directly toward your candidate DevScore.
Inspect In Interactive Course Canvas

In-Depth Curriculum & Video Masterclasses

Curated step-by-step guides with zero paid subscriptions. Complete the hands-on project before advancing.

1

SQL Mastery for Analytics

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

Curated Free Courses & Guides:
Mode AnalyticsTop Pick

Mode Analytics SQL Tutorial for Data Analysis

Interactive • ~15h100% Free
SQLZoo

SQLZoo Interactive Exercises

Interactive • ~10h100% Free
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.

Curated Free Courses & Guides:
KaggleHands-on Certificates

Kaggle Learn: Python, Pandas & Data Visualization

Interactive • ~20h100% Free
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
Industry Skill Alignment

Live Industry Roles Requiring Data Analyst & Scientist Skills

Industry hiring requirements matching these curriculum milestones. Master these nodes to pass screening.

Explore Visual Course Canvas
Dealer TireTarget Role Profile

Associate Data Scientist

Competitive Market Compensation (Official)REMOTERemote, Global
PythonMachine LearningPyTorch
StudyNest Skill Match
StripeTarget Role Profile

Fraud Architect

Competitive Market Compensation (Official)REMOTERemote, Global
TypeScriptPythonSQL
StudyNest Skill Match
RazorpayTarget Role Profile

Senior Software Development Engineer

Competitive Market Compensation (Official)ON_SITEGurugram, Haryana, India
TypeScriptPythonSQL
StudyNest Skill Match
Opinov8Target Role Profile

Senior Software Engineer (Node.js/Python)

Competitive Global Standard (Official)REMOTERemote, India
TypeScriptPythonNode.js
StudyNest Skill Match