What's up everybody Jason here from jazzy's case breaks calm We just sold out 2020 tops former the one chrome hobby one box break random teams number four Number four guys and again. This is 250 dollars a spot as you can see number five has already been posted because number four sold out earlier But again super hot Ten spots everybody gets a tiered random team from the list below will randomize the list of names and the ten tiers And you match up with what you get and Joshua got the first five and Danny got the last five It's a little competition between both of them and Then of course you got Alfred Romero with a combo team from F2 all the way down to Williams racing F2 Trident Roll Six and a three nine times one two three four five six seven eight Nine nine Danny at the top down to Joshua Let's get a blank sheet Duh, no way. Did you really? That's sick All right nine times one two three four five six seven eight Anytime I hear of Ashton Martin, I just think of DOOM ashton Martin music Or Austin Martin, whatever it is ashton Martin. I don't know why All right, so Danny you have Ashton Martin Red Bull Racing plus F2 BWT race lab As well as offer my racing and F2 are Grand Prix McLaren F1 team plus the F2 Churros racing team racing system, I should say Joshua the BWT racing point F1 team plus the combo of F2 compels racing and F2 uni Racing over there as well Mercedes AMG F1 team plus F2 dance Scuderia, sorry, Alpha F2 MP Motorsport Danny with Haas F1 team plus the F2 of Carlin Bernal D P world 1 F team so many different F1 teams man, it's wild clubs, I guess just say high-tech Grand Prix F2 Danny with Ferrari there F1 or Scuderia Ferrari Plus F2 Prima racing and then Joshua with Williams racing F2 Tri-Benz And again, that was a 9 9 9 Let's quickly actually make this just a little bit bigger For the sheets today the fifth already That is damn. All right guys. Well, I'm assuming you guys are not gonna trade Obviously Red Bull Racing that'd be max for stopping right he's really hot right now And I believe Mercedes for Joshua you would have a Lewis Hamilton, correct? I think he's Mercedes So you guys pretty much got the one-on-one best two out there You know obviously, I think we're stop is playing like a racing like lights out, right? But Lewis Hamilton what he's done in his career is pretty much like Jordan level like he's just People were like he's like the Michael Jordan of racing Renault. Thank you and knife guys Always always Yeah, I feel like a lot of people were saying that they were kind of tired of Mercedes all the time, right? My thing though is that I Don't know not too sure obviously because I'm not really into this so much, but I remember people were saying that obviously every racing team Has a different budget right kind of like MLB where they can spend more so like it all depends on the motor, right? Can someone have a much better motor because they spent more money on the motor than the other? But that's kind of unfair though It's like it needs to be more fair around everybody, but I didn't hear them say though people were saying that they are kind of changing a lot of the rules were everybody kind of You know should have similar Motors or something like that, you know because it's like the same Mercedes, right? They're like so rich or whatever Ashton Martin They're just gonna just spend so much more money on their motors and they're just gonna wipe everybody out You know, which I didn't know that at the time. That's what oh pure ghastly Sebastian V tail car number three is coming up over stopping purple.  It's like if you're a rich F1 team Yeah, you're most likely gonna have the best motor now. Just try to get the best driver But I think a motor is a bigger bigger thing than the driver, right? I mean Obviously you have to be very talented I think you have to be more talented in this than you have to be in NASCAR, right? Although NASCAR fans don't be mad at me, but I think we kind of all agree But at the same time imagine having a better like imagine just going with Mercedes and wanting to sign with them because you know You're gonna have a better car AT-01 Alpha Lando Norse rookie head rupee kit and quick Mick Mick Schumacher max for stopping little insert silver or I should say Yeah, I mean that's a 70th orange so that will not be numbered but still short print It was Hamilton insert On you Charles Leclerc look like a superfactor there for a second Daniel Ricardo long guard Renault RS 2.20 and Max for stopping purple inserts Very nice, and that is number two three Couple Max for stoppings. I feel like he's dominating right now where I feel like the boxes are also dominating for him, too The towel and the Iceman Which is a Kimi Hopefully we can get an autograph here. Did Joe get an autograph in the last box that he opened? Pierre ghastly Sebastian Vitao Felipe Drogovic both us Sir will Sebastian Vitao and the rising star. Oh We did get an autograph it was a F2 auto gotcha Lando for stopping insert and McLaren Tee fee high-tech F2 Grand Prix. All right. Come on one more color guys one more color. Give me a big color Louis Hamilton insert Antonio Giovinazzi Jeremy and Mercedes AMG F1 Two more packs Car number five album. Oh, we've got a gold. You should just flip these this way Bugs in our album Lauren you got a purple Louis Hamilton That's numbers of 399 and a Daniel got a gold wave Something gold 11 out of 50 That's good area Right there. That's a nice one A Louis Hamilton purple is also pretty nice That is number 369 out of 399 our last pack here guys. Good luck Get another one is posted onto the website Hamilton both us Yuki and Haas All righty guys and there you go. That was F1 Box break number four. So again, all these would be top-loaded for you. Everything does ship But I got all these penny see free to be top-loaded by the shipping team and here was your colors Well, it's Hamilton and a couple max for stoppings. So really appreciate it guys again This is break number four number five is on the website Jaspies case breaks calm. Thank you guys


