What's going on everybody welcome back to another video today we are starting our second portfolio project in Tableau. Now in the very first project we focused on SQL so we imported a COVID dataset and then we looked at that and just wrote a lot of queries and if you haven't done that one yet that kind of leads into this video now and so you might want to do that one first and so I'll leave a link in the description if you want to do that. This project is all about creating visualizations in Tableau so we're going to create multiple visualizations we'll combine all those to create our dashboard and then we can share that dashboard and you can put that on your resume and your portfolio or on your LinkedIn. I want to mention once again I tried to make this as beginner-friendly as I possibly could so if you have no experience with Tableau at all you should still be able to do this portfolio project and add it to your portfolio. Without further ado let's jump over to my screen and get started on the project. So let's start the project and the very first thing that we need to do is download Tableau public. All you have to do is go to the link that I will leave in the description below. All you have to do is go in here put in your email click download the app. Of course I've already downloaded it and I checked multiple times and it works. Then you just go through the process to actually create an account and once you have that account then you can start building your visualizations. Now you will also get an online account this is my Alexi Analyst account this is the visualization that we're going to be working on and just to give you a really quick look at it this is it this is what we're going to be working on it's nothing crazy nothing too hard anybody should be able to do this this is supposed to be a more of a roadmap to how to get started how to create your first dashboard whether it is very simple like mine which I would consider this pretty simple. One that I think we can do in under an hour and a half whereas I tried earlier to do one and I recorded for about three hours and it was what I would consider much I don't want to say better but it was just more advanced a lot more colors more different things but it just took forever I didn't think it was very helpful for a lot of people I thought it was a little bit too complex so I trimmed it down got down to the nitty gritty and this is what we're going to be working with so I'm really excited about it because I think this is actually a lot better than the longer version so you'll have this account and once you download everything you'll be able to kind of search like I'm searching right now search for Tableau a Tableau desktop is going to come up and you will now be able to insert it now you know we worked in all these things in SQL and we created the views we did all this work Tableau public you can't connect to a database you can't connect the SQL server and that's kind of a bummer because they'd be super great to be able to do that and in a work environment that's what you would do you know ideally that's what you do sometimes you download it for excel for different reasons but we can't do that we're going to use using excel for this so what I've done is I've created these queries used for Tableau project and I've already saved this query I'm going to put it in the descriptions that you have it I tweaked again I went through and I tweaked some of the scripts that we worked through it's very similar if you notice it's very very similar that's what we worked on in the first project I tweaked them these are the first four these are the only four visualizations we're going to be doing nothing crazy I promise you originally and I kept the original queries in here in case you were curious and wanted to look at them and try to use them I had these and there were seven of them and again it just took a really long time to get through the video I felt like it was just too much to be fair so I genuinely do believe that trimming it down was the best decision and it's going to be better for you it's going to be better for me and we will go from there so all we're going to do is we're going to run this let's execute it and we're going to hit up in this top left and we're going to do is control shift c and what that does is it copies the data as well as the headers and that's that's something we need so really quick let me get out of these this is from a previous attempt let's go to excel and we are going to insert this and we're going to save it so we're going to do file save as I'm just going to go to my downloads and I'm going to say let's do table low table one and replace for me because I already did that one let's go back and I have I put some notes in there you can read through it this is just to double check that the numbers are right and why it's correct and why we're using it this is number two plus copy again upper right control shift c is going to copy everything with the headers and that is what we want again I know this is tedious it's not really that tedious I hope this isn't crazy tedious but it is very manual normally you wouldn't have to do this but we do and that's okay I think um the tablet table two I think this is a good learning experience good bonding experience for all of us if you do this with me then we that means we've seen stuff together man and gals um so this one control shift c is going to be our tablet table three all right oops oops oops what am I doing I need a new one um so something you need to look out for and something that we didn't have to look out from the previous two is nulls now when you insert or upload data or import data into table low table low is going to do the best job that it can to assign a data type to that column and if you have nulls in any of your columns it could mistake that for a string or it most likely will um if you look I already have this um sorted by highest to lowest if we go down to the very bottom there are these nulls here we don't want the nulls we want those to be zeros um because then it will be numeric and it'll sign it a numeric uh data type and so what we're going to do is we're going to do control h and that's just habit I almost always do that so we're going to do null and that just assigns it to not just one sheet but if there's multiple sheets with nulls in it um we'll do that well no we'll go to zero replace all and we should be good to go this should fix uh any issue that we might occur or or have in the future and I promise you somebody's going to skip this part of the video and they're going to have this issue and they're going to come back they're going to be watching this wishing they just watch this in the first place um so stick around because we have to do this in the next one as well um so we'll do file we'll do save as download so do table three now you may be wondering Alex why aren't we just saving this in one excel with different sheets why aren't we doing that well that's great really a fantastic question to be honest the reason for that is if we include all of these in I'm just going to keep going while we're talking if you include all of these in just one excel they have to all be able to tie together um and as you can might may be able to tell now they don't um and that's because you know it's like a joint you have to be able to join it on like a date or the continent or the location or multiple of those things and if you notice we can't do that with these um and so we have to separate them out now we also need to change the date in this one so let's do short date I just have to go right up into this drop down after clicking on the c and there are nulls in this one as well let me see if we'll find any yeah there's nulls here as well so we need to do the exact same thing so nulls to zero replace all and there was 5000 done um let me make sure because I thought there were more than that um but let's see maybe I'm wrong okay that's great no that's fantastic okay so we're good to go we have uh once we save this we have our four uh I can't talk at the same time I can't talk and type table table four we have all of them ready to go we have all of them set up now we need to actually get them into tableau and then we need to start building our visualizations so pull up tableau with me uh click microsoft excel and we're gonna go to table one and we're gonna open and this is exactly what we had before this is our table one now we don't want to uh add connections to this what we want to do is let's go down to this it says it's prompting us to go to the worksheet so now we have access to this table that we just imported or this excel sheet that we just imported what you'd want to do is you can you can do it here um I'm for sake of what we're doing I'm just going to go to sheet two go to um this this one right here it says uh new data source go to microsoft excel and we're just going to do this for all of them so we're gonna do um we're gonna import it we're gonna go over here now we have our table two in here again just doing this you don't have to do it exactly how I'm doing it there's a faster way but for visual purposes uh I'm gonna do it like that um all right and then four we're gonna add it and now that we have them all opened up what I'm going to do now is I'm gonna cut myself off the screen because you don't you don't need to see me anymore and I'm gonna I'm honestly I'm gonna get in the way um because we're actually gonna start building our visualizations I want you to be able to see everything be able to track everything I don't want to be in the way in this upper corner wherever I am um so thank you for sticking with me I'm gonna get out of here so you can just hear my voice and we will continue on from here all right so you should still be hearing my voice I am still here but uh we are gonna get started now the very first one that we're gonna do is by far the simplest um it's extremely simple um let me show you we're gonna be looking we're gonna be doing this one right here okay so the uh these global numbers with just these colors and and the columns and rows so very simple let's go back over here so what we need for this is the total cases total deaths and the average death percentage so we have those over here uh oh let's go over to table one because we were just on table four because we just imported that one so we have total cases um we'll make that a column uh total deaths and death percentage now of course this is not how we want it visualized at all um what we want to do is go over to the show me and then go right back up here for these text tables so if let me click on it so right down here oh gosh come on it says text tables down there at the very bottom of this box down there it says for text tables try one dimension one measure so um that is what we have now and we want to move these measures right up here into the columns um and let's rearrange these really quick not perfect that's exactly how I wanted it so now we have the total cases total deaths and death percentage um let's expand this just a little bit so we can see each one perfect um there's a few things that we need to we need to change in here um to make it just more user friendly make it look better um and once we actually put this into the dashboard at the end we'll probably have to come back here and change a few things anyways but it'll give us a pretty good start so the very first thing that we want to do is just change the coloring change some of the formatting um and and make it look a little nicer and then we'll do a little bit after that so you know you can if you see over here on these marks there's color size text detail tool tip that's referring to these numbers right here or what is in these rows so if we go over here to color and we you know make them orange or green we can do that I like them black I think it's going to stand out when we put the color behind it I personally like that look um you can also change the size um and make it as large as you want I actually do want the size to be a little bit larger anyways so let's do that right now it doesn't hurt um and let's pull this down a little bit um so if we go up here to format and let's do shading this is going to where we can get some of these colors let's go over to columns and our header I believe that's what these are our headers let's go over to this color that's perfect let's just keep it like that I think that's easy enough and let's see let's see if this is referring to our maybe it's not I was trying to change these really quick but I'm forgetting where those are uh not super important um we can always do that later but we also want to change the shading on these as well now if you go over here and you go to the worksheet and you change that it's going to change the entire thing that looks absolutely terrible I do not recommend that but if you go to the pane the pane is what's referring to um this uh with the rows in it so we can do this I like it a little bit lighter maybe like that I think that doesn't look bad at all um so there's a lot that you can customize in here um you can even do grid lines trend lines let me see maybe we want to do something like this I mean I I personally like um doing some sort of lines like separate these out but we don't have to but I'm gonna I'm gonna try to do a little bit um no not try line grid lines yeah something like this so let me do a little smaller just like that super simple separates it makes it look nice we'll probably come back and change this at some point but I think this is a really good this looks very similar to what I did originally and I think this will be good to go for now um let's keep going let's go on to our second sheet hey future Alex here I realized that I forgot to show you something and I did not want to leave it out I wanted to make sure that you knew how to do this so I'm coming back in time um we have already completed the entire dashboard but we're gonna pretend that we have not and we are still on sheet one what we're going to be looking at is this death percentage right here it says two as in two percent but it's rounding to the nearest whole number and for death percentage we want to be a little bit more accurate than two percent maybe two point one one zero three or whatever that number is we want to be a little bit better um and so I think we want to go to the two decimal points or the or the you know two point one one uh which is what the number will be so the first thing that I'm going to show you is how not to do it um and this is probably something that a lot of people will do I know I did you'll go right here and you'll right click and you'll go to format um and you know this is not where you need to be looking although you can look through here and figure that out yourself if you want to the actual place where you need to look is right here in this measure values so let's go over here let's click the drop down we'll go to format and under the default pane there's this numbers and if we click on it we can go to number custom and change the decimal place so as you can see right now it's affecting every single column and we don't want that and it's very easy to just specify what column you do want so we're going to go up here to fields click the drop down and go to some death percentage and now the only option we have is just numbers so that makes it really easy we're going to click here go to number custom and then it automatically goes to two but you can go as you know specific as you'd like I'm going to keep it at two four um at the end of the video you're going to see that it says two uh on mine because I'm going back the next day and showing you this but I hope that yours says 2.11 or as specific as you'd like to be so that you have that so I hope now yours will be better than mine at the very end I hope that this was helpful and we'll let's continue with the video so sheet two and let's get rid of this format lines go to table two so what we're doing in this one is we're going to be creating and I'll go back here to show you where you're creating this graph right okay that's great you have a second um we're going to be carrying that bar graph that you just saw um and I'm not going to wait for it it's if you look right here the small bar graph um that's what this one right here that's what we're going to be making right now this one should I believe the the second simplest I kind of did them in order of simplicity um so let's go over here we need our location you can either drop it down here as a column or drop it in here as a column either one works um so it's Africa Asia Europe North America Oceania South America let's try to expand this a little bit okay that was way too far let's do like that perfect um so we have our locations and what this one is going to be actually looking at is total death count so the current global death count so we want to do this by rows and it's already looking super close to what we wanted or what we had in the um the previous thing so super super close already um and you can do other things if you want to you know you want to mess up your visualization with a pie chart go for it um or do what I just did you know go for it but I like the simple look of of the pie charts you know I'll show you how to kind of change the colors in a little bit if you want to do that you don't have to but you absolutely can um so something that I want to do that I personally like doing is going is ordering them by highest lowest I like that descending look so let's go up here and let's go to sort and I want to do it manually so let's see which one's the biggest so Europe should be at the top then North America and then Asia and then South America oops South America's before Asia there we go let's exit out of that so we could keep it exactly how it is and it would be fine but we want to make some additional changes to it um I want to rename this location to continent that's not right I think it's right here that's it so let's do let's do um continent is that a useful continent yeah it's a useful continent perfect and it changes up here um super easy um if we do go if we do this right here and we oops we change this to color then we can change the colors these are our marks and we can change certain things about them so the size right if we want to change the size we can do that um I like to keep it pretty moderate just a normal one I don't I'm not I don't want to get too crazy over here all right I'm just trying to trying to help so if we do the color you can do lots of different colors um and and you can uh you know you can do it in like an ascending order uh that didn't work at all orange assign palette apply there we go you can do it in descending order if you want that looks totally fine um you can keep a theme in your tableau dashboard which will be something that I probably talk about in my tutorials um speaking of something I have not mentioned I'm just going to take a super quick break like 30 seconds something I have not mentioned is if you have never done a tableau project before a lot of this might be very confusing and I hope I'm not going through it too fast I'm coming into this with hopefully the I'm I hope I'm explaining it and going through it slow enough I am going to be doing a complete tableau series coming up very soon like within the next two months I'm starting it um and so I'm going to have a complete tutorial on a lot of the basics a lot of the things that we're looking at right now as well as a few more advanced things so you know I I did that backwards I you know I could have done the tutorial first but I really think these projects are important to do so I got them up first but if you're having trouble with these look forward to those in the future um and just try to keep up with these you'll learn a lot just by going through these and doing what we're doing anyways so let's get back to the project I don't harp on that too much but um the colors you can do a lot with if you want to I I personally just want to keep it how it was I'm just doing control z I'm just going to keep it like this not getting anything not doing anything too crazy not doing anything fancy um but please play around with it do what you think looks nice again I am trying to keep it as simple as possible that's not confuse anybody um so we have this there's a few other things that you may consider doing speaking of something like like this you can enter this access now as of right now it's doing tick marks or I think I'm going to call them tick marks they are they are called tick marks of 100,000 okay you don't have to have it like this you can change it and customize it however you want so you know if we want to make it let me see if that's right yeah if we want to make it like this where it goes up a little higher that's totally fine and if these tick marks they're automatic they're doing tick marks of whoops you know that's just a million so that's what's going to look like with a million over here um and we can also get rid of one and then it's going to be the exact thing that we just did or we can get rid of another one and it's going to look like that or we can get rid of another one and it's just going to you know it's going to it's going to look how you make it look okay I'm just going to keep it with the automatic again um not because it I'm lazy but because I think it's just a little bit easier if you want to change this total death count you definitely can I personally we can keep it like that I might even change it to death count later on but I think this looks nice it's in order it's simple um and and visualization so that should not be crazy hard to read so that is the end of our second visualization we're going to move on to our third one and arguably my favorite which is the map um so let's go to number three let's go to table three and let's go look really quick at what this looks like just kind of like this and I I think how we have it or going to do it is going to be even better so what we have is we have the location and in the location as you can see these are all countries now it's not going to open up these map options and to show me it's not going to open up the those map options because um that's not how the map options work as of now it's just looking at as a text but we want to tell it and say hey this is not just a location this is this is part of a geography this is something that you should be looking at um differently so we can change this and we go we're going to we're going to click on this little drop down I'm going to go down right here to geographic role and we're going to go down to country region and let's click on that and as you can see down here they just generated some loud longitude and latitude so what we need to do for that is stick them right up here there's our longitude here's our latitude excuse me for a second I just sneezed it is allergy season for me my goodness it is not pretty over here um so we have the longitude and latitude um and as you can see it opened up that map for us that is fantastic and now what we need to do is we need to start adding things in now it's not um automatically um it really quick if you want to do the pan you want to be able to like reposition it that's what I want to do reposition about right here uh you just click on this arrow click pan this is how you like select multiple I don't really need that so I keep it on the pan for most part anyways now this is where we need to um insert like what is going to be looked at and then what is going to be what colors how are we going to assign colors to these countries okay so the first thing I want to add over here is the location so that I can now look and assign something to each location and I want to make um I'm going to keep that the same really quick because I want to add in what we're actually going to be looking at which is our percent population infected now why do I not want to add it over here is because it ruins everything um that's why I want to add it right down here and that's fantastic and I want to actually make this a color oh now that already much how do I say this it resembles it a lot more closely um so you know this is a lot more along the lines of what we were hoping for so this is looking really really good so um there's a few things that I you know want to mention or talk about before we actually start moving into this one tablo has their own whole section called map up here um and there's a lot of things that you can do with it we're not going to be looking at everything today but one thing I do want to look at is just these background maps um it whoops it adds a little bit of depth a little bit of um it can change the moods like this is a nighttime one so if you have like nighttime data we're looking at I don't know the stars suns rotation I have no idea you can do that the one we're going to be doing is this outdoors one and it's just going to show the ocean and if you notice the United States and like all the actual country names got a lot brighter um something that you know you can do is add something like a label and before that would have made sense um because if we have it like this where it's light you can't really see the United States behind there but you may have a label on there uh and the label helps but I don't like this label per se you can always change it and go and make it better I don't necessarily like how they have those labels so I'm going to use the outdoors I'm going to get rid of this so I'm just going to go to detail I like how this looks a lot more it just suits what I personally prefer but if you don't like that as much um go over here go to label and then adjust that label to how you like it I think that is perfectly acceptable um now these colors aren't to my taste as you can see over here we have this um this legend and we'll get to that in a second but I personally like a little bit different colors and we can change that by going whoops by going to color clicking on that going edit colors so um I don't know why I pulled it over there I'm gonna pull it back doesn't make sense it's I personally like reds oranges um these kind of things at least the infection rates because I feel like it I don't know it's kind of a scary thing so I want to make it uh that way and so you can do something like this I think that looks very nice we may even keep it like that but just for sake of um what we're doing you can do something like this and again it's the personal taste okay so if you don't like this one don't use it I I don't want you to use it I want you to find one that that really looks good to you um and just know that anyone that you choose you'll still have this right over here okay so you should be all right let's do just try this red to gold I think this is kind of what we're going for and to me right off the bat just starting out looks like we're doing pretty good let's go over here really quick let's go to this legend and drop us down so there's a few things you can do over here but one thing I want to do is just edit this title I don't want it to say the sum because each country has its own row in our excel so it's not actually the sum it's just it's a row but you know I don't want people thinking this is some type of aggregate function I just want people to know this is the percent of the population infected and speaking of uh we should edit this to do let's see let's do percent population infected per country I don't know if that's what we had it in the last one but that's what we're naming it in this one um all right I think I think this one looks good I mean we could do more with this in terms of labeling and colors and different stuff but we don't need to we do not need to do that one thing I will note again just to make this more of a memorable or a teachable moment you don't only have to have one thing in these marks if I wanted to add a location down here I can and I can change it and make it I didn't want to do that that looks terrible but you can do multiple things so I can have a label here and and I can do you know the color down here I can do multiple things with it so just know that if you want multiple if you oh hey I want to have a color on the location I also want to have a label on the location you can do that um you just have to add multiple things that that marks uh teachable moments just trying to try to keep it kind of keep trying to keep the learning alive um let's go on to the next one let's go to sheet four and go to table four now this one we're going to be doing some time series we have some time series data here and for this we're going to be selecting a few specific countries you can select whichever countries you want um but I have a few that I'll show you in a little bit that you know I think are just not the most relevant but are really interesting um so what we need to do is we need to bring over the date and we want that to be on our um a column because we want it to show the progression over time uh the thing that we're going to be looking at is actually the percent of the population infected so let's bring that down right here um and look it already tried its best to create something um and and it really did it tried its best um let's why do I keep scooting it just a little bit I want to scoot all the way it tried its best it really did um let's pull let's drop this down really quick there's a few different things that we want to look at first off is like just this the dates because right now it literally is just 2020 and 2021 and that's not exactly what we want um but let's let's do this really quick let's put month um it's breaking out by month um and now I'm regretting making it larger um if you notice it doesn't have 2020 or 2021 in here at all um it just has January, February, March, April, May and June, July so it's breaking it out per month um let me go back to make it small again it's breaking it out per month and that's not what we want um and we don't quarter either we want to have it by year we we do want it separated by year because we want the distinction between 2020 and 2021 because those are not those are not the same there's can there's a continual time period from year to year so what we're going to do is go down here and this is where we can adjust now just for the sake of things I'm going to show day and it gets very specific um and you can do it this way um and so on each day um you can do the percent population effect and as you can see it's going higher and higher that's not there won't be that way um in just a little bit that's summing the percent um of all the countries so you know we have it like this um you can also whoops we can also do month and this is kind of what I prefer it's just simpler to do it it simpler look so look at it like this so you know just the way it has it and then look at it like this um it's just what I would consider a little bit easier okay so you don't have to do like that um do it however you would like um whoops that is not what I was trying to click so we want to break this out by each individual um country okay we don't want the sum that's not what what we want so let's go down down here let's say average um that's not what we want either why did I do that um we want to break this out by the location right we want to break this out by country completely ignore the last like two things I just did we want to break it out by location um and as of right now this is a this is a hot mess um they're all in there let's look at this one andora they're all in there but they look horrible um I mean that's that's not what you want um so you know let's we can easily break this out oops by color and starting to look a lot better and look now we have this legend that shows us which color is what so I mean we're already just killing um this looks 10 times better than it did just a minute ago it still looks terrible um and we can limit this to specific locations um I think it's right up here let me see is it sort I don't know if it's sort um let me see let me see if it's location maybe it's filter here we go so if we go I'm gonna restart if you didn't see that so I'm just gonna go to location I'm gonna do the drop down I'm gonna go to filter and what I'm gonna do is I'm gonna look for a few specific countries so I'm gonna go to none um I want to do the United States as well as the United Kingdom um let's do Mexico we'll do India we'll do China and where else should we do um any other any other places no I think that should be fine let's just keep it there and we'll apply that and we'll click okay so as you can see um it's still summing it let's go ahead doesn't that go to sum let's just go to I mean it's not wrong it's just excuse me it's just doing the max I mean let's see what the difference is between max and the average it's nothing uh or hardly anything you know what for simplicity simplicity sake I don't want to get into um all that stuff we're just gonna keep it with average um so it's going to over that month what is in that month what's the average in that month if you the maximum it's breaking up by month so what's the max in that month again I'm not going to go into all that why we want to do it let's just stick with average it's the I think that makes the most sense it's simplest so what we have right now is it starts off at literally the January where almost no country's had any infection rates and it slowly progresses and there's you can see the United States we're just unfortunately doing well I'm in this category and as of April of 2021 um you know we have a 9.5 this is by the way this is that exact same data we used two weeks ago for the first portfolio project if you want this to be current and upgraded you're just going to have to get the new data and then and and um update that in your tables to get the most recent data for may um so we have this and it's looking really good there are obviously some things that we can do with this to make these better some things like um you know we can add labels and and excuse me um and if we do add labels really quick why why not we'll add a locate another location let's do label let's see what that looks like so now we have the label on here looks you know perfectly fine um we can also do let's see let's see what else we want um do we want to add the path because we could let's see what the path looks like oh that looks terrible we see if the the order changes anything um no it's just accidentally ate it whoops um let's see what else we can get in here um so dimension no I don't I'm just messing around real quick to see if I can um find anything interesting um but the colors are auto-generated you can always change the colors um just remove this one it didn't really add anything to it so we have this and it looks pretty good now something that we can do that's extremely easy is to add some pr predictive analysis or forecasting like where are these numbers going to go in the future so all you have to do is go to analysis go down to forecast and just say show forecast and that's about as easy as it could possibly be um at least you know I mean it could be easier that's about as easy as it's going to get um now I want to know I want some additional information in here just for me myself and I so I'm going to do this percent population um and let's do labels for these as well why is it saying 279 oh because that's the sum let's go over here go to average okay so now it's showing um now it's showing our numbers okay so it went back to march and then it's forecasting ahead now if I shrink this a little bit to like june when it starts like ramping up the forecasting will go away um I I can do that I could do I can do an exact oops let me not do that I can do like a custom range um let me see if I can what am I doing what on earth am I doing um is it format let's take a look in here uh I genuinely don't know what I'm looking right now I'm trying to um shrink this date to like june and somebody out there who is watching is like alex come on in I'm like yeah I know I really do get it um I don't remember where did I go to do that um but that's okay just imagine shrinking it to like june and the forecasting go away going away because it needs I believe 12 months of data to be able to predict into the future um and these look numbers look pretty accurate it's it's predicting till march to the end of the year um and if I know the US yep that's uh probably pretty accurate so by the end of this year it's projecting about 20 percent it's very possible um and who knows who knows we're starting to love loft right right you see this curve it's starting to go down yeah I'm gonna go straight back up so um this right here I mean it's pretty good right we're doing all right so let's rename this let's call this percents population infected now this is just what I wanted to do you don't have to do this you can do um you know whatever you want if you want to make it look different make it look unique I recommend you just mess around with here and we can mess with the tick marks as much as we want um I don't want a whole month of date that seems odd to me I'm just going to type I'm just going to do month I don't know just seems better so now we have our last visualization and now if we go down here that's another sheet that's a new dashboard which is new so we have our new dashboard right here uh let's change the size just do automatic makes it the largest um and let's start let's start adding things I'm just going to start adding them because well I can um and let's do this out of this map and let's add this just a as a start that's what we have and it's already looking pretty good I want this to come down next to this visualization or be attached to it I'm going to drag it right here okay this one I'm going to drag let me see if it um we'll stay stay in here oh that looks terrible I'm just going to keep it there I'm going to drag try to drag this let me see how can I get this to stay up top oh here let me um let me try to extend this one that's not that's not really how that helpful to be honest okay getting closer and let's scooch this out just a bit maybe even to here oh that didn't work that's not working geez I am butchering this um formatting in these things I am not a fan of um um but you know what can you do whoops let me go right here to drag picture covers a lot of countries um okay this is very close I mean we could get closer but I mean this is about it uh and let me stop right here and just say if you've made it here you're doing a really good job um I don't know if I went too fast or too slow or what I did but you know we got the data into tab low we looked at our data we um we then created each of the four visualizations and then put it into a dashboard and as is right here we're pretty close right there's some things that need to be changed um so we'll like we need some new headers and stuff like that but let's take a look and this one needs to be um what are we going to call this one this is the total deaths per continent just keep it simple keep it simple so I mean for as quickly as we got as we did this is a fairly good beginner dashboard there's so so much that you can do with this there's so much that you can do with this um and if I had three hours four hours five hours uh you know we could do that but honestly that that would just be insane um in all to be completely realistic this did not take me an hour and a half to make initially right I had to mess with things I had to um I had to readjust things I had to go back and look at my queries in all actuality this took me a week um or probably the more advanced one took me a week and and so I don't want you to get this picture in your head like this is just only takes an hour and a half like legitimately this could be weeks of work um to look at the look at the data make sure that the data is clean to make sure that your visualizations do what you want um you may want um to have some type of theme some code of theme along the way you know there is so much that can go into visualizations that we have not even discussed that I will talk about in the series um a little quite a bit more there's so much that could go into this um and so I don't want you to get the impression that I was able to do this in a short amount of time I promise you it took me quite a while um legitimately a week on and off working on it um like an hour or two at night because I just I'm not perfect I make mistakes I'm like oh I messed this data up oh I forgot there were nulls in there things that I polished up and got and told you beforehand because I made those mistakes when I was going through it so wanted to set that precedent now so you didn't think that I was some genius because I don't want anybody to think that is not uh the case so let's keep going we have now let's say let's just call this completed of course there's more that we can do to make it better um this could be a little larger um and honestly I should make that a little bit larger yeah I don't know why I didn't do that make it a little bit larger and and so now we're done now we want let's say say okay uh you know I finished my dash where I want to share this to LinkedIn I want to share this as a portfolio project in on my resume how do I do that so so simple we're gonna go to file we're gonna do save to public or tablet public as it's gonna basically say what is it and I'm gonna say um I'm gonna say COVID dashboard let's say tutorial you don't write that that's nice tutorial tutorial I am uh as you can tell I talk to myself a lot when I'm spelling helps me sound things out so we're gonna save this and watch the magic it's amazing it's saving it it's saving it and boom it opens it up and there is your dashboard now you get your own um URL that you can literally copy and you can send to somebody and say hey look I made this and they can click on that link and they can go to it so um again oh what is this I don't know why it's doing that again this is not perfect by any means but I hope it showed you some of the concepts some of the ideas that I had behind the data itself um I didn't want this to be three hours which it was before and so I condensed it maybe this is now like 45 minutes which I would be super happy about to be honest I'm the shorter the better um because I want people to be able to actually get through it and learn something and see how you can easily make a dashboard and be able to share it and it make a huge impact on your potential career it really can make a difference and so I highly encourage you to make many of these right on my on my alex analyst he's not going to get a job with one dashboard maybe maybe he is somebody really likes his current dashboard but do two three four five um this is your tablo portfolio right your portfolio for sequel your portfolio for python those are going to be in github and those you'll need multiple of those as well so don't just stop here with one okay let this be um a starting place and then you grow from here this should not I don't think this should be your final product it's it's not bad but you can go further from there and and improve on what we've worked on today and make it awesome so that is all I got uh you know I I hope this has been helpful I you know I again I hope I didn't disappoint anybody by not doing like the three hour one because there's that one guy out there like oh man I wanted to do the three hour tutorial well you're the only one I didn't I wouldn't have wanted to do my own three hour tutorial so I hope that the people out there who are watching this who got this far were able to successfully complete it um to get the kind of visually visualization they were hoping for I really appreciate you watching this I hope again I hope it was helpful uh if you liked it be sure like and subscribe because I have a lot more content coming out um with the portfolio series as well as Tableau and Python tutorials coming up and I will see you in the next video thank you and goodbye


