- Hello, I am Professor Rick Jerz and I welcome you
to this session titled cluster charts in Tableau.
In this session,
we're going to see how to make cluster charts
which can be made in Microsoft Excel,
but we are going to learn how to do these in Tableau.
I think that you will enjoy this session,
let's gets started.
A clustered chart is a bar chart
showing more than one category.
This type of chart can be handy when we want to compare
two more more samples of data.
We will be learning how to compare
two samples of data statistically.
The cluster chart allows us
to compare two samples visually.
In Microsoft Excel you can create a cluster chart
by using this tool.
We are going to see how to do this in Tableau.
I have provided to you a real estate data set
that contains cells of homes
from the North Valley Real Estate company.
We will use this data set
to create our charts using Tableau.
I begin by opening Tableau and connecting to this Excel
real estate file.
Immediately, the data is brought in to Tableau.
I am going to work on sheet one.
The first thing that I want to explore
is the number of homes sold within a price range of homes.
I am going to use a price range of $50,000.
Since price is a continuous measure,
I need to create bins,
in order to create separate bars
and I am not going to show you how I do this right here
I want you to return to my previous session
where I show you how to create bins for continuous data
and see if you can create price bins again
using what I have previously taught you.
So in this session I already have my price bins created,
I drag my price bins to columns
and the number of records to rows.
I rename the sheet to number of homes by price,
and I size it to fit.
This chart shows the overall number of homes sold
within each price range,
but let's say I'm curious to know
the number of homes sold by agent in each price range.
I drag agents to columns,
and I'm going to drag agents to color
just to color the agents.
Now I have a clustered chart showing
the number of homes sold within each price range by agent.
I'll change the title of this sheet.
We can use this Tableau graphic to see that
Peterson has sold one of the most expensive homes,
and Carter has sold the most homes
in the $350-400,000 price range.
The power of visual analytics is that you can get a lot
of detail about what is going on
in a very short amount of time.
You might want to spend some time dragging different kinds
of dimensions into the columns,
to see what kind of cluster charts you can create
and the kind of data that you are able to observe.
Remember to save this Tableau file.
What I would suggest doing
after you have finished this assignment,
is to go back and repeat it.
Repeating what you have done
will help you learn how to use this Tableau product.
Thanks for taking time to spend some moments with me.
I hope that you have enjoyed what I have shared with you.
If you ever have any questions,
or need my help,
please let me know.