Welcome to the weather forecast for the week beginning Wednesday, August 17th, 2022. I'm chief meteorologist John and it's worth for long long public media and sorry I need to have the camera off today. Thursday, August 18th will be our third quarter moon So if you're getting out early in the morning, you'll see it beautiful in the southeast sky The Sun right now is pretty active with a couple sunspots putting on a show Just about straight at us Looking at drought things are getting even better on the state You go look out especially along the front range and down here around Pueblo and the mountains We are drought free for some strips of Area here on Longmont. We're just in the moderate drought area Naturally things in the entire west have gotten better with this Continual plume of moisture things in Texas are worse, but rain is coming to them, too So here we go to this week. You see a lot lighter colors And that's why we've had more rain and more rain Again many places over two inches in the mountains and in the south and even some moisture making it out of the western part of the state looking at the Progression of severe weather climatology going into the second week of August and the third week of August Still have a chance still possible. It's decreasing though in Probable of severity Looking at Wednesday. We had no chance of convection within the storms north of Denver For Thursday high and dry again For Friday a chance of storms returns, but the marginal risk of severe weather is way out here on the plains For Saturday a chance of storms that nothing severe looking nationally. We've got Me do that real quick Technical problems, but I can't go back and re-record. We got to just pop through here So for Wednesday, we have dry conditions in the northern part of the state There's our dry conditions again over much of the stakes of the four corners Arizona continues to get lots of precipitation and That continues on Friday with those front draped here. We just don't have the moisture coming over Very easily. This is cooler more stable air and for Saturday same thing We still got this old front draped here slightly cooler air We do have going the ridge in the west. We're going to take a look at that moment fires up here Be sending smoke down. So you're gonna see some air quality alerts over the next few days and you'll See a haze there might even be times you can't see the mountains because of the smoke We've been largely smoke-free this year. So that's very nice All right, you're gonna get the ensemble forecast. We have temperatures below At least in the lower part of the normal range Normal has gone from a 785 and I had to put the line above the graph 85 to 55 for low. So you can see the normal nighttime temperature is dropping pretty significantly bone dry for a couple days here at the beginning of the forecast period and then Sort of the end of the weekend weekend We have a chance of showers coming back dries out a little bit more precipitation later on So we have this ridge in the west and that's bringing the smoke down and the cooler air that's stabilizing us Cool air is going to go down and settle into Texas and the southern plains and the south It's gonna be pretty interesting because they've had a very hot summer so far So a couple notable Tent poles in the forecast before we look at the animation is Thursday evening with our high almost over Colorado We don't have the north flow though on the side of the high a big ridge out west big trough in the east And the dry air is very obvious the browns here or below normal Precipitable water and the moisture continues in the southwest and the western states Looking at Monday. The highs just moved a little bit to sit over the top of this That's that next dry period and all the trough is kind of passing to our east and digging down And looking at the moisture. Yeah, it's still pretty dry in the north east part of the state So let's take a look at all this in motion Just keep an eye on this Ridge you have the ridge center up here in Montana for a little bit kind of a secondary ridge down here and big overall ridge itself just keeps Rolling around right over the top of our heads. So that makes it hard to get significant amounts of Convection especially off of the mountains. So, yeah, the ridge is still here. It's in Utah now four corners area Grand Canyon area Las Vegas Going out to next Friday Looking at temperatures. We are right on the edge of pretty warm stuff out here For night time and morning temperatures cool in the afternoon because of the moisture But look at this blob of cold sitting to our southeast and just kind of settles in over Oklahoma and then down into Texas here about Tuesday Wednesday I see the Mountain storms in the afternoon. It's this unusual cold. That's with that Northly flow around the ridge to the west And because of that we just keep getting dry air pushed in to the northeast part of the state So we have moisture not far away. Sometimes it tries to surge over. There's Sunday So we get a little more storm activity on Sunday and then the dry air is back We've got moisture even north of us in Wyoming and Montana But the dry air is not far away kind of flowing into the eastern part of the state on the plains by the end of next week So storm-wise not much to see I'm probably gonna cut this a little short But the mountains at least get a precipitation. That's good. I have heard that Water levels at Lake Mead are rising some I'm gonna have to look Deeper to see how much maybe I can bring that to you next week. But yeah, nothing here. It's just dry for the next Wednesday So over the next five days northeast is missing out on much in the way of precipitation because of all that north flow and dry air 10 days hints that things change and the plume moisture might be coming back later next week or next weekend into the state So we start pretty cool 80s on Wednesday Just get to the 90s then we hover back down to the 80s upper 70s on Saturday and then upper 80s through the beginning of next week with a small chance of Precipitation may be picking up next Tuesday. So kind of quiet kind of normal and kind of dry Frequent weather updates can be found at Longmont leader and bring filled leader a dot-com This has been chief mayor August John is worth keep looking up


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 data set. 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 of 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 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, 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 on 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 to 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 be 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 to 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 on 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 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 1 and replace for me because I already did that one. Let's go back. And 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 Table 2. I think this is a good learning experience, good bonding experience for all of us. If you do this with me, that means we've seen stuff together me and Engels. So this one, control shift C is going to be our Table Table 3. All right. Oops, what am I doing? I need a new one. So something you need to look out for and something that we didn't have to look out for in 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. If you look, I already have this 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 because then it will be numeric and it will assign it a numeric data type. And so what we're going to do is we're going to do control H and let's just have it. 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, we'll do that. Well, no, we'll go to zero, replace all them, and we should be good to go. This should fix any issue that we might occur 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 watched this in the first place. So stick around because we have to do this in the next one as well. So we'll do File, we'll do Save As, Download. So do Table Low, Table 3. 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. And as you may be able to tell now, they don't. And that's because 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. 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 dropdown after clicking on 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 5,000 done. Let me make sure because I thought there were more than that. 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, once we save this, we have our four. I can't talk at the same time. I can't talk and type. 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 Table Low. And then we need to start building our visualizations. So pull up Table Low with me. Click Microsoft Excel. And we're going to go to Table One. And we're going to open. And this is exactly what we had before. This is our Table One. Now we don't want to 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 do it here. I'm, for the sake of what we're doing, I'm just going to go to sheet two. Go to this one right here. It says new data source. Go to Microsoft Excel. And we're just going to do this for all of them. So we're going to do, we're going to import it. We're going to 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, I'm going to do it like that. All right. And then four, we're going to add it. And now that we have them all opened up, what I'm going to do now is I'm going to cut myself off the screen because you don't need to see me anymore. And I'm going to, I'm honestly, I'm going to get in the way because we're actually going to 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 where I am. So thank you for sticking with me. I'm going to 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 we are going to get started. Now the very first one that we're going to do is by far the simplest. It's extremely simple. Let me show you. We're going to be looking, we're going to be doing this one right here. So these global numbers with just these colors 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. 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. We'll make that a column. Total deaths and death percentage. Now, of course, this is not how we want it visualized at all. What we want to do is go over to the show me and then go right back up here for these text tables.  So right down here, 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 that is what we have now. And we want to move these measures right up here into the columns. 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. Let's expand this just a little bit so we can see each one perfect. There's a few things that we need to change in here to make it just more user friendly, make it look better. 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 and make it look a little nicer. And then we'll do a little bit after that. So 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 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. You can also change the size 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. And let's pull this down a little bit. 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. Not super important. We can always do that later. But we also want to change the shading on these as well.  That looks absolutely terrible. I do not recommend that. But if you go to the pane, the pane is what's referring to this with the rosemate. So we can do this. I like it a little bit lighter. Maybe like that. I think that doesn't look bad at all. So there's a lot that you can customize in here. You can even do grid lines, trend lines. Let me see. Maybe we want to do something like this. I mean, I personally like doing some sort of lines to separate these out. But we don't have to, but I'm going to try to do a little bit. No, not try 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 very similar to what I did originally. And I think this will be good to go for now. 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. We have already completed the entire dashboard, but we're going to 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 2 as in 2%, but it's rounding to the nearest whole number. And for death percentage, we want to be a little bit more accurate than 2%. Maybe 2.1103 or whatever that number is. We want to be a little bit better. And so I think we want to go to the two decimal points or the 2.11, which is what the number will be. So the first thing that I'm going to show you is how not to do it. 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. 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 specific as you'd like. I'm going to keep it at two for at the end of the video, you're going to see that it says two 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. Let's go to table two. So what we are doing in this one is we're going to be creating and I'll go back here to show you. We're going to be creating this graph right here. Okay, that's great. Give it a second. We're going to be carrying that bar graph that you just saw. And I'm not going to wait for it. It's if you look right here, this small bar graph. That's what this one right here, that's what we're going to be making right now. This one should, I believe they did the second simplest. I kind of did them in order of simplicity. 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. 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. 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 previous thing. So super, super close already. And you can do other things.  Or do what I just did. You know, go for it. But I like the simple look 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. So something that I want to do that I personally like doing is going is ordering them by highest and 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 is before Asia. There we go. Looks like it's 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. 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 continent. Is that how you spell continent? Yeah, that's how you spell continent. Perfect. And it changes up here. Super easy. And if we do this right here, and 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. I like to keep it pretty moderate. Just a normal one. I don't want to get too crazy over here. I'm just trying to help. So if we do the color, you can do lots of different colors. And you can do it in an ascending order. 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. You can keep a theme in your Tableau dashboard, which will be something that I probably talk about in my tutorials. Speaking of something I have not mentioned, and 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 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. 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 I did that backwards. 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, 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 the colors you can do a lot with if you want to. I personally just want to keep it how it was. So I'm just doing Control Z. I'm just going to keep it like this. Not doing anything too crazy, not doing anything fancy. 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. So we have this, there's a few other things that you may consider doing. Speaking of something like this, you can enter this axis. Now, as of right now, it's doing tick marks, or I think I'm going to call them tick marks. They are called tick marks of 100,000. You don't have to have it like this. You can change it and customize it however you want. So 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, that's just a million. So that's what it's going to look like with a million over here. 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, it's going to look how you make it look. Okay, I'm just going to keep it with the automatic again, not because 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. And visualizations should not be crazy hard to read. So that is the end of our second visualization. And we're going to move on to our third one, and arguably my favorite, which is the map. 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 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 location, as you can see, these are all countries. Now, it's not going to open up these map options and the show me it's not going to open up the those map options because 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 part of a geography. This is something that you should be looking at differently. So we can change this and we go we're going to we're going to click on this little drop down. We're going to go down right here to geographic roll. And we're going to go down to country region. Let's click on that. And as you can see down here, they just generated some 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 needs it is allergy season for me. My goodness, it is not pretty over here. So we have the longitude and latitude. 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 automatically really quick. If you want to do the pan, you want to be able to reposition it. That's what I want to do. Reposition it about right here.  This is how you select multiple. I don't really need that. So I keep it on the pan from most part. Anyways, now this is where we need to insert 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. I want to make, I want 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? It's because it ruins everything. That's why I want to add it right down here. And that's fantastic. 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. So this is a lot more along the lines of what we were hoping for. So this is looking really, really good. So there's a few things that I want to mention or talk about before we actually start moving into this. One, Tableau has their own whole section called map up here. 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. It adds a little bit of depth, a little bit of, 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 get a lot brighter, something that you can do is add something like a label. And before that would have made sense. 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 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, go over here, go to label, and then adjust that label to how you like it. I think that is perfectly acceptable. Now, these colors aren't to my taste. As you can see over here, we have 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 to color, clicking on that, and going edit colors. So I don't know why I pulled it over there. I'm going to pull it back. It doesn't make sense. I personally like reds, oranges, 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 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 a sake of what we're doing, you can do something like this. Again, it's the personal taste. So if you don't like this one, don't use it. I don't want you to use it. I want you to find one that really looks good to you. And just know that anyone that you choose, you'll still have this right over here. So you should be all right. Let's 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 its row. But 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, 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. All right. 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 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 I can do the color down here. I can do multiple things with it.  I also want to have a label on the location. You can do that. You just have to add multiple things that that marks teachable moments. Just trying to keep it kind of keep trying to keep the learning alive. Um, let's go into 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. 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. So what we need to do is we need to bring over the date. And we want that to be on our a column because we want it to show the progression over time. 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. And look, it already tried its best to create something. And it really did. It tried its best. 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. But 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. But let's do this really quick. Let's put month. It's breaking out by month. And now I'm regretting making it larger. If you notice, it doesn't have 2020 or 2021 in here at all. It just has January, February, March, April, May and June, July. So it's breaking it out per month. Let me go back to make it small again. It's breaking it out per month. And that's not what we want. We don't quarter either. We want to have it by year. 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 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 today, it gets very specific. And you can do it this way. And so on each day, you can do the percent population effect. And as you can see, it's going higher and higher and higher. That's not, that won't be that way. In just a little bit, that's summing the percent of all the countries. So we have it like this. 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 looks. So look at it like this. So, you know, just the way it has it. And then look at it like this. It's just what I would consider a little bit easier. Okay. So you don't have to do it like that. Do it however you would like. Whoops. That is not what I was trying to click. So we want to break this out by each individual country. Okay. We don't want the sum. That's not what we want. So let's go down here and let's say average. That's not what we want either. Why did I do that? 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. And as of right now, this is a hot mess. They're all in there. Let's look at this one and Dora. They're all in there, but they look horrible. I mean, that's not what you want. So, you know, we can easily break this out by color. And it's 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. This looks 10 times better than it did just a minute ago. It still looks terrible. And we can limit this to specific locations. I think it's right up here. Let me see. Is it sort? I don't know if it's sort. Let me see. Let me see if it's location. Maybe it's filter. Here we go. So if we go, I'm going to restart if you didn't see that. So I'm just going to go to location. I'm going to do the drop down. I'm going to go to filter. And what I'm going to do is I'm going to look for a few specific countries. So I'm going to go to none. I want to do the United States as well as the United Kingdom. Let's do Mexico. We'll do India. We'll do China. And where else should we do? 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 OK. So as you can see, it's still summing it. Let's not go to some. 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 or hardly anything. You know what? For simplicity's sake, I don't want to get into all that stuff. We're just going to keep it with average. So it's going to... Over that month, what is in that month? What's the average in that month? If you use the maximum, it's breaking out 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 it 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 as you can see, the United States, we're just unfortunately doing well in this category. And as of April of 2021, we have a 9.5. This is, by the way, the 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 update that in your tables to get the most recent data for May. 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, you know, we can add labels and excuse me. And if we do add labels really quick, why not? We'll add 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. We can also do... Let's see. Let's see what else we want. Do we want to add the path? Because we could. Let's see what the path looks like. Oh, that looks terrible. Let me see if the order changes anything. No, just accidentally ate it. Whoops. Let's see what else we can get in here. So dimension. No, I'm just messing around real quick to see if I can find anything interesting. But the colors are auto-generated. You can always change the colors. 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 predictive analysis or forecasting, like where are these numbers going to go in the future? So all you have to do is go up to analysis, go down to forecast, and just say show forecast. And that's about as easy as it could possibly be. At least, you know, I mean, it could be easier. That's about as easy as it's going to get. Now, I want to know, I want some additional information on here, just for me, myself and I. So I'm going to do this percent population, 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. So now it's showing our numbers. So it went back to March, and then it's forecasting ahead. Now, if I shrink this a little bit to June when it starts ramping up, the forecasting will go away. I can do that. I can do an exact, oops, let me not do that. I can do a custom range. Let me see if I can. What am I doing? What on earth am I doing? Is it format? Let's take a look in here. I genuinely don't know where I'm looking right now. I'm trying to 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. I don't remember where to go to do that. But that's okay. Just imagine shrinking it to like June, and the forecasting going away, because it needs, I believe, 12 months of data to be able to predict into the future. And these numbers look pretty accurate. It's predicting until March to the end of the year. And if I know the US, yeah, that's probably pretty accurate. So by the end of this year, it's projecting about 20%. It's very possible. And who knows? Who knows? We're starting to love Lough, right? You see this curve is starting to go down.  So this right here, I mean, it's pretty good. We're doing all right. So let's rename this. And let's call this Percent Population Infected. Now, this is just what I wanted to do. You don't have to do this. You can do, 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. I don't want to call it a 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. It 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. Let's change the size. Just do automatic. Makes it the largest. And let's start adding things. I'm just going to start adding them because, well, I can. And then let's do, let's add this map. And let's add this. Just 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 will stay in here. Oh, that looks terrible. I'm just going to keep it there. I'm going to try to drag this. Let me see. How can I get this to stay up top? Oh, here. Let me try to extend this one. That's not really how that helps, 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. Formatting in these things, I am not a fan of. But, you know, what can you do? Whoops. Let me go over here to drag. I'll do that picture. It covers a lot of countries. Okay. This is very close. I mean, we could get closer. But, I mean, this is about it. And let me stop right here and just say, if you've made it here, you're doing a really good job. I don't know if I went too fast or too slow or what I did. But, you know, we got the data into Tableau. We looked at our data. We then created each of the four visualizations and then put it into a dashboard. And as is, right here, we're pretty close. There's some things that need to be changed. 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, 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. And if I had three hours, four hours, five hours, you know, we could do that. But honestly, that would just be insane. 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 readjust things. I had to go back and look at my queries. In all actuality, this took me a week. Or probably the more advanced one took me a week. And so, I don't want you to get this picture in your head that this is just only takes an hour and a half. Like legitimately, this could be weeks of work. To look at the data, make sure that the data is clean. To make sure that your visualizations do what you want. You may want to have some type of theme, some code 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 a little quite a bit more. There's so much that could go into this.  I promise you it took me quite a while. Legitimately a week on and off working on it like an hour or two a night. Because I'm not perfect. I make mistakes.  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 that you didn't think that I was some genius because I don't want anybody to think that is not 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. This could be a little larger. And honestly, I should make that a little bit larger. Yeah, I don't know why I didn't do that. Make this a little bit larger. And so, now we're done. Now we want, let's say, say, okay, you know, I finished my dash where I want to share this to LinkedIn. I want to share this as a portfolio project on my resume. How do I do that? So, so simple. We're going to go to File. We're going to do Save to Public or Table of Public As. It's going to basically say what is it. And I'm going to say COVID dashboard. Let's say, tutorial. You don't write that. That's nice. Tutorial. I am, as you can tell, I talk to myself a lot when I'm spelling. It helps me sound things out. So, we're going to 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 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, again, 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. I didn't want this to be three hours, which it was before, and so I condensed it. And maybe this is now like 45 minutes, which I would be super happy about, to be honest. The shorter the better, 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. On my Alexi 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. This is your Tableau portfolio. Your portfolio for SQL, your portfolio for Python, those are going to be in GitHub and you'll need multiple of those as well. So, don't just stop here with one, okay? Let this be a starting place and then you grow from here. This should not, I don't think this should be your final product. It's not bad, but you can go further from there and improve on what we've worked on today and make it awesome. So, that is all I got. I hope this has been helpful. 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 to get the kind of visualization they were hoping for. I really appreciate you watching this. I hope, again, I hope it was helpful. If you liked it, be sure to like and subscribe because I have a lot more content coming out 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.


