Tag: analytics Page 1 of 2

coding in data science and analytics

Beautiful Soup Tutorial 4. – Saving Scraped Data to a CSV File, then Analyzing it with Pandas

This is the final part of the Beautiful Soup tutorial series. Just to remind you, here’s what you’ve done so far: in episode #1 you learnt the basics…

thoughts about data science and analytics

How to Get a Job in Data Science and Analytics (episode #1)

Hello fellow job seekers! My name is Peter. About a year ago, I was in your shoes. I wanted one of those high-paying jobs in data science and…

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…

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

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…

coding in data science and analytics

Python For Loops Explained (Python for Data Science Basics #5)

Remember that I told you last time that Python if statements are similar to how our brain processes conditions in our everyday life? That’s true for for loops…

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. Or at least you will use them a lot during your Data Science projects! This…

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…

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 it’s one of the most commonly used data languages.It’s popular for 3…

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

statistics in data science and analytics

Statistical Bias Types explained (with examples) – 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…

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)

Today I’ll show you some more advanced SQL moves! Okay, I’d rather put them into the intermediate category. They are not beginner things — but it’s also for…

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…