And so everything is just going to be there.  And as I said, it's free. How many of you have registered on that group, please? Not for you to try, please. Not for you to try, please. Not for you to try, please. Not me to try, not for you to try. PowerGames is pviusernook.com slash link of C. Yeah. Pvi. Let me see. I think I had a page that had a slide right here. Yeah. This was the website. So just a reminder for those that can't believe it. PowerPi, of course, is Microsoft forgot. So they sent out user groups all over the world in various cities wanting to do this thing. So many cities around the world right now, this is happening. Many cities around the world. And everybody learning from each other. Right? And the whole idea is we build a community around this tool. And then we'll be able to share our ideas and all that kind of stuff for free for ourselves and for the group. And so for my career, it's pviusernook.com slash link of C. When registering this, when it started, when I was writing it out, like, okay, yes, probably it's nice. I'm an Excel guy. I come from the Excel side. There's some people that come from the analytics side. Some people that come from the database side, SQL side. The funny thing is everybody's coming from different sides and RBI is like the hub. So they're all coming from different sides. And we're all using the same technology, or at least the new technology is going to be the same. And then we're now coming to this Power BI for the visualization. The most important thing is no matter how wonderfully technical or excellent you are, if you cannot tell a story, that's the most important thing. You need to learn how to tell stories. So yes, we do the data. We make all things look nice.  You can't get that promotion. You can't really move on. You need to learn storytelling. Who is the first person that came today? Who is the very first person? Okay, guys, that's enough for me. So thank you very much. Thank you very much.   Okay, who knows Uche? You should have talked to each other. Who knows Uche? Okay, I introduce Uche. So introduce Uche. You met him today, right? Yes. So small introduction. Okay, everyone, I'm very glad to introduce you. That is like 419. Okay, well, you try. So I give you Uche. The thing is, when it comes to data, you really need to learn visualization. How do I visualize it in a way that when people say they're like, ah, insights are coming in across your presentation to show you the correct visuals. And to do that, you need to understand numbers. You need to show the numbers to wherever it is you're presenting. Now, one of the best people in the world, for me, with my research, when I was trying to learn this stuff, one of the best people in the world is Stephen Fewe. He is not S-T-E-P-H-E-N-F-N-W. He is an excellent guy when it comes to visualization for business. It's not an IT guy, it's just he knows how to visualize data for business. And when it comes to visualizing data for business, it's the same worldwide. We have actual data. We want to compare it to something like vortex or compare it to something like same period last year or same period last month. And then we want to know whether or not are we in the hoop zone? Are we almost meeting targets? And then also you want to see projections to a certain time. No matter what business it is, it's the same thing. So is it sales data? Is it technical data? Is it the uptime for the Vita base or whatever it is? So we're going to give a book from Stephen Fewe. Show me the numbers. It's a very fancy book. It's very happy. Yes. Thank you. You told me that. Thank you. It's really interesting. It's a really good book. Show me the numbers. Do we explain a little bit of statistics, not the top one in school, but very time statistics and how do you show the numbers? How does it make sense? Right? So please join our group. Let me ask one of two more questions and then I'll jump into my brief demo. One more. Who wants us to finish on time? Well, I think we asked this question. What was the question? Just analyzing. This was the Office 365. So we're mostly 2016 and 365. So we have advanced people here. Oh, somebody has passed. Perfect. Perfect. So we helped with our demo, the small demo I have. We asked this question. We have some people that are average that can vote my own. Okay? Now we have some experts in the house. Come to me for advice. Please, you need to be a volunteer in camp. Yeah? Because I'm going to have a small meeting. I told you. Just 20-minute meeting as an official Power BI user group. But some are unofficial. I haven't joined. But yeah, official. Yeah? So, next question. People are already answering this one. Can you quickly answer this? What word comes to mind when you think of Excel? Just thinking of Excel. What word comes to mind? Just type the word. What comes to mind? Be influenced by the words that are there. Just type them. Okay, so as the words are coming to mind, please work with the volunteers for the last presentation. Can I just stand up, please? The volunteers. Do you want that? Volunteer in your addresses. Can I stand up? Yes. And if you look back, she has a price for you. Okay. So have some nice shots from Microsoft. Thank you very much. Can I give them a hand, please? So these are the words that come to mind. What word is it? That's my name, please. Oh, that's interesting. So data analysis, magic. Interesting. So no horror. Okay, I think that's something worth it. So I'm going to ask these questions. What are things that are terrible? Horror. Stress. Yeah, it's difficult. Difficult. Yeah, it's difficult. Yeah, it's difficult. Yeah, it's difficult. Yeah, it's difficult. Yeah, it's difficult. Yeah, it's difficult. Yeah, it's difficult. Yes, it's difficult. Yes, it's difficult. Donating. Yes, it's difficult. Computation. Fantasy. Fantasy, okay. Difficult. Fantasy football. Sell. Yes. So what is Invoice? Invoice. What do you mean that's what they use for Invoice? I like that. I like it. I like that. So that's cool. So I'll be asking you more questions. Let me just pop on the comments. So this is, this is the, I don't know how many people use Power BI, okay, let me find out, sorry, that's our next question, let me find out. Okay, first of all, rate your Power BI, what's your experience with Power BI? Let me just know that. Interesting, very interesting. So I have never used it. It's good to have feedback, it's so important. You can imagine you go to a place, you're talking to a thousand people, and you also do an advanced, this something, raw context and context transition. And you think you're so tight, you don't have to have presentation, everybody's looking at you like this. And then the rate is gone, you just give the whole rubbish with no sense. That's what happens. So it's very good to get feedback, very important to get feedback. And guess what, this is to guess what's happening, data is flowing and entering this thing and see, right? And guess how much it costs? Zero, although it costs me a lot of money after. It costs zero, but if you have up to 20 audience, I think it's free. Well, let me give you a website that is zero regardless of the size of the audience. Because this is very useful. See, it's called, what's it called? Socrative, yes, socrative, S-O-C, I can't spell. Socrative, see, S-O-C-R-A-T-I-V-E dot com.    This one is all everywhere, all everywhere, that's this one. All everywhere, it has a little bit more functionality that's socrative. It connects to your PowerPoint and it's very clean. So is that why you went to the live world cloud as well? Yes, so I think Socrative has it now, I'm not sure. The live world cloud is really cool. It's a very cool way to engage your audience. I was telling you, I said everything is about presentation. Me learning, yes, I like Excel, I like Power BI, but frankly speaking, if you are very determined, you can learn it yourself, sitting at home. I tell people this every presentation I make. I say, what stops you from learning a new skill? That's how I just answer, what stops you from learning a new skill? Okay, well that's fine for me. Where to start? That's a good one, where to start is the interest. Okay, interest, that means it's a skill that your boss has said you've quite learned it. I've been thinking about a skill you really already have an interest, so yes, but if your boss says you've got learned it, please go and learn it. Time, information overload. Information overload, where to start? Very true. That one, I don't have that. Estimation. Yes, anybody else? Resources. Okay, maybe he's saying too much resources, you are saying resources. It's too much resources. Yeah, the tool to use. So there's so much information, there's so much noise, everybody has scattered everything. So all that data, you need someone to help you filter it. Because it's too much data. So how you get someone to filter is you want to look for influencers. You want to look for who are the top people. So I give you an example, when us, our team on the back and elsewhere, trying to create a course, we are so stinkless for data, we go to the whole world. Who is the expert in financial modeling? I believe to UK, and had a discussion with them and all the discussions came back, did research, research, research, research. Unfortunately, it used my approach in a format. So we did all that research and everything. They would now develop one crazy course and then the course broke it down and the day we created the course, about two years. Probably cost us, actually can play the time, probably to $10 million to develop a financial modeling course. Because we needed to look for, and this was before the age of the real real internet, so look for who are the influencers, they go to the US, UK, who are the best in the UK, London, and eventually you have a very good course. But then when you do that, you need to market it. How many of you know or like sales and marketing? Sales and marketing, you like sales and marketing. How are you fortunate for the rest of you? Everybody must like sales and marketing. You need to market yourself. If you know how to market yourself, you can market anything. Because at the end of the day, yes, you learn how to market yourself. Sorry, you really need to learn that. It's a soft skill that is so, so important, very important. And one big problem for people learning new skills is usually time. So what I tell people is this.   You walk for eight hours. You sleep or rest for eight hours. What do I do in the last eight hours? Say traffic. Traffic is one of your best friends when it comes to developing yourself. Right? No, even if you're driving. Driving or not driving, entering a bus. When I started my career in Anderson, I mean I was in the bus. Sometimes you go in the bus from Ajarra, not Ajarra, where was I then? To Milan, then I went to Ajarra. Anyway, enter. What happens? This is what just happened. I tied a collar in itself. It has brought me a unique list of states. See? Is Lagos sitting here? Okay, let's go and tie. Why is Lagos sitting here? Let's just tie Lagos here. So Lagos is inside our data. I know there's no lookout on my collar, but it's fine. Let's go there. So let's come to where we control. Any Lagos? Right. It has expanded everything fine. Perfect. Now this data, won't it be nice to sort it alphabetically? How do you do that in Excel? You go to data, right? And sort. Excellent. Opportunity, opportunity. There's another function. Let me just come to the beginning of the meeting. The new function called sort. Open my bracket. And then I go to the end of the formula and I just close my bracket. And I enter. Wow. This is big. Sorting by reverse. Sorting by reverse. I just go to the function f. And the sort has various options. So I do comma. Then it says what? Sort index. They say sort order. And the option is ascending or descending. Is it descending or descending? Or something that says enter. Yeah. Right? Wow. It's crazy. It's crazy. Crazy.  Now you look at it. The first form, like you look at the formula bar, is clear. In the formula bar it's clear. The rest are kind of grayed out. Right? If I delete this, it will, I don't agree. Not going to. Well, I feel very stubborn. I type inside here. I enter. There's a new error function. Error message is going to come up. Spill. Okay? So what spill means in this new Excel is, I'm trying to spill information. Why are you stopping me? Yeah? So it will, I've removed those error messages. I don't like them. So if I keep the error message, tell you where the obstruction is. Please remove this guy. Yeah? So I'll just, I'll be able to remove the guy. Delete. It spills back. Right? So this is the new Excel. There's just two functions I've shown you. I'll show you some more. Now, if I look at this list, look at this. I'm coming to mapping now. I need a unique list of states. I could do the same thing here. So what do you need? Well, my stress. I've done it somewhere else. It's like equals two. I go to that somewhere else, which is in control. Yeah? Do you normally do an array from where you have to write? Yes. In this case, you don't, right? I don't. No, any array. Yes, any array you now type. It just spills. So even I can't even do the old one. I mean, it's arrays. Although there's something called single and active. I don't do that. Anyway, so here, I select, you know, is this cell that started doing that spilling thing? Yeah. I click on it. When I click on it, look at the formula variable. Like, control. This is something, like, E6. I enter while nothing really happens. But look at what happens when I modify this formula a bit. If I want to refer to something that has a spill or something, I put this new thing, hash. I put hash at the end. Then it spills. Now, it can't spill. See, it wasn't stopping it at the bottom. Map. Map. Map. Please, can you move? Let me take it from here. Take it down there. Then I delete this one. Delete. It spills. Yeah? I see that. I'm looking at this. It's not Excel. What happened to my word Excel? So that is how it is. That's Excel. So this is the new formula. There's also software. I don't need that one. Actually, unique. There's some, too, couple of other ones. I don't know how to see it. There's one in very particular I'll show you. I don't want to go over time. But let me show you some other things in the new Excel engine. So if this is a new thing, right? So I want to use something else. So I can't use this new thing without something else. I'm just going to copy a special values. Yeah? And then enter. So now, the next thing I want to do is I need all these things to give me information. Now, this information is going to give me is live. It goes to the internet, pulls information from the internet, and dumps it live. And how you do that is you convert to a new data type called geography. So if you see information that looks like geography on that data, there's a new data type. This is available in Office 365 already. We still have all those things are not available in Office 365. They're still fixing some bugs, some small, small bugs. I think they said it's going to be released like next month. So if you have Office 365, those unique and software stuff are going to be the next month. Right? You want to fix some things first. But they give us the so-called experimenters. The inside experimenters. Yeah. But it can be on the inside. I'll show you how. So if I click geography. So geography now goes and checks everything we can get. Does it recognize it online? Is there anything about it that recognizes? And I'm going to recognize everything there. Yes. And then it changes to state and stuff. So this is now a new data type called geography data type. So if I click on Yobi, for example, and I say, hey, Yobi, you are the new data type. And this new data type is a rich data type called rich data types. Because I can click on this funny thing that comes up here. And say, you know what? I want to see what's the capital. I'm sitting here. No idea. What's the capital? What's the capital? No people. No people. No people. No people. Yes. So a good capital. See? I click on it. I go to the edge and I double click. So everybody else has his own. Right? I come here again. And I said, you know what? I don't know. What's the largest city in Ayurveda? I don't know. Never heard of it. I come to the edge. Double click. Yes. At least the Lagos. Why is Lagos? No, I have Lagos. Lagos. Lagos. Because Lagos, right? Lagos. Okay. Then I come here again. I say, okay, I need population. That population there. Yeah. Yeah. Yeah. All right. So I guess maybe it's right. I don't know what sensors Lagos is using, but this is the latest information of Ayurveda. It's actually from Bing. So it does go to Bing. And then there's a way that algorithm works. Who's data? You saw what Michael showed you. How it starts. It's the same kind of thing. But it's inbuilt now. Inbuilt. So who? Okay, let's see. Let's just see if this thing is smart. You know we just had elections, right? Yeah. Let's see. Let's see. I know you don't know any of the governors in other cities. You know Lingos too. So let's just check. Where is the leader? I think he has leaders. Leader. Okay. I don't know if this is true. Obviously the governor has every office. He keeps our vacations. So let's see. Let's see. Wow. Where's Lingos? Where's Lingos? He puts his picture everywhere. We know him now. But what do you guys want to know? These two. Yes? Yes. He puts his picture everywhere. We know him now. Yes. But what do you guys want to know? These two. Yes. Is that correct? So see field. This is another new error type. Field means that I've gone online and we can't find the information. We in Nigeria have some type intent. Maybe we are. So because of this, we can use our old Excel tricks. We can say, you know, I don't like to see this kind of thing. So old Excel guys already know this. It's a simple formula that says if error. If error, right? If error. So I can say if error. If error. You can see how simple this thing is. It's not as complex as our old Excel. It's just like magic really. Then I come in. There's an error. What do I do? What's blank in Excel? Double. Double. I close my bracket. Enter. And then I go click. So this works nicely. Yeah. It's not bad. Pretty good. And with this information, for example, I can decide. I'm going to insert a map, which is another new thing they've added, which I think is very smart. They have this new map thing, which has been there for a while, actually. If you click on this map thing, it kind of creates a map of Nigeria. And it's supposed to, if my internet is good. And this is a good visual. I can now change the visual that you see. It's coming. It's coming. Internet. So let me go to the chart design. Let's change the page that I've been sitting with. So currently, I have a copy. What was that? I'm not just sitting. Let's just move the guy. Population is a key thing. I don't need the leaders. Let's move. Maybe it's a recap. Let's say this is, and it's population. Show me by the population. So let's see if this works. My internet is on. We'll see Nigeria. Nigeria doesn't want to show. So let's move to Nigeria. Nigeria shows. So that's examples. You can do other amendments and stuff. Plenty things you can do. But let me jump to something else. But this is cool, isn't it? Super. Super. So how do you insert the map? I just click anywhere. Anywhere in the data. But ideally, how she do it is this. Have your states, then have your values next to it. So you don't have a complexity of many things. And then just visualize. And even if this visual is not really correct, as far as I'm concerned, I wanted to visualize this on the figures. So population. Is it based on the figures? Let me see. I think it's based on... Yeah. So if I edit this, current values... Follow by numeric value. Follow by numeric value. Map, flap, flap. Okay. So it's supposed to be based on the values itself. By the way, let's move on to something else. Quick, quick, quick. I'll show you something else. Yeah. So now, this data. Let me just quickly show you a small demo of something interesting. The other quick tools. Okay. Are you okay? Should I go on? Sure. Yeah. Because we've really gone over time. So the array. This is your dynamic arrays. Okay. Okay. So one of the main guys that invented or that helped Microsoft to do this is a guy that used to be a financial modeler. Used to be a top financial modeler. He's working at Microsoft now. And I just love the fact that he used to do financial modeling and stuff. So he can tell them what the real people need that he's excel very well. So he's kind of spearheading this in Microsoft. When it comes up, I'll see it. I'll look at my internet world. Yeah. His name is... What's his name again? Yeah. Joe. Can't be dumb. Yeah. So this is him saying preview. I'll send you all these links on the... Sorry, all the links on the screen. So let's quickly do one interesting experiment here. Show how complex you can build stuff with this thing. Very, very quick. So I'm going to get my unique list of states. Give me the best fastest way to do that. Unique list of states. Not to do the same problem again. Okay. Let's say sort. Sort what? Sort. Unique. Unique. Very unique. Yes. Okay. Here, give me feedback. Unique. Then what do I do? I go to data. Now, I've converted this to a table. There's something called table. Inserts table. Always try. When you get your data, put something like that, convert it to a table. You do that by going to insert. Once you go to insert, you see table. So you've converted or you control team. That's the shortcut. No, no. Next up. The same. Don't help. I don't need help. Help is actually better than before. Very cool help. Not like before. Help us. Help us. Okay. I don't know if the formula looks right. Does it? Does it look right? Yeah. How many times should I build my bracket? Twice. Twice. Then I enter. It spills, right? Now, it's a new function that gives you random numbers. Anybody do Monte Carlo simulation? This is superb for Monte Carlo simulation. So, here I will say equals to. I want to give me random numbers using the new function called random rate. What is random rate? Yeah. What's the last one? Random. So, random rate. I need to read what it says it means. Rows. Rows? Rows. Rows. Rows. Rows. Okay. For random rate, the first one is what? Rows. Okay, so how many rows do I want this thing to show me? You know, most times when you write a formula, that means to give you plenty things. It's one cell you will not write it. Once you write it in one cell, it's still. So, I want to write the formula in one cell and I want it to spill precisely the same size as what I have to the left. Don't think so, right? So it doesn't feel more or less. So you know it already in Excel. It's count A, counter, right? I don't know if that's counter. I'm going to go down, is it? So that's counter. So counter. I'm going to counter an argument, not counter anything. Counter what? Counter, now somebody will do this in old Excel. I like it like this, but that is not good enough.  You forgot to do that hash. Remember the hash? Very hash. Yes. Really? Yes. So that hash is what gives you the skill. Then hash, and then what next? What's the next thing for rendering? Column. Column. How many columns do you want it to be? So if you say two columns, then it's going to fill it in two columns. Just one column. So it's one column, it's fine. Then minimum, what should I use for minimum? Let's use this thing at the top. I'll do my normal F4 to lock. F4, which is difficult for this thing, F4. Then comma, what? I don't actually need to lock. We're writing a formula in one cell, isn't it? So I don't need to lock anything.  Anyway, let's just return to minimum. So I go to max. Now integer means you want the answers to be an integer. But let's see what it gives without integer. Let's enter. So look at that. So it's giving me random numbers between 30 and what? 999. But this is not a whole integer. So I need to come here and change. Maybe I want integer, I want integer. So I do this. I say comma, right? And then the option is what? What option? True. True. So I go to true. I close my bracket and I enter. Now it's full numbers. Now one report that many people do is bins. The bin bins. Zero to this, this to that. This is that, this to that. So I want to create some bins. So the bins I want to do is this. I want to create 10 bins. I want to create 10 bins of data.  And then I want to now see the frequency of things that are coming in each bin. Now, if I come to this bin thing, I can say equals to. And I want to create 10 bins. So I'm going to use a new function called sequence. It's one of the new functions. How many have we mentioned so far? I don't see it like a completely six. You need some of them. You already know some by hash. Sorry? Random. Random. Random. Random. Random. And now sequence. But there's only one more option left. Yes, that's cool. What time do you? Part three. Part three. Sorry, sorry, sorry. We'll put it in later. Sequence. OK, so sequence. What are the options, please? Rows, columns, starts. Rows, columns, starts. 10. OK. That's 10. I think it's 10. So rows is what? Rows, how many rows do we need? 1. No, think about when creating bands. How many bands do we need? 10. 10. Go to the cell. OK. Right? 10. Yes? So how many columns? Zero to that. But actually, we just have one column. We'll do the other one separately. So let's say 1, comma, starts. It will start from zero, obviously. It's going to start from zero. Then comma, steps. 9 to 9. 9 to 9, yes. So if I come up here to 9 to 9, if you think about it, first I'm going to start at zero to something. Then next one is 100, 100. So now we'll be right. We have to add one to it, right? 99 plus 1. So I close my bracket, and I enter, and it gives me a list. Can I see that? Right, pretty cool. So I come to the next thing I say equals to, and I do another sequence. Sequence of what? Sequence of how many rows, same cell, right? And then comma, and how many columns? 1. Comma, how many, what does it start? So this one is zero to 99. So it's going to start by this, I think. Right? Then comma, steps. 9 to 9. Yes, yes, 9 to 9. So the next one will be 1, 9 to 9. The next one will be 1, 9 to 9. So 100, perfect. See some mathematicians here. Nice. So 99 plus 1, close bracket, enter. This sign means I'm up. All right, it looks fine. I think, yeah? Perfect. So now, come here and say, OK, no, we want the bins to be only five. Five, it's, this is, perfect. So it's now the bins to be 20, yeah, again. It's so simple, it's like crazy. So anyway, we come here, we're going to do a small complex formula. What I want to do is this. I want to find out these names of the states. I want you to show me the names of the states between zero and 99. So to show something like this, Lagos, maybe comma, Abujara comma, or your comma, like that. Just list out those that fall into those brackets. This is savvy, a bit more complicated. So in Excel, you know what to do. You say if, for example, yeah, if a logical test, OK. So the logical test is, normally, you say if this cell is greater than that cell, it's a test. So instead of that, I'm going to come to this cell and I'm going to say that you're hashting. Now, you've already broken rules of Excel completely. This thing said logical test, not tests, not plural, test. So test means one cell. What you have given it is spill, which means I'm testing plenty things. In bold Excel, it will never work to give you one error. And you need to know that you need to highlight the range and do one more. The formula for what we're about to do is like this. Now, let's see. So anyway, this hashting, we are checking in to see if it is greater than, I think, greater than what? Yeah, so we need to look at the number of people to maybe this cell. Right? OK, that's true. It's greater than equal to the whole thing, isn't it? No, no, no, you do. No, it's only one cell. It's only one cell. OK. It's one cell. So let's just, for, we need to lock this. Because this is old Excel we're using now. Old Excel. So I'll lock that. To mean lock this too, maybe since we're dragging it down, we should probably going to write this in the old Excel way. Yeah. So I'm using old Excel and new Excel. Sorry guys, we're almost done. I know this is so strange to you, but it's fine. F2, I'm going to lock F4, F4, F4, F4, F4. OK, so this is our first test. Well, we have two tests. In bold Excel, you say and. And. You don't have to bother your and to now work. And it's not going to work. There's something about the new cell and the and and some. I can't start explaining the technical reason why it won't work. So the way it will work is if you put a bracket around this first argument or logic and multiply it, yeah, then multiply it by the new logic. The next one, which will be the same cell, which I do. And therefore, the less than 4, and I put a hash to make it still, is it? Yes. So the same thing, but this time what? Less than 4 equal to what? This is 4, right? And 4. Yeah, I should just lock it now. I need to lock it. Yeah, I need to lock it. Then I close the bracket. So now, you're saying if all of you are less than or equal to this guy, and all of you are less than or equal to that guy, then the next thing after is then, right? Then give me all of these guys, right? What do I do to make it? You see, you guys are very hash, so very hash. Then I do them to make a G9, the frequency reference as well. Yeah, I don't need to. G, what we did is we locked the column. And when you lock the column, you're saying that any time I go right, don't change. So since I'm never going right, I'm going down, doesn't matter. Lock it or not lock it, it doesn't matter. So this is value if true. Value if false, I just want a blank. So there's going to be a problem now when I do it. I'm just going to just watch. There's going to be a small problem. Right, how should I explain the problem? Anybody can explain the problem? So what I've just done is I've said what is inside 0.99. If you check this list, what are the two states? Cross river, cross river, and cross river. So it has done the answer for 0.99, and it spilled it. Problem is I don't want it, I want it in a cell. So when you want a spill, a range in a cell, you need to use something called an aggregator. The aggregators we need know is sum. Sum is an aggregator. Average is an aggregator. Say average plenty things, one answer. So what we need to do is say, do you know what? We're going to use a new function, which I think is already in all this described. We're going to use text join. So we're going to use text join. So text join is a new function. So we're going to say, hey, text join. I want you to join. What's text join asking for? To give it a term. To give it a term, what do you separate in these things? I want you to text join. Let me say double quotes. I like this five thing. I don't know why I like it. It's five quotes. And then double quotes. Common. Now, this five, let me put a space before it, and a space after it, just make it nice. So the next thing you ask for is ignore empty. What does that mean? Yes, it should ignore, I think. Yes, ignore empty. And then, can you see the next thing? Text one. Well, it's not text one, I want this one, only togetherness. Well, hopefully it will work. So let's see. Is it only federal capital? Let's check. Let's increase the bin size to 250. So the bin sizes are bigger. Let's see that. Interesting, right? I come here, and I come here, place the edge, and I go click. Right. Do it. Yes. Would concatenate have gone too? No, no, that's it. Concatenate won't give you the little concatenate you can use. So concatenate is an old function. And let me show you something about those funny functions. Look at this. See concat, concatenate, right? Any function, guys, any function, you see a yellow mark. It means it's going to be paced out. Out. Yes. It means it's going to be paced out. And it means there's a new function that replaces the small power. So what replace concatenate is concat. Something called concat. So our texture is a little more powerful than this. So this is the end of my demo, guys. Excel has changed. And there are many things here. Go to the format. Only looking for that. Perfect. Excel has changed seriously. So look at it. Some hash signs and some funny things and all that. Who uses data validation here? If you use data validation, you can use hash too. So you go to data validation, list validation. This side of the format, let me just quickly show you that we want to use data validation in this new thing. You can't change all your old arrays. You don't need to put that into this. You want it to take a while for those that built plenty of arrays, right? So this is the end of the demo side, guys. It was a lot, it was hard. So we're just looking at the, so this is one year ahead. I'll show you one year ahead, right? The boy is amazing in each of these. It's amazing. Yes, but I know we have time off, but I left the last one. I haven't told you the last one. The last one, unfortunately, if you can't give me a second. I'm just going to type Lingos here, right? Well, no, Lingos doesn't have anything. You may state that you know of their plans in ABAC. ABIA, ABIA State. Let's say market, no, market. Line of business, I don't know what line of business it is. Trading, or that trading, spare parts. Spare parts, I like that, okay, parts. Okay, very right, very right. Parts, parts, parts. Where are we? Okay, all right. Okay, parts, right? Parts, parts, parts, parts. Let's see, I think the data is from where to where. First of April, 20, 15, 20, 20, perfect, perfect, perfect, perfect. So let's say one beta from 21st of April, 2014, so I don't know, 30th of June, 2014. Right, now, this is full. This is all you need to do. Now, we're going to create a table that mimics this, that just automatically gives us this, almost like if people take it with us. Yeah, in five to six months. The question I'm going to do is that when it goes to sign, I need the entire headings of this, sorry, the headings. Yes, okay, now I come here and I highlight this. I like, oh no, I want one, I want those headings. No, it looks like headings, not one, one, one. Okay, that would be good, after two months. Okay, time, one more minute. Okay, good, sales headers. That's, this is the table language, right? When I enter, it spills, remember spills. So if I type something here, it can't spill, I delete this one, it spills. So anytime in the new Excel, it type equals to highlight a ring, it spills. Don't give me an error to always spill, right? So now that this has spilled, what I want is, I want to give me exactly the data I need based on that criteria, right? There's a new, the most powerful of all the functions is filtered, so there's powerful of all the new functions is filtered. This guy is crazy, yes? And you know how crazy people, they don't like shouting. See how many arguments the guy has? How many is it, three? Two, two, two, two, two, three, I know. It's just crazy. So this one, I know the entire table is called sales, I'm just gonna say sales. I want you to go and filter sales, right? Common, and in this sales table that you are filtering, I want you to give me what? I want you to give me a market, right? So I also give me sales market, sales dot, no, in the square market that is used in this thing. This is table will, sales market, right? Sales market that is what? Sales market that is equal to what? Appearance. Appearance, right? Now let me just close this, right? And let's just enter. Madness, madness, absolutely madness.  Okay, no, it's not just this, right? It's what? Let me just do two, I don't know what I'll do two. As I told you, hand won't work, so the trick is to use a lot. Use and multiply, multiply is like the hand operator.  Now we're looking for parts, where's parts? Nine of business, and then close the square bracket. That is also what equal to this guy. Yeah, and I close my bracket. Close for field timing. Yeah, so I enter. Now, if you check the parts, it's only parts. Then this column is supposed to be dates, so I guess I like it, I maybe format it as a big contourship towards Windows, or contourship three to make it a date format. Yes, contourship three, it's actually control hash. It's hash variable. So anyway, so that's it. So I won't do the rest. The rest is simply dates. I want you to give me sales. Bates is greater than or equal to start date. Comma, sales, this is less than, and you just build your table by a table continuous to reduce. And obviously we know we only have one in Lagos, so if I type Lagos here, Lagos will probably not have data, so it's in half, it's the new error message. That says this thing does not exist, okay? It doesn't exist in your database, so please go and think of something else, okay? We did it one last time, sorry? Okay, so data. Let's pretend that Lagos has what? Parts. So I can change data to parts. Now, it says it has parts. Hopefully it will not give me an error, where are we? It should now give me that data, right? Excel has changed forever. Once this thing is released, it's crazy. So thank you very much everybody. Thank you. Thank you. Thank you. Thank you very much, please. Sorry, and questions? Just let me take two or three questions of them. Three questions. Second question. One of these. The one? One of these. One of these. One of these. No, no, I think I just mentioned. Ah. Second question. Second question. Go online, watch the video. It's one thing to come to events like this, and learn this kind of field. But I've noticed that when I haven't come to my place, deadline, yes, and I've also been to my place. Yes, I've been like this. I've been like this for like two, nine months, and I get it to you, and I see it to me. But you know, where can we volunteer to you? Yes, unlike in Excel and Excel, there's some problems we have. So, quick, excellent, thank you for the question. And it just takes me to the next thing I want to say. We need to form a, we need all to join this group. Because I really need to be more active in this. RBI is like, right? Because what I work on is we should do monthly, there's not talks like this, but monthly labs. So monthly labs, when you come with your computer, and then we agree in the group what the case study is going to be, maybe it's really your job, you know what, we'll review all the sensitive information. And then if you're going to work on this, I'm going to do part three in this lab. To come, somebody volunteers as an expert part three, comes and teaches part three. The next one, we're going to build a data model for RBI. We're going to get data from election data or something. So I ask election data, oh, let's talk, let's put election data and let's come and do a RBI model for another month. So if we're talking on the group a lot, we can do that. And I volunteer my time, and I'm sure some experts here will also volunteer their time. So that in the year, we have like 12 labs, right? And then we can have this as a quarterly talk, this quarterly talk, we bring in people to talk. Because let me tell you something. As much as possible, there are MPPs here. And if Microsoft can see people volunteering and talking, you put it in their data place, you become an MPP and there are lots of perks there. So as much as possible, let's build this group together and let's get some, let's have a target. Two MPPs by next year, three MPPs and like that. And we continue growing. The best thing is this knowledge is a very funny thing. It's the only thing that when you give away, you get more back. It's the only thing in the world. You give it out and you actually get more back. So don't hoard it. Don't hoard it. And networking is another thing. There's the next Bill Gates here. There's the next Microsoft here. And all you need to do is talk to the next person. Who has talked to the most people? Who can stand and say, I've talked, I can introduce five people or six people? What's the highest you can do? Just shout it out. Three, anyone more than three? Not your colleagues. Not your colleagues, not your colleagues. Any of them are higher than three? Three, four, four, it's not your colleagues. Four, six, I see you. Six, wow, okay. Who can beat six? Who can beat six? Can I introduce you? Okay, that means five, right? Well, it can't be six. Okay, sorry, I'm with you on the spot. I understand that. He added me. No, it doesn't go down. No, no, no. You said five, so we'll have some more competition. Winning the last prize, and then we're gonna close. So we're gonna continue the conversation online. Please join the group, please. Join the group, and what I've said, isn't that valuable for all of us? Please, just if you join the group, let's start the conversation. So can we stand up for the competition and you guys are winning the prize? The competition is simply this. Name the five people. Introduce the five people. All you need to do is introduce their name at least you've tried, their name at least. It's just one sentence. Who are the five people? Okay, sorry. Which team has left? Okay, which team, okay. Who is which team? What? Ten. Okay, okay, which team? Then who?  Which team are you? That's a qualifier, sorry. Five, five, five, five, five, five, five, five, five, Where are you guys from? Princess. Princess. What? The camera guy here, okay. Okay, how many people care about you? You don't agree with your name? It's fine. That's four. That's four. Four? Can't be. Can't be. Who's can't be? You can't be.   Then, then, that's not your name, okay. Okay, five. Okay, try, try. Let's wait for a second. Can you? Can you? What? He mentioned the one who becomes the princess. Yes, okay. I am a princess. Sorry, but can you? Okay, can you? I am a princess. I am a princess. Nice, so, George, George. What is your name? Princess. Princess. Princess. Chilly. Chilly.  I don't think I know all about him. I don't think that's what I'm talking about. Sorry, I thought you were going to say that.  He asked, like, did he grow up? No. No. Okay, so guess what? Both of them are getting it right. They're getting it both, too. They're getting that both. Wow. Yes, yes, yes, yes. Thank you, thank you, thank you, thank you. Please read it, it's very heavy. Thank you. Yes, yes, thank you very much. Thank you very much for coming. And we hope to agree online where we're meeting again. Yeah, because obviously I like the next session to be a Power BI session. To actually build a model. We can get interested later. We agree in the group. And then next month, if you can, next month, hopefully, next month we'll do a session. A 2012, a Angela. What we need is this. We need volunteers for space. So I want to say, okay, use our office and let's say we leave it to, like, 50 people or something like that because it's only in the group. Anybody that wants to come, I'll join the group. So, say, okay, volunteer space. Oh, I'm volunteering my time already. Volunteer my time. Someone says, okay, K3. And there are 50 people, 10, 15, 15. I volunteer 15, 15. I volunteer this, I volunteer that. That's how we now gradually grow and continue building knowledge and sharing knowledge. So we see online. Thank you very much, everybody. Thank you very much.


