17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
Learn how to combine the three most important tools in data science: Python, SQL, and Tableau
Video Details
ISBN 9781838987916
Course Length 5 hour 1 minutes
Table of Contents
• Introduction
• What is software integration?
• Setting up the working environment
• What's next in the course?
• Preprocessing
• Machine Learnings
• Installing MySQL and Getting Acquainted with the Interface
• Connecting Python and SQL
• Analyzing the Obtained data in Tableau
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
About
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
Style and Approach
This course is designed so that each section covers a new scenario and uses a step-by-step approach to help you learn and understand each concept.
Features:
• How to use Python, SQL, and Tableau together
• Software integration
• Data preprocessing techniques
• Apply machine learning
Author
365 Careers
The company's 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 training. By choosing 365 Careers, you make sure you will learn from proven experts who have a passion for teaching, and can to 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.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
0. Websites you may like/How you can help Team-FTU.txt
237 B
01.Introduction/0101.What Does the Course Cover.mp4
39.5 MB
02.What is software integration/0201.Properties and Definitions Data, Servers, Clients, Requests and Responses.mp4
30.3 MB
02.What is software integration/0202.Properties and Definitions Data Connectivity, APIs, and Endpoints.mp4
56.2 MB
02.What is software integration/0203.Further Details on APIs.mp4
55.8 MB
02.What is software integration/0204.Text Files as Means of Communication.mp4
29.5 MB
02.What is software integration/0205.Definitions and Applications.mp4
33.9 MB
03.Setting up the working environment/0301.Setting Up the Environment - An Introduction (Do Not Skip, Please)!.mp4
4.9 MB
03.Setting up the working environment/0302.Why Python and why Jupyter.mp4
35.3 MB
03.Setting up the working environment/0303.Installing Anaconda.mp4
30.4 MB
03.Setting up the working environment/0304.The Jupyter Dashboard - Part 1.mp4
6.8 MB
03.Setting up the working environment/0305.The Jupyter Dashboard - Part 2.mp4
14.4 MB
03.Setting up the working environment/0306.Installing sklearn.mp4
7.9 MB
04.What's next in the course/0401.Up Ahead.mp4
25.8 MB
04.What's next in the course/0402.Real-Life Example Absenteeism at Work.mp4
25.5 MB
04.What's next in the course/0403.Real-Life Example The Dataset.mp4
25.8 MB
05.Preprocessing/0501.Data Sets in Python.mp4
13 MB
05.Preprocessing/0502.Data at a Glance.mp4
39.4 MB
05.Preprocessing/0503.A Note on Our Usage of Terms with Multiple Meanings.mp4
20.1 MB
05.Preprocessing/0504.Picking the Appropriate Approach for the Task at Hand.mp4