SQL + Tableau

It is next to impossible to analyse data in SQL. This course will give you methods of using SQL and Tableau simultaneously, helping you find hidden value in your data faster than when using them separately.

Sign up to
preview the course
for FREE!

Create a free account and start learning data science today.

create free account
Our graduates work at exciting places:
walmart
tesla
paypal
citibank
booking.com

Section 1

Combining SQL with Tableau: Introduction

In the introductory part of the course, we will talk about the lessons you will see next and discuss why a data scientist would want to be able to connect tools like SQL and Tableau. We will show you how to do the integration with Tableau Desktop, and we will provide you with a workaround in case you use Tableau Public.

Premium course icon Welcome to SQL and Tableau
Premium course icon Introduction to software integration
Premium course icon Combining SQL and Tableau
Premium course icon Installing Tableau Public
Premium course icon Loading the Database

Section 2

Problem 1

In this section we will continue to use the ‘employees’ database we worked with in a large part of our SQL training. By connecting Tableau and SQL you will be able to visualize several trends related to the company’s gender gap situation.

Premium course icon Problem 1: Task
Premium course icon Problem 1: Solution in SQL
Premium course icon Exporting your output from SQL and loading it in Tableau
Premium course icon Chart 1: Visualizing the Solution in Tableau - Part I
Premium course icon Chart 1: Visualizing the Solution in Tableau - Part II

Section 3

Problem 2

Here, we will continue to explore the ‘employees_mod’ database and will run a sophisticated SQL query to answer the remaining questions in our task. The topic under investigation continues to be ‘gender gap’ policies.

Premium course icon Problem 2: Task
Premium course icon Problem 2: Solution in SQL
Premium course icon Chart 2: Visualizing the Solution in Tableau

Section 4

Problem 3

Much like in Problem 2, here, in Problem 3, we will use SQL to extract a particular part of the 'employeed_mod' database to a respond to another business question related to exploring different statistics for the women and men in the company.

Premium course icon Problem 3: Task
Premium course icon Problem 3: Solution in SQL
Premium course icon Chart 3: Visualizing the Solution in Tableau

Section 5

Problem 4

Problem 4 is an exercise that builds on your entire knowledge of SQL and Tableau and takes you to solving a more challenging business task, using a more sophisticated SQL Code, and creating a different type of visualization in Tableau.

Premium course icon Problem 4: Task
Premium course icon Problem 4: Solution in SQL
Premium course icon Chart 4: Visualizing the Solution in Tableau

Section 6

Problem 5

In this short section we will show you how to gather your data in a well-organized dashboard and will show you how to add an interactive filter which makes analysis much quicker and intuitive.

Premium course icon Problem 5: Organizing Charts 1-4 into a Beautiful Dashboard
MODULE 2

Programming for Data Science

This course is part of Module 2 of the 365 Data Science Program. The complete training consists of four modules, each building up on your knowledge from the previous one. In contrast to the introductory nature of Module 1, Module 2 is designed to tackle all aspects of programming for data science. You will learn how to work with relational databases and SQL, as well as how to code in Python and R. By the end of this Module you will have a versatile programming skillset.

See All Modules

Trust the other 276,000 students

Ready to start?
Sign up today for FREE!

Whether you want to scale your career or transition into a new field, data science is the number one skillset employers look for. Grow your analytics expertise and get hired as a data scientist!