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 here articles and videos about data analysis, AB-testing, researches, data science and more...Tag: learn to code
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…
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….
In my previous SQL for data analysis tutorial I’ve briefly mentioned, that I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you, how you can install it…
SQL is a must, if you want to be a Data Analyst or a Data Scientist. I have worked with many online businesses in the last few years…
Smaller companies have smaller data teams (maybe just one person), bigger companies have bigger. The tricky thing is that the several aspects of a data project need several…
This is the last piece of my “Data Coding 101: Introduction to Bash” series, where I introduce the very basics of how to use the command line for…
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…
This is third episode of my Data Coding in Bash series, here on data36.com! We’ve already set up a fully functioning data server, have learnt the basic orientation…
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…
Note: to get the most out of this article, you should not just read, but actually do the coding part with me! If you don’t have the data…
The ultimate step by step guide – for non-developers and wannabe data scientists! This is how to install R, Python, SQL and Bash in 30 minutes and start learning…