IIRF Online > Development > Database Design & Development > Database Programming > Python + SQL + Tableau: Integrating Python, SQL, and Tableau
Python + SQL + Tableau: Integrating Python, SQL, and Tableau by Udemy
See the full picture: Learn how to combine the three most important tools in data science: Python, SQL, and Tableau
Course Highlights
- How to use Python, SQL, and Tableau together
- Software integration
- Data preprocessing techniques
- Apply machine learning
- Create a module for later use of the ML model
- Connect Python and SQL to transfer data from Jupyter to Workbench
- Visualize data in Tableau
- Analysis and interpretation of the exercise outputs in Jupyter and Tableau
Skills you will learn!
Curriculum
1 Topic
What Does the Course Cover?
10 Topics
Properties and Definitions: Data Servers Clients Requests and Responses
Properties and Definitions: Data Servers Clients Requests and Responses
Properties and Definitions: Data Connectivity APIs and Endpoints
Properties and Definitions: Data Connectivity APIs and Endpoints
Further Details on APIs
Further Details on APIs
Text Files as Means of Communication
Text Files as Means of Communication
Definitions and Applications
Definitions and Applications
11 Topics
Setting Up the Environment - An Introduction (Do Not Skip Please)!
Why Python and why Jupyter?
Why Python and why Jupyter?
Installing Anaconda
The Jupyter Dashboard - Part 1
The Jupyter Dashboard - Part 2
Jupyter Shortcuts
The Jupyter Dashboard
Installing sklearn
Installing Packages - Exercise
Installing Packages - Solution
5 Topics
Up Ahead
Real-Life Example: Absenteeism at Work
Real-Life Example: The Dataset
Real-Life Example: The Dataset
Important Notice Regarding Datasets
33 Topics
What to Expect from the Next Couple of Sections
Data Sets in Python
Data at a Glance
A Note on Our Usage of Terms with Multiple Meanings
ARTICLE - A Brief Overview of Regression Analysis
Picking the Appropriate Approach for the Task at Hand
Removing Irrelevant Data
EXERCISE - Removing Irrelevant Data
SOLUTION - Removing Irrelevant Data
Examining the Reasons for Absence
Splitting a Column into Multiple Dummies
EXERCISE - Splitting a Column into Multiple Dummies
SOLUTION - Splitting a Column into Multiple Dummies
ARTICLE - Dummy Variables: Reasoning
Dummy Variables and Their Statistical Importance
Grouping - Transforming Dummy Variables into Categorical Variables
Concatenating Columns in Python
EXERCISE - Concatenating Columns in Python
SOLUTION - Concatenating Columns in Python
Changing Column Order in Pandas DataFrame
EXERCISE - Changing Column Order in Pandas DataFrame
SOLUTION - Changing Column Order in Pandas DataFrame
Implementing Checkpoints in Coding
EXERCISE - Implementing Checkpoints in Coding
SOLUTION - Implementing Checkpoint in Coding
Exploring the Initial "Date" Column
Using the "Date" Column to Extract the Appropriate Month Value
Introducing "Day of the Week"
EXERCISE - Removing Columns
Further Analysis of the DataFrame: Next 5 Columns
Further Analysis of the DaraFrame: "Education" "Children" "Pets"
A Final Note on Preprocessing
A Note on Exporting Your Data as a *.csv File
16 Topics
Exploring the Problem from a Machine Learning Point of View
Creating the Targets for the Logistic Regression
Selecting the Inputs
A Bit of Statistical Preprocessing
Train-test Split of the Data
Training the Model and Assessing its Accuracy
Extracting the Intercept and Coefficients from a Logistic Regression
Interpreting the Logistic Regression Coefficients
Omitting the dummy variables from the Standardization
Interpreting the Important Predictors
Simplifying the Model (Backward Elimination)
Testing the Machine Learning Model
How to Save the Machine Learning Model and Prepare it for Future Deployment
ARTICLE - More about 'pickling'
EXERCISE - Saving the Model (and Scaler)
Creating a Module for Later Use of the Model
4 Topics
Installing MySQL
Installing MySQL on macOS and Unix systems
Setting Up a Connection
Introduction to the MySQL Interface
12 Topics
Are you sure you're all set?
Implementing the 'absenteeism_module' - Part I
Implementing the 'absenteeism_module' - Part II
Creating a Database in MySQL
Importing and Installing 'pymysql'
Creating a Connection and Cursor
EXERCISE - Create 'df_new_obs'
Creating the 'predicted_outputs' table in MySQL
Running an SQL SELECT Statement from Python
Transferring Data from Jupyter to Workbench - Part I
Transferring Data from Jupyter to Workbench - Part II
Transferring Data from Jupyter to Workbench - Part III
6 Topics
EXERCISE - Age vs Probability
Analysis in Tableau: Age vs Probability
EXERCISE - Reasons vs Probability
Analysis in Tableau: Reasons vs Probability
EXERCISE - Transportation Expense vs Probability
Analysis in Tableau: Transportation Expense vs Probability
1 Topic
Bonus Lecture: Next Steps
Python + SQL + Tableau: Integrating Python, SQL, and Tableau
Related Database Programming Courses
Thank You!
Your review has been submitted successfully.