Python, SQL, and Tableau: Integrating Python, SQL, and Tableau

Preview this course

Learn how to combine the three most important tools in data science: Python, SQL, and Tableau.

Unlimited access to 750+ courses.
Enjoy a Free Trial. Cancel Anytime.

- OR -

30-Day Money-Back Guarantee
Full Lifetime Access.
71 on-demand videos & exercises
Level: Intermediate
English
5hrs 1mins
Access on mobile, web and TV

What to know about this course

Python, SQL, and Tableau are three of the most widely used tools in the world of data science. Python is the leading programming language SQL is the most widely used means for communication with database systems Tableau is the preferred solution for data visualization.  

The course starts off by introducing software integration as a concept. We discuss some important terms such as servers, clients, requests, and responses. Moreover, you will learn about data connectivity, APIs, and endpoints. Then we continue by introducing the real-life example exercise the course is centred around: the Absenteeism at Work dataset. The preprocessing part that follows will give you a taste of what BI and data science look like in real-life, on-the-job situations. Then we continue by applying some Machine Learning to our data. You will learn how to explore the problem at hand from a machine-learning perspective, how to create targets, what kind of statistical preprocessing is necessary for this part of the exercise, how to train a Machine Learning model, and how to test it—a truly comprehensive ML exercise. Connecting Python and SQL is not immediate; we show how that's done in an entire section of the course. 

By the end of that section, you will be able to transfer data from Jupyter to Workbench. And finally, as promised, Tableau will allow us to visualize the data we have been working with. We will prepare several insightful charts and will interpret the results together.  All the code files are placed at https://github.com/PacktPublishing/Python-SQL-Tableau-Integrating-Python-SQL-and-Tableau

Who's this course for?

This course is for anyone looking for a career in Business Intelligence and Data Science. Data scientists who are eagerly looking to break into the field and learn the necessary essentials of Data Science and software engineers who are interested in building intelligent applications driven by Python and Machine Learning will also benefit from this course.

What you'll learn

  • Create a module of the ML model for later use.
  • Connect Python and SQL to transfer data from Jupyter to Workbench.
  • Visualize data in Tableau.
  • Analyze and interpret exercise outputs in Jupyter and Tableau.

Key Features

  • How to use Python, SQL, and Tableau together.
  • Software integration.
  • Data preprocessing techniques.
  • Apply machine learning.

Course Curriculum

About the Author

365 Careers Ltd.

365 Careers' courses have been taken by more than 203,000 students in 204 countries. People working at world-class firms such as Apple, PayPal, and Citibank have completed 365 Careers trainings. By choosing 365 Careers, you make sure you will learn from proven experts who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time. If you want to become a financial analyst, a finance manager, an FP&A analyst, an investment banker, a business executive, an entrepreneur, a business intelligence analyst, a data analyst, or a data scientist, 365 Careers' courses are the perfect place to start.