Tag: data Page 1 of 3

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

thoughts about data science and analytics

Data Science Career Question #1: “Is Data Science For Me?”

Last time I wrote about why it’s worth it to become a data scientist. This time I’d like to answer another important and very common data science career…

statistics in data science and analytics

Statistical Averages – Mean, Median and Mode

As I have mentioned several times, Data Science has 3 important pillars: Coding, Statistics and Business. To succeed, you have to be well-versed in all three. In 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…

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

Strategy and Business in Data Science and Analytics

The structure of your Data Team. The flow of the data in your organization.

Smaller companies have smaller data teams (maybe just one person), bigger companies have bigger. The tricky thing is that the several different aspects of a data project need…

conversion rate optimization cro

Usability testing (for Data Analysts)

Usability testing is a widely used research method to collect detailed and direct qualitative user feedback about your product (or website, mobile application, anything…) What is it exactly…

coding in data science and analytics

Data Coding 101 – Intro To Bash – ep5

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…

coding in data science and analytics

Data Coding 101 – Intro To Bash – ep4 (with video)

Data Coding in Bash – this is episode 4! Let’s continue with some basic bash best practices. Today I’ll show you 9 tips, that will make your data coding…

coding in data science and analytics

Data Coding 101 – Introduction to Bash – ep2

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…