Hey, I'm Tomi Mester. This is my data blog, where I give you a sneak peek into online data analysts' best practices. You will find articles and videos about data analysis, AB-testing, research, data science and more…Category: Coding In Data Science and Analytics Page 1 of 2
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…
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…
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…
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…
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…
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!
Remember, that I told last time that Python if statements are similar to how our brain processes conditions in our everyday life? That’s true for for loops too….
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…
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…
“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….
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…
Where we left off? Oh, right, we learned about how to use variables in Python. Here is the second essential topic, that you have to learn, if you…
Read these 7 free articles about Bash/Command Line and take your very first step to learn the basics of coding for Data Science!
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…
This is the final episode of the SQL for Data Analysis – Tutorial for Beginners series. Today I’ll show you some more advanced SQL moves! Though junior data…
This is kind of a special blogpost, because here I share 3 videos from my brand new O’Reilly Video course – called Data Science Fundamentals for Marketing and Business…
Combining tables is a key component, when you are doing data analysis. And SQL is really good at it! Of course each case is different, but I’ve run…
You have already learnt a lot about the basics of SQL for data analysis. I figured, it would be nice to have now an episode focusing only on…
Today I’ll show you the most essential SQL functions, that you will use for finding the maximums or the minimums (MAX, MIN) in a data set and to…
This is the second episode of my SQL for Data Analysis (for beginners) series and today I’ll show you every tiny little details of the SQL WHERE clause….