SQL + Tableau

Combining two expertises for a powerful integration: extract information from multiple databases using Tableau while coding in SQL.

Hours

Lessons

Quizzes

Assignments

Create Your Free Account

Join over 900,000 students

Our graduates work at exciting places

Course description

It is next to impossible to analyze 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.

Martin Ganchev

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.

Quiz Assignment
Quiz Assignment
Quiz Assignment
Quiz Assignment
Quiz Assignment

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.

Quiz Assignment
Quiz Assignment
Quiz Assignment
Quiz Assignment
Quiz Assignment
Quiz Assignment

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.

Quiz Assignment
Quiz Assignment
Quiz Assignment

Problem 3

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

Quiz Assignment
Quiz Assignment
Quiz Assignment

Problem 4

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

Quiz Assignment
Quiz Assignment
Quiz Assignment

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.

Quiz Assignment

SQL + Tableau

Combining SQL with Tableau: Introduction

Course Introduction (Less than a minute)

Introduction to software integration (5 min)

Combining SQL and Tableau (5 min)

Installing Tableau Public (2 min)

Loading the Database (3 min)

Problem 1

Problem 1: Task (4 min)

Important clarification

Problem 1: Solution in SQL (5 min)

Exporting your output from SQL and loading it in Tableau (4 min)

Chart 1: Visualizing the Solution in Tableau - Part I (6 min)

Chart 1: Visualizing the Solution in Tableau - Part II (5 min)

Problem 2

Problem 2: Task (4 min)

Problem 2: Solution in SQL (4 min)

Chart 2: Visualizing the Solution in Tableau (6 min)

Problem 3

Problem 3: Task (2 min)

Problem 3: Solution in SQL (3 min)

Chart 3: Visualizing the Solution in Tableau (5 min)

Problem 4

Problem 4: Task (3 min)

Problem 4: Solution in SQL (3 min)

Chart 4: Visualizing the Solution in Tableau (3 min)

Problem 5

Problem 5: Organizing Charts 1-4 into a Beautiful Dashboard (6 min)