Interestingly enough, the application of certain frequencies by frequency-generating devices can enhance cellular resonance and cellular metabolic and electrical functions.


John, the title of your piece is Ghost Fence. What's it a ghost of? It's a ghost of the original park boundary fence for Lincoln Park before it was cut off in the creation of a wider Franklin arterial. And so it's kind of the memory of the fence in its approximate original site. And it also shows the corner pillars as well, those boundaries as well. Yes, so those mark the original corners at Franklin in Congress and then Franklin and Federal Street. And what's the fence made of? It is a white flagging tape like you would see marked on trees or poles for repair. And there's wooden stakes like you would use in a garden and then clear plastic sheeting. I was really inspired by the new construction around the site and the materials seen in those sites when choosing the materials for this. I've always been interested in working on Franklin. I find it a very interesting spot with its history and how much it's changed over the years. And urban renewal is such an American dream in a way. It was like a way to idealize an urban environment, make it better for the people who live there. But there's also social consequences of that too. So that critique of the American dream that it's like for the greater good, but like what's the cost also? Older Portland residents will remember when this boundary was here and was the park. Are you hoping to invoke memories in them? But what about memories, new memories for people who have never seen the old park? Yeah, I've been getting a lot of response from people walking by and driving by who recognize it for what it is pretty quickly. But there's also especially younger people who don't have the memories here that maybe only see this as a street that's like hard to cross and is really windy or there's a lot of cars. And so I wanted to help create like a positive memories in this space for people who don't remember it when it was a park. The park is a community gathering space. And because John's piece is showing the original boundary of Lincoln Park, we wanted to plan this event around the idea of community and gathering and creating a place for people to come and sit and linger and have conversations the same way that they would as if the park still existed in this space. The idea that the city uses this space, they're kind of turning it into a meadow. You can see that the grass is really high in the middle of the area and it dips down a little bit so it is a little bit more removed from the busy streets on the side even though there's hundreds of cars that have passed by just in the hour that we've been here. It does seem to be a little bit more peaceful in our little pocket where we are. Alice, the ghost fence event here with June's First Friday is the first of three installations that you're going to have over the rest of the summer. Talk about what's coming up. The next piece that opens on I believe July 7th will be a garden project in Kennedy Park with a number of immigrant women from Syria and Somalia and the signage for it will be out in the public way showing people the way to the garden. The final piece in August is going to be by an artist called Christian Prash and it's going to be in Post Office Park and he's going to be building a number of big wooden blocks that participants can build in various configurations including a fence and possibly a gateway and so those are the three different projects we have this summer. They're small, they each last for a month and then we also will be choosing our 2018 project. We have a curator we've hired and in a couple of days we're going to go look at sites along Back Cove which is where the next project will be cited. When you think of art you think of something that's permanent but the whole concept behind these projects is something that's temporary. Talk about the philosophy behind that a little bit. Temporary art is wonderful because it doesn't cost a lot. It can address timely issues. It can come up and down quickly. It can provide interesting surprises in sites all over the city. It has an energy that permanent art doesn't have because it has to be permanent. It's a capital investment of the city and it's very, very costly. So this is a whole different approach and also in large part we can use younger artists without as much experience and give them public art experience.


