Learn SQL for Data Analysis – from scratch

Learning SQL is very useful for anyone in the online world. And it’s a definite must for Data Analysts/Scientists! Here are 8 articles to start with…

learn_python

Learn Python 3 for Data Science – from scratch

I put together a ‘Python 3 for Data Science’ tutorial series starting from the very basics. It features 9 practical articles – that covers everything you need to know!

bash_data_science_command_line

Learn Data Analytics in Bash – from scratch

Read these 7 free articles about Bash/Command Line and take your very first step to learn the basics of coding for Data Science!

data_dictionary_book_english

Practical Data Dictionary

I decided to create a dictionary which unifies the most used data expressions and places them within a clear framework. This is an 54 pages handbook and actually it’s…

coding in data science and analytics

Python Import Statement and the Most Important Built-in Modules for Data Scientists

So far we have worked with the most essential concepts of Python: variables, data structures, built-in functions and methods, for loops, and if statements. These are all parts…

coding in data science and analytics

Python Syntax Essentials and Best Practices

In my Python workshops and online courses I see that one of the trickiest things for newcomers is the syntax itself. It’s very strict and many things might…

coding in data science and analytics

Python For Loops and If Statements Combined (Python for Data Science Basics #6)

Last time I wrote about Python For Loops and If Statements. Today we will talk about how to combine them. In this article, I’ll show you – through a…

coding in data science and analytics

How to connect Google Data Studio to PostgreSQL

Connecting Google Data Studio to your PostgreSQL database is easier than you would think. I will walk you through the whole process step by step. By the end…

coding in data science and analytics

How to Import Data into SQL Tables

Following the previous article about creating data tables in SQL, now we want to load data into our freshly created SQL table. In this article, I’ll show you…

coding in data science and analytics

How to Create a Table in SQL

Working with SQL for data analysis sometimes requires creating new tables. Do you want to store the output of your SQL queries? Do you need to pull new…

thoughts about data science and analytics

Data Science Career Question #1: “Is Data Science For Me?”

Last time I wrote about why it’s worth it to become a data scientist. This time I’d like to answer another important and very common data science career…

thoughts about data science and analytics

Why Become a Data Scientist? (7+1 Selfish Reasons)

Why become a data scientist? From time to time, I get this question from people who are flirting with the idea of becoming a data professional. Since you…

statistics in data science and analytics

Statistical Averages – Mean, Median and Mode

As I have mentioned several times, Data Science has 3 important pillars: Coding, Statistics and Business. To succeed, you have to be well-versed in all three. In this…

coding in data science and analytics

Python For Loops Explained (Python for Data Science Basics #5)

Remember that I told you last time that Python if statements are similar to how our brain processes conditions in our everyday life? That’s true for for loops…

coding in data science and analytics

Python If Statements Explained (Python for Data Science Basics #4)

We use if statements in our everyday life all the time – even if our everyday life is not written in Python. If the light is green then…

coding in data science and analytics

Python Built-in Functions and Methods (Python for Data Science Basics #3)

It’s fair to say that using functions is the biggest advantage of Python. At least you will use them a lot during your Data Science projects! This is…

coding in data science and analytics

Python 2 vs Python 3

“Should I learn Python 2 or Python 3?” For everyone who has just started to learn Python for Data Science, this is an important initial question to answer….

thoughts about data science and analytics

Data Analytics Basics (introduction)

You might have heard that Data Scientist was ranked as the best job of 2017 in the USA (based on Glassdoor’s research). Recently many IT professionals have started…

coding in data science and analytics

Python Data Structures (Python for Data Science Basics #2)

Where we did we leave off? Oh, right, we learned about how to use variables in Python. Here is the second essential topic that you have to learn…

coding in data science and analytics

Python for Data Science – Tutorial for Beginners #1 – Python Basics

If you are learning Data Science, pretty soon you will meet Python. Why is that? Because it’s one of the most commonly used data languages. It’s popular for…

statistics in data science and analytics

How not to be biased?

In the last 2 weeks I’ve introduced 9 common statistical bias types. If you went through them, you have already done the first very important step to overcome…

The best way of learning Data Science is practicing.
Check out my 6-week online data science challenge:

“The Junior Data Scientist’s First Month” video course

(Early bird discount until this Friday!)