You know even if you're just staying in the local area where you are and You're taking that three-day or four-day holiday. You know, it's a whole different mindset when we go into the winter holidays Thanksgiving, Christmas, Kwanzaa, Hanukkah. I mean, you know, we're just loaded down with festivities and family and friends and food and travel and you know, sometimes we don't really Stop and think how are we getting there? How much is it gonna cost? You know, what is my frame of mind and my mentally, physically, emotionally, financially prepared for the holidays? And if you're driving particularly, you know, do I have snow tires where I'm going? Do I have, you know, a map laid out where gas stations are or hotels as you mentioned? And there's a great program that the military has that can help you plan And so I kind of want to talk about in this first segment about trips So let's talk about trips. For all military, I believe it's on, you know, your your army knowledge online, your Navy knowledge online, your Air Force knowledge online For us in the Navy at www.incao.navy.mail with your cat card. When you log in Somewhere there on the front page, it may even be in the center right now or on the left You'll see the big trips and travel planning And trips is a program about going on a trip and it's got a great checklist for you as an individual For you as a supervisor to sit down with your sailors and start talking about, you know, how do I go on my Travel? What is the trip report say? What does the trip form remind me of? And I think one of the best, you know, parts of trip That I use and I still use today Is the checklist for driving, you know, when you open up the form and it's got that checklist for your car You know, your tires, your air pressure, your oil, your gas, your windshield wipers. Boy, if your tires aren't fit for the type of travel, whether it's off-road or snow or rain High desert. Many people just like you are trying to get home for the holidays And so being very, very vigilant on the road is never more critical than it is during the holiday season So use your trips report. It's great. It can give you an idea of the distance you should travel and When you should get a hotel. So I urge everybody just go to NKO supervisors Go to NKO, print out the trips checklist Go over it with your sailors at quarters and just talk about it Even if you don't do the individual planning Just talk about the existence of the trips report being there and get your sailors up online to look at it because It really can have just one moment, just one moment in that trips report that can save your sailors life on the road Don't wait for things to happen to you. Make them happen for you


