Recommended Courses for Data Analysts¶
Curated list of online courses — prioritised by quality and alignment with this bootcamp.
SQL¶
Mode SQL Tutorial (Free) The best free SQL learning path on the internet. Covers everything from SELECT to window functions with an interactive SQL editor. No setup required. URL: mode.com/sql-tutorial
SQLZoo (Free) Interactive SQL exercises in the browser. Start at "SELECT basics" and work through to "More JOIN operations." Excellent for practice. URL: sqlzoo.net
The Complete SQL Bootcamp — Jose Portilla (Udemy) Paid, but frequently on sale (£10-15). Most comprehensive beginner-to-advanced SQL course. Covers PostgreSQL.
Python and Pandas¶
Python for Everybody — University of Michigan (Coursera, Free to audit) Best beginner Python course. Dr. Chuck is one of the clearest teachers online. Covers Week 01 Day 03 content thoroughly. URL: coursera.org/specializations/python
Kaggle Python (Free) Short, interactive Python notebooks covering data types, functions, and loops. Kaggle also has free Pandas, Data Cleaning, and Data Visualisation micro-courses. URL: kaggle.com/learn
Real Python (Partially free) High-quality tutorials and articles. The Pandas tutorials are especially good — practical, with real datasets. URL: realpython.com
Data Visualisation¶
Storytelling with Data Practice (Free blog + paid workshops) Cole Knaflic posts monthly challenges. Reading the walkthroughs teaches more than the book alone. URL: storytellingwithdata.com
Information Dashboard Design — Stephen Few (Udemy / YouTube) Academic but foundational. Covers the cognitive science behind why some dashboards work.
Power BI¶
Microsoft Learn — Power BI (Free) Microsoft's official learning path. Covers everything from connecting data to DAX to publishing. Earns you a Microsoft badge. URL: learn.microsoft.com/en-us/training/powerplatform/power-bi
Guy in a Cube (YouTube, Free) Adam Saxton and Patrick LeBlanc from the Power BI team. Practical tutorials on DAX, Power Query, and deployment. Very active — content covers latest features.
Tableau¶
Tableau Public Training (Free) Tableau's official free training videos. 6-hour "Fundamentals" course is well-structured. URL: tableau.com/learn/training
SuperDataScience — Tableau Course (Udemy, Paid) Comprehensive beginner course. Good for Week 02 Day 02 preparation.
Statistics and Analytics Thinking¶
Statistics and Probability — Khan Academy (Free) Clear, from-scratch statistics. Start at "Analyzing data" for the Week 01 Day 05 content. URL: khanacademy.org/math/statistics-probability
Think Stats — Allen B. Downey (Free PDF online) Statistics for programmers. Uses Python throughout. Covers EDA, distributions, hypothesis testing.
Causal Inference for The Brave and True — Matheus Facure (Free online) A/B testing, difference-in-differences, regression discontinuity — how to answer causal questions with data. Advanced but readable.
Excel¶
Excel Skills for Business — Macquarie University (Coursera, Free to audit) Most rigorous free Excel course. Covers formulas, charts, pivot tables, and data presentation in 4 courses.
ExcelJet (Free reference) The fastest lookup for Excel formulas. Type what you want to do, get the formula. Bookmark it. URL: exceljet.net/functions
Interview Preparation¶
Ace the Data Science Interview — Nick Singh & Kevin Huo Book + website with hundreds of real interview questions from top companies. Covers SQL, Python, statistics, A/B testing, and product analytics.
LeetCode — Database (Free/Paid) SQL interview problems from top companies. Start at "Easy" and work up. Use the Pandas section for Python interview prep.
Stratascratch (Free tier available) Real interview questions from companies like Airbnb, Spotify, Google. Better than LeetCode for analytics roles because questions are more applied (not just algorithms). URL: stratascratch.com