Your cart is empty.
Keep shopping
Teach on Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn MorePython and Tableau: The Complete Data Analytics Bootcamp!
Rating: 4.4 out of 54.4(409 ratings)
2,850 students
Python and Tableau: The Complete Data Analytics Bootcamp!
Become a master at Data Analytics with Python and Tableau - Build 3 Projects, share on your resume and learn by doing!
Created byDee Naidoo
Last updated 12/2023
English
What you'll learn
- In this course you'll understand the inner workings of the data analytics pipeline from using Python for Data Cleaning & Analysis and Tableau for Data Visuals
- Be able to program in Python and execute code
- Create Interactive Charts and Dashboards on Tableau
- Create a portfolio of 3 real life Python/Tableau projects to apply for data analytics jobs
- Learn how to perform Data Analytics on Python with Pandas, Numpy, Matplotlib and Others
Explore related topics
Course content
8 sections • 43 lectures • 11h 34m total length
- Introduction to the Course: Why we're learning Python and Tableau2:19
So you’re interested in Data Analytics but you’re not too sure where to start? Well, this is the course for you! Welcome to Python and Tableau: The Complete Data Analytics Bootcamp! In this course you will learn how to use Python and Tableau, the two powerhouses in the data analytics and data science community.
The best part about this course is that it’s practical, you work on realistic projects and you publish your work online so you can share it on your resume or to your friends and coworkers.
Like I said, In this course, we will learn how to analyze data with Python through a platform called Anaconda. And then we’re going visualize the data with Tableau Public.
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python and Tableau: A Brief Overview2:31
Hi,
In this lecture, I go through an Intro to Python and Tableau.
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Lecture 3: Python for Data Analysis4:42
Hi, in this lecture I go over the benefits of using Python for Data Analytics
- Why Data Visualization is Important7:05
So, we know why Python is needed but why is Data Visualization important?
- How to Install Python on Windows4:32
In this Lecture, we install Python on Windows.
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- How to Install Python on Mac4:34
In this Lecture, we install Python on Mac.
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- How to Install Tableau Public - Windows and Mac1:43
In this Lecture, we install Tableau Public on Windows/Mac.
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- How the Course is Structured3:22
In this Lecture, we around the Structure of the Course.
The first half is Python. The second half is Tableau.
Where to get resources:
All resources are in the Project Brief.pdf file.
View the link to my blog, which also has the resources:
https://databudd.com/blog/python-and-tableau-the-compete-data-analytics-bootcamp
Resources are all available in the lecture description of the relevant videos you are watching.
- Introduction to Spyder5:58
In this Lecture, we get introduced to Spyder and Anaconda.
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Playing around with Python14:51
In this Lecture, we play around writing code in Python!
Where to get resources:
All resources are in the Project Brief.pdf file.
View the link to my blog, which also has the resources:
https://databudd.com/blog/python-and-tableau-the-compete-data-analytics-bootcamp
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 1 - Value Inc - Project Introduction and Working with Pandas22:10
In this Lecture, we install start our first Project!
Project:
Value Inc is a retail store that sells household items all over the world by bulk.
The Sales Manager has no sales reporting but he has a brief idea of current sales.
He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (transactions.csv) – 153 MB file
https://drive.google.com/file/d/1i6MQZmXUuqyqGjSGbsPrNKV-eJPAhx-U/view?usp=sharing
Value Inc Seasons:
https://finch-groundhog-9245.squarespace.com/s/value_inc_seasons.csv
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python - Project 1 - Value Inc - What happens when we close Spyder?1:55
In this Lecture, I note on what happens when Spyder is closed.
Project:
Value Inc is a retail store that sells household items all over the world by bulk.
The Sales Manager has no sales reporting but he has a brief idea of current sales.
He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (transactions.csv) – 153 MB file
https://drive.google.com/file/d/1i6MQZmXUuqyqGjSGbsPrNKV-eJPAhx-U/view?usp=sharing
Value Inc Seasons:
https://finch-groundhog-9245.squarespace.com/s/value_inc_seasons.csv
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 1 - Value Inc - Working with Calculations on Python45:46
In this Lecture, we start creating Calculations in Python
Project:
Value Inc is a retail store that sells household items all over the world by bulk.
The Sales Manager has no sales reporting but he has a brief idea of current sales.
He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (transactions.csv) – 153 MB file
https://drive.google.com/file/d/1i6MQZmXUuqyqGjSGbsPrNKV-eJPAhx-U/view?usp=sharing
Value Inc Seasons:
https://finch-groundhog-9245.squarespace.com/s/value_inc_seasons.csv
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 1 - Value Inc - Concatenating Variables and Working with iloc26:42
In this Lecture, we learn how to use things like Concatenating variables and working with iloc.
Project:
Value Inc is a retail store that sells household items all over the world by bulk.
The Sales Manager has no sales reporting but he has a brief idea of current sales.
He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (transactions.csv) – 153 MB file
https://drive.google.com/file/d/1i6MQZmXUuqyqGjSGbsPrNKV-eJPAhx-U/view?usp=sharing
Value Inc Seasons:
https://finch-groundhog-9245.squarespace.com/s/value_inc_seasons.csv
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 1 - Value Inc - Using functions in Python like Split, Replace34:47
In this Lecture, we learn how to use functions like Split, Replace, Merge, Drop and Lower.
Project:
Value Inc is a retail store that sells household items all over the world by bulk.
The Sales Manager has no sales reporting but he has a brief idea of current sales.
He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (transactions.csv) – 153 MB file
https://drive.google.com/file/d/1i6MQZmXUuqyqGjSGbsPrNKV-eJPAhx-U/view?usp=sharing
Value Inc Seasons:
https://finch-groundhog-9245.squarespace.com/s/value_inc_seasons.csv
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 1 - Value Inc - Running our Final Script2:40
In this Lecture, we run out full script.
Project:
Value Inc is a retail store that sells household items all over the world by bulk.
The Sales Manager has no sales reporting but he has a brief idea of current sales.
He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (transactions.csv) – 153 MB file
https://drive.google.com/file/d/1i6MQZmXUuqyqGjSGbsPrNKV-eJPAhx-U/view?usp=sharing
Value Inc Seasons:
https://finch-groundhog-9245.squarespace.com/s/value_inc_seasons.csv
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Quick Review on Python
- Python Project 2 - Blue Bank - Working with Blue Bank's JSON data38:20
In this Lecture, we learn how to import JSON files on Python
Project:
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are.
Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Date File: (loan_data_json.json) – 761 KB file
https://finch-groundhog-9245.squarespace.com/s/loan_data_json.json
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Blue-Bank-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 2 - Blue Bank - Working with Arrays18:28
In this Lecture, we learn how to work with arrays.
Project:
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are.
Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Date File: (loan_data_json.json) – 761 KB file
https://finch-groundhog-9245.squarespace.com/s/loan_data_json.json
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Blue-Bank-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 2 - Blue Bank - If Statements and For Loops50:33
In this Lecture, we learn about IF statements and FOR loops in Python.
Project:
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are.
Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Date File: (loan_data_json.json) – 761 KB file
https://finch-groundhog-9245.squarespace.com/s/loan_data_json.json
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Blue-Bank-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 2 - Blue Bank - Using Exceptions and Plots31:15
In this Lecture, we learn about Try and Except as well as Plots in Python
Project:
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are.
Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Date File: (loan_data_json.json) – 761 KB file
https://finch-groundhog-9245.squarespace.com/s/loan_data_json.json
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Blue-Bank-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 2 - Blue Bank - Running our Final Script0:54
In this Lecture, we learn about running our final script.
Project:
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are.
Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Date File: (loan_data_json.json) – 761 KB file
https://finch-groundhog-9245.squarespace.com/s/loan_data_json.json
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Blue-Bank-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching
- A Quiz covering learnings from Blue Bank
- Python Project 3 - BlogMe - Group By and Aggregates23:26
In this Lecture, we learn about Group by and Aggregates in Python.
Project:
BlogMe, a famous blogging business has a dataset of news articles that they need further analysis on.
Firstly, they’d like keywords to be extracted from headlines of the article. Secondly, they would need to determine the sentiment of the news articles. The data is in an excel sheet and they would like to see a dashboard outlying sentiment, top articles etc.
Date File: (articles.xlsx) – 4.7 MB file
https://finch-groundhog-9245.squarespace.com/s/articles.xlsx
BlogMe_sources.xlsx
https://finch-groundhog-9245.squarespace.com/s/BlogMe_sources.xlsx
Logo: (BlogMe Logo.png)
https://finch-groundhog-9245.squarespace.com/s/BlogMe-Logo.png
Tableau Joins:
https://finch-groundhog-9245.squarespace.com/s/TableauJoins-xc7w.pdf
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 3 - Blog Me - Functions on Python44:24
In this Lecture, we learn about Functions in Python.
Project:
BlogMe, a famous blogging business has a dataset of news articles that they need further analysis on.
Firstly, they’d like keywords to be extracted from headlines of the article. Secondly, they would need to determine the sentiment of the news articles. The data is in an excel sheet and they would like to see a dashboard outlying sentiment, top articles etc.
Date File: (articles.xlsx) – 4.7 MB file
https://finch-groundhog-9245.squarespace.com/s/articles.xlsx
BlogMe_sources.xlsx
https://finch-groundhog-9245.squarespace.com/s/BlogMe_sources.xlsx
Logo: (BlogMe Logo.png)
https://finch-groundhog-9245.squarespace.com/s/BlogMe-Logo.png
Tableau Joins:
https://finch-groundhog-9245.squarespace.com/s/TableauJoins-xc7w.pdf
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 3 - Blog Me - Classes in Python18:41
In this Lecture, we learn about classes in Python.
Project:
BlogMe, a famous blogging business has a dataset of news articles that they need further analysis on.
Firstly, they’d like keywords to be extracted from headlines of the article. Secondly, they would need to determine the sentiment of the news articles. The data is in an excel sheet and they would like to see a dashboard outlying sentiment, top articles etc.
Date File: (articles.xlsx) – 4.7 MB file
https://finch-groundhog-9245.squarespace.com/s/articles.xlsx
BlogMe_sources.xlsx
https://finch-groundhog-9245.squarespace.com/s/BlogMe_sources.xlsx
Logo: (BlogMe Logo.png)
https://finch-groundhog-9245.squarespace.com/s/BlogMe-Logo.png
Tableau Joins:
https://finch-groundhog-9245.squarespace.com/s/TableauJoins-xc7w.pdf
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Python Project 3 - Blog Me - Sentiment Analysis on Python32:11
In this Lecture, we learn to do Sentiment Analysis using Vader in Python!
Project:
BlogMe, a famous blogging business has a dataset of news articles that they need further analysis on.
Firstly, they’d like keywords to be extracted from headlines of the article. Secondly, they would need to determine the sentiment of the news articles. The data is in an excel sheet and they would like to see a dashboard outlying sentiment, top articles etc.
Date File: (articles.xlsx) – 4.7 MB file
https://finch-groundhog-9245.squarespace.com/s/articles.xlsx
BlogMe_sources.xlsx
https://finch-groundhog-9245.squarespace.com/s/BlogMe_sources.xlsx
Logo: (BlogMe Logo.png)
https://finch-groundhog-9245.squarespace.com/s/BlogMe-Logo.png
Tableau Joins:
https://finch-groundhog-9245.squarespace.com/s/TableauJoins-xc7w.pdf
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- A Quiz Covering the learnings from Blog Me
- Tableau Project 1 - Value Inc - Introduction to Tableau Public3:49
In this Lecture, we are introduced to Tableau Public.
Project:
Value Inc is a retail store that sells household items all over the world by bulk. The Sales Manager has no sales reporting but he has a brief idea of current sales. He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (ValueInc_Cleaned.csv) – this is the CSV export from your python file.
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 1 - Value Inc - Reviewing what we will be building3:02
In this Lecture, we will be reviewing what we're going to be building on Tableau
Project:
Value Inc is a retail store that sells household items all over the world by bulk. The Sales Manager has no sales reporting but he has a brief idea of current sales. He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (ValueInc_Cleaned.csv) – this is the CSV export from your python file.
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 1 - Value Inc - Connecting to a Data Source14:22
In this lecture, we learn how to connect to the data source.
Project:
Value Inc is a retail store that sells household items all over the world by bulk. The Sales Manager has no sales reporting but he has a brief idea of current sales. He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (ValueInc_Cleaned.csv) – this is the CSV export from your python file.
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 1 - Value Inc - Creating a Line Chart17:53
In this lecture, we learn how to create a line chart.
Project:
Value Inc is a retail store that sells household items all over the world by bulk. The Sales Manager has no sales reporting but he has a brief idea of current sales. He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (ValueInc_Cleaned.csv) – this is the CSV export from your python file.
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 1 - Value Inc - Creating Bar Charts19:40
In this lecture, we learn how to create bar charts.
Project:
Value Inc is a retail store that sells household items all over the world by bulk. The Sales Manager has no sales reporting but he has a brief idea of current sales. He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (ValueInc_Cleaned.csv) – this is the CSV export from your python file.
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 1 - Value Inc - Creating Maps and Headline Cards20:56
In this lecture, we learn how to create maps and headline cards.
Project:
Value Inc is a retail store that sells household items all over the world by bulk. The Sales Manager has no sales reporting but he has a brief idea of current sales. He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (ValueInc_Cleaned.csv) – this is the CSV export from your python file.
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 1 - Value Inc - Creating Dashboards and Publishing21:32
In this lecture, we learn how to build a dashboard.
Project:
Value Inc is a retail store that sells household items all over the world by bulk. The Sales Manager has no sales reporting but he has a brief idea of current sales. He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Date File: (ValueInc_Cleaned.csv) – this is the CSV export from your python file.
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Introduction to Tableau Server13:56
I thought it would be beneficial to introduce you to Tableau Server. If you don't have a Tableau Server license (which is a paid license), I suggest watching this still to give you a good idea of the Tableau product.
https://www.tableau.com/products/server
- Tableau Project 2 - Blue Bank - Reviewing what we will be building1:43
In this Lecture, we review what we will be building.
Project:
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are.
Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Date File:
Use the cleaned data that we exported from python: loan_cleaned.csv
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Blue-Bank-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 2 - Blue Bank - Connecting to the Data6:38
In this Lecture, we connect to the data.
Project:
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are.
Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Date File:
Use the cleaned data that we exported from python: loan_cleaned.csv
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Blue-Bank-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 2 - Blue Bank - Building Charts Part 120:42
In this Lecture, we will build charts.
Project:
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are.
Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Date File:
Use the cleaned data that we exported from python: loan_cleaned.csv
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Blue-Bank-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 2 - Blue Bank - Building Charts Part 223:35
In this Lecture, we will build more charts.
Project:
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are.
Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Date File:
Use the cleaned data that we exported from python: loan_cleaned.csv
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Blue-Bank-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 2 - Blue Bank - Building and Publishing Dashboard22:10
In this Lecture, we will build the dashboard.
Project:
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are.
Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Date File:
Use the cleaned data that we exported from python: loan_cleaned.csv
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Blue-Bank-Logo.png
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 3 - BlogMe - Reviewing what we will be building1:09
In this Lecture, we review what we are building.
Project:
BlogMe, a famous blogging business has a dataset of news articles that they need further analysis on. Firstly, they’d like keywords to be extracted from headlines of the article. Secondly, they would need to determine the sentiment of the news articles. The data is in an excel sheet and they would like to see a dashboard outlying sentiment, top articles etc.
Date File: Use the cleaned file from the python export: blogme_clean.xlsx
BlogMe_sources.xlsx
https://finch-groundhog-9245.squarespace.com/s/BlogMe_sources.xlsx
Logo: (BlogMe Logo.png)
https://finch-groundhog-9245.squarespace.com/s/BlogMe-Logo.png
Tableau Joins:
https://finch-groundhog-9245.squarespace.com/s/TableauJoins-xc7w.pdf
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 3 - Blog Me - Connecting to the Data13:04
In this Lecture, we connect to the data.
Project:
BlogMe, a famous blogging business has a dataset of news articles that they need further analysis on. Firstly, they’d like keywords to be extracted from headlines of the article. Secondly, they would need to determine the sentiment of the news articles. The data is in an excel sheet and they would like to see a dashboard outlying sentiment, top articles etc.
Date File: Use the cleaned file from the python export: blogme_clean.xlsx
BlogMe_sources.xlsx
https://finch-groundhog-9245.squarespace.com/s/BlogMe_sources.xlsx
Logo: (BlogMe Logo.png)
https://finch-groundhog-9245.squarespace.com/s/BlogMe-Logo.png
Tableau Joins:
https://finch-groundhog-9245.squarespace.com/s/TableauJoins-xc7w.pdf
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 3 - BlogMe - Building Charts Part 125:51
In this Lecture, we build charts on Tableau.
Project:
BlogMe, a famous blogging business has a dataset of news articles that they need further analysis on. Firstly, they’d like keywords to be extracted from headlines of the article. Secondly, they would need to determine the sentiment of the news articles. The data is in an excel sheet and they would like to see a dashboard outlying sentiment, top articles etc.
Date File: Use the cleaned file from the python export: blogme_clean.xlsx
BlogMe_sources.xlsx
https://finch-groundhog-9245.squarespace.com/s/BlogMe_sources.xlsx
Logo: (BlogMe Logo.png)
https://finch-groundhog-9245.squarespace.com/s/BlogMe-Logo.png
Tableau Joins:
https://finch-groundhog-9245.squarespace.com/s/TableauJoins-xc7w.pdf
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 3 - BlogMe - Building Charts Part 25:43
In this Lecture, we build charts on Tableau.
Project:
BlogMe, a famous blogging business has a dataset of news articles that they need further analysis on. Firstly, they’d like keywords to be extracted from headlines of the article. Secondly, they would need to determine the sentiment of the news articles. The data is in an excel sheet and they would like to see a dashboard outlying sentiment, top articles etc.
Date File: Use the cleaned file from the python export: blogme_clean.xlsx
BlogMe_sources.xlsx
https://finch-groundhog-9245.squarespace.com/s/BlogMe_sources.xlsx
Logo: (BlogMe Logo.png)
https://finch-groundhog-9245.squarespace.com/s/BlogMe-Logo.png
Tableau Joins:
https://finch-groundhog-9245.squarespace.com/s/TableauJoins-xc7w.pdf
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- Tableau Project 3 - BlogMe - Building and Publishing the Dashboard14:35
In this Lecture, we build the dashboard.
Project:
BlogMe, a famous blogging business has a dataset of news articles that they need further analysis on. Firstly, they’d like keywords to be extracted from headlines of the article. Secondly, they would need to determine the sentiment of the news articles. The data is in an excel sheet and they would like to see a dashboard outlying sentiment, top articles etc.
Date File: Use the cleaned file from the python export: blogme_clean.xlsx
BlogMe_sources.xlsx
https://finch-groundhog-9245.squarespace.com/s/BlogMe_sources.xlsx
Logo: (BlogMe Logo.png)
https://finch-groundhog-9245.squarespace.com/s/BlogMe-Logo.png
Tableau Joins:
https://finch-groundhog-9245.squarespace.com/s/TableauJoins-xc7w.pdf
Where to get resources:
All resources are in the Project Brief.pdf file.
Resources are all available in the lecture description of the relevant videos you are watching.
- A Quiz about Tableau
Requirements
- Basic Knowledge of Computers
- Internet
- Microsoft Excel if Possible
Description
Welcome to the most comprehensive Data Analytics course available on Udemy! When you become a Data Analyst, there are two things that you should be skilled at in order to be a master data analyst, Python and Tableau!
This course is a great choice for beginners looking to expand their skills in Data Analytics. You also create a solid portfolio of your work online and can link it on your resume.
At 11+ hours, this Python and Tableau course will teach you the core principles of Data Analytics at every stage in the pipeline. Even if you have no programming experience, this course will take you from beginner to professional.
Why you should take this course:
Our learning is going to be project-centric: we will tackle the core concepts in Python and Tableau as it comes up in the real life projects we’ll be working on.
You get experience in both Python and Tableau - the two powerhouses in the data analytics community
You also understand how you can clean/analyze data in Python and then visualize it in Tableau - an end-to-end process that many data analysts use today.
You get a chance to showcase your work in a portfolio online
What are the Projects you will work on?
Sales Analysis for Value Inc: We’re going to be working on a Sales Analysis for a popular retail company called Value Inc.
Here we use Python for the following to clean our data and we use popular libraries like pandas and learn how to work with dataframes, perform calculations and much more. We are then going to extract that data to Tableau where we learn how to create calculations, parameters and develop a dashboard for the sales manager.
Loan Analysis for Blue Bank: We’re also going to be working on a Loan Analysis for a bank. Using Python and Tableau, blue bank wants to see an analysis of people who have taken loans but might have issues paying back. We learn how to read JSON files, work with lists, dictionaries, Numpy and if statements. We also learn how to do exceptions, for loops and plots in Python. Once that's done, we extract the data to Tableau and build charts, work with Tableau Calculations and create an interactive dashboard.
Sentiment and Keyword Analysis: We’re also going to be doing a sentiment and keyword analysis for Blog Me. A blogging website that would like us to analyze news headlines and extract a sentiment from these articles. Here, we use a Natural Language Processing Library called Vader, that can extract sentiment on Python. We also learn about functions and classes on Python. Once we extract the data to Tableau, we learn how to perform Tableau Joins, work with sets and context filtering and finally create an interactive dashboard.
In this course you will learn the following:
Python:
Install and Set Up Anaconda
Learn about python variables and data types
Learn about strings, integers
Using lists, tuples and dictionaries
Creating functions
Using if statements and for/while loops
Creating exception handling
Using the exponent function
Working with comments
Reading and writing files
Scripting classes and objects
Sentiment Analysis
Tableau:
Connecting to a data source
Understanding tableau joins and unions
Rename a data field
Assign an alias to a data value
Assign a geographic role to a data field
Change data type for a data field
Change default aggregation properties
Bar Chart
Line Chart
Map
Dual Axis
Create a set
Add a filter
Manual and computed sorts
Reference lines
Table calculations
Bins and Histograms
Calculated fields
Parameters
Create a dashboard
Add dashboard actions
Download dashboards
By the time you complete this course, you'll be a highly proficient Python and Tableau user. You will be using your skills as a data analyst to extract knowledge from data so you can analyze and visualize data with ease.
Who this course is for:
- This course is for anyone who wants to kickstart their career in Data Analytics
- This course is for anyone who wants to learn more about Tableau
- This course is for anyone who wants to learn more about Python