Over 250 free analytics courses and resources
A great selection for data analysts, product analysts, web analysts, marketing analysts and especially those who want to become one. From the author of the Telegram channel “Analytics and Growth mind-set“
But first, a few important points:
All materials are free, except books, which you will need to purchase
In order to become a data analyst, as a rule, you need to study a lot of materials; one free course/book will not cover the required amount of information
Some of the courses are in English, if you don’t know English, use Yandex Browser – it does simultaneous voice translation for any video
Some courses are from Coursera, I told you how to get them for free, WITHOUT linking a card and a trial period Here.
Table of contents:
Data Analytics Basics
Excel
SQL and Databases
Python
Statistics
Visualization and business intelligence tools
Git and Github
A/B testing
Machine learning
Product analytics
Marketing, digital and other analytics
Blogs
Building a Career in Data Analytics
Data Analytics Basics
Provides a basic understanding, fundamental principles and concepts, and a basic mastery of the core skills required by a data analyst.
Courses in English
❗If you don’t know English, use Yandex Browser – it does simultaneous voice translation for any video.
On the English-language Internet you can find many courses on data analytics, from well-known companies such as Google, IBM, Harvard and others. Their programs often cover everything or virtually everything a data analyst needs as an entry-level analyst.
I did a review of courses from Google in this video.
❗Here Here in her telegram channel on analytics, she told me how to take all courses on Coursera for free, WITHOUT linking a card or a trial period.
Courses in Russian
As for the Russian market, it is quite difficult to provide a good free course that would cover all the topics a data analyst needs. If there are free materials, they are usually from paid schools and offer only small pieces of knowledge to motivate the purchase of paid courses.
And those that do not belong to schools do not provide the necessary basis or use outdated tools, for example, Data analysis is simple and accessible (he tells an interesting story, but uses the Orange program – it is not used in his work, so it is hardly worth recommending for a serious study of analytics), Marathon on competent work with data (there will not be enough information in this course).
Practice
The projects below will help you practice on your own, and are also suitable if you are a beginner and need an example of what a data analyst does in practice.
Books for general analytical education
Working with data in any field, Kirill Eremenko
Everyone Lies: Search Engines, Big Data and the Internet Know Everything About You, Seth Stevens Davidowitz
The Illusion of Choice, Cass Sunstein
How to Lie with Statistics, Darell Huff
Why: A Guide to Reasoning and Making Decisions by Samantha Kleinberg
BIG DATA. Big data. A revolution that will change the way we live, work and think, Victor Mayer-Schoenberger, Kenneth Cukier
Data Science. Data science from the ground up. Joel Grass
Theoretical minimum for Big Data. Everything you need to know about big data. Su Kenneth
Game of numbers. How analytics allows video games to live better. Vasily Sabirov
Analytics skills for non-specialists. Jordan Morrow
Courses and resources to follow according to the specific skills and knowledge of the analyst data – Excel, Python, SQL, statistics, Git and Github, a/b testing.
Excel
Courses in Russian
Courses in English
Below is the use of Excel specifically for data analysis.
Practice
Below are practical Excel projects for a data analyst. In each video, the authors show their solution from beginning to end.
SQL and Databases
Courses in Russian
Courses in English
Practice #1: SQL Trainers
Interactive simulators with exercises to sharpen your SQL skills.
Practice #2: Projects
Below are practical SQL projects for data analyst. In each video, the authors show their solution from beginning to end.
Practice #3: Preparing for an interview
Online tests for knowledge of SQL in Russian
Tests to test your SQL knowledge.
Online tests for knowledge of SQL in English
Articles in Russian
Articles in English
Books
SQL. Collection of recipes. Anthony Molinaro
SQL for dummies. Allen Taylor
Learn SQL on your own in 10 minutes. Ben Forta
Master SQL on your own in 24 hours. Ronald Plew
Learning SQL. Alan Bewley
Python
Read before you start How to quickly start programming data analytics in Python? And Python for Data Analyst: Self-Paced Roadmap.
Courses in Russian
Basic courses in Python, without specialization in data analytics.
A small video course with specializations, but it covers only the very basics.
Courses in English
All courses here are specialized in data analysis.
Exercise equipment
Online tests for Python knowledge
On hackerrank You can take the test and receive certificates for your knowledge of Python. Moreover, there are tests for different levels – Basic, Intermediate, Advanced. Just keep in mind that Python knowledge will be tested for general knowledge, not for analytical knowledge.
Books
Practice #1: projects with step-by-step explanations
Below are practical Python projects for data analyst. In each video, the authors show their solution from beginning to end.
Practice #2: preparing for an interview
Statistics
Courses in Russian
Courses in English
Books
Statistics and cats. Vladimir Savelyev
How to lie using statistics. Darell Huff
Naked statistics. Charles Whelan
Statistics for everyone, Sarah Boslough
Visualization and business intelligence tools
Each visualization tool offers its own free training on its websites.
Materials from tools
Courses in Russian
Courses in English
Books
Speak in the language of diagrams. A Guide to Visual Communications. Gene Zelazny
Dashboard for the director. Alexey Kolokolov
Nathan Yau “The Art of Visualization in Business”
Information Dashboard Design, Stephen Few
Storytelling with Data, Cole Nussbaumer Knaflic
The Big Book of Dashboards, Andy Kirk
Practice
Below are practical visualization projects for a data analyst. In each video, the authors show their solution from beginning to end.
Git and Github
Read the post Why does a data analyst need to understand what Github is?
Materials in English
A/B testing
Courses in Russian
Courses in English
Books
A/B testing. Dan Siroker, Pete Koeman
Confidence A/B testing. Xu Y., Tang D., Kochavi R.
Practice
Examples of A/B testing with code and explanation in English
Company practice in Russian
Company practice in English
Machine learning
Machine learning is increasingly penetrating our lives and is being required from data analysts more and more often, at least from the Middle and Senior levels.
Courses in English:
Please note that different courses may use different Python libraries for machine learning. The main libraries (Scikit-learn, TensorFlow, Keras, SciPy, etc.) and their advantages and disadvantages are considered in the article by Enryu NG.
Next comes more specialized materials for product, marketing and web analytics. Read Types of Data Analysts: How to Understand Them?
Product analytics
Courses in English
Books in English
Product Analytics: Applied Data Science Techniques for Actionable Consumer Insights. Joanne Rodrigues-Craig
Experimentation Works: The Surprising Power of Business Experiments. Stefan H. Thomke
Designing with Data: Improving the User Experience with A/B Testing. Rochelle King, Elizabeth F. Churchill, & Caitlin Tan
Marketing, digital and other analytics
Blogs
Blogs of leading companies
Other blogs
Building a Career in Data Analytics
Internships
Career
Job search
English language