Oh, yeah Yeah, we on boss talk one-on-one.  We'll be lately. It's a unique hustle. Check it. Check it. Check this you because it's your boy You see all the love Lee amazing outstanding official. Mr. Make up. What's going on? No, no, no, no, my dad will go on man. Hey man, hold up man You know we come all the way down here to New Orleans and we run into a jewel somebody from out of Port Arthur, Texas Man, I mean one of those chosen ones man. She from the land of P.m. See man. See hey, man This dude right here, you know anything to say it's Port Arthur. Oh, they in their own boss talk She said she said you know what I'm from Port Arthur. I said you got to come on Check it man Tiffany Hamilton's in the building community activists. Absolutely man. Thank you for coming on the show Thank y'all for having me man So man, you know, we bring people on here man You know outstanding people people of the community people that has left legacies and legendary things that has happened around him Man, you know, so we thought it right to bring Tiffany Hamilton on boss talk 101 where the boss is tall Man, so thank you for coming on this show man And we like our audience to get to know you a little bit more So tell us what it was like growing up in Port Arthur Have your family ever ran into Pemce's family are they attached to them? I mean tell me it ends in out the whole background. Go ahead Growing up in Port Arthur the first thing I think about is family. Mm-hmm. That's what my community is built around, right? And my family is serious about how we love on each other and how we love throughout the community Mm-hmm. I personally don't have a connection with Pemce. Oh, but as this morning We were having breakfast breakfast. My dad was telling you guys about who he was raised with and so he's very familiar with his mother Mm-hmm. And just last week we had the 10th year anniversary of UGK Day in Port Arthur So that was an amazing amazing experience. I love to have you guys come out next year for that I heard about it. You said a word earlier that meant a lot legacy and that's what we want to leave Man, you know that's every year they have this and this is the 10th year. This is the 10th year honoring UGK Day This is the first year that I'm aware of that there was a huge event surrounding it. Correct. I heard about it I had heard about it through Bobo talked about it. It was a couple of guys from up there that One that y'all spoke of you going you went to school. What was his name the guy that I told you I talked to a few weeks ago Lionel's friend. What's his name? Oh, Lonnie's friend is we call him P. Shoe that guy He called him P. Shoe. He called me and a matter of fact, we talked about that a little bit No, so at the end of the day I was just excited that somebody's doing something because I'll ask you now, you know Because you've heard the UGK movement new the UGK sound What was it for you that stuck out about PMC when you heard his music? Well, I was in high school or maybe leaving junior high headed into high school when that was hot And it was something that we had that was specifically for us when they spoke about Gulfway Drive That's something I can relate to riding down the Gulfway Drive when you talk about Troy's the place where we will go and get Burgers fresh fish. So it's all things that we can relate to it makes it personal for us Well, we want to listen to it more and more and more.   That was a big deal You know what I'm saying and just to see some guys that would mention Texas because there was a street there I've never been there, but I know Texas Street. It's there short Texas You know when you see that and hear that I've never been there But it I've tell people all the time to me It felt like he was representing the whole Texas the whole time Because of the way that he would speak on it and then being from a small town and I'm from a small town I just loved it and then it had songs like now. Not it got me running from the feds and and I was hustling during that Time so I definitely could relate to everything they were saying so it made it was organic for me and my you know Me growing up as a kid. So thank you guys in Port Arthur, Texas Bumby and Pimp C for those songs and the UGK movement the botany boys all them people man so that's why I feel that it's very important that when You grow up in a certain city and you become a celebrity or a person that has a voice that you really rep Where you're from not only where you now reside because a lot of people do rep where they now reside as their hometown But also rep where you're from because it makes the people there feel good even if you don't go back and Donate to the community or do anything for the city You are actually verbally doing things for the city by bringing awareness to that city when people would have not known Port Arthur before but now when they think of Pimp C they think about Port Arthur they know that name So as much as some of these celebrities might not go back and Contribute build this center do this Their contribution is bringing awareness to their city. That's right.  So I would say you're doing a lot of boss stuff So, um, tell me was that something you've always wanted to do growing up and why? Um, I was a child in elementary school being an advocate for oh my goodness When we had a red yellow and green light of who could talk during lunchtime? Why and when and so I would write letters to our principal and say I don't think that's fair As a kid time to have a break Wow And If I would get in trouble at school It's most of the time for my mouth because I wanted to speak up. I was put out of Science class in junior high school once because I told the science teacher I wasn't created From a sail along the beach. God created us.  That's right, but um So tell me the movements you started making Where you you you made the change In your community as a kid maybe because I know you spoke up, but did you Actually make a difference when you were a kid or it's just now as you're an adult And you're able to do more that you're now making a change When did the changes actually because People get frustrated because they write letters They speak up, but nothing ever changes So it discourages a lot of people like, you know, I'm not going to do this anymore I don't see where I'm making a difference. So how long were you doing this before you actually started seeing changes occurring? Even in elementary school, I would see changes occur And so then there was certain time frames in certain days that we wouldn't have the Green yellow and red light. So that was because of your letter because of our letter But it wasn't just me. It was also other students who said, yeah, I'm standing with her So it's the the rallying learning how to rally people and not necessarily follow you, but follow the cause So whether I follow the face of the earth tomorrow or not, this is still a cause that they can Carry on that's right But we also have to learn that the initial Reason that you may have stood up even though you may not have won that small battle You're still winning the war because you've empowered other people along the way And so for those who may not have had a voice if you're teaching them how to speak up for themselves Then you're still making the impact But I've seen a lot of people is sometimes it can be discouraging And it's such a big wide world and then some people are like, okay How can I make a difference just speaking up here? Do I do I have to go there's so much red tape depends on what topics you want to tackle What issues, you know, you might have to write a governor.  I mean and I know some people just Get tired especially when you you trying to fight for injustice. I know that's a harder topic to fight for Simple stuff as in like changes in your community getting this done this moved here That's easier But a lot of people tend to want to fight for injustice especially injustice for people of color And that right there to me is taking longer To to change So it definitely has but we have to remember our why So even when you may not become successful at that first That first battle Again, you have to remember your why to understand what you're fighting for to win the war So the injustices one of the things that's very passionate to that I'm very passionate about is voting rights And that specifically affects communities of color Not only communities of color, but those poor communities Classism comes into play with that as well. And then also human trafficking. I see that's a big thing now often And my community do you see it a lot in port author? Yes. Really? Yes It is a corridor. We can build it ship it rail it in port Arthur And that's my plug again always speaking up for pa we can build it ship it rail it and Whether those are oil and gas companies that recognize that or the coyotes that recognize that They come So these are not the only We have a lot of different things around social justice that will affect not only my community but communities around the world But when it comes to going back to black and brown communities We have to make sure that we are working as a unit We need enough of the same people speaking up at the same time fighting for the same thing But I think a lot of people doing doing what's real doing great work But if we're not cohesive and working in sync with each other, then we're gonna continue to be defeated But I think a lot of it stems from lack of Education, absolutely a lot of people don't know What their rights are they don't know people I'm not I'm not gonna say it's just us people in a whole When always feel like you coming to me and trying to educate me Sorry on something What are you getting out of it? That's right.  Ain't none free in this world What you up so it's like a trust issue That we have even to someone who looks like us You know what I mean? I've always heard I've always heard some people that we are easier to trust people of other race than we are To trust somebody of our own. Yes. Why is that so even the bible speaks about that? That a man has to leave their own Leave home in order to be reverenced right or to be heard And what they're fighting for to be accepted But um, I think the most important thing is when you continuously shut down or people thinking that you're wanting Wanting to know what you're going to get out of it. You got to keep showing up And over time then they'll start to believe you They'll say she shows up or he shows up regardless of the fact and then they'll start to humble themselves 55,000 uh is what I'm seeing a population to be within I guess uh 2021 but uh, it's small community. Um It's got a uh, what what what it's got. What's what's the main attraction and port author that I I can come to when I come there. That's they're known for Oil and gas Oh, I think that's that money. That's the money team. Yes. We can't come for that. That's that's usually for like investments Yeah, so we don't want to so what can we what can we come to see? Yeah? Yeah, like like downtown Uh, we're gonna stop by such as y'all ain't got none. What y'all ain't got what no that We don't see there is there is no main attraction of entertainment in the city. Is there a restaurant? That y'all know there's a cook. Okay. I can tell you my favorite. Yes. That's what I'm talking about I absolutely love tequila's on gulfway drive Shout out. I will go there three times a week shout out all of my chips and saw tequila And the owner louise makes it himself. That's always tequila's on gulfway drive So I want to spend my money at home as much as I can because I want places like tequila's to continue to grow But then we have the restaurants bj's we have several different pop-up Trucks all trucks now. I just uh, have you seen trill burgers pop a food truck there? I have not yet, but I heard about it and arena. I asked you that's because I told shout out to bobo I said bobo. Why is bum be not putting? Something you could do a drive-through or anything with trill burgers in in port arthur and that will go crazy because this is hometown Lani and I were talking the other day about trill burgers and the first thing I asked was So I'm I'm pescatarian. Yeah, do they have veggie burgers? Yeah, do they have seafood a seafood burger and We don't know but I'm willing to try yeah, so trill burgers if you don't can't you please Come through yeah, right? You gotta come through boy. Don't have to drop that thing Yes, I just know that that that's legacy. That's legend. You know that trill word come from that that place, you know and uh When you think of trill burger you you think of uh Just a good burger. I've seen the burger. It's definitely oily. It's it's someone like I would eat I'm not a bit. What'd you call a vegetarian? I'm not that's not me. No, and uh pescatarian Pescatarian seafood.  For real? That's how you came up down here in Louisiana No Golf oh, it's oh, it's right there too Yeah, it's right there. I think that but don't get me wrong my people's family Yeah, I'm apollosis man. So and so every it's funny how pimpsies ties, uh, Louisiana ties, you know Um, um being born in Louisiana and then moving to port arthur, but then letting people know how many port arthur You know because I think he was very up and when he moved to port arthur, wasn't he? That's what I've been told. Yeah. Yeah. Yeah, but so let me ask you this You went to the college. Did she go through what college you went through already? No, sir I would like to ask you like like Getting out of school in port arthur making a choice to come to college here in this area down in la Louisiana I ain't gonna say that but I like to say something but anyway shout out lose them But anyway just uh, how was it and what school did you attend and and what did you major in and what was your aspiration and dreams? So I attended Xavier University of Louisiana here in new orleans, and I Started school august 1998 man It was a it was a big deal. So my whole family dropped me off at school My whole family helped me decorate my dorm room. It was a family affair And so while I was here my my younger brother and my younger sister would come here to visit me all the time And I just fell in love with the city new orleans is one of my favorite places. That's hard That's hard and the reason I said it's hard is because You know, um, I love Louisiana like that So I was I'm really born six miles, you know, what raised six miles away from Louisiana state line So me I just always connected texas and losing yellow together because it connects in any way Yes, so we have this special place called pleasure island in port arthur.  It is so years ago. There used to be like Are you guys familiar with galveston texas? Yes, of course. And so there's the the boardwalk So port arthur texas had that on pleasure island So the goal is to recreate that again. Wow. So growing up you would have Picnics out there parties out there every year Sean johnson a shout out to shaka shon he And others would create an opportunity for classes from high school Graduating classes from the different high schools in port arthur to come out and have a day So we literally would have thousands of people on pleasure island just for family friendly fun And right across the bridge Cameron louisiana So growing up we would always want to race race with our older cousins to go across the pier on sundays And if they did not take us with us, then we would tell that you were going across that bridge to buy beer. Wow Man, you know when you was talking I just kept thinking about I'm about to hit Gulfway just past choice Man it's something about just the music is when you get older. I don't know I'm older than you But the music comes back to your mind all the time like you can be doing something and not even worried or I don't know the mind is so powerful Because you can be doing something and I know I'm like why would I even think about that song? And it just pops up and I just think that about my sense of smell will make you think about well, you know, covid mess of people's male love No, I'm just gonna be real with you girl. I had I had I had caused something I never because I'm a I'm a god-fearing man So I greatest heat is in me than he is in the world I'm walking around the house quoting scriptures trying to fight off whatever this is they trying to put on me No, man I don't want nobody in the house to be alone man And I walked with my chest out in my head and I would go shopping I had my mask on but I was like man one day I'm my wife was cooking some beans And you know how they smell when they burn I don't know burn like yes when the water just run too low and I was just sitting there on my computer I never smelled it And when she came out of the room from sleeping she said you don't smell that I don't know I'm just telling you this was probably by the year and a half a year or something when it was real I never got covid in my mind and in my heart He never accepted it. I don't know what that was, but I just know I never I didn't smell it This was and I wasn't sick. This this was after all after the going through the phases So that was a crazy part. So I mean Smelling is something you take for granted But Covid made you understand that a lot of things we were taking for granted. Yes, right? What was the biggest impact when you had to? Go home Isolate yourself and look at whatever your issues was he had on What was what was some of the things that happened during that? Were you married at that time when covid was going on? No, okay This was um So I divorced in 2011. Okay, so that was the while back But during covid I didn't stop Okay, because I actually worked for a nonprofit organization worked from home and my responsibility was to house homeless people And they were also affected by covid So we created This organization allowed me to create an opportunity for myself and for my family To make sure we fought for those who couldn't fight for themselves.  So When my grandmother was passing away. She wanted to come home. Okay, so my mom and her where was she said come home? What city she Imported our important author, but she was in the nurse. Okay, and she did not want to was from covid No, she had other health issues However, we believe that Covid was one of the health issues that she did get and we think from loving on her it may have spread To us And about at that time about um 20 of my family members We have a large family about 20 of my family members got covid and but nobody passed away from it Nobody passed away specifically from covid. That was a true blessing But my mom and dad they They owe each other's right to die. And so they got covid at the same time. And so they were in the house And they were sick and it was it was scary We brought our lawn chairs to sit at the door to see them through The door to go and check on them and leave groceries, you know at the door for them But it wasn't um, it was nothing to play with We did not know what the heck that was we had never seen anything like that in my lifetime So it was like for me like man, what is what is going on? I wouldn't let them go out I was taking my clothes off gig going into house taking a shower three four times Anytime I went I made contact. I just didn't really know what it was and I really didn't want to jeopardize the family her mother Does live with us and basically, you know being an older lady Uh, you trying to figure out ways not to let them but then lo and behold, it's still crept up in the house Some kind of way and uh showed its ugly face Eventually, but that what that happened like Way after way after once, you know once you start putting your guard down because you you know, it's not as bad That's when that happened about a year into it maybe a year after so everybody was kind of comfortable with covid So my sister and the kids are the only ones in our family who did not Even up to today even up to today and she's a nurse. What does she do?  For you far as where you want to see things out in your life far as what what do you want to what do you want to accomplish? Where the city no Tiffany Just overall I want to fight every day to be the woman that god has created me to be What is that person and so that person is an advocate for a community that person is a life a mother a good sister a good auntie a good daughter And professionally I would love the opportunity to get to the senate. I don't know why I just felt that I feel because the way how you speak your passion I feel that's where you're gonna be What was that guy named we interviewed in chicago nero nero. He was he's going for president, right? Yeah, he's running 2024 Yeah, nero shout out nero. See you said you didn't think I I told you got to prove yourself to me, baby We're fighting we're fighting hard and it's gonna take every single community Whether it's small or large to make sure that we have the right representation and the right leadership for our country Right. Yeah. Yeah, I agree. I do that right now as a precinct chair for within my county in jefferson county And it is a grassroots movement. I don't care what anybody says the numbers matter But we can have we have 250 000 approximately residents in jefferson county about 140 000 of them are registered to vote It makes me cringe Because a lot of people come out to vote because a lot of people honestly as I was getting older because I was always raised Where my daddy saw was like you're gonna vote. That's right, but um As I got older and I hear all the people especially all the people of color They'll be like Why it's not going to make a difference. Like why should I waste my time?  That's an advertisement. I hear that name that whatever advertisement come on The most that's right. That's the name that's sticking their head. I'm like, oh, I'm gonna go vote for this person because that's what I hear I don't know what the person represents. I don't know what changes they're gonna They're gonna do for my community. I don't know anything about this person But I'm gonna vote for them because that name stuck in my head How many people actually do because you tell everybody or these advertisements tell everybody to come out and vote but Need to know what you're voting for and who you're voting for that's right And what suppose if you do research it and everybody that's there you don't agree with Then what you can't tell me to vote because I have nobody to vote for I tell people that you're under vote You not voting is saying yes for what you don't want.  Hey, I'll go on one and uh, we we blessed to be able to you know, uh Be a A place where people feel comfortable telling their stories so their legacy and legend can move can can live on You know, that's what I that's when I done this it was cause I said man I'm gonna happen to me anytime my kids can always go I can look at this and they'll be able to look at this for years on end If we just keep working And um, that's what we that's why we do what we do Having a platform for people to share their truth Is the truth? Wow It really is it is and we have to offer safe environments for people to speak up So that we can eliminate some of the things that mr. Mako just mentioned people will say well Why why don't need to vote? Why don't need to go out? I don't like them or I don't know them or I don't know what this is about So if you know better you supposed to do better So it is our responsibility when we have a voice and have a platform to be able to share with people Who these candidates are? What the policy issues are? What this office is responsible for? We have to go I don't care if it's five people in the room those five people know another five people And those five people know another 10 people we have to spread the word that way Let me ask you something. Do you do you really um Because we got into we didn't go into the college much something happened I don't know if she walked back in or what but I want to circle back to that Just like your education because it's so important that people see How you built the foundation with the family I know you say your father and all them came and did a dorm room with you But how was it on campus and during the 1998 like like, you know what I'm saying walking around young I got a 17 year old daughter about to go to college. She's number. She's seen my grades yesterday. She's straight a student Uh 95s and up. That's all we call she number Number three number two in the school now Maybe three between she right between three and two Lucas number one shout out lucas.  So shout out to hbc us They really wrapped their arms around us loved on us to make sure that we were ready for the world However, when it comes to To your children leaving home It doesn't matter what you taught them. They're still going to make their own decisions Yeah, we just hope and pray god will have grace and mercy Continue to have grace and mercy and cover them with the decisions that they're making and that you planted strong enough seeds For them to make good decisions, right? But my experience as aviar was fight fight fight hard for it Because we're dependent on you. So it wasn't just from our family, but that's the message that we got from My hbc you and from miss carolyn. I will never forget miss carolyn in the career services department That skirt is too short That skirt is too tight Or when we would have different companies come in to want to interview us for internships We wanted those companies that we wanted don't come here because you're trying to meet a quota So we had to learn how to advocate for ourselves And to make sure that when you get a seat at the table that you speak up for those who are not at the table But also humble yourself enough to learn the game so that you can be invited into the room And then you work your med to get your seat at the table.  They went in most That's what i'm gonna do. That's what i'm gonna let you around have a run.  She gonna want it because when you step on there together Oh, it's pressure It's pressure. It's pressure and it's not that it's it's a bad thing But one you know the expectations that your parents your family your friends have for you And regardless of what happens, you know while you're there, you don't want to have to leave Because it'll feel like man. I failed Even though it may have been for a good reason, you know if you left is you did not Complete what you initially accomplished to do so you want to fight to do it, but that's with anything so again Having a humble heart enough to speak up when you need some help But you also got to fight for yourself. I did hair just don't have to call home every week to be like I need some money Would I look like trying to be at On chopper tulips somewhere at the river boat or at the river boat hallelujah calling my daddy for money because I want to Go have a good time girl, please Let me ask you this and I still have younger brothers, you know brother and sister at home. Yeah, it's not how they go Yeah, well you was a leader from jump um Just uh, how can people get a hold to you if they're trying to link with you to help the community or If they see something the way they want to donate or anything How would they be able to get a hold of you? I Have to say my cell phone is no longer private. What do I I don't mind sharing it And people call me all the time, but I want to be accessible Okay, and I want people to know when I say I want to help I mean that And if I can't then that means I need to introduce you to somebody that can that's it Um, but also email. So my email is tiffany l. Hamilton at iCloud.com. Okay, and uh, definitely, um Like, uh, I would like to do something with you. I'm trying to do my backpack thing Well, we can help some homeless people and and put you know, put you gonna be calling We're gonna be calling you we try to I'm trying to link with the right person because I did it before we've done Giveaways we've helped so many different people But a lot of times I just like to I would like to structure it in a way to where we can Start an organization So there is so frontliners is a nonprofit that my brother started back in 2013 And we've been doing what you just described. So right now we bring those things to the schools And it is an organization that is focused on frontlining your life Don't wait for somebody else to do what you can do right now be that leader front line it And literally I say front line your life and he checked me and say front line your life Because he wants people to know that you don't have to be In order to sit at this table don't come here having to be precise Don't come here having to speak correctly. It doesn't matter. We want to know where your heart is We want to know if you really really want to work in the community. Well Tiffany Thank you for coming on boss talk one or what thank y'all for having me say man This has been another great segment of boss talk one on one. Make sure you guys like and subscribe to our channel um Make sure you guys link up with us man and get Tiffany number call Call me to you know my number. It's always it's not it's public as well So man check it man zero four two three six 20 18 Man, it's been another great segment of boss talk one on one with a boss's talk and we out So when are you running for city council?


