DEV Community

Marieintheworld
Marieintheworld

Posted on

Over 100 free courses and resources for beginner data analysts

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, telegram channel).

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.

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

Google Advanced Data Analytics Professional Certificate

IBM Data Analyst Professional Certificate

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

Product Analytics Micro-certification (Mixpanel)

Data Science: Machine Learning (Harvard university)

Principles, Statistical and Computational Tools for Reproducible Data Science (Harvard university)

Data Science: Linear Regression (Harvard university)

Learn to code for data analysis (OpenLearn)

Introductory Data Science Courses (Dataquest)

Courses from Udemy

Short course from CareerFoundry

Company Blogs about Analytics

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

Booking.Datascience
B.log
Netflix Technology Blog
Stack Overflow blog
Research at Yandex
Data / ML blog Uber

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)

SQL and Databases

Courses

Khan Academy
SQL for Data Science (IBM)
SQL Tutorial (SQL ZOO)
Intro to SQL (Kaggle)
Advanced SQL (Kaggle)
Introduction to Databases and SQL Querying
SQL Tutorial — Full Database Course for Beginners

SQL Simulators

Additional for “honing” skills.

Hakerrank
SQL EX
Strata scratch
SQLBolt
W3schools

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)
Introduction to Statistics (Stanford)
Statistics with Python Specialization (Michigan University)

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)
Data Visualization (Kaggle)
Data Visualization and Building Dashboards with Excel and Cognos (IBM)
Data Analytics and Visualization Capstone Project (IBM)
Data Science: Visualization (Harvard university)
Dashboards in Power BI (Davidson)
Dashboards in Microsoft Excel (Jordan Goldmeier)
Dashboards in Excel and Cognos (IBM)

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)
Python (Kaggle)
Data Cleaning (Kaggle)
Pandas (Kaggle)
Machine Learning Explainability (Kaggle)
Data visualization with Python (IBM)
Data analysis with Python (freeCodeCamp)
Python Basics for Data Science (IBM)
Analyzing Data with Python (IBM)
Visualizing Data with Python (IBM)

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
A/B Testing & Optimization Course (XP2)
Advanced Experimentation Course (XP2)

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. There is a test account.
Google Tag manager.

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)
Towards universal event analytics — building an event grammar
Measuring Metrics (Microsoft Corporation)
Ultimate Guide to Product Analytics (TechMagic)
Observations on Data, Metrics & Goals (Dan Hill)
Announcing Growth Model v2.0 (Chris More)
Day in the life of a data analyst in Phuket (my day)
TOP 5 free Platforms to Practice SQL (I recommend to you)
Fastest way to become a data analyst for free and actually get a job my experience (my experience)
10 Free Online Data Analytics courses and platforms (Which I have studied)
Algebra basics
Example of portfolio #1
Example of portfolio #2
Example of portfolio #3
Datasets #1
Datasets #2
Datasets #3

About me: My name is Mariia. I am a data analyst, blogger (My youtube channel, telegram channel).

Top comments (0)