Harris, welcome to Bratford City. How happy you are to be here. Thank you. I'm glad that I signed for Bratford and I'm looking forward for my Debbie. And what do you know about the club? Because obviously you had a trial spell here a couple years ago, didn't you? Yes, I had training for a week just to see the facilities and everything. So everything was okay. Just on the end Newcastle and Bratford couldn't agree for a loan deal. But now I'm here, so that's the most important. And you're working on a shoot, McCall, again. You've of course spent time under him at Rangers. What can you tell us about your relationship with him? I had really good relationship with Stuart. I had a great spell at Rangers. I've been playing all the time, scoring goals. So hopefully I can do that here as well. And you covered it slightly there. You obviously had a loan spell at Rangers. What can you tell us about that? Because that was quite a successful one for yourself, wasn't it? Yes, that was one of the most successful loan spells that I had. I was playing all the time, scoring goals. Start to enjoy the football again after the bad injuries I had. That was the best loan spell I had. And were aware that you spent time at Rangers with Nicky Lowes here now? Do you know any more of the lads here? I know a few. I can remember a few from the training a few years ago. I know Nicky Lowes. I know Jordy. He was with me at Wigan when he was alone there as well. So I know a few lads. So it's always easier for you to settle. They're helping you out. So it's all good. And what memories do you have of playing against Buffett City? Because I've always had a memory of you scored a couple winning goals against us. Good memories of winning goals. But the fans won't be really happy if I talk about that. So I think they will expect me to start scoring goals for them now.


