Hello and welcome back to the course that will prepare you for your tablet certified associate exam.
Super excited for this section.
This is one of the most difficult sections but at the same time the one of the most fundamental or the
most fundamental section in the course and the good news is that by the end of it you will be an expert
at Tableau fundamentals and good news number two is we've got a very exciting dataset for our analysis
today.
So the dataset is the NBA season 2018 19.
So let's go ahead and drag that into Excel.
Open it up it's the CSP file and that's totally okay.
Excel can handle those.
So let's have a look what do we have here we have a lot of data as you can see if you zoom out you have
all these columns you have how many columns do we have.
We have 30 columns and we have almost all we have six hundred and twenty three rows.
Well 622 not including the header.
So what do we have.
Well we have something called a conference a division the team of the NBA and NBA by the way in case
you're not familiar with story find is the National Basketball Association in America.
That's where Michael Jordan played and lots of interesting things are happening is really very interesting.
But I actually really like the NBA.
They've got the player.
So this dataset is at player level.
That's the most granular level you can go so you got individual players the team they belong to the
division.
And don't worry if you don't know exactly how these divisions and conferences work.
I didn't know either.
And we're going to discuss that in next material just that we're all up to speed.
But for now let's just have a look.
So player which team they belong to.
Which division that team belongs to and which conference that division belongs to.
So quite a lot of different layers of depth so you can see here that was first team here in the data
set as Boston sell ticks.
Then after that we've got Toronto Raptors and they all are in Atlantic Division.
So if we scroll down you see all these teams around Antarctic Division.
Then we've got the central division still in the Eastern Conference.
Then you have Salafis division in the Eastern Conference and so on.
And then it changes to the Western Conference so there's only two conferences eastern and western and
each one is three divisions.
But again we'll talk about that in the next tutorial.
Now let's look at our player stats.
So here we've got their age during that season the number of games that they played.
And by the way if you're an NBA fan we hear we're looking at the regular season not the playoffs so
first the regular season comes.
Each team plays about 82 games in the regular season.
So you can see a J Jason was part of 79 of those two games.
And then if the team performs very well then they go into the playoffs which is the tournament part
and then there's the finals.
So this is just a regular season game started.
I understood I understand the stat is is how many games they actually were in the game at the very least
from the very start.
They didn't like go into the game later but they came from the stars.
For instance here you can see Dane Daniel was in 66 games but he only started to as I understand is
that he entered the other 64 games after the game had restarted not because he was late but because
exists coach probably put him in later.
That's as I understand this that.
But we won't be using this one much anyway minutes played how many minutes that player played during
the season field goal scores.
That's how many hoops they scored field goals attempted.
That's how many troops they tried to get in.
That's the percentage.
Very interesting statistic.
How many what is their accuracy rate.
Basically that's across all field goals two pointers and three pointers.
Now you have the same statistics for three pointers so you can see that this player's accuracy for three
pointers is that which is normal for all players.
Usually the three three point three points are accuracy is less because you're further away than the
here's a two pointer statistics.
Separately again.
So this one total how many they got in 350 whoops went into 125 attempts.
Total accuracy 48 percent effective field goal percentage.
That takes into account that three pointers are worth more than two pointers.
So that's similar to a field goal percentage but it takes into account the difference between the two
and three pointers in terms of points free throws.
How many free throws that person tried 10 did completed attempts.
Again accuracy offense offensive rebounds we like if we won't be using a lot of these stats but if you're
an NBA fan you will know them or you can look them up so you can look them up and understand exactly
what they mean.
To discuss them now because I'm not that proficient of NBA at all and very very amateur NBA observer.
So I'll mention the ones that we are important assistance when that player passes a ball to another
player and that player makes you know makes a score.
That's an assist deal is when you take away the ball block is when you don't let another player score
in Europe turn into your net turnovers.
Yeah I'm not sure exactly what her is personal or I can't explain it well enough I'm not going to attempt
explaining it personal files.
How many follows him made points is how many points they scored.
So there you go that's our NBA stats and here we can see it's all like by team by player division conference
and so on a lot of a lot of stats very exciting data set.
So how do you get into tableau.
Well step one is you can just open this TWD X in every folder.
We have a TWX applied for you for your convenience so that all you have to do especially if you have
double desktop or you have to do is just open it up and the data center is already connected here so
don't worry about the connections.
Everything is done for you.
You can later on later on we'll have a whole section about connections so you'll you'll be sick of them
by then.
And the other option is just take this CSP file so open up Tableau and give it a second to load that.
This is a very fast option as well.
In case you can't open the TWX for whatever reason just drag it in.
Boom you are connected don't need to change anything here.
Proceed straight to the sheet.
Great.
Don't forget to save your workbook press Come on [REMOVED] press this button and you're ready to go.
So that is how we can tell there is that that is what it's all about.
If you want to explore a little bit please go ahead.
Otherwise I'll see you in the next tutorial.
And until then happy analyzing.