Tag: sql

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…

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…

thoughts about data science and analytics

Data Analytics Basics (introduction)

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…

statistics in data science and analytics

Statistical Bias Types explained – part 2 (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….

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…

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…

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

coding in data science and analytics

When and why to build your own data tools?

For the record: I’m a big supporter of the third-party data services (eg. Google Analytics, Hotjar, Crazyegg, Optimizely, Mixpanel, etc.). I like them, because they are easy to…

coding in data science and analytics

How to Install Python, SQL, R and Bash (for non-devs)

This is the ultimate step by step guide to installing Python, SQL, R and Bash and starting to learn coding for data science. It takes no more than…

conversion rate optimization cro

The Data Analyst’s Toolset (UPDATED: Aug, 2017)

In this post I collect the best data – and UX-research – tools and I break them down into 3 categories: 1. The baby steps: this is for you, if…