11 fun ESL activities for young learners When teaching young learners, it's important not to spend too much time on any one activity as they can soon lose interest. It is also a good idea to have activities that give younger learners the chance to move about and use the boundless energy they have at that age. Below we present a list of short activities suitable for young and very young learners of English. What's the time Mr Wolf? This is a good activity for practicing time with small classes. Clear a space in the center of the classroom and have a student stand in front of the board with their back to the class. This person is the wolf and the rest of the class stand at the back of the room. For each turn, the class asks the wolf what's the time, Mr Wolf, and the wolf replies with a time it's three o'clock. The rest of the students then take three steps forward. The class keeps asking the question until the wolf says it's dinner time at which point he turns around and tries to catch someone. The person he catches then becomes the wolf for the next round. Telephone Split the class into two teams. Have students stand or sit in a line and whisper a sentence to the first student. Each student then whispers what they heard to the next student until they get to the end of the line. The last student then says the sentence aloud. The team who is closest to the original sentence wins.  Before they can take their shot, they must answer a question from the teacher correctly. If they get the ball in the basket, they get two points. If they hit the basket but don't get the ball in, they get one point. Volleyball Use two chairs and a piece of string to make a net across the middle of the classroom and use a balloon as the ball. Divide the class into two teams and have them play volleyball. When a winning shot is played, the teacher asks the whole class a question, the team that answers correctly wins the point and gets to serve next. Vingo This classic game can be played with numbers, words or pictures on the student's bingo cards. The teacher calls out a number or word and the students mark off the corresponding number or word on their card. The first person to complete their card shouts out bingo and wins the round. Can you? The teacher asks students if they can do certain actions. If they can, the student answers yes, I can and then performs the action. If they can't, they say no, I can't and the teacher asks them if they can do another action. Be sure to have some actions that are easy for shy students to do. I spy The teacher starts the activity by saying I spy with my little eye, something beginning with and chooses the first letter of the object. Students have to guess what object the teacher is thinking of. The first person to guess correctly takes over the teacher's position. For younger learners, colors can be used. Odd one out The teacher writes four words on the board, three of which are related to each other in some way. The students have to say which word is the odd one out. This activity can be done with objects or pictures in place of words. Stand up please The version of Simon says where the phrase Simon says is replaced with please. The teacher or a student asks the class to do certain actions, but they must only do them if the teacher says please. Anyone who does the action without it please, being said is out of the game. Mastermind This is a good activity for older children. The teacher chooses a four or five letter word and draws the corresponding number of dashes on the board. The students have to choose a word of the correct length and one of them writes it on the board under the dashes. The teacher marks each letter with a tick, a circle or a cross. A tick means the letter is in the original word and is in the same place. A circle means the letter is in the original word, but in the wrong place. A cross means the letter is not in the original word. Blindfold obstacle course Create a course in the classroom using chairs and desks, etc. Make sure that students won't hurt themselves if they bump into them. One student wears a blindfold and the rest of the class has to guide them through the course with directions, such as turn left, go straight on, climb up, stop, etc. Rearrange the course for each new blindfolded student. Are you ready to teach English abroad? These 11 activities are ideal for young learners in the ESL classroom and are also handy to know when you have some spare time in your lessons. Sign now for your TEFL TESOL certification course and start teaching in a matter of months. Speak with an ITTT advisor today to put together your personal plan for teaching English abroad. Send us an email or call us toll-free at 1-800-490-0531. To speak with an ITTT advisor today.


