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…

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!

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 ranked as the best job of 2017 in the USA (based on Glassdoor’s research). Recently many IT professionals started considering to…

coding in data science and analytics

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

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…

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 that’s one of the most commonly used data languages. The popularity of…

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…

statistics in data science and analytics

Statistical Bias Types explained – part2 (with examples)

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….

statistics in data science and analytics

Statistical Bias Types explained (with examples) – part1

Humans are stupid. We all are, because our brain has been made that way. The most obvious evidence to this built-in stupidity is the different biases, that our…

Strategy and Business in Data Science and Analytics

Data visualisation and discovery with Tableau

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…

coding in data science and analytics

SQL for Data Analysis – Tutorial – ep6 (advanced stuff)

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…

conversion rate optimization cro

How to Create UTM Codes and Track Your URLs

Wouldn’t it be good to know where most of your traffic is coming from? What about email sign ups or even revenue broken down by social channels? How…

thoughts about data science and analytics

Data Science Fundamentals for Marketing and Business Professionals (video course demo)

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…

conversion rate optimization cro

Website Heatmaps – Tools, Features & Best Practices

Heatmapping is a simple and efficient way to analyze visitor interaction and user behavior on your website. If you are in a Conversion Rate Optimization (aka. CRO) project…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep5

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…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep4

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…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep3

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…

conversion rate optimization cro

How to Optimize Facebook Campaigns Based on Conversion Data

“How do I optimize Facebook campaigns?” This is the question that I hear all the time from clients to whom I teach Facebook marketing. Of course, it depends…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep2

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….

coding in data science and analytics

How to install SQL Workbench for postgreSQL

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…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep1

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…