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…Tag: data Page 1 of 3
Pandas is one of the most popular Python libraries for Data Science and Analytics. I like to say it’s the “SQL of Python.” Why? Because pandas helps you…
Did you know that Python wasn’t originally built for Data Science? And yet today it’s one of the best languages for statistics, machine learning, and predictive analytics as…
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…
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…
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…
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…
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…
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…
It’s time to continue our discourse about Statistical Bias Types. This is part 2 – if you missed part 1, read it here: Statistical Bias Types part 1….
Humans are stupid. We all are, because our brain has been made that way. The most obvious evidence of this built-in stupidity is the different biases that our…
The usefulness of visualisations in data analysis is often questioned. At the end of the day, the outcome of the analysis should be quantifiable, right? Well, maybe. But…
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…
This is the second episode of my SQL for Data Analysis (for beginners) series, and today I’ll show you every tiny little detail of the SQL WHERE clause….
In my previous SQL for data analysis tutorial, I briefly mentioned that I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you how you can install it…
SQL (Structured Query Language) is a must if you want to be a Data Analyst or a Data Scientist. I have worked with many online businesses in the…
Smaller companies have smaller data teams (maybe just one person), bigger companies have bigger. The tricky thing is that the several different aspects of a data project need…
Usability testing is a widely used research method to collect detailed and direct qualitative user feedback about your product (or website, mobile application, anything…) What is it exactly…
In this article I will show you 3 data coding concepts, that won’t only be useful in bash, but Python and R as well! Today we will go…
Data Coding in Bash – this is episode 4! Let’s continue with some basic bash best practices. Today I’ll show you 9 tips, that will make your data coding…
It’s time to continue with learning data science and data coding in Bash! Last time I covered the very basic orientation commands. Now moving on with the most…