Slam ball is bad, and it's the most electric thing in sports. I mean, these highlights, you can't even argue with it. This is crazy. One minute, you got somebody getting slammed out on the ground like it's nothing. And the next thing you know, you got somebody jumping on the trampoline and getting crammed on like, Hey! Then you got coaches getting into each other's faces like they're about to throw hands? And don't forget, these guys are doing this every single week now. If we keep going at this rate, slam ball might be the most exciting thing in sports right now. I cannot wait to see more.


I thought you guys know I'm gonna take a break for a really long time, but I'm okay and I'll be okay. I always am It was really it was tense. She was mad at me and I said, I'm sorry. I won't say anything again I won't say anything again. That was Trisha Payness and Jason Nash. Are they getting back together? I'm about to explain why it won't work What is up everybody? This is Chris from the rewired soul where we talk about the problem Focus on the solution and if you are new to my channel my channel is all about mental health and a huge part of our mental health is the Relationships that we get into the relationships that we get back into the relationships that we pursue that affects our mental health More than anything so many people so many people struggle with their mental health because they keep getting into bad Relationships so in this video. I'm gonna be talking about two pretty big youtubers Jason Nash and Trisha Payness So a few things a few disclaimers real quick The first one is those of you who are new to my channel I do not make these videos in any way to drag anybody to talk bad about them or anything like that I am somebody who gives tough love though Okay, but the goal of my videos is never because I think that they're gonna explode or even these big youtubers are gonna See them my videos are to help you my videos are to help my audience So when I talk about the mental health of different youtubers and what they're struggling with I hope that you can take lessons from it I hope that you can take a step back look at your life and say oh do I do these things am I somebody who's been you know Getting into bad relationships. How can I reevaluate what I'm doing and maybe improve my mental health? So these videos are to help you the second disclaimer. I'm gonna throw out there is time is a very Valuable and precious asset especially for me. Okay six years ago. I almost died So the way I live my life one of the ways that I keep good mental health is that I do not waste time I refuse to waste my time So the reason why I'm saying that is Jason Nash and Trisha Payness have made a lot of videos back and forth about their breakup Okay, and most of them are anywhere between 20 minutes on a low end 40 minutes on the medium side and over an hour on the high side and in no way am I going to sit through and watch those Okay, I have skipped through got the gist read the comments. That's what I'm going to be taking and putting in here So I'm not gonna have a million clips. I'm gonna use a couple, but that's it I will provide the links to their videos down below maybe just a couple videos because there's a lot of them But again, I am not going to waste my time watching it, especially when half the video is like this I thought I was so sure I wanted to go earlier this morning and then So those of you who are all up in the YouTube drama sphere like I like to do This is the the too long dinner read type gist of things Okay, Jason Nash is one of the friends of David Dobrik David Dobrik is a huge youtuber He started out on vine very big Jason Nash.  You do you? Okay, Trisha Paytas. She is somebody with millions of subscribers herself and she makes a lot of videos and I Could do a million videos just about the mental health of Trisha Paytas alone the symptoms that I see not to give her a diagnosis but just what I see that she struggles with but a lot of people do follow Trisha Paytas and She documents just about everything going on in her life and sometimes it's pretty much a hot mess and again like when I go through This video one of the reasons I'm making this video is because these two were me Okay, I used to be this person one of the reasons I started this channel is because I have a lot of lived experience Being a crazy person. I have a lot of lived experience getting into terrible relationships All right, so when I watch these things now that I'm doing much better mentally I watch them and I'm like man that used to be me and hopefully hopefully some people can learn from these lessons Okay, so anyways what happened with these two is Trisha is a little on the heaviest side Jason, you know he works out and stuff like that tries to eat healthy and Trisha has said to him, you know, she can make fun of her weight, but please don't make fun of my weight Please don't talk about my weight. Okay, so in Jason's first response video He talks about how he's had to tiptoe around the subject and he apologizes and all these things talks about her diet and things like that She gets very mad upset and he says, sorry. Sorry. Sorry. By the way First big red flag if a lot of your relationship is based around tiptoeing around different subjects Especially if you can't get it through your head what topics to not discuss or how to approach them properly This is a huge red flag of when this relationship isn't going to work So anyways, the reason this breakup happened was these two were doing some kind of show Some kind of reality show and Jason made a joke Trisha gets really really upset about this and she makes a video Something along the lines with the title of he called me fat and in this video. She is just a crying mess It's like an hour long and she's talking about how he called her fat and she can't change for him And you know, she doesn't want to eat around him and she feels uncomfortable So one of these things is if you're if you're the person in the situation where you feel like this Especially when it's a new relationship if you feel like this person doesn't accept you in your body and stuff Maybe maybe it's not the person you should be dating But there's also the fact the fact not opinion the fact that you have a lot of work to do Okay, so for example me. I've made some videos about my weight my weight loss and stuff like that This is a hundred percent for me. Okay, I realize that my body is a result of my choices All right, I have to accept it I do not get offended when people make fun of my weight or anything like even when people leave comments I like laugh with them like whatever like you're not telling me anything. I don't know I am overweight, but if you are struggling with this like you need to look within yourself and say, okay How do I deal with this because it is an insane Expectation to go around thinking that nobody's going to comment or say anything and stuff like that If you don't like the way you look start making small baby steps towards a solution Now part of this this whole series going back and forth is how they talk about how they're so in love They're so in love. They're so in love. She loves them so much. They've been together for six months Okay, about six months. I believe they might have known each other a little bit longer. All right now This isn't something this isn't something I'm gonna, you know diagnosed. I'm not a clinician or anything But when I talk about symptoms of different mental illnesses like when I talk about borderline personality disorder, there are these extreme emotions right extreme emotions and one of those Extreme motions is I don't just like somebody. I love this person Okay, and even if you don't have something like BPD It's something to watch out for because when you feel these intense emotions what happens is it clouds you to all of the defects of the other person because you just love the feeling of being wanted, okay So not only are they saying that they're in love but like Jason even got a tattoo or Trisha's name By the way, this is not mental health related But like I'm not a very superstitious person But getting a tattoo of your boyfriend or girlfriend's name is like Extreme bad luck just from what I've seen. All right. So anyways after all these back and forths and stuff like that We've slowly seen them start talking again Okay, a little bit here a little bit there things are calming down and something they started talking about in these videos is That you know, not only are they gonna meet up in Boston and things like that And she's gonna hang out with his family and all that but they say this They say that one of the main issues with their relationship is that they filmed together They're both youtubers and when they make videos together, that's the source of the problem So the first one of the first issues I want to point out with this is that is that when you start to lie to yourself In this in this deceptive way like you pick out this really trivial weird thing and you say oh That was the problem and by the way, I've done it too And I'm thinking about dedicating a week to all the terrible relationships I've been in and stuff like that and a lot of it had to do with me and my thought process of my mental health make Believing that the filming together was the issue. Let's say they're right. Let's say filming together was the issue. Well These next clips that I'm gonna show you is Them filming together. So that's another issue when you acknowledge a problem But then you still do it anyways they literally film together in the same videos where they're talking about one of their main issues is Filming together. Okay. So whether they were in a mental health space of self-deception or not They are doing the exact thing that they said was a problem And what happens with this is they slowly start to do it thinking that you can do that toxic thing again And it won't be an issue and then the definition of insanity happened It's doing the same thing over and over and expecting different results. So like I said, I'm not going to use a million clips But I do just want to point this out because there's a lot of self-deception with these two getting back together But they don't know they don't they didn't think in their defense. They weren't privy to All the inside information that like I was texting with you during that time. So I knew that You know and I'll stay also.   That's another lie. I definitely apologize. I apologize several times This is something that we do I'm gonna link in the info card a video I did about the the spoiled milk philosophy and Long story short spoiled milk philosophy is this getting back with an X is like Taking spoiled milk out of the fridge Drinking it putting it back in the fridge coming back to it days weeks or months later Pulling it back out and thinking it's gonna be good again. That is insane and that's what we're watching here And it's it's an interesting part of human nature So some of you know I work at a drug and alcohol treatment center and it's very common with drug addicts and alcohol It's but it's also part of human nature and it's very fascinating But it destroys our mental health and here's what I mean you start to lie to yourself about the past You start to minimize things you say. Oh, it wasn't that bad. Oh, no, I didn't mean it like this Oh, no, she wasn't really lying. Oh, okay, you know and all these things and maybe we'll never know who's lying Who's not but when you start moving back towards that relationship that bad relationship and lying to yourself It wasn't that bad, you know things were okay. This is gonna work like it's not it's not I Often say this When you think that you're gonna change somebody when you think that you're gonna get in this relationship and wait for somebody to change Think about how hard it is for you to change. When is the last time you made a major life change? I'm not talking about going to the gym. I'm not talking about dieting. I'm not talking about moving to a different city I'm talking about like a pure like Personality change like it is very hard. It is very rare for someone to go through this Experience where they do this complete change so when you're getting into a relationship and you're waiting around for the other person to change and Bend and mold into the person you think they should be or the think they the person they can be you are Wasting your time and again time is very valuable. All right I often ask my clients in groups and there's 60 to 70 people in these large groups that I do I say how many people in this room have spent far too much time in a relationship Waiting for the other person to change and you see about 75 to 90 percent of the hands go up Quit wasting time. We have one life to live quit wasting time Waiting for somebody to change.  Okay, so in my opinion my prediction This is not gonna work. They're gonna break up again They might break up multiple times and it's not gonna work out very well So again, I ask you to look at yourself and see what's your experience with getting back with exes With lying to yourself minimizing the toxic relationship that you were in Minimizing the past and the stories and the craziness and the chaos How often do you do this and has it helped you or has it hurt you? Okay, but anyways, I hope you enjoyed this video and if you liked it, please give it a thumbs up And if you're a new here I'm always making videos to help you out with your mental and emotional well-being make sure you click that little round Subscribe button and thank you to everybody supporting me on patreon and helping me try to spread this message of hope For people to improve their mental health if you would like to support the channel on patreon You can click or tap right there. All right. Thanks so much for watching get out of toxic relationships, and I'll see you next time


