the junior data scientist's first month

The Junior Data Scientist’s First Month (Video Course)

100% practical 6-week data science challenge & video course — simulating of being a junior data scientist at a true-to-life startup.

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!

statistics in data science and analytics

Statistical Significance in A/B testing (and How People Misinterpret Probability)

A few years ago we were running a major homepage A/B test with one of my clients. Huge traffic, huge potential, huge expectations — and huge risk, of…

thoughts about data science and analytics

Data Science Projects for Boosting Your Resume

We all know the old catch-22 — you need a job to get job experience and job experience to get a job. Luckily, that’s not entirely true in…

Strategy and Business in Data Science and Analytics

Data Beats Opinion… or does it?

Data Science is trending! Year by year more and more online businesses start their first data science projects, build up their data teams, hire more data scientists and…

Strategy and Business in Data Science and Analytics

Data Science for Business

Doing Data Science without a sense of business is like playing chess without the kings on the board. For every business, making its products or services better is…

thoughts about data science and analytics

Learning Data Science – 4 untold truths

Did you flirt with the idea of learning data science? You are not alone. This has been a really hot topic in the last few years and it…

Strategy and Business in Data Science and Analytics

A 10-minute crash course on Google Data Studio

This is a guest post from Ben Collins – freelance data analyst and developer, and founder of The Collins School of Data. What is Google Data Studio? Data…

thoughts about data science and analytics

Presentation Tips for Data Professionals

Not so long ago, I saw one of my data scientist friends speak in front of his whole company. He worked for two months on a great data…

thoughts about data science and analytics

How to be a more productive Data Scientist? Don’t do more, do it smarter!

A few years ago, I put a lot of work into a hobby project of mine: a self-learning Python chatbot that learns like a newborn baby. It was…

coding in data science and analytics

SQL Interview Questions: 3 Tech Screening Exercises (For Data Analysts)

Over the last 6 years I’ve been part of many job interviews – on both sides of the table. The most fun, but also the most feared, part…

coding in data science and analytics

Pandas Tutorial 3: Important Data Formatting Methods (merge, sort, reset_index, fillna)

This is the third episode of my pandas tutorial series. In this one I’ll show you four data formatting methods that you might use a lot in data…

coding in data science and analytics

Pandas Tutorial 2: Aggregation and Grouping

Let’s continue with the pandas tutorial series. This is the second episode, where I’ll introduce aggregation (such as min, max, sum, count, etc.) and grouping. Both are very…

coding in data science and analytics

Pandas Tutorial 1: Pandas Basics (Reading Data Files, DataFrames, Data Selection)

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…

coding in data science and analytics

Python libraries and packages for Data Scientists (the 5 most important ones)

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…

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…