This is stock number 9250. We are here at Summit Automotive in Fond du Lac, Wisconsin, your truck headquarters, checking out this super clean 2014 Ford F250 crew cab short box. This truck has the 6.7 liter power stroke diesel. From this HD video you'll be able to tell that this truck is extremely clean all the way around. We shoot all of our videos in 1080p so if you have HD capabilities on your computer tablet or smartphone device, turn them on right now because it's like you're right here looking at the vehicle with me. It has MotoMetal 20 inch chromed alloy rims and it has Nitto Terra Grappler G2 tires. These are 35 by 12.5 R20s and they have probably about 60 to 70 percent of the tread left. You can see that the springs and shocks are in really nice condition as a nice suspension lift on it. Frame and underbody is very clean. I believe the color is ruby red on this one. The hood is in excellent condition. Headlights are nice and clear. The grille is in excellent condition. No chrome peeling or anything like that. Passengers side rim, no scuffs, no scrapes, no corrosion. Very nice clean rims and as you go down this side of the truck you can see just how clean the body is, how reflective and glass like that paint is. We take these HD videos so if you are far away or even if you're close behind you just cannot make the trip down. You can still see the truck, hear the truck and have confidence in the vehicle that you're looking at before you even get here. We saw a lot of trucks out of state so we want to make sure that you get the most accurate representation of the vehicle as possible so that when you get here there's absolutely no surprises and you can get a really good feel and have the confidence to buy that plane ticket and make that drive. Back rims are in excellent condition as well and the back tires have just as much tread as the front tires. You can see the frame and underbody on this truck is very very clean. This truck has been straight piped. I believe the DEF has been removed as well. The frame and underbody is very clean. Lower rockers are in excellent condition. Nice big exhaust. It's in excellent condition as well. You can really see that color on that ruby red there. It has a lot of nice metal flake in it. Tailgate is in excellent shape. No dents or dings. It has backup sensors, full towing package which includes a four pin and seven pin wiring. It has a soft tonneau cover. There are no rips or tears in that tonneau cover. Really nice condition. It has a gooseneck hitch. The bed has a little bit of light due to usage but that's what happens when you have a truck. But for the most part very clean. Tailgate lifts up nice and easily and it is a locking tailgate. As you go down this side of the truck just as clean as the passenger side. Didn't see any dents or dings down this side of the vehicle. Like I said we want to make sure you get the most accurate representation so when you do get here it's a matter of driving the truck, loving the truck and taking it home. Passenger side rim. Absolutely perfect as well. You can see just how clean and glass like that paint is. Driver side door code entry. This one does have the telescopic toe mirrors. They also fold in like that. They are not powered. They are not the power scope mirrors but they are telescopic. Inside the XLT package gives you the tan cloth interior. There are no rips or tears on these seats. Very nice condition. Has husky floor liners throughout the truck. Carpeting is nice and clean underneath. Power windows, power locks and power mirrors. Auto headlamps, power pedals and this truck has 46,101 miles. It is a little bit low on fuel. We will put some in right after this video. Has a mini max h&s programmer, cruise control, steering wheels in nice shape, bluetooth audio, radio controls. Has a turndile four wheel drive, factory tow command brake controller, four upfitter switches and it does have the CD player and stability control. Has the sync system, AUGS and USB jacks which also allows you to connect to your bluetooth phone. Passenger seat is absolutely perfect as well. No rips or tears. I don't believe this truck has ever been smoked in. Smells very clean. Has side current airbags and just very clean inside and out on this truck. Probably one of the nicest 2014's we've ever had. Take a quick look at the back seats. Back seats are very clean as well. No rips or tears back here. It does have a fixed glass window. You also get a 110 volt, 150 watt plug-in. Husky liners in the back here and then you do get a lockable storage bin underneath the rear seats so that locks with the ignition key and then behind these back seats you have the latch tether anchors so you can put car seats back here. They don't have them in the seats like most trucks do but they do have the tether anchors in back and of course power windows back here. Take a quick look under the hood. 6.7 liter power stroked diesel. Engine bay is very clean, runs very smooth. This truck has been fully safe and inspected by our service shop. Has a fresh oil and filter change. All the fluids have been checked and topped off and this truck is 100% ready to go. And to see more pictures of this truck or one of our other 400 new and used cars, trucks, SUV's, minivans, Wranglers, you name it, we got it. 3.25 tons, 1 tons, 1.5 tons, we got everything. Go to our website www.summitauto.com. Full pictures and descriptions of every vehicle on our lot. Videos of every single used vehicle that we have all at summitauto.com. Thank you so much for checking out the video. If you want to make this super clean 2014 years, give us a call right now<PHONE_NUMBER>. Ask for one of our sales associates to make this truck yours today. Once again that number is<PHONE_NUMBER>. Thanks for checking out my video. If you like it and want to check out more, go to youtube.com. Remember to like, subscribe and share on those videos. In fact in a second you'll see a subscription button on your left. A link to more heavy duty truck videos like this one on your right. If you haven't been to our website on the bottom, a link to this truck on our website, click those, check it out, and we look forward to helping you with this super clean 2014 Ford F-250 crew cab shortbox. Thanks again.


