02.06.2023
A practical project after the basic "SQL" course, pretty familiar to me! Not only for more sql practices, but a good introduction to "Tableau" as well. Highly recommanded after finishing the basic "SQL" course!
SQL + Tableau
with
Martin Ganchev
Combining two expertises for a powerful integration: extract information from multiple databases using Tableau while coding in SQL.
5 hours 20 lessons
Start course
20 High Quality Lessons
6 Practical Tasks
5 Hours of Content
Certificate of Achievement
Course Overview
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.
Topics covered
data analysisdata visualizationSQLTableauTheory
What You'll Learn
This course will show you how to combine SQL and Tableau. The included use cases will help you discover professional methods for analyzing and visualizing your data appropriately.
Understand the concepts of software integration
Learn to work with SQL and Tableau simultaneously
Respond to business questions using SQL and Tableau
Visualize data
Organize dashboards
Curriculum
- Combining SQL with Tableau: Introduction Free4 Lessons 15 Min
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.
Introduction to software integration FreeCombining SQL and Tableau FreeInstalling Tableau Public FreeLoading the Database Free - Problem 1 Free6 Lessons 24 Min
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.
Problem 1: Task FreeImportant clarification FreeProblem 1: Solution in SQL FreeExporting your output from SQL and loading it in Tableau FreeChart 1: Visualizing the Solution in Tableau - Part I FreeChart 1: Visualizing the Solution in Tableau - Part II Free - Problem 23 Lessons 14 Min
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.
Problem 2: TaskProblem 2: Solution in SQLChart 2: Visualizing the Solution in Tableau - Problem 33 Lessons 10 Min
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.
Problem 3: TaskProblem 3: Solution in SQLChart 3: Visualizing the Solution in Tableau - Problem 43 Lessons 9 Min
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.
Problem 4: TaskProblem 4: Solution in SQLChart 4: Visualizing the Solution in Tableau - Problem 51 Lesson 6 Min
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.
Problem 5: Organizing Charts 1-4 into a Beautiful Dashboard
Student feedback
Filter by rating
- 5 stars
- 4 stars
- 3 stars
- 2 stars
- 1 stars
Sort
- Newest
- Oldest
- 1
- 2
- 3
- ...
- 8
- ...
- 15
“In this course, I will teach you how to combine two of the most massively used tools by data analysts and data scientists – SQL and Tableau. This will give you the invaluable know-how to solve diverse kinds of problems in business intelligence and analytics efficiently.”
Worked at the European Commission
SQL + Tableau
with Martin Ganchev