Good morning everyone. Nice to see all of you here and thank you Anurag and Naval for inviting me to speak this morning and share my views.  I think all of us have seen a carnage like never before at least I don't think I have seen such a carnage. India was more affected than the rest of the world in advertising overall, advertising took a dip of I think about 25% always took an even sharper dip, which market share dropped from 5% to 2% it's now up to 4% which is good news and from speaking to everyone in the room and others and from my own experience at Madison I feel OH now has really a right to win and it has already begun to take shape from the sort of optimistic view and the smiles I see from outdoor people when I meet them. Now whilst all that is good news, I think at conferences like this probably an opportune time for us to sit together and discuss and debate what can we do more to you know make the flag fly higher and higher. So over the years expert but yes, I've been around in marketing and advertising for 50 years so I obviously have a point of view on what outdoor should do to actually gain back its market share for a long long time globally outdoor used to have a 7% share of addicts Over the years today, it is 4%. Obviously outdoor as an industry has been growing but the fact that share has come down to 4% globally not just in India means the other media are growing much faster than outdoor is so why should we in this room allow that to happen or what can we do so that outdoor can also grow much faster then it is going now and that I thought should be the theme of my 15 minute talk to you this morning So to give you a global perspective, you know according to what I'm talking about, I'm talking about a stock whose figures I respect because they're an independent agency not involved in the media business they're more a third party research kind of agency according to them the world today spends 880 billion US dollars on advertising. Yes, that's the size of the global addicts market. Despite Covid if you take the last 10 years last 5 years it has been growing at a compound annual growth rate of 10%. Of course we all know this that you know the new dazzling mistress in addicts is digital and you know digital never fails to surprise me or all of us in the room do you know globally globally digital has gone up in share from 33% to 56% today that means digital alone is larger than all other mediums put together now I'm talking global figures not India figures you know even the mighty television which we thought was invincible at one time and the favorite medium of most large big multinational and Indian companies who even today spend 70 to 80% of their huge budgets on television is beginning to soften you know television globally has lost its share from 39% to 29% today over the last 5 years print seems to be the worst effected and the carnage there is dramatic a drop of 14% I mean a share of 14% is now down to 6% actually India is one of the bright spots for print where it still has a share of 22% so given all this you may say that we are doing reasonably well at least we have grown our share back from 2% to 4% but is that really good or is it good enough for us should not our ambition be higher digital technology also you know has not just penetrated OH or outdoor actually it has penetrated every medium you know if you take television now within television I would say we have connected TV which is nothing but digital and in OH you know my figures say globally digital now contributes 27% to overall OH in India it's a little lower but I was happy to hear from Nubi this morning that actually our local municipalities are now encouraging you to put up more digital screens which I think is very good news for all of us including the advertisers so now let's take a little closer look at OH we can do to sort of further build on the momentum that we now seem to have gained did some analysis to see which countries do better than 4% in OH 4% is the global average the countries that do much better are Japan and it has stopped the list for the last 3 years with a share that is almost 3 times the global average so in Japan share of OH is 12% it's followed by France, China, Russia and Germany all these countries have a much higher share of outdoor on the other hand UK, Brazil, USA and Italy are lower than the global average now I think we should try to analyse those countries which are higher what are they doing in outdoor how are they wooing the advertisers there and how are advertisers looking at outdoor in Japan versus in India I am also trying to do an analysis to see whether there are sharp differences in the category wise contribution to global average and OH should give special attention to certain categories and what I came up with is that they are not very different except in the very large FMCG category in India FMCG in India at least is the largest category of addicts it is about 30-32% of addicts it has been like this for the last 10 years and some years it has gone up to even 40% for one reason or another does not use outdoor in India as extensively as it should another area where OH is under index seems to be technology and electronics so I think special efforts must be made with advertisers in these two categories to convince them about the power of OH in building brands in these categories now a disconcerting fact for many people in this room is what these very large management consultancies global consultancies have to say about outdoor you know many of these large companies employ such consultancies to do very elaborate return on investment analysis on the money they spend in advertising and rightly so because as I told you advertisers are spending $880 billion on advertising so their company boards must be demanding to know what it is doing for them now recently I came across some figures put out by Ibequity and Bain pretty respectable names they say television delivers the highest ROI of 71% online video, radio and OH just delivers 3-4% now we can say thankfully not many advertisers are taking Ibequity or Bain despite their reputation very seriously seeing the way OH is growing in India at least in the last one year but this is something that I think we as a group should try to address wonder based on my personal experience with some advertisers as to why outdoor is not growing as much as it should our outdoor does not have the kind of share that I really it deserves to have in India's ads the first I think Anurag alluded to it is I think widespread diffused ownership a lot of issues could get resolved if there were few large corporate players with good holding power to deal with agencies, clients and authorities whether we like it or not the unfortunate truth is media today is bought and sold based on some very very stringent negotiations and it is important unfortunately for the seller to have some holding power if you see other media they are concentrated in the hands of a few players and therefore they have better ability for holding power important point I feel is lack of advertiser confidence now this stems from fourth is one lack of credible third party monetary was in a large outdoor pitch I think I have not attended too many outdoor pitches but the one question the advertiser asked what guarantee can you tell me that every board that you say that is in your estimate or plan can you say with a certain guarantee will actually be up it is a telling question for all of us to reflect in this room secondly third party credible industry supported and recognized viewership data is still eluding us my friend Numi is trying to do a lot in this but somehow the industry does not seem to be responding well for one reason or another a third as I see it is lack of clear guidelines of local regulatory bodies rendering legality of sites in question I was personally involved in an issue I think about a year a year and a half ago where four of my clients very prestigious clients got legal notices from the government those notices created a scare at the board level and you know we had to fly our people several times to some I think distant place in UP or somewhere to try and understand what the issue was I mean fortunately I think after six to eight months we were able to cool things down and the advertisers were led off the hook but this kind of thing no advertiser wants to get involved in and least of all CMOS would then take the easy way out and say look I don't want to get involved in this laffra where I get pulled up by my ward also what you're done for and I don't think this is often spoken about is inadequate selling efforts by sales teams to both educate and sell to media planning agencies resulting in inadequate awareness of the opportunities that exist in outdoor the efforts put in by print TV and radio if you come to the Madison reception on any average day in the afternoons there is no standing room it is full of well sales people in one way or another from different media waiting to meet our media planners to talk to them to sell them to overtly or otherwise about the opportunities that are coming up all this time I don't think outdoor does that in the same aggressive way and maybe they do it they do it more to the outdoor agencies and not to the media planning in the full service media agency who actually sits on the total budget so what should we do to target say a 10% share you know if we hopefully achieve try to reach for the skies we'll at least go somewhere higher than 4% I want to do say that I am personally extremely bullish about the prospects of OH in the coming years and why am I so for a few reasons one as we all know now technology has entered OH which earlier it had not and I do know from my experience in other media that once you have the benefit of technology actually scaling up becomes faster and advertisers also love the input of technology second is the arrival and rapid adoption of digital OH around the world I'm sure it's going to happen in India too sooner than later third reason why I'm bullish is the immense possibility that programmatic will offer to advertisers which will allow optimum use of even non-marky sites and some of you may know this I have put my money where my mouth is and invested in a platform called Lemma about which I'm sure you'll learn more of in the months to come this will allow OH to operate not just in the OH market as we narrowly define it today which is estimated at 4% as I told you but participate in the much larger digital market and in the much larger TV market whose main characteristics of audio plus visual is always laptop in this room have to do a few things one, we need to develop category wise knowledge and expertise we need to develop case studies of when outdoor works how it works why it works what works and when it does not work and we should not miss out outdoor understand why some countries do better why does Japan do better and try and incorporate some of those learnings here understand why some categories do better present these and talk about all this in ANM industry fora like this one write about it in AMN journals and websites and one-to-one meetings at agencies and advertisers end secondly, we need to develop testimonials from prominent marketing people who have used outdoor and are willing to speak about it I don't see too many such testimonials floating sometime ago I was asked to present my views at one outdoor congress I think in Malaysia and I asked five advertisers to talk about their experience with outdoor and I was surprised they gave their I believe they were honest views but they were extremely happy with what outdoor was doing for them but I don't see such videos floating around in India we need to get the mere agency who should be media agnostic and who has the year of the advertiser to be more familiar with such successful outdoor case studies and also be familiar with the opportunities available and a few basic mechanics like rates, impressions, viewership and what not I dare say today they are not and of course we need to build confidence in outdoor trying to take care of as many impediments as possible sometime ago I had done an analysis may not be a very thorough analysis but there are only about 550 advertisers who spent more than a crore of rupees in outdoor now this number is just too low in a market where there are lakhs of advertisers using digital and definitely a couple of lakhs to use print why are advertisers mega advertisers only 550? I think it's something that we have to address and my last point and I made this point before in other industry forums is the importance of creative in outdoor even recently Google had put out a study which said that 50% of the impact that an ad makes is because of creative content it's only the balance is affected or impacted by media now the truth is historically creative reputations of individuals or even agencies have been built on television advertising also I've seen spend 95% of their time developing creative for advertising films and even those who use outdoor do not pay adequate attention on the creative use in outdoor I hope I'm wrong but in my view almost 50% of our sites have created that I believe is not ideal it is overcrowded, too busy, too many words not enough color contrast they do not use typeface which is suitable for outdoor and very often the layout is not suited to the parameters of the site I use the ceiling very often and I've seen there is a large hoarding that has come up in the last one or two years on Tarz Landsend and I see that hoarding I'm sure many of you have seen it more than half the time sure it's a very expensive hoarding the layout or the creative use is not suited to that hoarding you can't read it clear sometimes you can't even make out what the brand advertises because you are seeing it from a huge distance it's a terrifying site but nobody is paying attention to creating a design for that site maybe that site costs I don't know 2-3 lakhs a month isn't it worth everyone's while to spend at least 15 minutes thinking about what creative should go on that site a simple rule of thumb that I would use for creative is not more than 5 words on the site one dominant visual or word and flat bold colours you wouldn't go wrong guys I'm very bullish about the possibilities that outdoor is going to present to advertisers with the rapid development of technology but I think it requires some serious work from all of us in this room especially those on the sale side because ultimately they are the ones who rake in all the money to begin to invest seriously in this medium beyond what we are doing today in terms of technology in terms of deep knowledge in terms of sales efforts and some of the things I spoke to you this morning so thank you very much everyone have a good conference


