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.
1 hours
10 exercises
1 assignments
0 quizzes
3 downloadables 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:
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.
Welcome to SQL and Tableau Introduction to software integration Combining SQL and Tableau Installing Tableau Public 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.
Problem 1: Task Problem 1: Solution in SQL Exporting your output from SQL and loading it in Tableau Chart 1: Visualizing the Solution in Tableau - Part I 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.
Problem 2: Task Problem 2: Solution in SQL 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.
Problem 3: Task Problem 3: Solution in SQL 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.
Problem 4: Task Problem 4: Solution in SQL 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.
Problem 5: Organizing Charts 1-4 into a Beautiful Dashboard 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 Why Choose the 365 Data Science Program?
Practice
Real-life project and data. Solve them on your own computer as you would in the office.
Q&A Hub
Our expert instructors are happy to help. Post a question and get a personal answer by one of our instructors.
Certificates
Earn a verifiable certificate after each completed course. Celebrate your successes and share your progress with your professional network!
Trust the other 276,000 students
The course is in-depth and is delivered at a steady pace with eye catching visuals. The instructors go through all the basics really well. They try not to over-simplify the material, you get a good sense аof how deep Data Science is in the course. Great job!!!
This course is amazing! After watching the video carefully and doing all the exercises, I am even capable of having discussions with Machine learning major Master’s students! High standard course with reasonable pricing.
Very clear and in-depth explanation of data science and how all the inter-related concepts apply in real life business environment. Absolutely great for beginners! Best data science course I have come across so far!
I would highly recommend the course to any beginner who wants to venture into the world of Data Science. The concepts are very well explained and there is an emphasis on practical application which really helps create a better understanding of the concepts.
Ready to start?
Sign up today for FREE!
