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)
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)