 what's going on everybody welcome back to the tablet tutorial series this is a very last video in the series and today we'll be doing an entire project now if you're watching this video i hope that you watch the other four videos in this series just so you can get the basics down you kind of know what you're doing this won't be a crazy hard project this is a beginner tutorial series so i'm trying to make this super easy so they can follow along nothing super complicated i promise and if you were wanting to go above and beyond just make a lot of different dashboards or try a lot of different things there's a ton of data in here and so i'll show you some of the things that i would do you know as we go through it of the things that i would be looking at and some of the different visualizations that i might do as well but again in this video we're going to be singing to a lot of the basics but i'll switch over my screen in just a second i will show you the final product and then we will actually walk through step by step of how to do the entire dashboard and at the end you should have a completed project that you can add to your portfolio or you know just share on linkedin if you want to do that as well with that being said let's jump over my screen and let's get started all right so let's get me off screen and show you what we're going to be working on today this is the final dashboard that we're actually going to be building and so it's nothing crazy right i'm sure you have seen all of these things before and i'm just going to help you kind of build it out show you what to do the buttons to click and it's really going to be a simple walkthrough by the end of this you should be able to do all these things very easily and i highly encourage looking at the data and looking at these visualizations and seeing what else you can do with it there's a lot of different colors a lot of different visualizations that you can do with this data i'm just showing you this today and so the more you go out there and the more you do this on your own and you mess around with stuff and and choose different things and see how it all works the better you're going to get and so i highly highly encourage doing that so what we are going to be working with today is an airbnb dataset i'm going to show you that in just a second and i'm going to show you the data and we're going to just jump right into it all right so this is the dataset that we are going to be using this is the seattle airbnb open dataset and let's go down really quick there's three different csv's in here and so this is some of the data that we're going to be working with some date on listings and some pricing and then there's the actual listing that shows the actual street address the location the price the bedrooms all of these good stuff and then there's a reviews and it has you know some comments and you know talks about some of the reviews so this is what we're going to be working with but you don't have to go in here and download it i have already combined all of these csv's into one i've put it on the github so i'll have a link below so you can just click on that and you don't have to do all the stuff that i did to get this setup just so you know this is from 2016 so this dataset is a little bit old if you want to you can come right here and i will leave this link as well and you can get the dataset from you know what is this a couple weeks ago uh this is they they are continuing to update this this is always updated and so you can go ahead and download these but some of these are the csv.gz so you may need to like convert it i don't want to go through that process um you know in the video and so i am just going to go with what is literally in kaggle and use that but if you want to have an updated one for your project i just advise you to go in here and grab yourself and that should be perfectly good so go ahead and download the dataset from the github and we should be good to go so this is the excel that i was just talking about this has all of our csv's in one place this is you know an excel workbook so in this reviews actually i'll start with the listings because that's kind of where all stems from we have our listing and the date or the data in here is um you know really extensive there's a lot of data in here so let's get over really quick um the listing refers to the actual home that they're renting out the airbnb so it shows their location um and there's a lot more location information over here i'm getting into it in just a second so there's the neighborhood the city state zip code all stuff that you know may be useful there's a latitude and longitude it shows what type of property it is so that's really good um right over here it has you know how many bathrooms bedrooms and beds um you know sometimes if it's a five bedroom house it has seven beds so that's why there's those two different fields i don't know if you're familiar with airbnb and and you know what they have on there but just something to note they have the price this is the price per day there's a weekly price a monthly price and and if there's a deposit needed and then a cleaning fee as well so a bunch of financial data that's you know super useful we go into it a little bit but there's so much you can do with that um you know if you want to dig into that and that's kind of it the rest of it's pretty uh pretty useless um and there's a lot it's there's so much data in here almost you know more than half by far is nothing you would put in any type of visualization um and this is pretty common uh you're you're not going to get data every column where you're going to be able to use it a lot of times it's just a lot of useless junk and so you have to know what you're looking for and know uh you know what's actually useful so that's the listing then we have reviews now what's really a little bit confusing in here and something that you just need to kind of understand about the data um and something that if you were if you get a data analyst job you need to understand your data because it's very easy to come in here and say okay there's an id id field and here's an id field so that means that those are the same well not in this case um this id field is actually the review reviews id not the reviewer id that refers to like the person this is the reviews id this listing id is the actual id right there so really important to note um and then the lat and so then they just have their comment there what they left as a review and then on the calendar um i don't know why i'm scrolled down uh we have this listing id again so again that listing id is equal to the id in this listing table and we have a date and a price so this refers to a specific location and on this day they got 85 dollars for it somebody rented it out um and so then there's these like t's and f's um let's try to find a blank one really quick here's a blank one so there's these t's and f's uh the t means that it was taken um the f means that it's vacant uh i don't know exactly what it means uh with the t enough means but that we can deduce that much from this and so you can see when and how much this person was making or this home made uh in that time so really really good data in here there's a lot to work with um and so we're just going to be kind of i'll give you a little bit of a use case for it in a second and then we're going to start trying to answer some of those the building out some of the visualizations for that use case uh again you could have 20 different use cases for this data or more um honestly for this data where you could build out different dashboards and different reports literally with just this data but you know we're doing a pretty general broad project and so it's hard to answer all of them so let's jump over to tableau we're going to get started on this and we are going to build out everything all right so let's come right here uh this is a microsoft excel we'll open that up do this one we will open it and give it just a second since it's executing the query it's pulling the data in all right so we have our calendar our listing and our reviews those are different tabs at the bottom we're gonna start with the listing this is the kind of the main one has um you know the there's i didn't show you but there's about 3,600 locations that they had in there let's just have it update automatically i don't know why we need to click on that but so we have this listings we have our calendar and our reviews what we're going to do is going to come in here and we're going to open it as we did in our very last video for the joins so now that we've opened it we can kind of go in here and we can do the joins as as needed and so let's go over here and we're going to let's start with calendar i'll put it right there that was super slow i apologize all right let's wait for it to get the data so it's setting everything up did not think it would take this long i apologize no take your time so let's click on here and right now it has the uh the join based on the price which obviously is not going to work um and if you remember there is no id in this calendar it's just the listing id we can actually look right here there's just the listing id so we're actually going to put listing id is equal to id and right down here we can see that we have a lot of well you can't see it but we show that there is a lot of data and so we know that that is correct we know that that is now pulling in data correctly because it's showing up down here so that's a good thing now in this listings there are about 3600 about 3600 listings and so that all the data that's in listings is going to be in there but on the calendar because we converted from a csv to an excel workbook it isn't able to store as much information so some of the ones in calendar may have gotten cut off so we can just keep it this inner join because we know that if it's in listings is going to be in calendar we know that it if it um there may be some in calendar that aren't in listings so if we really um you know if we really really wanted to we could do a full outer or something like that i i haven't really thought through this as i'm talking through it in my head but we know that everything that's in listing is going to be in calendar and so you know we don't really need to do anything other than an inner join and we can also pull in these reviews and it's going to do the same thing as before we're just kind of pulling in the data and it defaults to id equals id now we know that that is not correct um because the id in here is referring to the review id we need to go to the listings id so we need the id be able to look you know be part of that listings id if we do the id it goes down to 2555 rows if we do how it's supposed and there because that's just you know it's random luck there happen to be some numbers that are in both fields um that tie together if we do the correct one where we hit the listing id it bumps it up to i think two million three hundred and seventy three thousand oh maybe more than that uh 23 million rows right a lot lot lot more and so it's super important to get these joins right to tie them together on the right fields if you just do it based off what Tableau tells you because it has that automated um you know it goes into these fields and says okay these are the same exact column name so they're most likely going to be what you're looking for well it was incorrect in this point so it's really important to check those things and make sure you're pulling in the right data again we're going to keep it that inner join um you know if you wanted to you know try to see if there's any other data that correlate or keeping it simple today but sometimes you need to join in multiple things uh so just uh uh you know a tip so let's get out of here um and we are good to go so this is our listings plus Tableau full project that's what we'll that's what we'll be working with um and we we were able to tie all three of these um you know as you call them tables or sheets or whatever you want to call them we were able to tie them together so let's go over here to our first worksheet uh and let's see all right so this is Tableau public only works with less than 15 million rows of data we have 23 million rows of data that is uh that's a problem um and when I did this before it didn't do that so I you know we're going to work through this together so this is date reviews I believe this is date for um this is date for the calendar which is going to be a lot of rows of data and so I'm sure that's part of it let's see let's do years should we only want 2016 oops we only want 2016 let's do okay let's see what that does let's see if that gets us under what we need um we only want 2016 data anyways so if it's in 2017 we were going to take it out um anyway so we'll see if that gets us underneath I have absolutely no if this ends up taking like 20 minutes I will just cut it and you know you won't have to wait as long as I'm waiting so let's see how long it takes all right so it took about 20 minutes and it absolutely nothing um one thing I do know is that we don't actually use this review tables at all it's just for demonstration purposes so we're going to remove that and let's see if that helps us in any way because if it does we're just going to keep it as is um you know the reviews table is really just for demonstrating how to do the joins but we're not actually using any of the data for any of the visualizations although you could again I'm going to see how long this takes and I'll cut ahead all right so that worked perfectly it apparently took out all the data that we needed all the rows that we needed to get under that level again I was just doing that to show you the that that joins how you need to change the columns to make sure that it joined properly we don't actually use it for any of the visualizations so their end product is going to be totally fine I don't know why this didn't happen to me when I when I created this whole thing already um so I'm just going to move forward because I make mistakes so let's keep moving the first one that we were going to make is that uh is that colorful one I'll probably pop it up on screen so you can see it well if I remember I'm going to pop it up on screen um it's the colorful one it's the price by zip code so we're going to be looking at these zip codes and kind of see um you know how expensive is each zip code um and before we actually start I just remembered I want to talk to you about the use case for this data I want to imagine you to imagine that you're working for something they're like hey where you know I I want to start an Airbnb business I want to know where I should go where should I buy a buy a home put it up on Airbnb and start renting it out where's the best place you know what are some of the factors that I should be looking at uh and so that's kind of what our use case is so we're going to the some of the things that he cares about are things like bedrooms um location which is really important and how much price he's actually going to get how much money can he charge and so he's trying to optimize that to make sure that whatever rental he gets he can make a the most profit from instead of choosing something that you know he thinks would work but you know in the end he's actually not making that much money so those things are important so that's our use case we're trying to help this guy out help him find a really good Airbnb um so let's take a look at these zip codes real quick we have uh quite a few of them and there's one that's null uh we'll exclude that or if it doesn't have zip code we'll just exclude those because they're not going to show up on them these visualizations anyways um and so we want to look at the price so we just want to find the price which should actually be down here and not the sum uh no we want to look at the average price and let's order that this is great um so this is the most expensive one uh zip code 98134 at 206 dollars uh per for the average price but let's give that some color really quick let's uh that where's the zip code it's up here so let's take that zip code we're going to put it right over here we're going to do color and it's going to give it some uh assorted colors now these colors are going to um when we do the map it just a little bit these colors will um match what we're doing in there and so you know I like to try to color coordinate things um we're not doing going too crazy with the colors today so this is our very first visualization congratulations it is uh it is complete so uh we can label this one and we can just do price by zip code and I'll make that bold I don't know I usually like a bold we'll apply we'll do like that and boom first one is done and this is our starting place to say hey person who's looking to buy this Airbnb here the zip codes where they are able to charge the most um for for their Airbnb so let's go over to the second sheet and we're going to be doing the map and so um map is pretty easy but it's pretty easy once you actually get the data that you need although there's a lot of different data that you can use for the actual map right here you need something that shows um the location and there's a lot of things that show location here in fact they already um provide a latitude and longitude and then at the bottom they generated a latitude and longitude from from some different fields and then there's just a bunch of different um state there's um states there's zip codes there are uh I think another one yeah like country there's a lot of location data in here so which one do we want to use we want to stay consistent we don't want to deviate from that and start using different um longitude and latitudinal coordinates because that could throw off our results completely we want to stay consistent with what we're using so we actually want to use this zip code but when we pull it up here it's going to give us basically the same um you know it's going to show these zip codes but we are going to right over here we're going to click on this one and now it's going to separate them out so now we have all of these um you know kind of separate it out what you might get when you first do this um is it might look like this you may have to zoom in um I know that that happened to me the other time excuse me go to here that's what happened to me uh just when I first did it so uh know that that may happen and we want to change the colors the exact same way that we did them before so we're just going over here we're doing color and these colors do um they do should match up with the um with the other ones let me um exclude this let me see if it does nine eight one three four that's the blue and right over here nine eight one three four it's a blue I I believe they are going to be the same yep and so just scrolling back if you look at the zip code on the far right uh they are the same so if you're looking like this section right over here I just wanted to make sure I'm not going crazy uh before I get into this and realize I'm not correct at all so uh now what we want is you know this doesn't really give us any information if I was just a glance at this map I would have no idea what you're trying to show me um any information off this so we want to show some actual information so first thing that we're gonna do is we're gonna actually add the label to this so that you can see it you know when you're going over here and you see okay here's this um zip code um in the dashboard when we create it you can't click on this but if you just want to do it visually without having to click anywhere you'll be able to see okay nine eight one three four that's right here so this location right here is you know able to charge a lot of money it's probably a really nice neighborhood so um and we can back that up by putting the average price so these these two visualizations are really they really go hand in hand now we're gonna add oops not the sum this one needs to be the average so you go to this measure the sum go to average and there you go and these should match so this should be 206.6 um I'm looking at the average price right here and then we go over here nine eight one three four 206.6 so this all matches um and we can uh we can actually change that size a little bit if you want to actually get it in um get it within each of these things you know adjusted as you see fit I think that's fine right there um no need to mess with it anymore all right so let me see I think that is everything for this one I don't know if I want to add anything else uh no I'm gonna keep it out of this so that is our second visualization again these ones are directly uh correlated and you know this there's just different ways to visualize that this one you can see actually on the map where it is and the average price this one you can see from highest to lowest so again you know sometimes when you're doing these visualizations you're going to have these accompanying um uh these accompanying visualizations in your dashboard that's very normal so let's move over to the third one and for this third one um you know something that our guy was looking at is he's like okay well you know I'm thinking about listing it on Airbnb but I also want to live in it so I want to know the best times to actually you know put it on the market for people to be able to use and so I was like okay man no problem uh let's let's take a look at when when are people spending the most money in Airbnb's and we actually have that calendar um if you remember let's look let's see this calendar so you have this available the date the listing all of that stuff um and let's look at the date in here uh and we obviously don't want it like this we want it to be more uh more of a time series and we're going to be doing that based off of the price for the calendar so let's go see if you can find that really quick okay here's the price where is that calendar one let me see okay there's the calendar oh here all right totally forgot what that was supposed to be oof that looks terrible okay um let's see let's let's start working on this because this needs some work obviously uh this is the worst visualization I have ever seen um so we need to work on this a little bit what we need to do is we need to change uh whoops we need to change some the way that these dates are are seen so right here is these are two separate things so if I go right here and I do by quarter it's just going to change the quarters here right that's it isn't really helpful we actually want to keep the year here what we want to do it is by year we want to separate it by year but we want to separate it let's just do I don't know let's try week and see what it looks like okay this is great this is this is what we're looking at again um if we went back and change just like quarter it uh changed a quarter and then change it to week it would show the quarters but it wouldn't show everything right this isn't all the data that we need and so you know you really need to make sure that you're doing this correct I it's on by default it's almost always year but if you're looking at it via quarter so like let's say somebody comes in you say hey what quarters I want to break these out by quarters um in that year over year that's how you would do this but in the year we want to break it out by the week and you see this huge drop off at the end well that is actually because the data doesn't go past that there's just like one day of data or one one week of data in here with actual with January of 2017 data so it just drops off because this is an as the sum so it only adds up to like um 591,000 compared to like the 2 million so we want to get rid of that um and how do we do that uh let's see I think it's filter bup bup bup um as a format no it's not format what am I thinking bear with me uh let's see a filter well I was looking for it I just couldn't find it uh let's bring it back to the 31st let's see if that fixes what we need perfect uh that's all you had to do um and the reason that this is helpful and oftentimes you'd have several years worth of data in here um and then you could have you could even do something like this um like this one where it has multiple lines the reason that this is helpful is because if I'm telling my friend let's I mean just I'm going to say it's a friend uh or business partner whatever you whatever you want to use this use case for I'm going to tell him hey the beginning of January all the way until like you know even February it's like really low it's half so there's not a lot of people traveling because everyone travels when at the end of the year so in November December for the holidays to visit family um and then in the summer for vacations I would tell him just based off this one thing I would say hey over the summer and then in the end of the year and during the holidays that's when I would be renting out your Airbnb okay so just this one very simple visualization can help him understand the best times to do that that may have been intuitive you may have already known that but you can prove it with the data which is always really helpful and let's see is there anything else that we need to do with this uh I'm just going to label it and I'm going to say um revenue for a year just do bold do apply there we go do I label this last one I didn't let's label that last one and we'll do price per zip code price per zip code we'll just keep it that just keep it simple um and let's do that all right I believe we have two more so we have done um we've done three of them um we got the zip codes we've got the you know the time of the year now something else that he was wanting to know is um you know just how things affect it and something that's going to affect the price of the actual Airbnb is going to be the amount of bedrooms so the the larger the house the more bedrooms the more it's going to cost typically so we can take a look at that let's pull in these bedrooms and that will be our columns uh no won't what we need to do um and so I I knew this is going to happen I just forgot it until right until right now what we this right now is actually a um it's a value right so it's a number and that's totally reasonable because if we go right here you count distinct that's because there's only seven values right it goes there's zero bedrooms one two three four five six seven all the way up to seven bedrooms right now it has it as a numerical value we want to um change that to create it as um these measure names not a value so we're going to um we're going to remove this we're gonna go right down here and click this drop down and we're gonna say convert to dimension and so now we're going to add it as a dimension so there that looks um much more normal I really quick I'm gonna I'm gonna keep these in here for a second but we're gonna get rid of these nulls and zeros because if a home has zero bedrooms that's a problem um and so we want to look at the price again let's go down here in the listings it should be the price now this is the price for the location per day if you want to look at monthly or or you know stuff like that they have that data but we're just going to do the price the average price not the sum although this is helpful so just really quick before we change it this is going to show you which ones make them which ones are bringing in the most money it also may show you which ones are the most common those are all different visualizations that we can do but the one that brings in the most money that brought in 63 or that has 63 million dollars worth of um worth of listings so they all add up those one bedrooms are doing phenomenal half of that are two bedrooms at 30 million three bedrooms at 18 million and so on and so forth so there's a ton of one bedroom ones we may even keep we could even keep that in there um you know if we wanted to um and then we do something similar later but you can keep something like this in there well we will do really quick those we're gonna do the same thing that we've been doing is keeping average um and we are going to get rid of this because if it doesn't have the bedrooms you know that's not helpful to us and if it has zero bedrooms that's that's genuinely a problem i will not be renting an airbnb with my family that has zero bedrooms in it so now we have this and would be really helpful to be able to see that in the visualization i mean it's just kind of hard to see it as is i mean it just does not hurt to add that right here do a label um why is it angled like that maybe i just need to move it out more that looks much better um that's the average price that cannot be right that's the sum that's why so let's go over here let's make that average as well much better because uh if the price was three million dollars for a three bedroom i would not be going there so this is really really useful information for our friend right if he wants to you know get into those one that one bedroom area you know you're not gonna be making a lot of money and maybe low cost up front but he's not gonna be making a lot of money it significantly goes up when you reach these five and six bedroom homes which makes sense i mean if it has five or six bedrooms in it it's probably a really large really nice home and you can charge a lot more money and our friend is extremely wealthy he can buy whatever he wants and so he may be looking at these larger ones seeing that there's a much higher return on his investment the higher and the more bedrooms he goes so we're gonna keep it just as it is and let me see if there's anything else that we want to do with this no we're gonna keep it just like this and the last one is by far the easiest and we actually just discussed it a little bit we want to know you know what's his competition look like so for those for the bedrooms specifically so let's go back up to the bedrooms we want that one to be right here in our rows so we show these and then we just want to count of how many listings there are so we can do that via the listings id so here's our listings each id represents one location or one home so we're gonna do that right here that looks absolutely terrible that looks terrible what am i doing wrong here oh let me see one thing we need to do is we want to get rid of these nulls and zeros do that really quick um and then we don't want to do just the id because i i'm realizing now uh what i'm doing i need to convert this to a numeric so we can do a count on it so let's um oops let me see what what is happening this is terrible all right let's put this back let's make let me see if i can just um do an attribute let's do the count and let's do text um no it needs to be a distinct count because that's that's basically like a count of the numbers themselves not each individual id okay it took some figuring out i'm gonna keep that in there because you guys need to see a lot of you guys like seeing when i make mistakes so you know it makes it feel like when you make mistakes it's okay um and i'm all about that so i'm leaving that in there you guys can see me fail a little bit um i just forgot how to do that for a second and this is exactly what we're looking for right we want we now it showed us in that visualization that we were looking at earlier before we um switched it to the average price this is showing us that there are for one bedrooms there's 1800 one bedroom two that 483 three that 206 four that 55 only five that 20 and six that have five so the more you go up the less and less it is or the less and less competition there's going to be now is there a lot of demand for four bedroom five bedroom six bedroom uh that's for our friend to figure out um well maybe we'll help them out with that later um in the with the data you know we could look at the reviews that we had um there's so much data in here and we could absolutely figure that out but for what it's worth we're giving him this initial stuff and he'll have follow-up questions for us later that's how it always works i promise um so now we're good with this one let's label this one did i label the last one i will go back and look um distinct i i'm gonna butcher this one i'm gonna do a distinct count of bedroom listings i don't that may not make sense at all but we're keeping it so we're gonna do bedroom apply okay let me see if i added the label on this one i didn't let me do that real quick do average price per bedroom again i'm oops you didn't see that i'm just going with whatever is coming to my head this probably wouldn't be what i would keep if i had this or like an actual project but it works for now so we have our five visualizations one two three four and five and let's create our dashboard that's going to be this button right here so we're going to click that we are going to uh go right here i'm going to say automatic because we want to use this entire area and so now we're just going to start um you know pulling them over and i'm just going to start from the very first one and go to the very last one keep it really simple so this very first one we'll pull it over it you know it's going to take up the entire space until you start adding all the other ones we'll include this one right here um and well let's leave it as it is you know we'll adjust it once it gets to its final place now we have number three we'll add this one on this side it looks terrible right now but give it a second uh and then we have number four we're going to add that across the top okay it's already starting to look a little better and maybe i you don't have to keep this in here um but you definitely can let's start to adjust things a little bit to do okay let's see if i can zoom in one more no i'm gonna do it just like that actually let me see if i can make it even just a little bit closer perfect uh that's the best you're gonna get um if you didn't see i use this um magnifying and then i could click on the area that i wanted to see so we're gonna keep that just like that we're gonna move this over because that is um definitely not as important um and then we're gonna move this way over as well keep it just like that again this is something where if you want to you can click on this um it didn't i don't know why uh i can't remember how to get this connected but you definitely can um but oh okay i was just clicking on the wrong one that's why that is why but you can click over here and you you know it'll filter based on so if i go to this one oops oh geez what am i doing oh this is a travesty okay let's try to get this back all right i'm not touching it guys you get the gist you can mess around with it yourself i'm not messing this up okay so the next thing we need to add is the very last one let's go right up here and then we're just gonna kind of move it off to the side and and let's see i'm gonna add yeah this caption um if you've never seen something like this before um and i actually want to make this bigger as well geez give me a second it's it's kind of lagging a little bit and make this a little bit man maybe i don't want it as wide but i definitely want it a little taller give it a second yeah let me scooch this back just like that that's fine we can keep it like that in my original one i didn't have this you can get rid of this if you want you know you can um you know just exit out right here if you want to do that but there you have it uh this is the entire thing so we started from the very start um we started with this one and this one uh did some um and this is you know all the zip all of our zip code work then we took a look at the calendar where we looked at the price and did some time series visualization and then we're looking at the bedrooms and and the count of bedrooms and so this should be really helpful for our friend it should be an initial dashboard to get him going and once he sees this he's gonna have a million other questions and he's gonna want another dashboard for different data that's in there he's gonna ask about okay well what if i want to do it weekly or you know i want to rent it out for the month or you know how many reviews are people five star reviews are people giving on you know when bedroom two bedroom three bedroom these are all things that you know he may ask and then we'd have to build out in the real world this is what happens all the time you know they make a request and then they're like oh this is great but i also want this so um you know your friend is is going to be right in line with just about everyone else um that has ever gotten a dashboard for work or for personal use with that being said this is it we have done the entire thing now if you want to share this it is super super easy to share and i'm going to try to remember how to share it so we're going to do it save to table of public as and we're going to do this and we're going to make it um let's do air b and b is it like is it a capital b so like that no that doesn't look great air b and b uh we'll do full project and we'll save and that is being created right now um and i will save this so if you guys want to go look at this you can um and i'll provide a link in the description as well for that and see if yours looks um similar to mine or better than mine give it a second because it's thinking all right so here it is so here's our final our final project um and if you followed step by step then you should get this exact or very very similar to this one again i encourage you to if you want to have the up-to-date data to go to that um link in the description that has um the the most recent data and they update that i believe monthly so you can go there get the most recent data and then you can do stuff and you can create a beautiful project just like this um but with the you know the most recent data again i use the kaggle data just so you guys can remember and i encourage you to look at the different data points that are in the excel there's so much in there and you can use uh honestly like there's probably 30 or 40 other fields that you could be using in there that we never even touched um but for this project we're keeping it pretty simple and so go do that make completely unique dashboards and visualizations and create projects and add it to your portfolios so you can create a fantastic portfolio website and get a job and that's what this is all about it's about upskilling and and getting these skills that you can you know get a job or do better in your job so i hope this has been helpful i really appreciate you guys joining me and and doing this entire project with me i have no idea how long this is probably this could be like an hour for all i know um so thank you so much for sticking with me this entire time if you like this video be sure to like and subscribe below and i will see you in the next video