Aloha and welcome back to JSATV live from PTC 23, the newsroom for tech, telecom and data center professionals. Buffy Harakitas live from PTC 23, wrapping up our final day here from the biggest PTC conference to date. And joining me today is Andy Fisher. He is the founder and CEO of Mirjad 360. Andy, welcome to JSATV. Thank you very much. It's great to be here. Yeah. So this is your first time at PTC? Indeed it is. We brought three people out this time. For two of us, it's our first time and it's been a great show so far. Okay. Enjoying the sun here and on Lulu. Here and there when dodging between meetings. Yes. Catch a little glimpse of the sun here. Yeah. Just a little bit. Definitely makes a difference though. Yeah. So for viewers that might not already know, I mean, I'm sure many of them already do, but can you tell us a little bit more about your company and what you do? Absolutely. We're a 20-year-old, we're actually celebrating our 20th anniversary this month. Happy anniversary. So very excited. Thank you very much. We're a 20-year-old VAR and Systems Integrator. We're based in New York City, but we've got global reach. We help our clients choose the right technologies, help them source it, help them warehouse it, help them configure it, help them implement it all over the world and manage all that out of our project management office. Okay. New York, huh? New York City. Giant jets? A little bit of both. Okay. I'm from Eastern Connecticut, so I'm more of a Boston, don't tell anyone. Okay. Boston team fan. We won't tell. All right. Well, moving on, you had an exceptional year in 2022 with some great highlights. Mm-hmm. Why don't you share with our viewers some of those key highlights from the past year? Sure. So we've, you know, we completed a ton of project with a lot of new customers. We grew revenue 45%. Wow. We've made a couple of key hires recently in hiring our new chief solutions officer who's essentially like our CTO, but he's customer-facing, so chief solutions officer. And then we also brought on last year a head of project management and program management who is putting a really tidy bow on everything that we do out in the field. So a really big year for us. And also we've developed a number of new assessments and sort of canned experiences that really create value for clients and help them make better decisions. Wow. How are you going to top that year with this year? It's going to be a challenge, but we're going to continue to do what we do best and bring more experts to the table and continue pushing forward. So you talked a little bit about your assessments. And you have 360 view of you assessments. Why don't you dive right into that and give us a little bit more information about those assessments? Sure. Every client engagement starts with a 360-degree view of you assessment. And essentially what this is, is us investing time and getting to know the customer intimately. At the end of the day, everything we do is revolving around the customer's needs and every customer is different. And so you can't possibly expect to be able to make recommendations that are valid and valuable and relevant unless you really understand the customer and their needs or infrastructure, sometimes the politics underpinning how they all work. And so that's the very first step. Once you understand the customer, then you can start to go down the path of making recommendations. And if they're happy with those, then they ask you to execute them and then it becomes the job of the delivery team and the PMO to make sure that all of that happens flawlessly. And so really investing in the customer and getting to know their needs, that's where you can, that's where you can really find yourself by the light out. That's where we can really find ourselves adding a ton of value and that's really what the name of the game is for us. Yeah. Well, it seems like you are very laser focused on the client. Is that in response to any growing trends or is that just part of the assessment process? Why don't you tell us a little bit more there? I'm going to say yes to both. I think we're in a world where there's more choice than ever before. So it's really important to focus on the client. And that really is the beginning of everything. If you skip the discovery step and you skip the trust building step, there's very little that you can do to add value. And for us, we need to be adding value to our clients in every experience, in every meeting, in every interaction. Yeah. I mean, client experience is so critical in today's market, especially as the landscape continues to change and they're even more demanding as ever. So I think you're definitely taking the right approach there. You've been a thought leader in our industry for quite some time now. What trends do you see impacting the marketplace in the year ahead? I'd love to hear from you. Sure. So I think we are going to continue to see people trying to do more with less. They're going to need to be able to deal with more complexity. And they're going to need resources that enable them to meet those challenges. And I think we're going to see over the next 12 months, greater challenges in bringing on new OPEX. And so finding partners that they can engage and trust around certain projects to take things off their plate and add some lift is going to be more and more important than ever. Yeah, I totally agree. Thank you for providing those insights. Sure. Can you give us a preview of what we might expect from your company in the next year ahead? Next year ahead. So 2023, we're looking for 25% to 30% growth. That means we're going to have to hire 15% to 20% more heads. We're going to bring on some fairly senior folks in people operations and in other areas to give us the experience that we need to get to the next level. We've been around for 20 years, but a lot of the work that we've done up until about five years ago has all been just organically figuring things out as we go. And at this stage, the types of clients that we are working with and the complex needs of those clients demands that we've got folks on our staff that have done it before for decades. And so those are the types of folks that we're bringing to the table and are going to be presenting and offering to our clients when they work with us so that they can get the expertise that they need. Is there anything else that you wanted to add today, Andy? Anything else that I want to add? So you said you're from Philly. So who are your teams? Well, I mean, I think it pretty much shows right here. I bleed green. I am an Eagles fan. Fly Eagles fly. All right. Yes. I didn't know if it was just matching the. Well, it's a combination. So I'm matching the greener data movement, which I'm sure you've heard all the news about that. Yesterday, we just launched a greener data directory. So exciting time for our company. So in addition to that, wearing green for my team, the Philadelphia Eagles. So yeah. So here we are live from PTC in our green representing greener data. Also, thank you so much, Andy, for joining us today. I hope you enjoyed your first PTC conference and that we get to see you again soon. Congrats on your 20th year anniversary of business. That's a huge accomplishment in today's space. And where can viewers go if they want to learn more, Andy? They can go right to our website, myriad360.com. They can find us on LinkedIn, on Instagram, Twitter. We're all over the web. So come see us. Yeah. Be sure to follow them. And thank you viewers for tuning in to another fabulous episode of JSA TV, live here from PTC 23. Happy networking, Maloha.


In the 21st century, stories are what we spoiled through you, and we're all alive. This is the center of creativity. This is where we need to be. Instagram is one of the most creative platforms in the world. Certainly, the community is a really big part of it, and so we want to make sure that we're showing up. We started working with Ez Devlin organically. We were a big fan of her work. We really thought that she was the right artist that could articulate how we felt about stories and how we felt that one story could actually shift an entire world. We expressed what we felt about stories. We were so happy to find that we're completely aligned, and so we worked with her throughout the rendering process, and then worked very closely with her. But we wanted her to have her vision intact, so we were very, very comfortable with letting her lead that artistic vision. I think the message is that stories and great ideas is what connects all of us, right? Not only do we create amazing moments, but again, entire cultural shifts can be made just by sharing our story with each other. So as much as, you know, you can't be here to experience it, you can kind of experience it through social media, and as well as just like through the stories experience.