What is IBD? What causes it? And who gets it? Inflammatory bowel disease is an autoimmune disorder that affects about 1 in 300 Americans. There are two forms of this disease, Crohn's disease and ulcerative colitis. Crohn's disease seems to affect the whole digestive system from the mouth to the anus whereas ulcerative colitis seems to just affect the colon. They also have a different way that they inflame the structures that they affect and that Crohn's seems to affect the whole wall of the digestive tract whereas ulcerative colitis only affects the topmost layer. The people that get it are traditionally thought to be Ashkenazi Jews but there's a large incidence in African Americans and and as America is quite diverse it seems to be affecting all ethnic groups. There's no specific reason people have inflammatory bowel disease. Genetics are part of it but the other aspects are also perhaps environmental or dietary or the bacteria that live inside us. We don't understand any of those specifically but we can say specifically related to the genetic component that monozygotic twins which are born from the same egg have only a 50% chance of having the disease. If one has the disease the other one has only a 50% chance of having it. What are the symptoms of IBD? The symptoms of inflammatory bowel disease are varied. People can complain of weight loss, abdominal cramping, bloody diarrhea, nighttime symptoms, nausea, bloat. Out of the ones that I listed the ones that are most specific for this disease are blood in the stool and waking up at night to go to the bathroom. How is IBD diagnosed? IBD is often diagnosed by a physician. It is hard at home to figure out if you have inflammatory bowel disease or just a bad case of gastroenteritis. There are a lot of clinical symptoms that can make both the patient and the doctor concerned for inflammatory bowel disease but the ultimate confirmatory diagnosis requires tissue. Uncommonly if the disease is in an area that's difficult to biopsy we could also make the diagnosis by radiologic findings such as a CAT scan or an MRI. When should I see a doctor for digestive issues? That is a very good question. If the symptoms have been going on for more than three weeks we consider them chronic and if they are bothersome then at that point they require a physician attention. Specifically related to inflammatory bowel disease the symptoms that I would be most concerned about are weight loss unintentionally especially at a time when you would be expecting to gain the weight as for example in adolescence or during a pregnancy.  Often patients don't realize that not only the digestive system is involved in these diseases but also other parts of your body. What is the best treatment for moderate to severely active IBD? Traditionally IBD patients were treated with long courses of steroids interspersed with periods of antibiotics and sporadic endoscopies and colonoscopies. Literature has evolved that demonstrates that patients should actually be treated in a more rigorous and organized way which is something that we could provide here at Winthrop University Hospital. There are two classes of medications which we are very comfortable prescribing here called the immunomodulators and biologics. Immunomodulators typically taken in pill form are used to block the bone marrow production of a specific kind of white cell that would otherwise inflame your digestive system. Biologics which are usually injectable to the same thing in a more targeted fashion. The combination therapy especially in Crohn's disease but perhaps also in ulcerative colitis has been clinically proven to be the most efficacious way to treat patients with moderately to severely active inflammatory bowel disease. What are the consequences of long-term steroid use? Steroids specifically prednisone are a very common medication in inflammatory bowel disease. They are of our armamentarium of medications, one of the fastest acting medications. So when a patient is very uncomfortable in a lot of distress or potentially about to be hospitalized we often use this class of medications as a way to calm their symptoms. The important thing to note about steroids though is that they are not altering the disease course they are just improving symptoms. So the optimal use of steroids in IBD is for a short-term specific clinical situation with the plan to transition them to a more long-term treatment strategy such as immunomodulators, biologics or both. The consequences of taking steroids for prolonged periods of time are multifaceted. In the short-term often my patients become irritable, moody, anxious. There's facial swelling, sometimes fluid retention in the body. There's bloating, easy bruising, the skin becomes thin, there's hair loss. In the moderate to long-term people have an increased risk of diabetes and high blood pressure, a loss of bone density which can translate into osteoporosis as well as fractures and most significantly a decrease in their immune system which makes them vulnerable to any infectious pathogen. What preventative healthcare steps do I need to take when I'm on IBD medications? That is a very good and important question. Patients with IBD should consider perhaps four categories of preventative health measures. Vaccinations, bone health, cancer screening and medication monitoring. Regarding the vaccinations these need to be checked before immunosuppressant medications are started such as immunomodulators or biologics and periodically during the course of treatment. Regarding cancer screening there are some specific cancers such as cervical cancer or melanoma which IBD patients are more vulnerable to and require careful attention. Regarding bone health, steroid use as well as protracted inflammation can decrease bone density and require careful observation for bone density. And regarding all the medications that we recommend IBD patients each one of these categories of medications has its own criteria for blood monitoring both in terms of efficacy of the drug and in terms of potential toxicity to the patient's body. Does this disease impact fertility? This is a question a lot of my patients ask me. It is a question that both my male and female patients ask me. I will address the female aspect of that question first. When there is ongoing inflammation in the pelvis this prevents adequate fertilization of the egg. So frequently my female patients who have inflammatory bowel disease have a difficult time getting pregnant. Once pregnancy is achieved whether naturally or through in vitro fertilization another concern that I have for my IBD patients is their ability to carry the pregnancy to term. I would like to specifically underline here that control of the inflammatory bowel disease it is the most important factor to consider in the health of the pregnancy. And because a lot of people are concerned about the medication side effects to emphasize that whatever medication was able to control your symptoms sufficiently to allow you to get pregnant is the correct medication for you to stay on during pregnancy with very few exceptions. Most of the IBD medications are safe during pregnancy. Regarding male fertility apart from the consistent inflammation and the fatigue that the disease causes there are very few medications that are contraindicated during the conception period. And a conversation with your gastroenterologist is necessary for those specific concerns. Is it necessary for me to change my diet if I have IBD? I get this question almost as soon as I tell a patient that they have inflammatory bowel disease. What can I do in terms of what I eat to control these symptoms? And it makes conceptual sense that you notice an increase in your bowel movement frequency with specific kinds of food. Unfortunately there is no universal answer that I could provide to all my patients and there is no such thing as a specific IBD diet. Though there are many sources of information on the internet that would say otherwise IBD is so multifaceted that the right diet is as individual as each patient. The only restriction that I have in terms of diet is if you have stricturing disease from Crohn's most likely you will have a harder time tolerating fiber. So in that patient population which is a unique subset of my IBD patients I recommend that they peel their fruit and cook down their vegetables. There is still a good source of fiber in their diet in terms of digestible fiber such as for example oatmeal. So I don't recommend completely restricting fiber just controlling the amount of undigestible fiber ingested. And this is again specifically only for patients who have strictures because of their inflammation. People that just have inflammation of their colon or certain portions of their, the rest of their digestive tract do not necessarily respond well to this diet and there is no such thing as gluten free, lactose free, FODMAP that applies to all IBD patients. How concerned are you about lymphoma risk with somebody with IBD? This is a concern and actually a fear in a lot of my patients before they start immunomodulators or biologics. And I do my best in meeting with them and also in webinars that I provide for them to assure them that the risk of lymphoma is exceedingly small and significantly less of an impact on their daily life than the risk of the disease being untreated. The numbers we quote in terms of incidence of lymphoma in patients on treatment for IBD are in the order of five to at most nine out of ten thousand patients. The chance of having a recurrent flare after a flare has not been completely treated is approximately 25% a year. What makes Winthrop's IBD center different from other centers? Winthrop University Hospital strives to be the place where you would be comfortable discussing this chronic and often debilitating disease with a person who will be vested in your care. We provide the latest biologics, including some that are not on the market yet. As for example, we use telera for ulcerative colitis. We are part of several clinical trials that are designed to either bring new therapies to IBD patients or provide information better in terms of their disease course. We benefit from a close partnership with our infusion center where we can infuse both biologics as well as iron and potentially blood. We are also affiliated with Winthrop University Hospital, which has a state-of-the-art endoscopy suite. Among other techniques we perform there is chromoendoscopy, which is a novel technique for detecting colon cancer in IBD patients in terms of surveillance protocol. We also benefit from a close partnership with our colorectal surgery colleagues. When a surgery is necessary, we work together to coordinate the care and assure the best outcome possible for that procedure. We're also interested in your disease course after a surgery, so we continue to keep in touch and make sure you keep your appointments, do your routine health maintenance, and address all your other concerns with this chronic illness. Where can I get more information about IBD? If you'd like any additional information or if you'd like to schedule an appointment with us at Winthrop Gastroenterology, please call us at 866 Winthrop or find us online at winthrop.org. Thank you.