Page 2 of 3

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…

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 aspects of a data project need several…

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…

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…

coding in data science and analytics

Data Coding 101 – Intro to Bash – ep6 (last episode)

This is the last piece of my “Data Coding 101: Introduction to Bash” series, where I introduce the very basics of how to use the command line for…

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

This is third episode of my Data Coding in Bash series, here on data36.com! We’ve already set up a fully functioning data server, have learnt the basic orientation…

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…

conversion rate optimization cro

The Conversion Rate Optimization Framework I Use at Data36…

… is exactly the same that many well-known startup and e-commerce companies are using. However somehow this fundamental research framework hasn’t been published anywhere so far! (As far…

coding in data science and analytics

Data Coding 101 – Introduction to Bash – ep1

Note: to get the most out of this article, you should not just read, but actually do the coding part with me! If you don’t have the data…

conversion rate optimization cro

Five Second Testing

Every online data analyst and/or researcher should use – or at least be familiar with – qualitative methods. Even if you are heavily into analytics and even if…

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

Data Coding 101 – How to install Python, SQL, R and Bash (for non-devs)

The ultimate step by step guide – for non-developers and wannabe data scientists! This is how to install R, Python, SQL and Bash in 30 minutes and start learning…