You Don't Need to Spend $15,000
Every day, someone asks: "Should I pay for a data analytics bootcamp?"
And every day, my answer is the same: "Try the free stuff first."
Because here's the truth: the skills you need to become a data analyst are available for free (or very cheap) online. The challenge isn't access to information—it's knowing which resources are actually good and in what order to use them.
This guide solves that. I've organized the best free resources by skill, from complete beginner to job-ready, so you can build a structured learning path without paying for an overpriced bootcamp.
SQL: The Most Important Skill
80% of data analyst work is writing SQL queries. Start here.
For Complete Beginners
SQLBolt (sqlbolt.com)
Time: 10-15 hours
Interactive lessons that teach you by doing. No setup required—you write queries in the browser and get instant feedback.
Covers: SELECT, WHERE, JOINs, GROUP BY, all the fundamentals
Why it's good: Clean interface, logical progression, hands-on from lesson one
When to use: Day 1 of your SQL learning
Mode SQL Tutorial (mode.com/sql-tutorial)
Time: 15-20 hours
More advanced than SQLBolt. Uses real datasets and business scenarios.
Covers: Aggregations, JOINs, subqueries, window functions, date manipulation
Why it's good: Real-world context, intermediate/advanced topics, built for analysts (not engineers)
When to use: After you've finished SQLBolt
W3Schools SQL (w3schools.com/sql)
Time: Reference, not a course
Good for quick lookups when you forget syntax.
Covers: Everything, but not in a structured curriculum
Why it's good: Fast, searchable, tons of examples
When to use: When you need to remember how CASE WHEN works or what LEFT JOIN does
For Practice
LeetCode SQL (leetcode.com/problemset/database)
Time: Ongoing
Coding challenge platform with 200+ SQL problems, ranging from easy to hard.
Free tier: ~50 problems
Premium ($35/month): All problems + solutions
Why it's good: Prepares you for interview questions, forces you to think algorithmically
When to use: After Mode tutorial, when you're applying to jobs
HackerRank SQL (hackerrank.com/domains/sql)
Time: Ongoing
Similar to LeetCode but with more beginner-friendly problems.
Covers: Practice problems organized by difficulty and topic
Why it's good: Good hints system, some problems come from real company interviews
When to use: Alongside LeetCode for more practice variety
StrataScratch (stratascratch.com)
Time: Ongoing
Real interview questions from Google, Amazon, Meta, etc.
Free tier: ~500 questions
Premium ($29/month): Video solutions
Why it's good: These are actual interview questions candidates have seen
When to use: When you're actively interviewing
Python: The "Nice to Have" That's Becoming Essential
You can get hired without Python, but it's increasingly expected.
For Complete Beginners
Python for Everybody (py4e.com)
Time: 30-40 hours
Free course by University of Michigan professor. Assumes zero programming experience.
Covers: Variables, loops, functions, data structures, file handling
Why it's good: Gentle introduction, video lectures + exercises, completely free
When to use: If you've never written a line of code
Automate the Boring Stuff with Python (automatetheboringstuff.com)
Time: 20-30 hours
Free book (also has a Udemy course that goes on sale for $10-15).
Covers: Practical Python for tasks like spreadsheet manipulation, web scraping, file organization
Why it's good: Immediately useful, shows you how Python makes life easier
When to use: After Py4e or if you want practical applications right away
For Data Analysis
Kaggle Learn (kaggle.com/learn)
Time: 15-20 hours for all micro-courses
Bite-sized courses (4-5 hours each) on Python, pandas, data visualization, SQL, ML basics.
Covers: pandas, matplotlib, seaborn, intro to ML
Why it's good: Hands-on, in-browser notebooks, free certificates, real datasets
When to use: After learning Python basics, before diving into projects
DataCamp Introduction to Python (datacamp.com)
Time: 4 hours
Free: First course only
Paid ($25/month): All courses
Interactive coding exercises in browser.
Covers: Python basics with a data focus
Why it's good: Very beginner-friendly, immediate practice
When to use: If you want structure and prefer guided learning
For Practice
LeetCode (Python) (leetcode.com)
Time: Ongoing
Same platform as SQL, but for coding problems.
Why it's good: If you're applying to tech companies, they might test Python logic
When to use: If you're aiming for data scientist roles (less necessary for pure analyst roles)
Excel: Don't Skip This
I know, I know—Excel isn't sexy. But every company uses it, and being legitimately good at Excel sets you apart.
For Beginners
Excel Easy (excel-easy.com)
Time: 10-15 hours
Step-by-step tutorials for formulas, charts, pivot tables.
Covers: All basics plus some advanced stuff (VLOOKUP, INDEX/MATCH, macros)
Why it's good: Clear explanations, tons of examples, completely free
When to use: If you know SUM() but not much else
Chandoo.org (chandoo.org)
Time: Ongoing
Blog + tutorials focused on Excel dashboards and business analysis.
Covers: Pivot tables, dynamic dashboards, conditional formatting, data modeling
Why it's good: Practical, business-focused, free newsletter with tips
When to use: When you're comfortable with basics and want to level up
For Practice
Excel Practice Online (excel-practice-online.com)
Time: Ongoing
Free downloadable practice files with real-world scenarios.
Why it's good: Hands-on, mimics actual work tasks
When to use: When you want to practice before an interview
Data Visualization: Tableau or Power BI
Pick one. Don't try to learn both at the same time.
Tableau (More Popular Overall)
Tableau Public (public.tableau.com)
Time: Free forever
Download Tableau for free. Limitation: all dashboards are public.
Why it's good: Full Tableau Desktop features, perfect for building a portfolio
When to use: Day 1 of learning Tableau
Tableau Training Videos (tableau.com/learn/training)
Time: 15-20 hours
Official video tutorials from Tableau.
Covers: Connecting data, creating charts, building dashboards, calculations
Why it's good: Straight from the source, high quality
When to use: After downloading Tableau Public
Makeover Monday (makeovermonday.co.uk)
Time: Weekly practice
Weekly data visualization challenge. Download a dataset, create a viz, share it.
Why it's good: Practice with real data, see what others create, build portfolio
When to use: Once you're comfortable with Tableau basics (ongoing practice)
Tableau Tim (YouTube) (youtube.com/tableautim)
Time: Hundreds of videos
Free YouTube channel with tutorials on everything Tableau.
Why it's good: Searchable, practical, covers beginner to advanced
When to use: When you get stuck or want to learn a specific technique
Power BI (Growing Fast, Especially in Corporate Environments)
Microsoft Power BI Documentation (docs.microsoft.com/power-bi)
Time: Reference
Official docs from Microsoft.
Why it's good: Comprehensive, always up-to-date
When to use: Reference material, not a learning path
Guy in a Cube (YouTube) (youtube.com/guyinacube)
Time: Hundreds of videos
Power BI tips, tricks, and tutorials.
Why it's good: Clear explanations, active channel, covers DAX (Power BI's formula language)
When to use: When learning Power BI or troubleshooting
Enterprise DNA (enterprisedna.co)
Time: Some free content
Free: Blog posts, YouTube videos
Paid ($29/month): Full courses
Why it's good: High-quality training, business-focused
When to use: If you decide to go deep on Power BI
Statistics: The Foundation You Can't Skip
You don't need a PhD, but you need to understand the basics.
For Beginners
Khan Academy Statistics (khanacademy.org/math/statistics-probability)
Time: 30-40 hours
Free video lessons on probability, distributions, hypothesis testing, regression.
Why it's good: Explains concepts visually, builds from scratch
When to use: If you slept through stats in college (or never took it)
StatQuest with Josh Starmer (YouTube) (youtube.com/statquest)
Time: Hundreds of short videos
Animated explanations of stats concepts: p-values, regression, confidence intervals, etc.
Why it's good: Makes complex topics intuitive, short videos (5-15 min)
When to use: When you need to understand a specific concept quickly
Seeing Theory (seeing-theory.brown.edu)
Time: 5-10 hours
Interactive visualizations of statistical concepts.
Why it's good: Beautiful, intuitive, makes abstract ideas concrete
When to use: When reading about stats doesn't click
Datasets to Practice With
You can't learn without doing. Here's where to find data:
Kaggle (kaggle.com/datasets)
Thousands of datasets on every topic imaginable. Download, analyze, share your work.
Google Dataset Search (datasetsearch.research.google.com)
Search engine for datasets across the web.
Data.gov (data.gov)
U.S. government open data. Everything from crime stats to weather to healthcare.
Our World in Data (ourworldindata.org)
Research-backed datasets on global issues: health, environment, economics.
FiveThirtyEight (github.com/fivethirtyeight/data)
Data behind their articles. Politics, sports, science—all clean and ready to analyze.
Awesome Public Datasets (GitHub) (github.com/awesomedata/awesome-public-datasets)
Curated list of datasets organized by topic.
Career & Job Search Resources
LinkedIn Learning (linkedin.com/learning)
Cost: Free for first month, then $30/month
Courses on SQL, Python, Excel, Tableau, Power BI, plus soft skills (communication, interviewing).
When to use: If you want structured video courses and have a bit of budget
Coursera (coursera.org)
Cost: Free to audit, $49/month for certificates
Google Data Analytics Certificate, IBM Data Analyst Certificate, courses from universities.
Why it's good: Reputable, structured, certificates add to resume
When to use: If you want a formal certificate to show employers
DataCamp Career Tracks (datacamp.com/tracks/career)
Cost: $25/month
Structured learning paths: Data Analyst with Python, Data Analyst with R, etc.
Why it's good: Curated sequence of courses, hands-on
When to use: If you want a guided roadmap and prefer structured programs
YouTube Channels Worth Following:
- Alex The Analyst (data career advice, tutorials)
- Luke Barousse (data job search strategies)
- Ken Jee (data science career tips)
- Tina Huang (data analytics, career pivots)
Communities for Support & Networking
Reddit:
- r/dataanalysis
- r/learnpython
- r/SQL
- r/dataisbeautiful
Discord:
- Data Analyst Hub
- Python Discord
- SQL Community
LinkedIn Groups:
- Data Analysts
- Business Intelligence Professionals
Slack Communities:
- Locally Optimistic (data community)
- MeasureSlack (analytics)
Free Tools You'll Need
For writing SQL:
- SQLite (lightweight database for practice)
- DBeaver (free database GUI)
- PostgreSQL (free, industry-standard database)
For Python:
- Anaconda (includes Jupyter notebooks, pandas, etc.)
- VS Code (code editor)
- Google Colab (free cloud-based Jupyter notebooks)
For version control:
- Git (free)
- GitHub (free for public repos)
For building a portfolio:
- GitHub Pages (free website hosting)
- Tableau Public (free for publishing dashboards)
- Medium (free blog)
The Learning Path (Month by Month)
Month 1: SQL + Excel
- Complete SQLBolt + Mode SQL Tutorial
- Excel Easy tutorials
- Practice: 10 SQL problems on LeetCode
Month 2: Tableau or Power BI
- Download Tableau Public
- Complete Tableau training videos
- Build 1 dashboard for your portfolio
Month 3: Python Basics
- Python for Everybody OR Automate the Boring Stuff
- Kaggle Learn: Intro to Python
- Practice: 5 small Python scripts
Month 4: Python for Data Analysis
- Kaggle Learn: pandas, data viz
- Analyze 1 dataset end-to-end in Jupyter notebook
- Publish to GitHub
Month 5: Statistics Refresher
- Khan Academy or StatQuest videos
- Apply stats concepts to your Python projects
Month 6: Portfolio + Job Applications
- Build 2-3 polished projects
- Start applying to jobs
- Practice interview questions (SQL, case studies, behavioral)
When to Consider Paid Resources
You might benefit from a bootcamp or course if:
- You've tried free resources and can't stay motivated
- You need accountability and structure
- You want networking/job placement support
- You learn better with live instruction
Good paid options (if you can afford them):
- Google Data Analytics Certificate ($49/month, ~6 months)
- DataCamp ($25/month)
- Udacity Data Analyst Nanodegree ($400-500)
- Local community college courses (often $200-500/semester)
Skip the $15K bootcamp unless:
- You have money to burn
- The bootcamp has a strong job placement record (ask for data!)
- You've exhausted free resources and need intensive support
Most people don't need it. Start with free, upgrade if necessary.
The Bottom Line
You have everything you need to learn data analytics for free:
- SQL: SQLBolt → Mode → LeetCode
- Python: Py4e → Kaggle Learn
- Excel: Excel Easy
- Tableau: Public version + official tutorials
- Stats: Khan Academy + StatQuest
- Practice: Kaggle datasets
Total cost: $0
The only thing you need to invest is time. And the ROI on that time is a career with $70K-$120K earning potential.
Start today. Pick one resource from this guide. Do one lesson. Build momentum.
When you're ready to apply what you've learned, check out data analyst job openings and put your new skills to work.