10 ways to make your planning sessions better. Hi there, I'm Geoff Watts and here is a short video to give you some tips on how to make your planning sessions more effective and you never know, maybe even more enjoyable. Tip one, do a little bit of prep. You know what I mean? What used to be called grooming in the old days, but now thankfully is called refinement. A bit of a look ahead, but don't go overboard. That's the biggest trap people fall into. It's so easy to over plan. You need just enough to make sure that this sprint planning session, you know, we're not sitting around twiddling our thumbs thinking, what do we do or waiting for an answer or just throwing darts in the dark at cards to estimate on them because we've just got no idea. Just enough. Remember, every minute you spend preparing for the next planning session is a minute that you're not delivering the higher value items in this sprint. Tip two, make it better than last time. Why would you inspect and adapt the product, but not the planning process? Take some time out to work at how you can make it better and bring something in from that retrospective to make this planning session better than the last one. Tip three, have a goal for the sprint. Now sprint goals have been around forever with Scrum, but they're not used anywhere near as often or as well as they could do. It's so much easier to build energy and focus into a sprint if we have a clear and compelling goal for the overall time box. So many teams turn out to a planning session and just pick the highest priority items off the backlog. And that's not a bad thing, but those teams are missing a massive trick. OK, if we've got a goal, a clear reason or a problem to solve, working with a product owner, we can figure out what that is, why it's important, how we are going to be an integral part in solving that customer's problem or adding this feature. And then we can work out what needs to be done within the time we have available to contribute towards solving that goal. So much more powerful. But see, see if it adds any value, see if it adds any energy, any quality, any enthusiasm. Tip four, make it collaborative. Don't be one of those teams where one person is at the front of the room with the post. It's in the pen or one person is driving Jiro or whatever tool you're using. Get everybody involved, break up into lots of small discussions.  The more people are involved in the planning session, the more energy, the more the time just flies, the more people feel genuinely committed to what's going on. And you'll end up with much higher engagement, much higher creativity, much higher productivity, quality, enjoyment, better solutions. And you never know, people might actually not dread coming to these things. Tip five, tell stories and visualize. I know you've all been taught to write product backlog items. You've probably been taught to write user stories, whether on a card or in a tool. And that's great. OK, we want that documentation. I'm sure it'd be useful to us in the future. But the most important thing is that we can tell these stories, that we can visualize these users' problems, these user needs. So when I get a product owner or a customer or even a developer standing up in a planning session and telling me about the problem that our users have or telling me about the value that we could add to our users' lives if we add this functionality, that makes it so much more powerful. I'm now not just delivering somebody else's requirement. I'm part of solving a real person's real problem. So much more engaging, so much more creative, so much more solution focused. Tip six, work out your capacity as a proportion of your ideal or typical. So I'm not going to go on about estimating. Loads and loads of stuff out there on estimating, estimate however you like. But the most important thing for me is that at the sprint level as a team, we're taking into account how much capacity we have compared to our previous data points, our previous sprints. So let's say, you know, if we take our three or four best sprints and we deliver, let's say, 75 units of a product backlog or eight to 10 user stories, whatever it is. And this sprint, we've got a few holidays. We've, you know, we've got a bit of training. You know, we've got extra support or we're onboarding someone new or whatever, which means that we're not going to be as productive as normal that maybe about 80 percent, then we would commit to about 80 percent of that figure. Just having that conversation is a really important thing for a team to become more and more predictable and more and more comfortable and avoid over committing. Tip seven, focus on the planning, not the plan. All great teams know that all plans are wrong, even sprint plans. All plans are wrong. They're out of date straight away.  They're full of ambiguities and things change. Things emerge, new ideas come out, new interpretations come out. So it's not that they don't worry about the plan. It's that they focus a lot more on the planning because all of those great teams also know that having the right conversations with the right people, asking the right questions, de-risking the right assumptions, working out what conversations need to be had afterwards. OK, all of those things make planning much more effective. And ultimately, the plan will become more useful as a result of that. Tip eight, don't fill the sprint. Now, I'm not just talking about the 80 percent that I mentioned in tip six. Here, I'm also talking about the breakdown of the stories into the tasks. OK, the best teams do not plan out everything in the sprint planning session. They know things are going to change, but also they know it's not the only chance they have to break these things down. The point of sprint planning is not to plan out every minute of every day of the whole sprint. It's to get to a point where we are confident that we can pick off a valuable chunk of work and realistically expect to be able to complete that within the time box. All right, we don't need to know everything now. All right, that causes all sorts of dysfunctional behavior as well as just wasting valuable time. Tip nine, find the natural order or bottlenecks for the stories. This is following on from tip eight, because working out the right questions to ask, working out the right level of detail and working out to make sure that we're not just busy all the time and then end up with all the big risks and bottlenecks and things, problems at the end of the sprint that causes the sprint to fail, plan out what needs to happen, what hold ups are likely to be, where the dependencies are and then bring those dependencies forward as early as possible within the sprint to reduce the chances of that sprint failing later on, just like everything in agile. If we're going to fail, we want to fail quickly because then we have more time to do something about it. So if the sprint is going to fail, I'd rather it failed in day two because then I've got more time to react to that as a team. And my final tip, tip 10 is commit as you go, not a big bang commitment at the end of sprint planning. Every time you're considering a story or a feature as a team, think, OK, can we commit to that? If we can, brilliant, put it in the box. Next time, next story. Can we commit to that without jeopardizing our current commitment? If the answer is yes, brilliant, add it into the pot. Next one, can we commit to that without jeopardizing the previous commitment? No. OK, so do we need to break that down? Do we need to go for something smaller? Don't think important, important, important, important. I know what that is, I know what that is, I know what that is, I know what it is. Can we commit to all of these? No, we can probably only commit to half of them. Then we've wasted that time looking at the bottom half. Simples. So follow these top 10 tips and your sprint planning sessions will be much more effective and maybe even enjoyable, but it is just 10, right? There's plenty of ways you can make your sprint planning sessions better out there and you've got a lot more ideas than me. So what's worked for you? Tell me, tell everybody else, add it to the comments. Plan on, people, maybe even more enjoyable.


