Creating great looking charts in Tableau: Real life Exercise on charts in Tableau
Key Takeaways
This video by 365 Data Science covers creating great-looking charts in Tableau using a real-life exercise on audiobook sales and reviews data, teaching how to build a complete dashboard and analyze review growth, average review score, and correlation with sales.
Full Transcript
hello and welcome back now that we are nearly finished with our introduction to tableau it is time to start creating great-looking charts and use them to build a complete dashboard this is way more exciting than getting acquainted with tableaus interface isn't it to do that will solve a complete real-life exercise and each lesson will build upon the previous one sounds great right all right then let's get started here's the excel data we'll use it was provided by a company that has produced several audiobooks and has been selling them at an online marketplace one of the main components of that marketplace is reviews so we have two files one about sales and another one containing information about reviews customers left for each audiobook both files contain the date when a purchase or a review occurred it will be great if we manage to produce a table that takes advantage of both types of data we have when a person bought an audiobook and when and with which rating a person left a review if we manage to do that we'll be able to create several different charts in tableau that would allow us to learn if the number of reviews the company receives has been growing how did the average review score change over time what is the percentage breakdown between 10 star 9 star 8 star and other types of reviews what percentage of people acquiring an audiobook leave a review visualize the correlation between audio book sales and number of reviews or perhaps visualize the correlation between average review score and sales in the lessons to come you'll see how to do all of that stay tuned and thanks for watching
Original Description
👉🏻 Download Our Free Data Science Career Guide: https://bit.ly/2POLaN8
👉🏻 Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/3iKD0lv
It is time to start creating great-looking charts in Tableau and use them to build a complete dashboard.
To do that, we’ll solve a complete real-life exercise. And each lesson will build up on the previous one.
Here’s the Excel data, we’ll use.
It was provided by a company that has produced several audiobooks and has been selling them at an online marketplace. One of the main components of that marketplace is reviews, so we have two files – one about sales, and another one containing information about reviews customers left for each audiobook.
Both files contain the date when a purchase or a review occurred.
It will be great if we manage to produce a table that takes advantage of both types of data we have – when a person bought an audiobook and when and with which rating a person left a review.
If we manage to do that, we’ll be able to create several different charts in Tableau that would allow us to learn:
• If the number of reviews the company receives has been growing?
• How did the average review score change over time?
• What is the percentage breakdown between 10-star,9-star, 8-star and other types of reviews?
• What percentage of people acquiring an audiobook leave a review?
• Visualize the correlation between audiobook sales and number of reviews, or perhaps visualize the correlation between average review score and sales;
In the lessons to come, you’ll see how to do all of that!
► Consider hitting the SUBSCRIBE button if you LIKE the content: https://www.youtube.com/c/365DataScience?sub_confirmation=1
► VISIT our website: https://bit.ly/365ds
🤝 Connect with us LinkedIn: https://www.linkedin.com/company/365datascience/
365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowl
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from 365 Data Science · 365 Data Science · 58 of 60
1
2
3
4
5
6
7
8
9
10
11
12
13
![INDEX and MATCH application of the two functions separately and combined [Advanced Excel]](https://i.ytimg.com/vi/9vrIFfMdYng/mqdefault.jpg)
14
![INDIRECT Excel Function: How it works and when to use it [Advanced Excel]](https://i.ytimg.com/vi/kDkS8rNCoBM/mqdefault.jpg)
15
![VLOOKUP and MATCH another useful functions combination [Advanced Excel]](https://i.ytimg.com/vi/2435x9FV6qY/mqdefault.jpg)
16
![VLOOKUP COLUMN and ROW - Handle large data tables with ease [Advanced Excel]](https://i.ytimg.com/vi/ToUaAqevy9E/mqdefault.jpg)
17
![The ELIF keyword [Python Fundamentals]](https://i.ytimg.com/vi/h3Vi9mtw2Jo/mqdefault.jpg)
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
▶
59
60
Population vs Sample
365 Data Science
Data Science & Statistics: Levels of measurement
365 Data Science
Statistics Tutorials: Mean, median and mode
365 Data Science
Skewness
365 Data Science
What is a distribution?
365 Data Science
The Normal Distribution
365 Data Science
Central limit theorem
365 Data Science
Student's T Distribution
365 Data Science
Type I error vs Type II error
365 Data Science
Hypothesis testing. Null vs alternative
365 Data Science
The linear regression model
365 Data Science
Simple linear regression model. Geometrical representation
365 Data Science
INDEX and MATCH application of the two functions separately and combined [Advanced Excel]
365 Data Science
INDIRECT Excel Function: How it works and when to use it [Advanced Excel]
365 Data Science
VLOOKUP and MATCH another useful functions combination [Advanced Excel]
365 Data Science
VLOOKUP COLUMN and ROW - Handle large data tables with ease [Advanced Excel]
365 Data Science
The ELIF keyword [Python Fundamentals]
365 Data Science
Working with Tuples in Python
365 Data Science
Database Terminology - A Beginners Guide
365 Data Science
Relational Database Essentials
365 Data Science
Database vs Spreadsheet - Advantages and Disadvantages
365 Data Science
Conditional Statements and Loops
365 Data Science
Backpropagation – The Math Behind Optimization
365 Data Science
Monte Carlo: Forecasting Stock Prices Part I
365 Data Science
Monte Carlo: Forecasting Stock Prices Part II
365 Data Science
Monte Carlo: Forecasting Stock Prices Part III
365 Data Science
365 Data Science Online Program
365 Data Science
Data frames - Creating a data frame
365 Data Science
Data Science & Statistics: Slicing a matrix in R
365 Data Science
Data frames in R - Exporting data in R
365 Data Science
Data frames in R - Transforming data PART II
365 Data Science
Data Frames in R - Subsetting a data frame
365 Data Science
Data Science & Statistics: Matrix arithmetic in R
365 Data Science
Data Science & Statistics: Indexing an element from a matrix
365 Data Science
Data Frames in R - Extending a data frame
365 Data Science
Data Science & Statistics: Creating a matrix in R FASTER
365 Data Science
Data Science & Statistics: Creating a Matrix in R
365 Data Science
Data frames - Importing data in R
365 Data Science
Data frames in R - Getting a sense of your data
365 Data Science
Data frames in R - Transforming data PART I
365 Data Science
Data frames in R - Import a CSV in R
365 Data Science
Data Science & Statistics: Matrix operations in R
365 Data Science
Data Science & Statistics: Matrix recycling in R
365 Data Science
Tableau vs Excel: When to use Tableau and when to use Excel
365 Data Science
Download Tableau: Learn how to download Tableau Public
365 Data Science
Connecting data sources: Useful tips when connecting data sources to Tableau
365 Data Science
The Tableau interface: See how to navigate through the Tableau interface
365 Data Science
Tableau data visualization: Create your first Tableau visualization!
365 Data Science
Duplicating sheets: This is how to duplicate a sheet in Tableau
365 Data Science
Build a table in Tableau: The steps needed to create a simple table in Tableau
365 Data Science
Custom fields in Tableau: Using Tableau operators to create custom fields
365 Data Science
Custom fields in Tableau: Add calculations to tables through custom fields
365 Data Science
Totals in Tableau: Learn how to display subtotals and totals in Tableau
365 Data Science
Gross Margin calculation in Tableau
365 Data Science
What is a filter in Tableau: Set up a filter in Tableau to specify the data you want to show
365 Data Science
Joins in Tableau: Inner, outer, left, or a right join in Tableau
365 Data Science
Building a Tableau dashboard: Three types of charts you want to have in a Tableau dashboard
365 Data Science
Creating great looking charts in Tableau: Real life Exercise on charts in Tableau
365 Data Science
Joins in Tableau: Choose the correct join type
365 Data Science
How to make a data check in Tableau: A quick data check is better than no data check
365 Data Science
More on: Data Literacy
View skill →
Related AI Lessons
⚡
⚡
⚡
⚡
The Attention Economy: Your Attention Is Worth More Than Gold
Medium · Data Science
What I Learned Building a Tableau Dashboard for Deloitte’s Data Analytics Simulation
Medium · Data Science
Six Months, 9,541 Restaurant Development Records, and What the Data Actually Says
Medium · Data Science
CRM Analitiği ile Müşteri Değerini Anlamak: RFM, CLTV ve Predictive CLTV Rehberi
Medium · Data Science
🎓
Tutor Explanation
DeepCamp AI