Over 100 free courses and resources for beginner data analysts
Published: 2023-08-16 08:36:22

A comprehensive collection for data analysts, product analysts, web analysts, marketing analysts, and especially those who aspire to become one!

All materials are free! (except for book purchases)

About me: _My name is Mariia. I am a data analyst, blogger ([My youtube channel](https://www.youtube.com/@mariadataanalyst/videos), [telegram channel](https://t.me/analyticsgrowthmindset))._

I studied data analytics by myself from scratch and for free. Below I share resources that I have used or know of.

In some categories you can see courses from Coursera. You can also go through them for free without linking a card and even get a certificate for free. How to do this, I told in my video, [the link will be here](https://www.youtube.com/watch?v=vB_eJ3R9Hsk).

The collection is organized according to knowledge areas that are essential for analysts to be competitive in the market.

Be sure to save and share with friends!

**General**

Provide fundamental understanding.

**General Courses**

I recommend you these courses as basic.

[Google Data Analytics Professional Certificate](https://www.coursera.org/professional-certificates/google-data-analytics#courses)

[Google Advanced Data Analytics Professional Certificate](https://www.coursera.org/professional-certificates/google-advanced-data-analytics)

[IBM Data Analyst Professional Certificate](https://www.coursera.org/professional-certificates/ibm-data-analyst)

But you can also try these courses depending on your needs.

[Product Analytics Micro-certification (Mixpanel)](https://productschool.teachable.com/p/productanalytics?ref=vc.ru)

[Data Science: Machine Learning (Harvard university)](https://pll.harvard.edu/course/data-science-machine-learning?delta=4)

[Principles, Statistical and Computational Tools for Reproducible Data Science (Harvard university)](https://pll.harvard.edu/course/principles-statistical-and-computational-tools-reproducible-data-science?delta=2)

[Data Science: Linear Regression (Harvard university)
](https://pll.harvard.edu/course/data-science-linear-regression?delta=4)

[Learn to code for data analysis (OpenLearn)](https://www.open.edu/openlearn/science-maths-technology/learn-code-data-analysis/content-section-overview-0?active-tab=content-tab)

[Introductory Data Science Courses (Dataquest)](https://www.dataquest.io/data-science-courses/)

[Courses from Udemy](https://www.udemy.com/courses/search/?price=price-free&q=data+analytics&sort=relevance&src=sac)

[Short course from CareerFoundry](https://careerfoundry.com/en/short-courses/become-a-data-analyst/)

**Company Blogs about Analytics**

In blogs you can find the practical experience of the largest companies, expand and strengthen your knowledge.

[Booking.Datascience](https://booking.ai/)
[B.log](https://blog.booking.com/?ref=vc.ru)
[Netflix Technology Blog](https://netflixtechblog.com/?ref=vc.ru)
[Stack Overflow blog](https://stackoverflow.blog/?s=test&ref=vc.ru)
[Research at Yandex](https://research.yandex.com/?ref=vc.ru)
[Data / ML blog Uber](https://www.uber.com/blog/engineering/data/?ref=vc.ru)

**Books**

Data Science from scratch by Joel Grus
Big Data: A Revolution That Will Transform How We Live, Work, and Think by Viktor Mayer-Schönberger
[Product Analytics for Dummies (Amplitude)](https://info.amplitude.com/rs/138-CDN-550/images/Product%20Analytics%20For%20Dummies.pdf?ref=vc.ru)

**SQL and Databases**

**Courses**

[Khan Academy](https://www.khanacademy.org/computing/computer-programming/sql?ref=vc.ru)
[SQL for Data Science (IBM)](https://www.edx.org/learn/data-science/ibm-sql-for-data-science)
[SQL Tutorial (SQL ZOO)](https://sqlzoo.net/wiki/SQL_Tutorial?ref=vc.ru)
[Intro to SQL (Kaggle)](https://www.kaggle.com/learn/intro-to-sql)
[Advanced SQL (Kaggle)](https://www.kaggle.com/learn/advanced-sql)
[Introduction to Databases and SQL Querying](https://www.udemy.com/course/introduction-to-databases-and-sql-querying/)
[SQL Tutorial — Full Database Course for Beginners](https://www.youtube.com/watch?v=HXV3zeQKqGY)

**SQL Simulators**

Additional for “honing” skills.

[Hakerrank](https://www.hackerrank.com/dashboard)
[SQL EX](https://sql-ex.ru/?Lang=0%29)
[Strata scratch](https://platform.stratascratch.com/coding?code_type=1)
[SQLBolt](https://sqlbolt.com/)
[W3schools](https://www.w3schools.com/sql/sql_exercises.asp)

**Books**

SQL All-in-One For Dummies by Allen G. Taylor
SQL in 10 Minutes a Day by Ben Forta
SQL Practice Problems by Sylvia Vasilik
Practical SQL: A Beginner’s Guide to Storytelling with Data by Anthony DeBarros
Practical SQL by Anthony DeBarros
SQL for Data Analysis by Cathy Tanimura

**Statistics**

**Courses**

[Statistics. The Science of Decisions (Udacity)](https://www.udacity.com/course/statistics--st095)
[Introduction to Statistics (Stanford)](https://www.coursera.org/learn/stanford-statistics)
[Statistics with Python Specialization (Michigan University)](https://www.coursera.org/specializations/statistics-with-python)

**Books**

All of Statistics: A Concise Course in Statistical Inference by Larry Wasserman
Data Analysis Using Regression and Multilevel/Hierarchical Models by Andrew Gelman
How to Lie with Statistics by Darrell Huff
Moneyball: The Art of Winning an Unfair Game by Michael Lewis

**Dashboards**

**Courses**

[Data Science: Visualization (Harvard university)](https://pll.harvard.edu/course/data-science-visualization?delta=3)
[Data Visualization (Kaggle)](https://www.kaggle.com/learn/data-visualization)
[Data Visualization and Building Dashboards with Excel and Cognos (IBM)](https://www.edx.org/learn/data-visualization/ibm-data-visualization-and-building-dashboards-with-excel-and-cognos)
[Data Analytics and Visualization Capstone Project (IBM)](https://www.edx.org/learn/data-analysis/ibm-data-analytics-and-visualization-capstone-project)
[Data Science: Visualization (Harvard university)](https://www.edx.org/learn/data-visualization/harvard-university-data-science-visualization)
[Dashboards in Power BI (Davidson)](https://www.edx.org/learn/power-bi/davidson-college-analyzing-and-visualizing-data-with-power-bi)
[Dashboards in Microsoft Excel (Jordan Goldmeier)](https://alison.com/course/foundations-of-microsoft-excel-dashboards-data-analysis-and-visualization)
[Dashboards in Excel and Cognos (IBM)](https://www.edx.org/learn/data-visualization/ibm-data-visualization-and-building-dashboards-with-excel-and-cognos)

**Books**

The Visual Display of Quantitative Information by Edward R. Tufte
Storytelling With Data: A Data Visualization Guide for Business Professionals by Cole Nussbaumer Knaflic
The Big Book Of Dashboards: Visualizing Your Data Using Real-World Business Scenarios by Steve Waxler, Jeffrey Shaffer, and Andy Cotgreave
Data Sketches: A Journey Of Imagination, Exploration, And Beautiful Data Visualizations by Nadieh Bremer and Shirley Wu
Data Visualization — A Practical Introduction by Kieran Healy

**Python**

**Courses**

[Intro to Programming (Kaggle)](https://www.kaggle.com/learn/intro-to-programming)
[Python (Kaggle)](https://www.kaggle.com/learn/python)
[Data Cleaning (Kaggle)](https://www.kaggle.com/learn/data-cleaning)
[Pandas (Kaggle)](https://www.kaggle.com/learn/pandas)
[Machine Learning Explainability (Kaggle)](https://www.kaggle.com/learn/machine-learning-explainability)
Data visualization with Python (IBM)
[Data analysis with Python (freeCodeCamp)](https://www.freecodecamp.org/learn/data-analysis-with-python/)
[Python Basics for Data Science (IBM)](https://www.edx.org/learn/python/ibm-python-basics-for-data-science)
[Analyzing Data with Python (IBM)](https://www.edx.org/learn/python/ibm-analyzing-data-with-python)
[Visualizing Data with Python (IBM)](https://www.edx.org/learn/data-visualization/ibm-visualizing-data-with-python)

**Books**

Python for Data Analysis: Data Wrangling with Pandas, NumPy, and IPython by William McKinney
Machine Learning with Python Cookbook: Practical Solutions from Preprocessing to Deep Learning by Chris Albon
Data Science from Scratch by O’Reilly Media

**A/B Testing**

**Courses**

[A/B Testing for Business Analysts](https://www.udacity.com/course/ab-testing--ud979?ref=vc.ru)
[A/B Testing & Optimization Course (XP2)](https://www.dynamicyield.com/lesson/introduction-to-ab-testing/)
[Advanced Experimentation Course (XP2)](https://www.dynamicyield.com/course/advanced-experimentation/?ref=vc.ru)

**Books**

Statistical Methods in Online A/B Testing by Georgi Georgiev
Bandit Algorithms for Website Optimization by John Myles White
The Innovator’s Hypothesis by Michael Schrage
Trustworthy Online Controlled Experiments: A Practical Guide to A/B Testing by Ron Kohavi, Diane Tang, Ya Xu

**Web Analytics Systems**

**Courses**

Google analytics. Google has a Skillshop training center where you can learn the new version [Google analytics 4](https://skillshop.exceedlms.com/student/catalog/list?category_ids=1162-google-analitika). There is [a test account](https://analytics.google.com/analytics/web/?utm_source=demoaccount&utm_medium=demoaccount&utm_campaign=demoaccount#/p153293282/reports/intelligenthome).
[Google Tag manager.](https://analytics.google.com/analytics/academy/course/5)

**Books**

Web Analytics: An Hour a Day by Avinash Kaushik
Web Analytics Action Hero by Using Analysis to Gain Insight and Optimize Your Business: Brent Dykes
Complete Web Monitoring by Alistair Croll and Sean Power

**Other**

[A guide to product metrics (Mixpanel)](https://discover.mixpanel.com/rs/461-OYV-624/images/Guidetoproductmetrics-Mixpanel.pdf?ref=vc.ru)
[Towards universal event analytics — building an event grammar](https://snowplow.io/blog/towards-universal-event-analytics-building-an-event-grammar/)
[Measuring Metrics (Microsoft Corporation)](https://exp-platform.com/Documents/2016CIKM_MeasuringMetrics.pdf?ref=vc.ru)
[Ultimate Guide to Product Analytics (TechMagic)](https://theproductmanager.com/topics/product-analytics-guide/?ref=vc.ru)
[Observations on Data, Metrics & Goals (Dan Hill)](https://uxdesign.cc/observations-on-data-metrics-goals-204a02654850)
[Announcing Growth Model v2.0 (Chris More)](https://medium.com/@chrismore/announcing-growth-model-v2-0-8bc096729773)
[Day in the life of a data analyst in Phuket (my day)](https://www.youtube.com/watch?v=hr_sI0oHF8E)
[TOP 5 free Platforms to Practice SQL (I recommend to you)](https://www.youtube.com/watch?v=70QVAvz7EK0)
[Fastest way to become a data analyst for free and actually get a job my experience (my experience)](https://www.youtube.com/watch?v=BjQCgS7gyh8)
[10 Free Online Data Analytics courses and platforms (Which I have studied)](https://www.youtube.com/watch?v=y5bnmurhqrc)
[Algebra basics](https://www.khanacademy.org/math/algebra-basics)
[Example of portfolio #1](https://www.claudiatenhoope.com/)
[Example of portfolio #2](https://harrisonjansma.com/)
[Example of portfolio #3](https://www.yan-holtz.com/)
[Datasets #1](https://github.com/fivethirtyeight/data)
[Datasets #2](https://cloud.google.com/bigquery/public-data/)
[Datasets #3](https://en.wikipedia.org/wiki/Wikipedia:Database_download)

**About me:** My name is Mariia. I am a data analyst, blogger ([My youtube channel](https://www.youtube.com/@mariadataanalyst/videos), [telegram channel](https://t.me/analyticsgrowthmindset)).