Senatorial candidate of Labour Party, Mushud Salvador has expressed his pleasure over the current crisis bedeviling the nation, especially the fuel, scarcity and the unavailability of the new Naira note. He however urged Nigerians to be patient, saying that all hope is not lost. Speaking at the media briefing, Salvador noted that corruption is associated with leadership of today and the younger generation, the ones gravely affected. Corruption has been the problem of this crop of leadership. If we are not careful, the young one will fall into it too. But we have to give them the training, let them know that you don't need to steal before you become anything. Salvador further admonished the youth to participate actively in politics by vying for positions in government or exercising their civic duties by voting. They should be the leader of today and that is why I encourage many, many, many young ones to be a member of House of Reps. We will train them into a better legislature. We will train them into an excellent legislative training and they will be perfect. Then they continue with the life. We can hand over Nigeria to our youth, to our children. That is what I am particular about. Hello, hope you enjoyed the news. Please do subscribe to our YouTube channel and don't forget to hit the notification button so you get notified about fresh news updates.


Too often, the simple things are what lead to success, but the irony is that the lessons most crucial for success are often the most difficult to learn. Simple as they are, these may not be the fault of the lessons, but because we are humans. As humans, we are prone to follow the path of least resistance. It comes natural to us, so it becomes unnatural and against our nature to attempt to do what is difficult, even if it makes for success. Most people aren't successful, not because they didn't have the opportunity, but because they do not do the things they are supposed to do. Those things are often difficult. Before you jump to people who label physically hard on their jobs, you may be surprised to know that most of those folks are lazy mentally. Human will easily pay the price to do labor that quickly brings success, but there are very few men who will be willing to label in their brain to bring success into reality. That's because mental work is real work, simple yet difficult, difficult yet guaranteed for success. There are several countless other difficult life lessons you must learn if you succeed. But below, I list just three basic ones you can start to use for yourself. 1. See fear as a friend Every year, starting more than five years ago, I do something on my bed day that I am most afraid of. I peak what I am very much scared to do and do it anyway. Also, I play this care game. This is the game I made up where I do one thing daily that I am most afraid of.  This may be the hardest lesson to learn. If I told you to meet the richest person on earth, would you do it? If I asked you to write the biggest cheque to yourself and expect to have that cash right in your bank accounts in ten years, would you believe it? Our greatest hindrances to success have always been fear. A lot of people may not admit it, but even the seemingly bold person exhibits fear. He can try a whole bunch of things, but he won't attempt the serious stuff that would make for even bigger successes. In your quest to have all the money that you need, make fear your friend. The presence of fear may be the proof that what you are attempting to try out in your business is what to try. Once, I heard the story of a king who wanted someone to marry his daughter. The only catch was that the shooter must be willing to swim in the river, swam in with crocodiles. None of the men around could swim the river, but a man who had been very poor for a long time dived in without thinking had swam through and married the princess. Leaping and swimming through the ocean filled with sharks may seem difficult, but when you are consumed by the desire to have wets at the end of the ocean, you jump on and swim through. On March 11, 1984, in the Westmans Island of Iceland, the 74-foot-strawler Helicy overturned in a storm. Goodlager Fritrosin made history. After falling into the 41 degrees water, he should have soon died of hypotemia. When the body temperature goes below 93.2 degrees, blood flow to the brain is reduced. His two companions from the boat sank in 20 minutes. But Godlager swam for six hours, breaststroke, breaststroke, backstroke, as he was close to the shore. A voice said to him, lie down and rest, you deserve it.  Somehow, Godlager defied all laws of physiology and survived. Everything you want is on the other side of fear. See fear as a notch to give it a try. If it fails, at least you gave it a shot. 2. When it comes to business, be far more curious than your competitors. Some years ago, when I discovered I would lead a particular group that was filled with smart and highly intelligent people. I was scared. At the time, I struggled with speaking good English and expressing myself confidently. What did I do? As soon as I was given the office, I bought all kinds of great books and novels especially. I read so much I thought my brains would blow out. I studied night and day, read everywhere, read while I was working on the road until I became proficient in English and gained some high level of confidence to lead that group. It's difficult to learn much more than your competitors because it means you have to spend most of your time doing what others won't do. You have to spend your time reading business, personal finance, or self-development books while others are watching TV. You have to stay up-planning and sometimes studying your market while others are snoring. You have to spend a large amount of money to travel for a significant business seminar while others think it is unwise to spend so much money training your mind. But the good news is, when you know what others don't know, you have what they don't have. I have lost jobs and opportunities in the past simply because I wasn't as prepared as I should be.  This may not be a fun thing to do, to be actively more curious than your competitors. But when Harry Ford wanted to compete and win in the highly competitive automobile market, the land watch his competitors didn't know and soon beat them to it, knowledge is still par. And the amount of information available to you that you use is still key to your liberation. 3. Never spend the money you don't have When I was planning for my wedding, I had very few clients. My business wasn't doing so well at that time. I had made so much money years and months before. Suddenly, now things just went awry. My father were out of jobs. My parents were out of jobs too. Coincidentally, so were my wife-to-be's parents. We had to have the wedding or postpone it. What we had planned was little, but it still required that we spend money. The money I didn't have. People suggested a lot of ideas. My spouse suggested some expensive stuff to do. I looked around and figured, see, I can't spend money I don't have. And even if I had the money, I will never spend so much money to feed people who will never remember my face in a few months. With that understanding, I had a beautiful small wedding and saved so much money in the process. In the country where I come from, it's almost a taboo to have a small wedding. You could be ashamed or embarrassed just by doing so. First, even low-income families often go out of their way to spend big on weddings, only to start the so-called marriage broke and in death. This is not limited to money. It also includes buying expensive cars, owning expensive houses, wearing costly suits so that you can look expensive and rich. Billionaire Warren Buffett, who is reputed for using a flip Samsung phone, said, I will get myself an iPhone when the last person on earth has gotten it. In other words, he's not planning to get an iPhone. Not because he can't, but because they'll reach spend money on what's important and relevant to their lives. Am I saying you should look tartar and use only cheap or low-quality stuff? No, that's not the point. But whatever does not move your finances forward, whatever takes from your finances and doesn't in any way add to you.  This includes getting away from friends who party and consistently leave off the booze. If your friends aren't people who help you multiply your money but look for ways to take your money, get them off your back. I know in a social media frenzied world where showing off what you've got is the numb, it is almost difficult to learn this lesson. But here's the thing, don't spend money you don't have to please people who don't like or care about you.  If this video inspired you, like this video. We love you.