SQL + Tableau + Python
Course descriptionWhile Python is the leading programming language for data science, SQL is unmatched when it comes to relational database management. Tableau, on the other hand, is a leading business intelligence software, providing tools for quick computations and rich visualizations. This course will show you how to combine these software products to solve real-life business problems.
We begin by introducing key terms, such as data, servers, clients, requests, responses, data connectivity, APIs, and endpoints. Understanding all of these terms and how they are used is crucial for grasping the concept of software integration.
Preprocessing the 'Absenteeism_data'
In this section, we will focus on cleaning and preprocessing an entire dataset. If you already are a Python guru and cleaning data sets comes as a second nature, you may wish to skip this section. But if it is possible that you have gaps in your Python mastery, even if it’s here and there, it is essential that you go through every lecture. We are actually coding all the time in this section, so you’ll quite likely end up having a lot of fun.
This section is at the core of this Absenteeism Exercise. Here, we discuss modern machine learning tools that can be used to solve problems like the one we’re looking at. Every step requires you to use Python, so stretch your coding fingers and let’s get to it!
Connecting Python and SQL
In this section, you see software integration applied in practice. You will not only be given the chance to experience how data can be transferred from Python to SQL firsthand, but you will also learn about the structure necessary for connecting two compatible software tools. Finally, we will export the dataset in the form of a *.csv file that’s ready to be used in Tableau.
Analyzing the Obtained Data in Tableau
In the last section of this course, we focus on the analytical part of the absenteeism task. We will load, analyze, and visualize in Tableau the data obtained in the previous sections.