Dein Einkaufswagen ist leer.
Weiter einkaufen
Bei Udemy unterrichten
Hier kannst du dein Wissen und Können an Millionen von Teilnehmer:innen in aller Welt weitergeben und damit richtig Geld verdienen!
Weitere InfosThe Hands-On Masterclass in Data Analytics with Tableau
Bewertung: 4,7 von 54,7(428 Bewertungen)
4.307 Teilnehmer:innen
Das wirst du lernen
- Install Tableau Desktop
- Develop 6 interactive dashboards and showcase them online to create a great profile of work for your Resume.
- Create bar charts, pie charts, and line graphs, scatterplots and much more!
- Combine multiple data sources and learn how to connect Tableau to data sources like Google Sheets, Excel, Azure etc.
- Create calculated fields with conditional logic.
- Format numbers and dates, and add labels, tooltips and animation.
- Work with Parameters
- Create advanced dashboards and tell a story using storyboards
Zugehörige Themengebiete entdecken
Kursinhalt
7 Abschnitte • 43 Lektionen • 9 Std. 36 Min. Gesamtdauer
- Introduction1:58
Hi! Thank you so much for taking my course, The Hands-On Masterclass in Data Analytics with Tableau.
I’ve been in the Data Industry for a while, and personally the best way to become a great data analyst is to learn by practicing. This is exactly what my course does!
In this course you will get to create 6 different dashboards for 6 companies. Each company has a common business problem that needs to be solved, such as analysing customer reviews, determining the performance of a sales agent and helping an e-commerce store flag late deliveries.
You will learn how to build a dashboard consisting of line charts, pie charts, packed bubble charts, tables etc! You will learn how to connect to a database include cloud databases like Azure. You will learn about SQL joins on Tableau as well as creating calculations. You will also learn how to use filters, parameters, sets and the list goes on.
The best thing about this course is you get to publish your dashboards to Tableau Public and share your work on your resume- so you can finally show your experience in a portfolio of work.
So thank you so much for choosing this course, I hope you enjoy it!
- What is Tableau?6:42
Before we start building our Dashboards, I thought a quick introduction on Tableau will be beneficial. Here, I detail why Tableau is so popular and well-known in the Data space.
- A Quick Note on the structure of this course1:24
- How to Download and Install Tableau Desktop1:20
In this lecture, we download and install Tableau Desktop (not Tableau Public). The link is below
https://www.tableau.com/products/desktop/download
- The Different Products of Tableau7:57
Hi, in this lecture we go over the different Tableau Products.
- The Data Lifecycle4:50
Hi, in this lecture we discuss the data lifecycle.
- Why is Data Visualization Important?7:05
Hi, in this lecture we cover why data visualization is important.
- A Tableau Walkthrough5:47
In this lecture, we walkthrough the Tableau interface.
- Park City Peaks - Project Brief5:34
See Project Brief attached
Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. At the moment, the hotel manager can get an excel spreadsheet that he downloads from the Hotel Booking system.
He has given us the spreadsheet and would like to see the following:
Bookings and Cancellations the hotel gets in a monthly basis
Repeated Guests Statistics
The food option guests generally chooses
Do they get singular travellers or family bookings on average?
Data:
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
hotel_bookings.xlsx
https://finch-groundhog-9245.squarespace.com/s/hotel_bookings.xlsx
Icon:
Park City Peaks Hotel.jpg
https://finch-groundhog-9245.squarespace.com/s/Park-City-Peaks-Hotel.jpeg
- Park City Peaks Hotel - Dashboard Overview2:44
In this lecture, we go over what we will be building for Park City Peaks Hotel!
See Project Brief attached
Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. At the moment, the hotel manager can get an excel spreadsheet that he downloads from the Hotel Booking system.
He has given us the spreadsheet and would like to see the following:
Bookings and Cancellations the hotel gets in a monthly basis
Repeated Guests Statistics
The food option guests generally chooses
Do they get singular travellers or family bookings on average?
Data:
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
hotel_bookings.xlsx
https://finch-groundhog-9245.squarespace.com/s/hotel_bookings.xlsx
Icon:
Park City Peaks Hotel.jpg
https://finch-groundhog-9245.squarespace.com/s/Park-City-Peaks-Hotel.jpeg
- Park City Peaks Hotel - Connecting to the Data32:25
Hello! In this lecture we learn how to connect our Data to Tableau.
See Project Brief attached
Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. At the moment, the hotel manager can get an excel spreadsheet that he downloads from the Hotel Booking system.
He has given us the spreadsheet and would like to see the following:
Bookings and Cancellations the hotel gets in a monthly basis
Repeated Guests Statistics
The food option guests generally chooses
Do they get singular travellers or family bookings on average?
Data:
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
hotel_bookings.xlsx
https://finch-groundhog-9245.squarespace.com/s/hotel_bookings.xlsx
Icon:
Park City Peaks Hotel.jpg
https://finch-groundhog-9245.squarespace.com/s/Park-City-Peaks-Hotel.jpeg
- Park City Peaks Hotel - Building our First Chart on Tableau42:23
In this lecture, we go over what we will be building our first chart! To get the data, check resources in the "Park City Peaks Hotel - Connecting to the Data" lecture, otherwise read below where you can download it.
Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. At the moment, the hotel manager can get an excel spreadsheet that he downloads from the Hotel Booking system.
He has given us the spreadsheet and would like to see the following:
Bookings and Cancellations the hotel gets in a monthly basis
Repeated Guests Statistics
The food option guests generally chooses
Do they get singular travellers or family bookings on average?
Data:
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
hotel_bookings.xlsx
https://finch-groundhog-9245.squarespace.com/s/hotel_bookings.xlsx
Icon:
Park City Peaks Hotel.jpg
https://finch-groundhog-9245.squarespace.com/s/Park-City-Peaks-Hotel.jpeg
- Park City Peaks Hotel - Building a Pie Chart on Tableau23:02
In this lecture, we go over what we will be building a Pie Chart! To get the data, check resources in the "Park City Peaks Hotel - Connecting to the Data" lecture, otherwise read below where you can download it.
See Project Brief attached
Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. At the moment, the hotel manager can get an excel spreadsheet that he downloads from the Hotel Booking system.
He has given us the spreadsheet and would like to see the following:
Bookings and Cancellations the hotel gets in a monthly basis
Repeated Guests Statistics
The food option guests generally chooses
Do they get singular travellers or family bookings on average?
Data:
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
hotel_bookings.xlsx
https://finch-groundhog-9245.squarespace.com/s/hotel_bookings.xlsx
Icon:
Park City Peaks Hotel.jpg
https://finch-groundhog-9245.squarespace.com/s/Park-City-Peaks-Hotel.jpeg
- Park City Peaks Hotel - Building a Packed Bubble Chart on Tableau19:25
In this lecture, we go over what we will be building a Packed Bubble Chart! To get the data, check resources in the "Park City Peaks Hotel - Connecting to the Data" lecture, otherwise read below where you can download it.
See Project Brief attached
Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. At the moment, the hotel manager can get an excel spreadsheet that he downloads from the Hotel Booking system.
He has given us the spreadsheet and would like to see the following:
Bookings and Cancellations the hotel gets in a monthly basis
Repeated Guests Statistics
The food option guests generally chooses
Do they get singular travellers or family bookings on average?
Data:
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
hotel_bookings.xlsx
https://finch-groundhog-9245.squarespace.com/s/hotel_bookings.xlsx
Icon:
Park City Peaks Hotel.jpg
https://finch-groundhog-9245.squarespace.com/s/Park-City-Peaks-Hotel.jpeg
- Park City Peaks Hotel - Building a Bar Chart on Tableau13:28
In this lecture, we go over what we will be building a Bar Chart! To get the data, check resources in the "Park City Peaks Hotel - Connecting to the Data" lecture, otherwise read below where you can download it.
See Project Brief attached
Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. At the moment, the hotel manager can get an excel spreadsheet that he downloads from the Hotel Booking system.
He has given us the spreadsheet and would like to see the following:
Bookings and Cancellations the hotel gets in a monthly basis
Repeated Guests Statistics
The food option guests generally chooses
Do they get singular travellers or family bookings on average?
Data:
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
hotel_bookings.xlsx
https://finch-groundhog-9245.squarespace.com/s/hotel_bookings.xlsx
Icon:
Park City Peaks Hotel.jpg
https://finch-groundhog-9245.squarespace.com/s/Park-City-Peaks-Hotel.jpeg
- Park City Peaks Hotel - Building a Dashboard on Tableau17:01
In this lecture, we go over what we will be finally building our Dashboard! To get the data, check resources in the "Park City Peaks Hotel - Connecting to the Data" lecture, otherwise read below where you can download it.
See Project Brief attached
Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. At the moment, the hotel manager can get an excel spreadsheet that he downloads from the Hotel Booking system.
He has given us the spreadsheet and would like to see the following:
Bookings and Cancellations the hotel gets in a monthly basis
Repeated Guests Statistics
The food option guests generally chooses
Do they get singular travellers or family bookings on average?
Data:
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
hotel_bookings.xlsx
https://finch-groundhog-9245.squarespace.com/s/hotel_bookings.xlsx
Icon:
Park City Peaks Hotel.jpg
https://finch-groundhog-9245.squarespace.com/s/Park-City-Peaks-Hotel.jpeg
- Park City Peaks Hotel - Publishing our Dashboard to Tableau Public5:08
In this lecture, we go over what we will be publishing our Dashboard! To get the data, check resources in the "Park City Peaks Hotel - Connecting to the Data" lecture, otherwise read below where you can download it.
See Project Brief attached
Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. At the moment, the hotel manager can get an excel spreadsheet that he downloads from the Hotel Booking system.
He has given us the spreadsheet and would like to see the following:
Bookings and Cancellations the hotel gets in a monthly basis
Repeated Guests Statistics
The food option guests generally chooses
Do they get singular travellers or family bookings on average?
Data:
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
hotel_bookings.xlsx
https://finch-groundhog-9245.squarespace.com/s/hotel_bookings.xlsx
Icon:
Park City Peaks Hotel.jpg
https://finch-groundhog-9245.squarespace.com/s/Park-City-Peaks-Hotel.jpeg
- 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 Interface Quiz
- GreatFit - Project Brief5:30
See Project Brief attached
GreatFit is an online e-commerce store that sells ladies clothing. They make a lot of sales through various platforms. Customers generally leave reviews and GreatFit hasn't been doing any analytics and investigation in the reviews.
The Customer Service manager has asked you to develop a dashboard to give her an idea of how the reviews are. She wants the following:
Do they get a lot of negative/positive reviews?
Analysis on the reviews by division
Do people recommend their products?
Do reviews mention anything about returning items?
She will also like the option to investigate bad reviews. The excel sheet is provided.
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
Greatfit Clothing E-Commerce Reviews.xlxs
https://finch-groundhog-9245.squarespace.com/s/Greatfit-Clothing-E-Commerce-Reviews.xlsx
Icon:
GREATFIT LOGO.png
https://finch-groundhog-9245.squarespace.com/s/GREATFIT-LOGO.png
- GreatFit - Connecting to a Data Source10:01
In this lecture, we learn how to connect to data.
See Project Brief attached
GreatFit is an online e-commerce store that sells ladies clothing. They make a lot of sales through various platforms. Customers generally leave reviews and GreatFit hasn't been doing any analytics and investigation in the reviews.
The Customer Service manager has asked you to develop a dashboard to give her an idea of how the reviews are. She wants the following:
Do they get a lot of negative/positive reviews?
Analysis on the reviews by division
Do people recommend their products?
Do reviews mention anything about returning items?
She will also like the option to investigate bad reviews. The excel sheet is provided.
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
Greatfit Clothing E-Commerce Reviews.xlxs
https://finch-groundhog-9245.squarespace.com/s/Greatfit-Clothing-E-Commerce-Reviews.xlsx
Icon:
GREATFIT LOGO.png
https://finch-groundhog-9245.squarespace.com/s/GREATFIT-LOGO.png
- GreatFit - Building Charts for our GreatFit Dashboard (Part 1)30:47
In this lecture, we build charts for our Greatfit Customer Review dashboard. Check the lecture resources under the lecture "GreatFit - Connecting to a Data Source" if you need the data.
See Project Brief attached
GreatFit is an online e-commerce store that sells ladies clothing. They make a lot of sales through various platforms. Customers generally leave reviews and GreatFit hasn't been doing any analytics and investigation in the reviews.
The Customer Service manager has asked you to develop a dashboard to give her an idea of how the reviews are. She wants the following:
Do they get a lot of negative/positive reviews?
Analysis on the reviews by division
Do people recommend their products?
Do reviews mention anything about returning items?
She will also like the option to investigate bad reviews. The excel sheet is provided.
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
Greatfit Clothing E-Commerce Reviews.xlxs
https://finch-groundhog-9245.squarespace.com/s/Greatfit-Clothing-E-Commerce-Reviews.xlsx
Icon:
GREATFIT LOGO.png
https://finch-groundhog-9245.squarespace.com/s/GREATFIT-LOGO.png
- GreatFit - Building Charts for our GreatFit Dashboard (Part 2)21:02
In this lecture, we build charts for our Greatfit Customer Review dashboard. Check the lecture resources under the lecture "GreatFit - Connecting to a Data Source" if you need the data.
See Project Brief
GreatFit is an online e-commerce store that sells ladies clothing. They make a lot of sales through various platforms. Customers generally leave reviews and GreatFit hasn't been doing any analytics and investigation in the reviews.
The Customer Service manager has asked you to develop a dashboard to give her an idea of how the reviews are. She wants the following:
Do they get a lot of negative/positive reviews?
Analysis on the reviews by division
Do people recommend their products?
Do reviews mention anything about returning items?
She will also like the option to investigate bad reviews. The excel sheet is provided.
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
Greatfit Clothing E-Commerce Reviews.xlxs
https://finch-groundhog-9245.squarespace.com/s/Greatfit-Clothing-E-Commerce-Reviews.xlsx
Icon:
GREATFIT LOGO.png
https://finch-groundhog-9245.squarespace.com/s/GREATFIT-LOGO.png
- GreatFit - Build and Publish the GreatFit Customer Review Dashboard20:44
In this lecture, we build our Greatfit Customer Review dashboard. Check the lecture resources under the lecture "GreatFit - Connecting to a Data Source" if you need the data.
See Project Brief attached
GreatFit is an online e-commerce store that sells ladies clothing. They make a lot of sales through various platforms. Customers generally leave reviews and GreatFit hasn't been doing any analytics and investigation in the reviews.
The Customer Service manager has asked you to develop a dashboard to give her an idea of how the reviews are. She wants the following:
Do they get a lot of negative/positive reviews?
Analysis on the reviews by division
Do people recommend their products?
Do reviews mention anything about returning items?
She will also like the option to investigate bad reviews. The excel sheet is provided.
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
Greatfit Clothing E-Commerce Reviews.xlxs
https://finch-groundhog-9245.squarespace.com/s/Greatfit-Clothing-E-Commerce-Reviews.xlsx
Icon:
GREATFIT LOGO.png
https://finch-groundhog-9245.squarespace.com/s/GREATFIT-LOGO.png
- Dashboard Design Tips7:43
Hi, in this lecture we go over some dashboard design tips.
- Tableau Building Charts
- MegaMart - Project Brief8:24
See Project Brief attached
MegaMart is a store which sells various goods to consumers all over the world. The company works only throughSales Agents who are responsible for selling products to their customers. The sales agents are responsible for thesales of products in specific product categories.
For example, Eli Kavanagh is responsible for selling products belonging in the following categories: Laptops, Kid'sClothing, Kitchen Tools.
The Sales Manager would like to have a complete sales dashboard based on the sales agents. He wants to select asales agent and a specific sales month. From there, he wants to see the following
Sales for the agent every month
A scatterplot showing quantity by sales for each product category
Top 10 SKUs by Sales of the selected month
Top 5 product categories by sales of the selected month
In addition to this, he wants to input a sales target and see how the sales agent is tracking. The data is supplied below
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
1. transaction_data.csv
https://finch-groundhog-9245.squarespace.com/s/transaction_data.csv
2. salesperson.csv
https://finch-groundhog-9245.squarespace.com/s/salesperson.csv
3. product.csv
https://finch-groundhog-9245.squarespace.com/s/product.csv
Icon:
MEGAMARTLOGO.png
https://finch-groundhog-9245.squarespace.com/s/MEGAMARTLOGO.png
- MegaMart - Connecting to Data27:57
Data is available in the Lecture Resources. You can also see Project Brief attached
MegaMart is a store which sells various goods to consumers all over the world. The company works only throughSales Agents who are responsible for selling products to their customers. The sales agents are responsible for thesales of products in specific product categories.
For example, Eli Kavanagh is responsible for selling products belonging in the following categories: Laptops, Kid'sClothing, Kitchen Tools.
The Sales Manager would like to have a complete sales dashboard based on the sales agents. He wants to select asales agent and a specific sales month. From there, he wants to see the following
Sales for the agent every month
A scatterplot showing quantity by sales for each product category
Top 10 SKUs by Sales of the selected month
Top 5 product categories by sales of the selected month
In addition to this, he wants to input a sales target and see how the sales agent is tracking. The data is supplied below
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
1. transaction_data.csv
https://finch-groundhog-9245.squarespace.com/s/transaction_data.csv
2. salesperson.csv
https://finch-groundhog-9245.squarespace.com/s/salesperson.csv
3. product.csv
https://finch-groundhog-9245.squarespace.com/s/product.csv
Icon:
MEGAMARTLOGO.png
https://finch-groundhog-9245.squarespace.com/s/MEGAMARTLOGO.png
- MegaMart - Building Charts (Part 1)52:45
Reading Material Mentioned in the Lecture:
1. Parameters on Tableau: https://help.tableau.com/current/pro/desktop/en-us/parameters_create.htm
2. Sets on Tableau: https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sets_create.htm
3. Tableau's Order of Operations: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm
For Data, view the Lecture Resources in the Lecture "MegaMart: Connecting to Data " See Project Brief attached
MegaMart is a store which sells various goods to consumers all over the world. The company works only throughSales Agents who are responsible for selling products to their customers. The sales agents are responsible for thesales of products in specific product categories.
For example, Eli Kavanagh is responsible for selling products belonging in the following categories: Laptops, Kid'sClothing, Kitchen Tools.
The Sales Manager would like to have a complete sales dashboard based on the sales agents. He wants to select asales agent and a specific sales month. From there, he wants to see the following
Sales for the agent every month
A scatterplot showing quantity by sales for each product category
Top 10 SKUs by Sales of the selected month
Top 5 product categories by sales of the selected month
In addition to this, he wants to input a sales target and see how the sales agent is tracking. The data is supplied below
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
1. transaction_data.csv
https://finch-groundhog-9245.squarespace.com/s/transaction_data.csv
2. salesperson.csv
https://finch-groundhog-9245.squarespace.com/s/salesperson.csv
3. product.csv
https://finch-groundhog-9245.squarespace.com/s/product.csv
Icon:
MEGAMARTLOGO.png
https://finch-groundhog-9245.squarespace.com/s/MEGAMARTLOGO.png
- MegaMart - Building Charts (Part 2)36:10
In this lecture, we build more charts!
For Data, view the Lecture Resources in the Lecture "MegaMart: Connecting to Data " See Project Brief attached
MegaMart is a store which sells various goods to consumers all over the world. The company works only throughSales Agents who are responsible for selling products to their customers. The sales agents are responsible for thesales of products in specific product categories.
For example, Eli Kavanagh is responsible for selling products belonging in the following categories: Laptops, Kid'sClothing, Kitchen Tools.
The Sales Manager would like to have a complete sales dashboard based on the sales agents. He wants to select asales agent and a specific sales month. From there, he wants to see the following
Sales for the agent every month
A scatterplot showing quantity by sales for each product category
Top 10 SKUs by Sales of the selected month
Top 5 product categories by sales of the selected month
In addition to this, he wants to input a sales target and see how the sales agent is tracking. The data is supplied below
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
1. transaction_data.csv
https://finch-groundhog-9245.squarespace.com/s/transaction_data.csv
2. salesperson.csv
https://finch-groundhog-9245.squarespace.com/s/salesperson.csv
3. product.csv
https://finch-groundhog-9245.squarespace.com/s/product.csv
Icon:
MEGAMARTLOGO.png
https://finch-groundhog-9245.squarespace.com/s/MEGAMARTLOGO.png
- MegaMart - Building the Sales Agent Dashboard18:39
In this lecture, we Build and Publish the MegaMart Sales Agent Dashboard.
For Data, view the Lecture Resources in the Lecture "MegaMart: Connecting to Data " See Project Brief attached
MegaMart is a store which sells various goods to consumers all over the world. The company works only throughSales Agents who are responsible for selling products to their customers. The sales agents are responsible for thesales of products in specific product categories.
For example, Eli Kavanagh is responsible for selling products belonging in the following categories: Laptops, Kid'sClothing, Kitchen Tools.
The Sales Manager would like to have a complete sales dashboard based on the sales agents. He wants to select asales agent and a specific sales month. From there, he wants to see the following
Sales for the agent every month
A scatterplot showing quantity by sales for each product category
Top 10 SKUs by Sales of the selected month
Top 5 product categories by sales of the selected month
In addition to this, he wants to input a sales target and see how the sales agent is tracking. The data is supplied below
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
1. transaction_data.csv
https://finch-groundhog-9245.squarespace.com/s/transaction_data.csv
2. salesperson.csv
https://finch-groundhog-9245.squarespace.com/s/salesperson.csv
3. product.csv
https://finch-groundhog-9245.squarespace.com/s/product.csv
Icon:
MEGAMARTLOGO.png
https://finch-groundhog-9245.squarespace.com/s/MEGAMARTLOGO.png
- Quiz on what we learned building the MegaMart Dashboard
- Facebook - Project Brief3:27
See Project Brief attached
A Facebook investor needs some help.
He would like to see a dashboard that updates daily to keep track of FB stocks.
His main priority is to see the following:
Most recent open price
Most recent close price
% change between open and close price
Daily close prices
He doesn’t have any data but is saying the data is publicly available.
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
We will create our own dataset on Google Sheets. Make sure you have a google account
Icon
facebooklogo.png
https://finch-groundhog-9245.squarespace.com/s/facebooklogo.png
- An Important Note before Watching the Next Lecture0:15
- Facebook - Creating the Google Sheet and Connecting to Data12:04
In this lecture we create our Google Sheet which updates daily. We also learn how to connect to Tableau via Google Sheets.
See Project Brief attached
A Facebook investor needs some help.
He would like to see a dashboard that updates daily to keep track of FB stocks.
His main priority is to see the following:
Most recent open price
Most recent close price
% change between open and close price
Daily close prices
He doesn’t have any data but is saying the data is publicly available.
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
We will create our own dataset on Google Sheets. Make sure you have a google account
Icon
facebooklogo.png
https://finch-groundhog-9245.squarespace.com/s/facebooklogo.png
- Facebook - Building Charts for the Investor Dashboard (Part 1)10:58
In this lecture we build the charts to create our Dashboard for the Facebook Investor.
See Project Brief attached
A Facebook investor needs some help.
He would like to see a dashboard that updates daily to keep track of FB stocks.
His main priority is to see the following:
Most recent open price
Most recent close price
% change between open and close price
Daily close prices
He doesn’t have any data but is saying the data is publicly available.
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
We will create our own dataset on Google Sheets. Make sure you have a google account
Icon
facebooklogo.png
https://finch-groundhog-9245.squarespace.com/s/facebooklogo.png
- Facebook - Building Charts Part 214:10
In this lecture we build the charts to create our Dashboard for the Facebook Investor.
See Project Brief attached
A Facebook investor needs some help.
He would like to see a dashboard that updates daily to keep track of FB stocks.
His main priority is to see the following:
Most recent open price
Most recent close price
% change between open and close price
Daily close prices
He doesn’t have any data but is saying the data is publicly available.
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
We will create our own dataset on Google Sheets. Make sure you have a google account
Icon
facebooklogo.png
https://finch-groundhog-9245.squarespace.com/s/facebooklogo.png
- Facebook - Building and Publishing the Dashboard7:25
In this lecture we build our Dashboard for the Facebook Investor.
See Project Brief attached
A Facebook investor needs some help.
He would like to see a dashboard that updates daily to keep track of FB stocks.
His main priority is to see the following:
Most recent open price
Most recent close price
% change between open and close price
Daily close prices
He doesn’t have any data but is saying the data is publicly available.
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
We will create our own dataset on Google Sheets. Make sure you have a google account
Icon
facebooklogo.png
https://finch-groundhog-9245.squarespace.com/s/facebooklogo.png
- Quiz on what we learned building the Facebook Dashboard
- OLIST - Project Brief3:29
See Project Brief attached
Olist is an online e-commerce store which sells and delivers items all over Brazil. The Logistics Manager, doesn't receive any reporting and works off a few spreadsheets.
He is responsible for optimizing the purchase and delivery process. He explains below what this consists:
When a customer orders from us, they make a purchase online. We then deliver all the orders. It is important for us to deliver orders within the estimated delivery date we have given to the customer otherwise the customers complain if their order is late. I want to have a line of sight of orders that have not been delivered yet.
Using this information, he would like the following on a monthly basis:
Total Orders per Month
Number of orders delivered after the estimated delivery date given to the customer
Orders outstanding delivery
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
1. olist_orders_logistics.xlsx
https://finch-groundhog-9245.squarespace.com/s/olist_orders_logistics.xlsx
2. olist_customers_dataset.csv
https://finch-groundhog-9245.squarespace.com/s/olist_customer_data.xlsx
Icon:
OLIST-LOGO.jpeg
https://finch-groundhog-9245.squarespace.com/s/OLIST-LOGO.jpeg
- OLIST - Connecting to the Data8:25
In this lecture we connect to the OLIST Data. See the lecture resources for the data, or see Project Brief attached
Olist is an online e-commerce store which sells and delivers items all over Brazil. The Logistics Manager, doesn't receive any reporting and works off a few spreadsheets.
He is responsible for optimizing the purchase and delivery process. He explains below what this consists:
When a customer orders from us, they make a purchase online. We then deliver all the orders. It is important for us to deliver orders within the estimated delivery date we have given to the customer otherwise the customers complain if their order is late. I want to have a line of sight of orders that have not been delivered yet.
Using this information, he would like the following on a monthly basis:
Total Orders per Month
Number of orders delivered after the estimated delivery date given to the customer
Orders outstanding delivery
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
1. olist_orders_logistics.xlsx
https://finch-groundhog-9245.squarespace.com/s/olist_orders_logistics.xlsx
2. olist_customers_dataset.csv
https://finch-groundhog-9245.squarespace.com/s/olist_customer_data.xlsx
Icon:
OLIST-LOGO.jpeg
https://finch-groundhog-9245.squarespace.com/s/OLIST-LOGO.jpeg
- OLIST - Building Charts for the OLIST Logistics Dashboard19:12
In this section, we build charts for our logistics Dashboard. For the Data, See the lecture resources in the lecture "OLIST - Connecting to the Data" or see Project Brief attached
Olist is an online e-commerce store which sells and delivers items all over Brazil. The Logistics Manager, doesn't receive any reporting and works off a few spreadsheets.
He is responsible for optimizing the purchase and delivery process. He explains below what this consists:
When a customer orders from us, they make a purchase online. We then deliver all the orders. It is important for us to deliver orders within the estimated delivery date we have given to the customer otherwise the customers complain if their order is late. I want to have a line of sight of orders that have not been delivered yet.
Using this information, he would like the following on a monthly basis:
Total Orders per Month
Number of orders delivered after the estimated delivery date given to the customer
Orders outstanding delivery
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
1. olist_orders_logistics.xlsx
https://finch-groundhog-9245.squarespace.com/s/olist_orders_logistics.xlsx
2. olist_customers_dataset.csv
https://finch-groundhog-9245.squarespace.com/s/olist_customer_data.xlsx
Icon:
OLIST-LOGO.jpeg
https://finch-groundhog-9245.squarespace.com/s/OLIST-LOGO.jpeg
- OLIST - Publishing our Logistics Dashboard10:05
In this section, we build and publish the logistics Dashboard. For the Data, See the lecture resources in the lecture "OLIST - Connecting to the Data" or see Project Brief attached
Olist is an online e-commerce store which sells and delivers items all over Brazil. The Logistics Manager, doesn't receive any reporting and works off a few spreadsheets.
He is responsible for optimizing the purchase and delivery process. He explains below what this consists:
When a customer orders from us, they make a purchase online. We then deliver all the orders. It is important for us to deliver orders within the estimated delivery date we have given to the customer otherwise the customers complain if their order is late. I want to have a line of sight of orders that have not been delivered yet.
Using this information, he would like the following on a monthly basis:
Total Orders per Month
Number of orders delivered after the estimated delivery date given to the customer
Orders outstanding delivery
Data
You can check the lecture resources or project brief in the course. You can also download it here:
Dataset:
1. olist_orders_logistics.xlsx
https://finch-groundhog-9245.squarespace.com/s/olist_orders_logistics.xlsx
2. olist_customers_dataset.csv
https://finch-groundhog-9245.squarespace.com/s/olist_customer_data.xlsx
Icon:
OLIST-LOGO.jpeg
https://finch-groundhog-9245.squarespace.com/s/OLIST-LOGO.jpeg
- AdventureWorks - Project Brief3:24
See Project Brief attached
Adventure Works is a retail store which sells bicycles and other fitness/exercise items. You are required to do a quick presentation on their shipping and sales data.
What are the top cities they ship to and the sales per city
Who are the top customers they sell to.
Who are their top sales agents
You can connect to their database on Azure. The manager has given you the following credentials
Data
Server: sqlservercentralpublic.database.windows.net
Database: AdventureWorks
User: sqlfamily
Password: sqlf@m1ly
You can also connect to the csv extracts, if you have an issue connecting to the data warehouse
If this is the first time connecting to Azure on Tableau, make sure you download the driver
https://www.tableau.com/support/drivers (Choose Azure Synapse Analytics). If you cannot connect to Azure, I have provided the csv extracts of the data.
Icon: adventureworkslogo.png
https://finch-groundhog-9245.squarespace.com/s/adventureworkslogo.png
- AdventureWorks - Connecting to a Cloud Database8:17
In this lecture, we connect to a cloud data warehouse, Azure! See Project Brief attached
You can also view the lecture resources in the lecture "AdventureWorks - Connecting to a Cloud Database" for the Data.
Adventure works is a retail store which sells bicycles and other fitness/exercise items. You are required to do a quick presentation on their shipping and sales data.
What are the top cities they ship to and the sales per city
Who are the top customers they sell to.
Who are their top sales agents
You can connect to their database on Azure. The manager has given you the following credentials
Server: sqlservercentralpublic.database.windows.net
Database: AdventureWorks
User: sqlfamily
Password: sqlf@m1ly
If this is the first time connecting to Azure on Tableau, make sure you download the driver
https://www.tableau.com/support/drivers (Choose Azure Synapse Analytics). If you cannot connect to Azure, I have provided the csv extracts of the data.
Icon: adventureworkslogo.png
https://finch-groundhog-9245.squarespace.com/s/adventureworkslogo.png
- Adventure Works - Creating a Story on Tableau23:07
In this lecture, we build our stores on Tableau! See Project Brief attached
You can also view the lecture resources in the lecture "AdventureWorks - Connecting to a Cloud Database" for the Data.
Adventure works is a retail store which sells bicycles and other fitness/exercise items. You are required to do a quick presentation on their shipping and sales data.
What are the top cities they ship to and the sales per city
Who are the top customers they sell to.
Who are their top sales agents
You can connect to their database on Azure. The manager has given you the following credentials
Server: sqlservercentralpublic.database.windows.net
Database: AdventureWorks
User: sqlfamily
Password: sqlf@m1ly
If this is the first time connecting to Azure on Tableau, make sure you download the driver
https://www.tableau.com/support/drivers (Choose Azure Synapse Analytics). If you cannot connect to Azure, I have provided the csv extracts of the data.
Icon: adventureworkslogo.png
https://finch-groundhog-9245.squarespace.com/s/adventureworkslogo.png
- A Goodbye Note0:23
Once again, thank you so much for taking my course!
Please have a look at my other courses as well:
https://www.udemy.com/course/the-complete-introduction-to-data-analytics-with-tableau/
https://www.udemy.com/course/tableau-crash-course-build-and-share-a-covid-19-dashboard/
Anforderungen
- No previous programming knowledge required
- Basic knowledge of computers is needed
Beschreibung
Are you ready to become an Expert in Data Analytics? Do you want more practical, hands-on experience in Data Visualization and tools like Tableau? Do you want to add a portfolio of dashboards to your resume so you can land your dream job in Data?
This course is for YOU!
In this course you will build 6 separate dashboards for companies that face real business problems . You will learn how to connect to various data sources from Excel files to cloud servers such as Azure. You will also learn how to build interactive dashboards and publish it to Tableau Online! You can link these in your resume to show potential employers what you can do!
You will create dashboards that help a hotel manage a booking system, assist a customer service manager in sorting through thousands of reviews, create a sales dashboard for a very busy sales manager and even put together a quick presentation based on the data in a cloud data warehouse!
You will master the skills to become a good Data Analyst and build a solid foundation in understanding the data pipeline.
In this course you will learn:
Create 6 interactive dashboards and publish it online to share
Learn how to connect to different data sources such as Excel, Google Sheets and Cloud Servers.
Create a variety of charts including bar charts, line charts, donut charts, maps, tables and dual axis charts.
Create calculated fields including developing IF Statements.
Create sets, hierarchies and groups.
Understanding how joins work.
Understand Level Of Detail calculations.
Create Parameters
Make use of the analytics pane including using trend lines
How to use dashboard actions and create interactive dashboards.
Creating a dashboard which updates daily via google sheets.
By the time you complete this course, you'll be a highly proficient Tableau user and use all the learning from to course to enhance your career in Data and Analytics.
Projects you will work on:
Park City Peaks Hotel: Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. You will create an interactive dashboard to help the hotel manager analysing guest and booking data.
GreatFit: Greatfit is an online e-commerce store that sells ladies clothing. Customers generally leave reviews and Greatfit hasn't been doing any analytics and investigation in the reviews. The Customer Service manager has asked you to develop a dashboard to give her an idea of how the reviews are.
MegaMart: Megamart is a store which sells various goods to consumers all over the world. The company works only through Sales Agents who are responsible for selling products to their customers. The Sales Manager would like to have a complete sales dashboard based on the sales agents
Facebook: A Facebook investor needs some help. He would like to see a dashboard that updates daily to keep track of FB stocks and the volume traded.
OLIST: Olist is an online e-commerce store which sells and delivers items all over Brazil. The logistics managers want you to create a dashboard so he can have a line of sight of any delivery issues.
Adventure works: Adventure Works is a retail store which sells bicycles and other fitness/exercise items. You are required to do a quick presentation on their shipping and sales data in their Cloud Data warehouse, Azure.
Für wen eignet sich dieser Kurs:
- This course is for anyone who wants to kickstart their career in Data Analytics
- This course is for anyone who wants to learn Tableau or Data Analytics