 In 39, developer, you know, I mean, you're not a country, you're not managing medicine. Medical. No, but you see rules or something, or... Medical, yes, medical. What are the options? What are the options? For combination. Oh, sorry. No, the combination. They have ICANN, they are developers, they are IT people, they're just... Yes, yes. I understand that. Okay, so I'll just quickly introduce ourselves. This is the Power BI User Group for Nigeria. We call it the Nigeria Modern Excel and Power BI User Group. How many of you are on the user group? You're on the user group? If you are not, technically you shouldn't be invited, yeah. But really, you should be to join the user group. It's a Microsoft group, it's called Pog Group. All the way they have it in every major city. We have it in Pog Group, Power BI User Group. So when we started talking Excel and Power BI, they are like brothers. Power BI is the grand child of Excel, right? So because all the technology of Power BI is inside Excel right now, as you see. Excel is so crazily powerful. So I'm going to give quite a few demos on Excel. And also I'm going to show you the new Cloud Engine. Who has seen the new engine called Excel? Who knows what I'm talking about? When I say the new engine. Okay, tell me a little bit about it. Dynamic arrays and so on. And you can only get it if you have one. Insiders. So how many of you have Office Insider here? How many of you are insiders? Only one insider. So how will you be insiders after today? Insider means that Microsoft will be developing some interesting stuff. And you want people around the world to test it. But it's at your own risk. If your system crashes and everything, you can't hold them to account. Because they are testing things, new things. So and then again, in the event of what version you have. When they finish testing and they want to put it up. Mostly Office 365. How many have Office 365? Office 365. Who is 2010? Office 2010. Yeah, 2010 probably. Okay, your office is 2010 but you are 20s. So just go about 2013. You used 2013, some people. 2016. 2019. 2019 is our opportunity. 2019. So don't buy 2019. Seriously. If you don't buy 2019. 2019 sounds latest. It's not the latest. Office 365. Always. So the Office 2019 is probably October version of Office 365. So October version of Office 365, the package, you can say, oh, this is the version that we're going to sell to people and they have the license for life. Yeah. But they don't update it. So really that's the old school way of doing things. New school is cloud based. So you'll see all that. So I would love you to register to this group. I'm going to try and get this group up as possible because the whole idea of these meetups, you do webinars every month. Every single month we do a free webinar on Excel and RBI. Another free webinar on financial modeling. And then also we're trying to arrange consistent meetups. We need only members of that group. And it's free. So that's what it's going to be. Try and raise this group up as quickly as possible. So it's PBIusername.com. So most announcements, like this meetup announcement, the first group to be here about it will be user group. So let's assume we only have 50 slots. The user group will be here about it. They will look at it for like two days in the field of 50. And then we'll now look at it in the public, right, after the user group. So that's the idea. You join the user group. Trust cuts all the information. We have some other meetup groups. So it's in our meetup group. So there's meetup.com. And there are more than an example. We have a meetup group. Anybody on the meetup? There are only a few people. So everybody else, how do you get to know Facebook? Hello. We're going to Facebook, right? Right. So we just went to the event. What the event's happening? Okay. So please join this group. Please join the group. Let's see if we can raise the numbers by 100 by the end of this session. So the sponsors of the events, the sponsors of today. Again, we need sponsors. Another reason why we can't really set so many meetups is because it's massive to create free events inside it. And so we need sponsors as much as we can. So it's our firm sponsoring and all the people here, the fact that we're organizing it, it's all for free. So come and just give them a hand. And you guys are lucky. We have three MVPs. Three MVPs that I'm going to talk to you today. Three MVPs. So Microsoft was a development professional. And they're going to talk to you today. So they're very pretty, pretty lucky. And so these are the sponsors of our firm, Deep Rock Consulting. This is what we do. Training, consulting, and payroll services. In training services, mostly anything to do with data. Then consulting, we do a lot of power behind financial modeling. And then we do payroll. We have one special confidentiality service that kind of guarantees confidentiality. People can't see their case lips. What happens in companies? People can't see. It's HR and maybe LNM finance. We need to pay taxes and it slips. People see people's pay, which is not as good. So we have a system that kind of makes up. So these are courses with you. Anybody have done any courses with Deep Rock? Anybody? There's a few of you. Okay. That's cool. So we do business intelligence, office, Office 365, Excel, financial modeling, and the likes. For those financial people in accounting and management, I advise you to go and check out AFM, AFMI Financial Modeling Institute. And one of the MDPs we're talking to today is an advanced financial modeler. So it's a certification for financial modeling. And it's super excellent. For our exam, all you do is go there and build a model from scratch. That's what it's like. For people who build a model from scratch, I've never seen an exam like that. No objectives, theory. You can build a model, you can build it for this company. And then once you finish, you can make your scripts and then you're a modeler. So it's pretty cool. You're an organizer. Okay, I'll do it. Organizer, I'm the organizer for the event. David and David Brown. I'm a consultant to the World Bank. I'm also a manager partner for the ground consulting. I'm also a Microsoft MDP. And I like trading the Rock. So I'm an ATD master trainer and instructional designer. And we're a lot of other things. One of the cool things I've written up is build courses on Office Trading Hub. So that's our Office Trading Hub, our online platform, Office Trading Hub. Right. That's me. John, quickly. Our speakers. So our speakers today is Michael Olapusi. I think the very first, I'm not mistaken, the very first MDP in Nigeria. Can I just give him a hand? He is a guru of gurus when it comes to Excel. So, as in, you will hear a lot of things there and how he, hopefully, he'll tell us a little bit about himself before he jumps into the demo. So you guys have predicted an analytic demo you're going to see. And you're going to see, actually, I think, using some part of the new engine, because Excel now takes JavaScript and all sorts of interesting things. So, yeah, Excel is not the Excel you used to know. It has Excel. So, then Michael is here with us. Also, another MDP that we're going to talk to you today is, not me. Another MDP is Puneo Shea. Puneo Shea. Yes. She is going to talk to us today as well. As a demo for us, special demo, you'll see it when it comes. And, again, it's related around Office 365. How to be more productive with that sort of thing. So, something around productivity. Yeah, and he's an expert on SharePoints and many other things. So, he'll be talking to us as well. I'll be talking to you as well a little bit. I have something. I want to kind of go into the engine, the new car engine and show you how it's going to be change everything about Excel. Everything you know about Excel can just throw it away. And, you need to kind of relearn but you relearn in a very different way. It's so much easier than we can. Very complex stuff. So easy. Right. Then, we also have Cynthia. I think so. Shea is talking to us. We're going to be having the presentation with Cynthia. So, it's excellent that we have the presentation. Isn't it super? It's very good. So, can we give Cynthia a hand? She's not here yet. And, yeah. So, that's us. What are we going to talk about? Well, welcome to the Power Registration. I assume everybody has now registered. We are all Pog members. Pog is probably our user group. Yes? No? Yes. Yes, okay. Good. We're all Pog members. So, I'll talk briefly about the joining but before that, I think I need to get, I'll talk about the joining later because our first presenter, this is our presenter, we needed to announce another event to attend. Then, we'll do an intro to the new Power BI user interface. So, they've just changed the user interface. I'll just show you the new interface which they've tried to modernize. And it's quite amazing. I'm going to use Power BI. I'm going to use Power BI. Right, excellent. Kind of. Kind of use Power BI. Halfway rewards. Good. All integrated. So, Microsoft are trying to integrate everything, the entire ecosystem. They're integrating it. So, when you learn something somewhere else, it's the same as what you're learning here. It's excellent. Really good model. Yeah. Common data model is what they call it. Everything is a common data model. So, it's cool. Then, we'll talk about, we'll just do some networking. It's very important to network. When you go to events, it's good to learn from the speakers but it's also important to network. Right? So, it's too important. So, I'll just ask you another question. I'm sorry. What's your name? Joshua. What are you? What's your name? So, please introduce yourself. The guys are next to you. And if you don't know them, or you don't know them, just introduce yourself. Now we do that, that's okay. Why do you need a password? Why do you need a password? Because you need a password, so what did you talk to, and then what did you do? Alright, thank you, thank you very much, it's very very important, some events I go to school, most events I go to school, the event is good, networking is the main thing, anytime you go to any conference, just know that you're not going there to do it, and yes here you learn a few things, but guess what, all few things are online as well, right? If you sit down properly, you get every single thing they have to say online, and guess what also, if I say professor, oh I have to go and learn and have a go, it is for learning, I'll look for that professor, I'll come by his book and I'll learn from him, and guess what, it's online, I'll chat with him and he'll give me everything, you go there and it's networking, it's networking, and I don't like having you, you have to be into networking, so always take advantage of that, right? So, you're already doing this, I think we can basically start with our first presentation, okay, so can we give Michael a hand please, answering this question, hasn't changed, so we can't get external people, so we'll be presenting, we'll be presenting to you about this at the back, until we get the external people. Oh you have, wow, sweet, can we do this excellent part? There is some, wow, okay, thank you, you're used to it. Good morning everybody, my name is Michael Olam, I'm a small athlete, and this is what I'm doing today I'm thinking it's probably a good thing to say about myself, but I'm going to go back to what I want to show you about that, moving the whole of you into something useful, maybe something you're not maybe seen for a few hundred years Microsoft Excel, predictive analysis. So beyond that, there are how many types of analysis in the level of real predictive analysis from one to ten times. You're going to do a focus of different kinds of analysis. And then there are types of analysis. So it's just predictive analysis. Then there is predictive analysis. Any other one? It's predictive analysis, which doesn't interact. So then we just still have that. Any other one? Don't care well for that. So it might be predictive, but when I explain why we call this a predictive, it also takes a little bit. So let me just explain what all those pockets are. You can, they are not too many. So I don't need to write them anymore. So let's start with the number 1.1. One that we are all very familiar with. This is descriptive. That's what we do a lot in business, right? So management and the business folks, they tell you, or if you're one of them, you really want to tell you that this is what you want to see on a daily or a weekly or a monthly basis, right? And typically you want it to describe what is happening. So you want to see maybe our sales, how your sales are going to be by day, by some different kind of dimension, maybe by food or by region, sales per se, right? So there is a lot of descriptive analysis. In fact, some of the things that are descriptive is like the role of what you can do. So that descriptive analysis, you are basically looking to the data you have and going from download data to the cycle reports, something that you can do that and you can see the kind of pattern you want to see and maybe it should be more or less what is happening to that figure, to all the data here, which are descriptive analysis. Then there is the predictive analysis. So what most of us do in business is we do much in normal. You know how we call much in normal? Then there are much in normal. So maybe I'm a sales person and then I get to work today and my manager calls us or he says to me, I say, oh, we have an emergency meeting. So you know what? We had an emergency meeting with my manager last week and a whole lot of things have come up. Your targets are going to be changed. And so maybe you used to do, say, 100 million per month and you say now your target is 150 million. And when you try and ask, how did it come up with that figure? It becomes the case of digital. You want your phone number, you want a better stack of people that are streaming, right? You might not have calls from somewhere. You can't really see. This was a calculation you need to come up with that. This is the number you should do, right? So it's very common. MDC is multiple tweets you send them here. Then everybody starts calling. 20% came from me. I don't know if it's going to shower. And then everybody else starts getting some other magic number that the few who have called are right. This magic number is in India. That's how you do it. And I understand what you're doing is magic number. So that is one secret thing that the user is to do. That's all you do that I do. Then the second one, we do moving average people. So we look at how you've been doing for the last couple of years, periods, and you've been doing 10% here or 2% month on month. OK. If we ordinarily do this, I want to get it to work harder. So if you're not able to get it to 10%, then you do 3% on what basically comes down to moving average. So those ones are very easy to do in Excel. The magic number, you don't need to do any work. There's nothing that's easy to do in the magic number. The right thing to do. And then when it comes to moving average, now to average of the last couple of periods. What about the much more intense ones? The ones that people are viewing and say, oh, data analysis. Oh, this thing can't do in Excel. So this is common land fighter. What about those ones? Are you now left helpless when it comes to that? And you're like, OK, if it's that, I'm not going to answer. How? If it's that, you don't have to do those. You're left. No. If you're an Excel person like me, you don't have to go there. Where do you learn something from? Why are you letting those things? Also, you need to do that. There's something already very important that you can take advantage of in Excel. So that's prescriptive. And someone said prescriptive. So prescriptive, that's why people vote. Because it's when you combine with it. So maybe now I put in a predictive analysis that can predict when, say, a particular product is going to go out of stock. So maybe we have to wear out some of these things. And so that thing does prediction. And then you want it so that any time the product is going to go out of stock soon, it makes generative waste for output and sends to all of your vendors. It's just the information that they want to do more. And then you get feedback. Once you put it in, it makes it better. And then there's exploration. The exploratory is much more like if you make a line, do it like this. Most of them are the friends of thousands into when you start to go to the hospital. Like, are you doing medicine or your thing? Program. So they call it sequential. There's some things we used to call the duality. Those kind of things. What are they doing? Their mind is black. When you're doing descriptive, you have an idea of what they're doing. Exploiting. You don't have anything in mind. You just look at what it is that you're doing. So maybe you're starting to close streams. So you kind of think you've got different descriptions. You're starting to close streams. You're starting to hear everything about some things that do market, do market, basket, analysis, business plan, the gain and segmentation. I think that that is a piece of kind of exploring what you're trying to make sense of. Okay, so that's predictive of any type of talk. When you do things like you don't really get the whole situation to be what people do. And then you want to run things like registration and registration. All those things you can mention when you talk about this type of thing. You have a lot of interesting things I can't find in the corner. That's an example. Then the second aspect is the example that you have. How many of you are familiar with PD? So we know that the PD is more like when you decide that you have whatever you want to use. You want to go out to do ready-made things inside. You want to do things like complicated things from scratch. Starts to make. Program the whole thing, what you create. It's already passed to the program attorney. Why do you write the program? I do this a lot to make people aware of these hours. But then there's something new. JavaScript. So this is where the whole point is right for when we get there or explain it. So let's start with the first one. So, if you can see what I'm doing on the screen. Say you work for a microphone or you don't give him money, right? You are interested in giving those regular guys money. That's why I said my question. So, if you now want to put some level of activation, you do more with your data, right? So you have people who are taking note from you before, and then they are giving information about them as it is like this. So their names, their gender, their age, the medical status, the employment status, the location where they live, then their monthly salary rate, and then the loan amount and then whether they eventually pay for it. Then this is information that is that you have someone who can look through it and find it a bit faster. And there are some people when you look at them, when you look at their own characteristics, they kind of fit into the kind of people that they bought or the people that they paid, right? So how can I do this? Where I'm going to do an algorithm that we're going to use to figure out the kind of situation that I'm creating so that the binary so we use something like a binary classification algorithm and then you want to come up with the ability for you to just approach you fast for your details and I'm going to do the Excel stuff I'm going to do and it's up to you whether you are likely to perform. We didn't do that. But the idea would be to first of all define what factors in the world factor determine how to go left or right and for one, how can you see it on the cloud view but then if you look at the office area it's not going to take any above and below so there are things like investments and TV's and all that so you can't just say no reason sometimes maybe you have to pick some factors in between and also besides doing it fully yes or no they do complicate the interview by same percentages like if somebody is an employee they are exactly like that they are in total and they are complicated because you are really the authority that you know me from back because you are supposed to use something that you are not the one there is no bias from you you are going to lose another person of knowledge you are not the one there is no bias you are not the authority I think yes sir maybe if you have units come back somewhere behind the engine you can go seek and see where that number is if I say anybody if I do this I will probably just now set a go seek program at the end just look for the guys who have looked at you look at you you can see that you have the highest cost of work that is the lowest cost that is the lowest cost that is the lowest cost okay the thing is really before I came up with this if you give this kind of a problem we don't think in terms of what is the problem I started in a if there is something I can do that can translate into a formula that can because the good thing is if you know statistics and you know what the good means it doesn't matter what you have you can't complete it we have to use exactly what we need we need regression regression but then regression is not the best for a binary outcome so we say okay let's try how to do regression how to do regression it's more complex but then there is a lot to it so we are trying to stretch itself and we write it in formula and we like using that here because there is a whole lot of work that we think we want to do when I need it because at the point you switch to hard when we need it in hard we want to do nothing because we are distressing it there because it's just the line code you look at it as it is a pretty much it's on specifications and now all of us spend like one day doing it and five minutes and that's what I want to show is how you too can leverage this new thing that I want to deconstruct so I'm saying is it possible to do this well I I was thinking you would ask me am I already sure about that are you really sure in Excel it's like who stayed who stayed in the mystic regression and don't worry what people tell is what we are doing so we are going to find out are you ready I'm going to do it there but here now I am at the point you need to do this work because I need to do some work there which is on to the Excel so okay so so this is the raw data it's about 5000 records what we want to do is we want to do is I want to do something that because if you give someone who is a statistician or what is going to do to build up something that we learn from that we look at what are the characteristics that we see those that we pay what are those characteristics and then we waste them so there might be some characteristics that are kind of like non-significant you put the call as well as you put the call let me see seven characters I think there might be three or two that kind of you see it by asking you go into big amounts and you pay and people maybe don't like to be that the call so you want to have authority and you want to be you want an authority that can keep relating so you get money every three months because this change so that's all we want to achieve but then how do we achieve it are you ready so there will be a small GTT at the end of the how's your that is the body or it's an embodiment of all Microsoft cloud so meaning that anything we want to do that we want to be able to leverage instead of building things we want to have our own self we want to leverage existing and in the many so that you can communicate with every single one of them that's what we will be that's what we will be now we are going to achieve what I want to show you right now so what I want to show you right now is so this is what we want to do so what I have is so I'm not going to anyone else so let me do three more so I have some random people that are happy that I've gotten their names so maybe you might be able to go now or you can even integrate this with the web platform Microsoft so if you integrate with that so that you can perform a laptop and the back end it means to we are named, gender all this information that you can ask them that for them if you don't understand that we are trying to do your customer but they don't know that if you are going to use it to take something more meaningful decision that you'll have in 25 so I now have what you want to request for I need something to predict at least on express level verification it's almost time to take an intervention let's first run it to the machine let it tell us if these guys are good people so I'm going to select the data that I have about them I'm going to I'll show you how you can do this many things but let me just demo for you how it works so I'll type it up and say yes you put the outcome here for me and so I think we only have to be it's a little bit right you can still see it see it I guess compared to the other one you make the most of the I wanted to be here so I can dance let me know and what I'll do next is I'll take it to make the pitch I'm going to see some locals and it's not me I'll just see that it will tell me that these people are liking to be bought and this is the probability score right so I know that in spaces for a visual default it's a lot higher than that's how binary classification works it's the probability scale so two things they are extreme so I could say it may be 0 even this one so whenever your probability is close that should be 0 right so you see that everything is 0.5 and a boom will be tuned into another 0.5 scale and then so that's why I know that this one that is really low will not do that because that's like so in case you I mentioned that you would like a probability like you're waiting to do so it's the same thing that all of them and so how do you make it happen? you see that it's possible how do you make your central approach from the raw data to the final result so we have to go back to our zoom since I used the web in documents I've been able to zoom I've never read anything like that better than zoom whatever it wants so it's true that we are going to use that I thought that was your right but if you you want to try it out as your studio.azio.ml those names it's a big product studio.azio.ml what you have done it gives you the so you get the algorithm and it gives you any type of information that you can use so that's why I'm going to increase the size so the way to try it out is this studio.azio.ml.net it's a pre-account everything is free so I don't think there's anything you can do please studio.azio.ml so once you go there you don't have an account like Microsoft so it's great to raise a new account in the same way and use any of it so this one is the one you're going to create and for me because I'm loving I'll just go straight to my experiment that best places cases so once you love me this is what you will also see if you want to sign up and love me because I'm already used to you want to experience this is where you see the labels on your left and you look up and write so it's not useful for us because we have to get it so when you love me you'll just see if I can make this video it's just better it's just better so I can go ahead and say this so this is how it works the better that I want you to make a prediction so the raw data that I want you to do is the algorithm because you must build up the algorithm I already have the data this is it so you will have given me your data and then I will have it already like this this is the way you see it whatever format you need so this is what I will use to train the model to build the algorithm this is how once I have that I go to this place I see I want to create an experiment so I want to create an experiment I do new that new can you see the new this is that new so once I click on that new it will say I want to create they have a lot of samples so you need to see something that you can analyze and make all kinds of predictions so I am not just about the experiment but we will do a blank experiment I am going to click a blank so that way I create from scratch so I click on the blank it gives a generic name so I am going to give it a name that I feel is relevant to what I want to do I want to do it alone so once you give it the name you don't have to do anything of the same and the first thing that we want to do is I want to bring in the data that I have that I want to use to you you can do analysis without data you can do this you can do this and then you forget about the these guys so I already have something in data it is very easy to bring it just to import it into I have it as my data set let me see if I can show you that it doesn't look like that on this left side experiment so I want to talk about the data set that way you can see it so I want to bring in the data set you can see it there is an lower left you can see the new so that is where I click and then I say I have it in my computer and I go click it off and I say yes bring it in so that is what we do so once you do that you will see it is ok so I am just going to take it out and see if it is dry or dry so you are not going to type in everything everybody knows how to do that they don't have to go like that so I am driving the data set so I think at this point I can go back for everything I need to do to dry it so you are beginning to find something to use that are similar what is happening in data when you want to train an algorithm you want to separate the data into two sets right doesn't make sense to use all your data with an algorithm how do you not test the algorithm so it is going to be like maybe 60 use 60 to bring an algorithm use 40 to test so that is what I am doing so I am going to say I want to split this data when you split it I drag this data and then I connect it to I connect this to this then I say it should split it in a algorithm if you want to use 60 so it is always the left that you are controlling so that left whatever you put here it will show the data on the left side and then I am going to now say this data by the way there is something I would like to do here you know we have our names I don't know if you remember the names I said but we don't have names in the prediction so I am going to tell the model I don't need your names how with your name you will hear a lot of things so I want to select some of the I am going to say I don't want to use all of the data I want to select it is not possible if I just write what I want to do it has to be something so once you say this is what you want to do type something I don't know select hold on so I am going to do that so so when I select I get this launch column selector you can say the columns I want to include so you see I can't without the columns because I want to do it faster let me do it faster let me just briefly show you what it will look like because it is just dragging and the faster if I show you what it will look like but I will put more on the aspect because I still have a lot to do so I will show you what it will look like I am trying to drag it there and then there are end results so this is you will not say that this is where we the data right we are going to select the columns that I need to use so this is what I was trying to show you select the columns I want I want to make it back home so I am going to select yes I take out the name right and then I click the data now so when you are calling you want to complete the name you don't have to say I don't need your names all the other columns all the other columns will be faster so I don't forget yes I click so I click the split which is I am going to use it as a split then it splits into I say so it is 7 to the left which will be my training set and 10 to the right and then I bring the I miss it I think in the set into the model where I connect they are very very fast so that you can so I am starting from I drag in the data set which is the one I want to select the columns I need so I click and I connect right then I want the columns then so you see it splits everything inside I want everything except the name so you see I pick everything except the name I move them to the other side then that is what I want to do then I am going to split this split then you see that that is why I click this one I connect the split right and then I say I want it to be less use 16 14 then I bring in the train model so it is anything I type in it comes up with the so I am going to train the model I drag that right in so as you are trying to it needs to start so the train model it needs to be left connect the data here to piece then I need to use an algorithm for the train so I end up what I want to do with the final addition I need things that are like classifications some of it I can classify into one of the slots to the right and this one I want to type so I can see all the options that there are and you know so if you state machine learning and then a different anomaly classification is what I want always I always have to do this thing because it does very well so I am going to drag it into regression it is like regression but the model aren't used to train the model so I drag that in then I am going to bring in the evaluate model so evaluate the model I bring that in I connect the output of the model to the evaluate model I connect the other output of my spring data to the other side so I will have to test it and then for once you have this is what I am drawing I need to like this so once you do this and once you run it it will allow you to deploy so is this possible to expand but I will see that like this I need to get from the known level up to the split where it is called and then it is evaluated and then it is found so once I run it and after I run it I will deploy it I am computing myself you guys are I am I am I am going to try it I am going to try it I am going to try it I am going to try it so it will so if you connect this together and then you run the model you run the model and you can deploy so if you run the model if I run it I will after I connect all of them so once I run it once it runs successfully it will now give you the option of set up I need to set up web service you can I need to run it so it is now so once I do the set up web service and I launch it launch then the other part which you will now bring into effect is you will see in 20 minutes you will see once you run it you will get I need to deploy that is what completes the model once you can deploy once you can deploy you can deploy once you can deploy deploy trying to deploy I can quickly switch where that one is doing so if you run it you will see something wrong I can switch to the complete part of mine once that is the last pitch you will see an Xero fighting countdown that you can have so that is the predictive side and everything all the different types of predictive are going into that so that is the predictive side I think you know in Portugal I am sure you have to do it it is amazing I am going to have a few questions that I will show you in the next part the next part of the presentation which is Xero Javascript I asked us that we are familiar with DBA and then this is the one and the other one is the new hardening experience so this one those of us that are IT we really enjoyed this one because one of the problems we have with the existing DBA is the fact that you it can be exploited I think some companies are disabled it is something like that so if you try to put in any program that has a DBA it is not going to go on so what are the ways you can deploy things that your company can use in the round of DBA that is Xero Javascript if you use an office 36 Friday thank you if you use an office 36 Friday if you go to INSAN you will see hardening if you use an office office 2013 and 2016 if you use an office 36 Friday you will get a lot more what you can explore you will see if you just can be writing stories or if you use your DBA you will see that let me show you the whole lot of tools that you can use beyond what is needed in the Excel and then if you scroll down you can see some that are useful for your song and then scroll down scroll down are you seeing something familiar can you see something in Nigerian market data so you can do something to it it is not just your organization if you want something anybody can install in my case I can allow people to use in some other cases solve the problem of distributing they can even pay you in company price so it is not the problem of distributing then you have to start doing things for marketing you can just see and then if you have it is handy to add it to your to your Excel and then it opens up so what I have done with this what I have done with this I made it possible for you to do information that we all like to get from in Niger like you want to know what the effects are who doesn't want to know it is one of the commonest things that you keep telling me about so I go there I want to see the exchange rate and it is handy to use it I want to see maybe the stock market I want to see the closing market prices it is handy to use it and so today it is 29 so that is the last market right what if I want to know what it was say this same year last year if I type in if I type in this same year for last year 2018 1906 1909 and I take it and I say get me for that same date let's say let's even go 2 years back less than 27 I like to see and if you type in so this can be good for those who have investment portfolios and you go back in time and the same thing even for the exchange rates you have an accountant you guys forgot to put the closing more exchange rates I can't think what about 2019 end of the month whatever it is don't get what the exchange rate was last year and I think it was a particular date so I like that and you get it out for you and you got the if you like the exchange rate people are going to put there before you say nobody puts even the closing rates so you have the exchange rate and I got it also all those things but I think I want to think about how to use something like this because the key thing is you want to see you can use it on your phone because the same functionality exists on your phone and then even when IT puts the password to give you all this you can use it also this does not work for them because you actually know it's going to be they only need something like this so how you do this is a part where some people might be like okay and now I know it but I will give it to some other guys you need to have you need to have because and then you fill it inside it what is it so if you have a very large organization that you work here inside this is something you can learn if you go here so now we are getting into the question time if you go here the same place I want to do the get add-ins right you will see my organization so there is a place where if I couldn't there is a place called and you manage this an organization you can publish add-ins that are just where you are putting your company so now we are on that way to deploy things things like that exchange rate so I have come to the end of my presentation unfortunately do you want that I was even wanting to show how you are taking okay it's finally done what is deployed so you say if I deploy and go back and then once you deploy any questions so I can give questions so once the deployment is done can you see something like let me just use all these things can you see that I can tell the director about it this is magical this is what I now can do that now makes it you open it you now see the same experience you saw me use to answer and then I can type in any questions so you now see that you saw me using the demonstration you see that the only thing that is outside of it is the moment you do that everything you see right here I saw you score I saw you score score more okay what did you do in taking the already smoothed it out whenever you put it on and you got testing testing that is right so that's what that's for because of time I couldn't show you the results this one we now give you the technical way of doing it this is a true positive so do you have to see true positive and it's called the accuracy and it's like you're waiting to use the test so that's what I didn't want to show you so it's a lot of the question how because the question that I did was what does it mean how do you have a very good question remember I said that everything can be done from first place this question is a regression model I mean what did I put as my parameters did I set the picture did I put something in good things of the shell product is I think they can find the best setting I don't know if you have this forecast if you go to data you will see something called forecast this forecast says that it's a time series but if you don't know the statistics behind you you cannot take it as trivial what it does is what we call triple exponentials find seasonality find strength that thing I've said if you try to do it outside of Excel or manually you can use it like you would do but they put it in there and the thing is because they don't expect it to be statistician it automatically determines what that is it automatically do all those things so that way the programs are those things I even if I need to use I usually don't know how to use these things it's always finding the best setting for itself because it can also score itself but I don't I'm doing a competition and I want to do it like I do so it's there so if you're in there it's as big as I can use to train the model and it's still in the field but it's not big enough so it's able to have more data like I used to so if you use this thing where I've done it's just if you have it's just if it has set to the place and those people so that you can now do it go you will know you don't even need to read out this game you just need to now replace the data out there they need to agree and they now know thank you so I just want to confirm right around this big data setting let's see does there any indication so I don't know if you are there is a significant population it's some significant sum if you use this formula so it's like the root of the formula to use to that it's easy to find out you can go on and say I have a population of 2 million that's representation so that's what people even call the election and government so they know that there's no body need for the guys so the first thing is once I know that I don't know what my data set is if I have a data set of say 5,000 when I do that and based on if the you can prove it you can prove it some people say the population size so if you say 19,000 if you give me I will have done that and say give me I will say times 5 because people can't talk now they're like what do you need what do you ask me so I will now use that back to how it has to be now when I know I have 5,000 but if this is I need 2,000 then in that case I can play as long as I put on the testing side it's more than 2,000 so they know more or if I have 3,000 I'm most apportionately locked to the testing side so that means that there are just you come to the step so you select the data set select from the split data I bring in the data set I select it because sometimes it's very common that there would be some opinion maybe from the India or things like that because it's my team that's what you select split data then you start with 2,000 split you change it but is that even what you use the train the score so the way it works is that one goes to the train the train goes to the score so that's the score the train goes to the score the second side of the other goes to the other side of the score and now the score so that one goes to the evaluation of the data so how do I evaluate the score how do I evaluate that evaluation what do I evaluate and view result so I'm going to show me that on many people write in English you can only write in 60% accuracy but then I can write sometimes I think there are cases where I can go and change the what you write that fact that I don't want to do so how do you you're very right about the result experience so how do you refine what it gets that I have a teacher he did a set of different this is something it comes to me it's already settled I think I have found a better way to do that you know I wrote it in detail I'm sure you can connect with it so you can let it just connect with it you don't want it to be in the same point so you need that to adjust you might need to it's better maybe you'll bring the last 5,000 you don't have to be just here select top what is that you don't like asking questions I like okay you have a question alright how much of how much of the theory of satan do you know for example say now you know your name binary is satan so when do you know how do you know when to use the principle component and how do you know speaking in grammar I'm just saying how do you know I'm speaking in English I'm saying how do you know how much of the theory do you need to know before you go and answer my time is up so I'll just also take the steps and provide you an answer so I don't know either the geography how does it relate to any aspect so you have a data sense a lot of data sense probably explains the americans' point of view if you bring it to the migrants it would be anything you need to do to account for behavior and expedition kind of matches what happens you don't just think it has to be better then so if you bring back your canals but once it's built can I just go online and pick a model and say this is how it is and then three months down the line how do you know how do you answer the questions again so question number one is how do you know which approach you use and how do you know do you know how to improve your statistics two things if this is a part you want you want to be a professional in that part then you can buy a part on that link down below for you this is going to be one of them maybe something you don't need to do not like maybe you want to switch career then you can just read what you want to do I can google that I want to do market packet analysis or I want to do association online I can just google that I will just focus on what I want to do and use that link that works sometimes when I have things that I don't want to use then question number two is can you take something that someone has used outside of the people who do it good thing is data is not where do you want to know that this is an example of data so it's more about data itself so it's always good that algorithm might be similar for example you run your screen from scratch you might use that as a guide you use that to do your text run then it stands fine too but you always never correct your statistics about data which you always have to do even in the same manner to defend confidence thank you very very much we need predictions in just a few minutes with the technology issues that we have and it's just right and wrong so that's the thing that Microsoft is doing Microsoft is making it as easy as possible of just integrating stuff just think about a company where one department is not talking to another department it's not possible for it to move forward as when people are not talking to each other yes you may still be growing but it's really ridiculously slow so think about Microsoft as a country it's not really a company it's too big it's huge it's just too huge so what happened before was people are not talking to each other Excel team are not talking to PowerPoint team or not talking to Word team they are not talking and even inside the Excel team there is the look up or function team not talking to the I don't know interface team not talking to different teams and really being to enough really working as a show and there was really no competition who used to watch this one to play wow these are ancestors I don't know who used to be a busy cop the guys should have done that busy cop is the very first spreadsheet ever very first spreadsheet but a lot of time that we have some stuff but even Excel too doesn't have what to do it has some really cool stuff and what I tell people is a lot of I think it was just a problem of success really and also they kind of packaged to the great one and you saw what Michael did here he just went and got a piece adding and put it in so before any small adding like that you would pay money so Lotus invented their pivot tables they had wanted to invent their pivot tables but I think you have to pay for it and attach it to Lotus and then Microsoft decided they did reverse engineering the Chinese are doing it now they were doing it then so they reverse engineered pivot tables and put it in for free in Excel and then the competition died but then innovation stopped innovation stopped in Microsoft after killing the competition who used Netscape whoever used Netscape Netscape was far better than Internet Explorer right so how you you can make your software good and sell or you can do a small trick and the small trick is to sell your products good enough by windows you have Internet Explorer which they decided to now do for free and then you have Netscape which you need to buy yes you know Netscape is better but you need to spend cash so you end up using Internet Explorer to manage how many of you like to say that we are all managers we are managers we are managing so that's what happened it's complicated they have a new focus the motto is wanting everyone in the world to achieve more so it's a completely different organ so they are integrating so many things so you can imagine like how we are in Excel to every single week how they are depleted every week I don't know who knows the Gapna report have you ever heard of that report Gapna report Gapna report just assesses many other IT tools Microsoft just keeps on going to the top because they are now talking to each other and we don't need to go and learn Excel they are now on Power BI come to start with learning new things same thing in Excel just a different looking package it's like Excel with Power Point looks like Power Point with drag and drop which is very nice you are learning the same thing data analysis, expressions the new language so you think you know Excel there's another language called DATS you have to know DATS there's another language you have to know M so Excel I don't think it's possible to finish learning Excel the thing is just focus on your path and learn that path very well and then understand the story around how Excel works so I'll give you that story about people that are hungry I'll give you the general story of how I bring down Excel and no matter what new thing comes in it's nothing new another secret of Power BI if you want to know what's coming in Power BI look at Excel because they are mimicking everything everything in Excel they make one as well but very rudimentary they will improve it Excel so they're just kind of replicating Excel I don't think it's a replacement they're not replacements they work together I have to learn how to use them well together so I'll give you a general story of the entire framework from musical to bass so you have a framework of how these people are thinking that way they will not surprise you so any new thing that comes you know you can use it without anything but should we have to break now okay cool let's have to break we just have to break there thank you thank you so she'll collect the money there yes so let's have to break let's say it's like 20 minutes and they'll come back we'll do two more sessions and then we'll do what less means let's talk to your people let me tell you something there's a price there's a price there's a price to be won for how many people do you know and the funny thing is the data is you guys which is nice they have one billion people okay say yes one billion yeses right so that is data and you guys are filling in data and they're using that data to do all sorts of machine learning AI coming next it's something else so at least what we have now let's see how productive you are what people have to say thank you if you want to highlight the process okay yeah my name is and most time I always win because my name is always between every other person and mind you my name is not there if I had it the people that would beat me around the world is from Egypt all those Indian combine brother father's name together mine is so I'm an MVP actually as David said office harp and service I'm also a trainer a regional lead for Nigeria and I study the responsibility to the West African coast so I've been around Microsoft for a while and that's my undo if you want to follow me so today what we're going to look at is why business insight in this digital transformed world you guys are the next wave you might not know everything that's going to happen in this new age is going to happen from guys that have that can create insight for people people that can use to I might not be the one that would do the demo for a cell like Michael or the one that David is going to come like the power bi but I just want to lay I'm the soft guy in between two of them to make you to understand that you are in an era that they need you for everything to happen why business insight in this digital transformed world like the question is that for description or for transformation into information what do you think can I have somebody in the house what do you think data is in those days when people that get data, house data they feel like champion I have got all this data I have it somewhere and when they talk they have this data world they have to link this transitional and the rest what do we use this data for that is the question and that's the age we have and this data there's a term now called big data everything is coming converging in the points but with all this you find out that it's not really worth it to have data without using it for information now I did a typical example I mean many of us go to one-bed party every Saturday do you know the the old data is every Saturday in legal so that the movie that is coming up because like I saw it in the preview when we took all of the MVPs that came from 9 down and they were showing how legal colorful party now let's take a typical example of their own one-bed party and let's look at the data that is coming every Saturday photograph Facebook, Instagram what can I use this data to do do you know I can actually use the data to know the what they need to wear for the next parties that is where you guys sit and that is the power you have look thank god for people like David and Michael and Dejan the rest that is bringing this kind of thing to this area because there's a lot we can do this is just my own my own pick person thinking this way all of you guys have this data to play with I leave it there what is business insight generally business insights they said is combining data and analysis together and when you combine this to what will happen I look at it this way business insights is the gap is the gap builder is the one that can tell a CEO or a CFO to understand the next trend of business it can go to I was in a presentation yes but I always tell this story I started up as a research assistant I watched for a company then a stock estate building and then my MD and CEO after we have gone to my degree we did a project for MTEL and we gather all this information put it on SPSS sure we put all this information there and the guy after spending two days with SL you know we have done the dirty work the guy come on stage and be bouncing and was telling MTEL that when you can get a phone with double steams there are so many people that want to use multiple lines and that's what we're having today almost 10-15 years ago but do you know the greatest the acronym for our own work was not to us we that went to gather the data was to the guy on stage that was bringing this insight and bridging the gap and telling the CEO telling the commissioner of information telling the minister this is the way we can make this run to be better and that is the era we are I read a story from McKinsey and I want to do I have a gift in those days in the recent time I noticed that instead of getting tattoos why don't you put tattoos on your system and make it colorful so I want us to discuss this can anybody analyze this to diagram I would love the ladies to do that first you know why I always preach inclusion anyway we want more ladies we want them to now take the center stage too much men how many MVP in Nigeria all males one female so that it will be soft landing any lady first can you analyze this too forget this capture just analyze it in your way Adia the boys come to you you say oh who can save her I know her I don't want to call her um ma'am can you help us with this I want you to be interactive can you help us with this to diagram your own understanding what do you think these two is saying you yes ma you say oh why the females can you help us to analyze this I'm not putting you on sport I just want your idea it's not something that yes to separate in and just analyze it okay this one you can see what do you think it's saying it's saying that okay more than the others more than the others so can you use this to make a decision instantly well or do you still need more analysis make a decision yes but if I was to just one one okay just diagram with statistics properly arranged by bringing using the inside tools by power bi like excel you can sell this to managers make them to see the importance of using data they have and making an informed decision sorry oh sorry and I'll give you a lady that made the statement I'm not putting you on sports thank you so what is the difference between data information and insights what is data I told you my experience that's where I travel around the nuts I went to Zamfara no those days there was no killing no we are safe so travel to Zamfara stay in the villages get data get those data in excel take it to the head office the manage with the SPSS we have the team that does that and my MD go on stage and become champion why we do all those dirty work then what is information information is actually collecting those things from the data like extracting it and what is inside inside is now combining the two and bringing what intelligence out of it now it has gone beyond just bringing intelligence Michael just showed us what we can use machine learning to do prediction and that is the exciting about you teams you guys the team here we are going to a point I was in a section when David and Deji were there somewhere in Microsoft and they showed something on Power BI and they asked Power BI a question what to be in my they brought some data said what to be the next opportunity for this business and Power BI brought it out do this do that and when you check it it's real and to work might not be 100% at least 98% in the past how do we do business inside now I just brought a diagram and it shows how industry now business now in those in the in the past you notice that most of the business stay 30 years times the lifespan but it has reduced gradually now a company that can survive without intelligence can only last more than 5-10 years they are gone how many of you know what we call batter I am an old block you know wait how the second is gone is it still around oh they are trying to bring it back what do you know the flavor of batter those days separate with your shoe oh god that as in the way they do inside those days is that they use intuition they use tools that cannot give you definite idea on where you should go and how to predict it and it was very it's like you are forcing yourself but in those era like my MD those days it looked like a champion what of if it is now what would the man become they will be calling me send me to go and present because it transforms those data it brings information out of it with the little technology it has it was using it for insights but we are equipped now and this day we are now we have a very good journey now for me this is the way I look at business insight first of all you need to have what happened the reporting aspect Michael was saying when I entered he said you cannot do anything except you have data so you must always unshake those data guys they are key to your success because if they give you although they don't know you have to transform those data clean it before you can use it for insight they don't know what you go through but the fact here is that you need to unshake them to get a proper reporting then you need what we call interactive dashboard and that's why the power of Power BI now I am going to show you a very simple tool how many of you use Office 365 they introduced it in 2016 they call Microsoft Planner very simple but do you know you can do a lot with it because the insight that is embedded in it we are going to look at it shortly we are going to have a short time then the next thing is what will happen in the future that's what we cannot get in the whole era you can predict what will happen in the future by creating model like what is showed us in the morning model that you can use Excel to create and you can predict loan many people need that prediction till now in the banks do you know how they do they go insurance is what sorry is anybody in insurance insurance do you know what they do they go and check the car okay do you know you can build a model that can predict if your car is from 2013 2016 it can leave this lifespan and you can now do a premium on it what they give to us now is a straight jacket 5000 and it can make more what if my car is just the only car made and I brought it to the country and my insurance to be this premium and I should get this premium but they don't know because there's no prediction then what should I do where you are the champion like my MD is when you talk in the office and you are telling the MD with the power BI this is what you can do this is what you can do take this it's become an insight to him instantly we say yes we are taking the next direction like when I showed that on one bet is a common thing we see something you can get out of it people go to party with different colors can you talk to the man father say can you produce this kind of clothes in the rainy season in Lagos the type of color they want is pink because of you know you know the way I wrote this people don't want to use whites and that's a prediction it can come like an insight and you can sell it and make money I'm gradually coming to an end so the convergence is now colorating power of the cloud sorry I'm talking a little bit marketing now David and Michael do the tech now the cloud now is giving us enough energy that you can spin up a VM at a short time and you can do a lot of things with the cloud services and that's what we do have then I remember when they are doing the SPSS this guy the transition can spend a week two weeks you will run and run with few minutes you can upload your data just as David did and do a prediction which you cannot have sorry Michael sorry Michael mix them David is half Sanjay and half people sorry so data the power because we have data everywhere we notice that you can even predict through Twitter Facebook what is people what do they want and get those information and make intelligence out of it everything is converging and the truth is that the power is in your hand you are so I'm a soft guy between Michael and David just to make you to know what you can do and to see how you can look at it now I told you about what is happening 25 years is 7 years now the lifespan is shorting to 15 years so that means your role is not showing anywhere everywhere because a businessman does not want to spend time to begin to build and build he wants information that can he carry him to the next level and that's what insight can do for you so many solution I said thank god they should one using Excel there are orders like bought, convergence all those things Microsoft is bringing up Microsoft is really investing and what they are trying to do is that they are making yeah they are making money to perform but they are trying to make things easier for us giving you tools that you can make and that's why we are calling for you to bring your own application look at what Michael did on Excel it's published you can do the same but how you look at it the channels is there and everything is there for you to take how do you take it a lot of it is all around the world this is banking professional services this is what intelligent has been making people and they have been using it now when we started with watching cinemas for those this Coco Dan video and to have it on the streets is only one person you just queue to the window to begin to watch films cinema came this guy Netflix they just came up what can we do let make a change everybody sitting at home we have this home theater somewhere for our home theater when it's just like the cinema why do you have to pay for cinema we can give you by service pay for the video per month and this guy is making it you can do the same simple case study Rose Royce they set out to do something and this is what the senior vice president said some years back now they have data you know intelligent cars are coming now what do you know before they start building those intelligent they went through research they analyzed those data they threw out information from it and they brought insight and this is their story now this what they did they have an objective they have a tactics and they brought out result for them I know there are some business owner here I met one there's one here I know him very well and a lot of us are here actually run on this and make a change don't look at this user group as just a time for you to just come and have knowledge go to the office think out of the boss what can you do to make impact in this society there's a lot of things we can change here in Nigeria and we just need people that can just look at this objectively and walk towards it finally I'll do my demo on planner I'll need volunteer just three people I'll send a team request to you just accept as a guest then I build it planner and we'll see the inside comment of it any volunteer thank God for the ladies they are volunteering now thank you any other person I still have a lot to give out just in Yamastika you got too good any other boss we want inclusion here let's promote them they should be on the center stage so I'll just connect to my and try to do the I hope my time my time will be almost up but yeah my time is running this is too funky man send it to me it's not funky this is a new toy and 6 just connect yeah just connect so the volunteer will give me your email address so you get a prompt from team I should join my channel just for us to display this so I should start adding so I just create this Demopabia is a group so I want to hard people so the first person ye tsunde ye tsunde okay o v hi o v hi t e do you mind just typing it and not mess up your name I'm used to that okay now can you see what team does it picks the name irrespective of the tenants then I can hard her we just wait for her to respond okay gone almost yeah gone the next person please once you have got the ticket my sticker please come forward maybe the first four we just stop there because of our time okay resolved and hold on let's once his heart goes okay let's add another person we have five okay I think this guy is a lot of his six five guy he knows what to do hold on have you got any prompts those that have added have you got a prompt this can you try okay last person okay what is this our dance and it changes and inside it got so in a nutshell what this story is all about is that this is inside power don't just sit on the data part get information try to drive it inside everything you do for Excel, Power BI for any function you try to bring an insight and the traditional aspect in becoming trendy now and that's where the big model is it takes time like for insurance I was building a software with my team then and we noticed that on sports when you are an accident how do you send those information now you need time to time you need to describe what kind of and you can use it on your mobile app just take the picture research it to the back end send it to the server and tell them at such a time and this is what happens they can actually use their model to leave what they need to pay if not to burn it there so this one of the following cars EKY 992D need to move it SNK 4004 need to move it EST118 DE GG18 ER needs to move it LND83 ZEW please so in conclusion inside thank you for that so in conclusion before I leave room for David to come and do this magic event maybe it will show us how I am going to bring data from one point and take it to the sky and I don't know what the power is to change the things we have been used to and make it more interesting thank you very much I see our sticker also thank you in the same city thank you thank you thank you we have done it in an hour yes, we've done it in an hour We really want to keep to time. We said four words, but we actually meant three. We don't have three, yeah? Well, we said 11, actually we need 11. I hope you've enjoyed ourselves so far. Yeah, so lots of knowledge, you've written some notes. We have a manner of backwards recording. What we intend to do is edit these, and export it into all this stuff, you'll edit it and we'll put it on the Fabia user loop. Only context from all of this, we're also gonna only put it in the Fabia user loop. And so everything's just gonna be there. And of course, if you're a member, you're just down there. Right? And as I said, it's free. How many of you have registered on LALA? Not going to, it's still on. Not me, not me, not me. Power game is key, be, I, user, loop.com slash link of C. Yeah. Key, be, I. Let me see, I think I had a page. I had to slide it. Yeah. This was the website. So just a reminder for those that can't believe, RBI of course is Microsoft product. So they set up 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 in many cities around the world. And everybody learning from each other, right? So, 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 Nigeria, it's pviusagroup.com slash Lagos. When registering this, when it started, when I was registering it, I was like, okay, yes, RBI is nice. I'm an Excel guy, I come from the Excel side. There's some people that come from the analytics side and people that come from the database side, SQL side. But 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's gonna be the same and then we're now coming to this power behind called 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. When you can't tell a story in front of top management, you really wasted your time. You can't get that promotion. You can't really move on. You need to learn story telling. Who is the first person that came today? Who's the very first person? Okay, can I start now? Can I start now for a quick question? Thank you very much. Thank you very much. Let's go start at this time, just start with your name, start with your name. Uche, Uche. Okay, who knows Uche? Because you should have talked to each other. Who knows Uche? Okay, can I introduce Uche? Please. So introduce Uche, you met him today, right? Yeah. It has a small introduction. Okay, everyone, I'm very glad to introduce you. So I'm giving 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 see, they're like, ah, insights are coming in across your presentation, showing the correct visuals. And to do that, you need to understand numbers. You need to show the numbers to whoever 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 Tew. He is not S-T-E-P-H-E-N-F-E-W, Stephen Tew. He is an excellent guy, when it comes to visualization for business. It's not an IT guy, it's not just, he knows how to visualize data for business. 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 hood zone, are we almost beating 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 top time for the beta base or whatever it is? So we're going to give Stephen Tew a book from Stephen Tew. We're going to jump on that book. Show me the numbers in the book. Very plentiful. It's very happy. Yeah, it's very happy. Help me, man. It's the last visit I've ever had. It is really interesting. So it's really, it's really good for show me the numbers. To really explain a little bit of statistics, not the top one in school, but very time statistics, and how do you show the numbers? That doesn't make sense, right? So please join this, join our group. I mean, ask one of two more questions and then I'll jump into my brief demo. Who wants us to finish on time? Well, I think we're asking this question. Oh, this question. Just analyzing, this was, okay. 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're done 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? And we have some experts in the house come to me for advice. Please, you need to be a volunteer speaker, yeah? Because I'm gonna 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 they are official, yeah? So, next question, people are already answering this one. Can you quickly answer this? What word comes to mind when you, 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? Influenced by the words that are there, just type. Okay, so as the words are coming to mind, please vote for the volunteers for the last presentation, okay? Just stand up, please, the volunteers. The ones that volunteer, they're in your addresses. Can you stand up? Yes, I need to look back. Jay has a price for you, thank you. So, have some nice shots from Microsoft. Don't, like, what happened? Is that what you're buying? Yes, yes. I just met a friend in England. Thank you very much, can I give them a hand, please? So, data analysis, magic, interesting. So, no horror, okay, I think that's something worth. So, I'm going to ask some questions about what I think is, like, terrible, horror, stress, what are the difficulties? Difficult, yeah, yeah, yeah, yeah, yeah. The x, the x, the x. Daunting, competition, fantasy. Fantasy, okay. Good, good, good. Very fast, good, good, sell, yes. Invoice. Invoice. Yeah. That's not the easy point, voice. Send that in, voice, send that in, voice. I like that, I like that. So, that's cool. So, I'll be asking more questions. Let me just focus on the eyes. So, this is the, I don't know how many people use Power BI. Okay, let me find out, sorry, that's the 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. It's 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 presentation, everybody's looking at you like this. And then the rate is home, you just give the world rubbish, shoot nonsense. That's what happens. So, it's very good to get feedback. It's 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? I guess how much this costs? Zero, although it cost me a lot of money after. It costs zero, if you have up to 20 audience, I think it's free. But let me give you a website that is zero, regardless of the size of the audience. Because this is very useful. It's called, what's it called? Socrative. Socrative, yes guess. Yes, socrative. S-O-C, I can't spell. Socrative, see, S-O-C-R, G-A, T-I-V-E, dot com. So, socrative.com, you go there and what you do is you become a teacher and then you have students. So you go in as a teacher, you set up your questions and then once you come to the audience, you put it up, question is there, everybody goes to the room. When you go to the deep ground, so you go to the room, answer and you see it, it's all free. 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, 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 doing it? Okay, where to start? Where to start, that's a good one, where to start, it's interest. Okay, interest, that means it's the skill that your boss has said, you can learn it. I've been thinking about the skill you really already have an interest, so yes, but what's his knowledge, please go ahead and learn it. It's not that I'm so interested, it's not that I'm not interested. Time, yeah, time, time. Information overload, information overload, where to start, very true. Is it? That one I don't have that I don't know. Estimation, that's the term. Yes, anybody else? Resources. Resources, okay, maybe he's saying too much resources, you are saying resources, so how much? He's saying too much resources. Because man, 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 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 also our team at the back and also trying to create costs, we are so stickless with data, we go to the whole world, who is the expert in financial modeling? I flew to UK and had a discussion with them and all the discussions came back, did research, research, research, research, unfortunately it used my approach with a format. So we did all that research and everything, there were not one crazy cost and then the cost broke it down and the day we created the cost, about two years, probably cost us, if we actually can play the time, probably $20 billion to develop a financial modeling cost. 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 cost. 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 wants to like sales and marketing. You need to market yourself. So if you know how to market yourself and 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 live three lives every, every single day. You live three lives. Every day, three lives. You work for eight hours. You sleep for rest for eight hours. What do I do in the last eight hours? Drap-drap. Drap-drap. Drap-drap. Drap-drap. Drap-drap. Drap-drap. Drap-drap. Drap-drap. Drap-drap. Drap, drap, drap. Drap-drap. Drap-drap. It's a good topic. It'll be interesting. It's very difficult. It's not something you think about. But you can't see traffic. You don't really get that. 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 BOSS. When I started my career in Anderson, I was in the BOSS, sometimes we'd go into BOSS from So anyway, enter, look at what happens. See what just happened. I typed a formula in Excel. It has brought me a unique list of states. See, it's lego state in here. Okay, let's go and type. Let's lego state now. Lego state. Let's just type lego state. So lego state is inside our data. I know there's no look out of my corner but it's fine. Let's go there. So let's come to where we control it. Okay, any lego state? 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, that's it. Excellent. Opportunity, opportunity. There's another function. Let me just come to the beginning of the week. 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. Wow. Sorting by reverse. I just go to the, what's it called? Function F. And the sort has various functions. So I just come up. Then it says what? Sort index. They say sort order. Let me just say sort order. And the option is ascending or descending. Is it descending or descending? Or descending or something like that. So you enter. Yeah. Right? Wow. It's crazy. It's crazy. Crazy. So if somebody goes and decides to type some nonsense or deletes it or press delete. Now you look at it. The first form, like you look at the formula bar, is clear. In the formula bar is clear. The rest are kind of grayed out. Right? So if somebody leaks this. 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. But if I keep the error message and tell you where the, 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. I've checked equals to. I go to that somewhere else, which is in control. Yep. You know, we normally do a real formula. Yes. In this case, you don't, right? I don't. No. Any array. Yes. Any array you now type. If you just spill. So even I can't even do the old one. I mean, arrays. Although there's something called single and act. But I don't do that. Anyway, so here, I select, you know, is this cell that started doing that spilling thing? I click on it. When I click on it, look at the formula very well. Control. This is something. I enter while nothing really happens. But look how it 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 spill. See, it wasn't stopping it at the bottom. Map. Map. Map. Please. Let me take it from here. Take it down there. Then I delete this one. It spills. Yeah? Can I see that? Some people are looking at this. It's not Excel. What happened to my old Excel? So that is how it is. That's Excel. So this is the new function. It's also sorted by. I'll leave that one. Actually unique. There's some, two, 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 this is a new thing. 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 do 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 spill and 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 self-established are going to be the next month. Right? They want to fix some things first. But they give us the so-called experimenters. The insiders. Yeah, but it can be an insider. 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 first. 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. We call it 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. What's the capital we're doing? No people sound there. So I put 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, I don't know. Okay. Then I come here again. I said, okay, I need population. The population there. Yeah. Yeah. Yeah. All right. So I guess maybe it's right. I don't know what census we got his uses, but this is the latest information on the island. Why is he putting it on the water? It's usually from the bank. So it does go to the bank and then there's a way that algorithm works like those data. You saw what Michael showed you about stocks. It's the same kind of thing. But it's inbills now. Inbills. So okay, let's see if this thing is smart. You know we just had elections, right? Yeah. Let's see, let's see, let's see. I know you don't know any of the governments in other states. So let's just check. Where's the leader? I think he has a leader somewhere. Leader. Okay. I don't know if this is true. Obviously the governor has a resume office. He keeps our vacations. So let's see, let's see. Wow. Where's the leader? Where's the leader? He puts his picture everywhere. We know him now. Yes. But what do you guys want to know? These two. Yes? Is that correct? No. That's correct. Exactly. Okay. So see field. This is a lot of new era type. Field means that I've gone online and we can't find the information. You know, we in Nigeria have some type of data. Maybe we are. I don't know. So because of this, we can use our old Excel tricks, right? 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. I can say if error. If error. That's how simple this thing is. It's not as complex as our old Excel. It's just like magic really. And 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. Right? So this works nicely. Yeah. Not bad. Pretty good. Right? 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. 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. Is it coming? It's coming. So what's the internet? So let me go to the chart design. And let's change the page that I've been sitting with. So currently, I have company. What's that? I'm not just sitting. Let's just move the guy. Population is the key thing. I don't need the leaders. Let's move. Maybe it's a recovery. Let's say this is an inch population. Show me by the population. Okay. So let's see if this works. My internet is on. We'll see Nigeria. Yeah? Nigeria is on to show. So let's move to Nigeria. Nigeria is on to show. So that's an example. 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. Super. Super. Super. Super. Super. Super. Super. Super. Super. Okay, so you don't have a complexity of many things. Then just visualize. Now, even this visual is not really correct as far as I'm concerned. I wanted to visualize this on the figure. So population, is it based on the figure? Actually, it's... Let me see. I think it's based on um... Yeah. So what I added is current values followed by numeric value. Okay, but 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 do one? Sure. Yeah. Because we've really gone over time. 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 in 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, values itself very well. So he's kind of spearheading this in Microsoft. And when it comes up, I'll see it. Yeah. His name is, what's his name again? Yeah. Joe. So this is him saying review. I'll send you all these links on the. So let's quickly do one interesting experiment. Show how complex you can build stuff with this thing. Very, very quick. So I'm going to get my unique list of states. Let's do the same for like a, okay. Let's say sort, sort what? And unique, unique. Yeah. Okay. Here. You do me feedback. Then what are you doing? I go to data. Now I've converted this to a table to something called table inserts table. Always try when you get your data. 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. Oh no. Next up. The same. Don't help. I don't need help. Help is actually better than before. Very cool. Not like before help us. Okay. I don't know if the formula looks right. Does it? Does it look right? How many times should I move my bracket? Twice. Then I enter. It spills, right? Yeah. Now there's a new function that gives you random numbers. Anybody do want to color simulation? Yeah. Okay. Okay. Okay. Okay. I don't know if the formula looks right. Does it? Does it look right? Yeah. How many times should I move my bracket? Twice. How many times should I move my bracket? Yeah. This is superb for multicolor simulation. So here I will say it calls to. I want to give me random numbers using the new function called random array. Where's random array? Yeah. What's the last one? Random array. So random array. I didn't read what it says it means. Rows. Rows. Rows. Rows. Rows. Rows. Okay. For random array. The first one is what? Rows. Okay. So how many rows do I want this thing to show me? You know, most I'm learning writing a formula that means to give you plenty of things. It's one cell you're now writing. Once you write it in one cell, it is still. So I want to write a formula in one cell and I want it to still precisely the same size as what I have to the left. Don't you think so? Right? So it doesn't still more or less. So you know it's already in itself. It counts A. Counter. I don't know. That's counter? What is it? 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 go to it and you go to your hash. You forgot to add hash. Remember the hash? Very hash. 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 that's fine. Then minimal. What should I use for minimal? Let's use this thing at the top. I will do my normal F4 to lock. F4, which is difficult with this thing. F4. Then comma. What? I do actually need to lock. We're writing a formula in one cell, isn't it? So I don't need to lock anything. You understand? Anyway, let's just return. 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 gives me random numbers between 30 and what? 999. But this is not the whole integer. So I need to come here and change maybe I want integer. So I do this. I say comma, right? And then option is what? True. So I go to true. I close my bracket and I enter. Now it's four numbers. Now one report that many people do is bins. The bin bins. Zero to this, this to that, this to that, this to that. So I want to create some bins. So the bins I want to do is this. I want to create ten bins. I want to create ten bins of data. So something, this to that, this to that, this to that bins. And then I want to now see the frequency of things that are coming in each bin. Okay? Now, if I come to this bin thing, I can say equals two. And I want to create ten bins. So I'm going to use a new function called sequence. Okay? It's a new, one of the new functions. How many have we mentioned so far? I don't see if I can quickly do that. Six. Right. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. Morning. So, rows is what? How many rows do we need? No, think about, we're creating bands. How many bands do we need? Ten. Ten, go to the cell up here, right? Ten, yes. So, how many columns? Zero to that, but actually we just have one column. So, let's say one comma. Starts. It will start from zero, obviously. Then comma, steps. Nine to nine. Ninety-nine, yes. So, if I come up here to ninety-nine, if you think about it, first I'm going to start at zero to something. The next one is 100. So, now we'll be right, we have to add one to it. Ninety-nine plus one. So, I close my project and I enter and it gives me a list. Can I see that? Right, pretty cool. So, I come to the next thing that I say equals to and I do another sequence, right? Sequence of what? Sequence of how many rows, same cell, right? And then comma, and how many columns? One. Come up, how many, what does it start? So, this one is zero to ninety-nine. So, it's going to start by this, I think, right? Then comma, steps. Ninety-nine. Yeah, it ends at ninety-nine. So, the next one will be what? Ninety-nine. The next one will be one ninety-nine. So, 100, perfect. See some mathematicians here. Nice. So, ninety-nine plus one. Close, bracket, enter. This sign means I'm up. All right, it looks fine. I think, yeah? Perfect. So, now, come here and we'll say, okay, no, we want the bits to be only five. Five, it releases. Perfect. So, it's now the bits to be twenty. Yeah. Okay? Yeah. It's so simple, it's like 30. 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 this names of the states. I want it to show me the names of the states between zero and ninety-nine. So, it should show something like this. Lagos, maybe comma, abudra comma, hoyo comma, like that. Just list out those that fall into those brackets. Now, this is a bit more complicated. So, in Excel, you know what to do. You will say if, if, for example, yeah, if a logical test. Okay, so the logical test is, normally you say if this set is greater than that set. So, on the inside of that, I'm going to come to this set 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. Tests. So, tests means oneself. What you have given it is spill. Which means I'm testing plenty things. In bold Excel, it will never work. To give you an error and you need to know that you need to highlight the range. The formula for what you're about to do is like this. Now, let's see. So anyway, this hashting, we're checking in to see if it is a greater than, I think, greater than what? Yeah, so maybe, no, greater than people to maybe this self. Right? Yeah, okay, that's true. It's greater than or equal to the whole thing, isn't it? No, it's only one thing. It's only oneself. So, let's just, we need to lock this. This is old Excel we're using now. Old Excel, so I'll lock that. Should we lock this too? Maybe it seems like dragging it down. We should probably, I'm going to write this in the old Excel way. So, I'm using old Excel and new Excel. Sorry guys, we're almost done. I know this is so strange for you but F2, I'm going to lock F4. F4, F4. F4, F4, F4. Okay, so this is our first test. Well, we have two tests. In old Excel, you say and. You don't bother your and will not work. And it's not going to work. There's something about the new Excel and the and and some, I can't start explaining the technical reason why it will work. So the way it will work is if you put a bracket around this first argument or logic and multiply it, then we multiply it by the new logic, the next one, which will be the same cell, which I do F4. F4, F4, F4. And I put a hash to make it still. Is it? Yes. So the same thing, but this time what? Equal to what? This is all right? Yes. Yeah, I need to just lock it. Yeah, I need to lock it. That's right. 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? Yes. What do I do to make it still? You see? Yes, a very hash. Very hash. Do you want to make a G9? Yeah, I don't need. So G, what we did is we locked the column. I want you to 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, 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 enter. Just watch. There's going to be a small problem. Right. I want you to explain the problem. Anybody can explain the problem. So what I've just done is I've said what is inside 0 to 99? If you check this list, what are the two states? Cross river and... Cross river and... So it has done the answer for 1, 0 to 99. And it spilled it. The 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 some. Some is an aggregator. Average is an aggregator. Say average, plenty things. One answer. Some, plenty things. One answer. Right. 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 office with this file. We're going to use text job. Yeah. 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? I'll see. Give me time. Give me time. So give me time means what you're separating this into. 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. Yeah. Common. Now, this five. Let me put this space before it. And this space after it. Right. So the next thing you ask for is ignore empty. What does that mean? Yes. It should ignore. Ignore empty. Ignore empty. Ignore empty. And then can you see the next thing? Text one. Well, it's not text one. I want this one funny togetherness. Well, hopefully it will work. So let's see. Is it only federal capital? Let's check. Let's increase the bin size. 250. So the bin sizes are bigger. Interesting. Right. I come here. I come here. It's the edge. And I double click. Right. Yes. Would concatenate have done it? No. No. That's it. Concatenate won't give you the concatenate and use. So concatenate is an old function. And let me show you something about those funny functions. Look at this. See concatenate, right? Any function, guys. Any function you see a yellow mark. It means it's to be placed out. Yes. It means to be placed out. And it means there's a new function that replace it. So what replace concatenate is concat. It's something called concat. Yeah. So our text is more popular. So this is the end of my demo, guys. Excel has changed. And there are many things here. Go to the format. Funny looking format. 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 is the format setting cost. Let me just quickly show you that. Why don't you use data validation in this new thing? You don't need to put that. So it's going to take a while for those who have built plenty of arrays. Right? So this is the end of the demo side, guys. It was a lot. Was it hard? We're just looking at this. I'll show you one year ahead. Right? Boy, it's amazing. 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, you can't just give me a second. I'm just going to type legal here, right? Well, no, legal doesn't have anything. You may state that you know what their plans are. But they are state. Let's say market. No, market. Line of business. I don't know what line of business is. Trading. What's that? I like that. OK, pass. Yeah, very right. Pass, pass, pass. Where are we? From the bottom right. OK, pass. Right? Pass, pass, pass. Let's see. I think the details are combined to where? First of April. 2015. First of April. Perfect, perfect, perfect. So let's say I want data from first of April 2014 to, I don't know, 30th of June 2014. Right. Now, this is cool. 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 off. Yeah, in fact, it's the same as if people take it off. The question I'm going to do is that when it goes to sign, I need the entire headings of this. Sorry, we had it. Yes. Now, I come here and I highlight this. I like, I don't know, I want one. I want those headings. No, it looks like headings. Not one, one. That would be good. I don't know. Headings, 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's spills. So anytime in the new Excel, time equals to a highlighted range, it's spilled. 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. The most powerful of all the new functions is filtered. This guy is crazy. Yes? And you know about crazy people, they don't like shouting. See how many arguments the guy has? Is it three? Three, I know. It's just crazy. So this one, I know the entire table is called sales. I'm just going to 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 markets, right? So I want you to give me sales markets. Sales dot. No, in this square market that is used in this thing. This is tableware. Sales markets, right? Sales markets, that is what? Sales market, that is equal to what? Abbey. Abbey, right? Let me just close this. Right? Let's just enter. Magic. Magic. Absolutely magic. So, you obviously know what's next. But you know what I'm going to say? Okay, no, it's not just this, right? It's what? Let me tell you to, I don't know what I'm going to do. And as I told you, and won't work, so the trick is to use a lot. Use multiply, multiply is like the end operator. So I say multiply. And I say again, I want a sales table that is sales, sales s. This square bracket, now we're looking for paths. Where's paths? Line of business. And then close the square bracket. That is also what equal to this guy. And I close my bracket. And close for field timing. Yeah, so I enter. Now, if you check the paths, it's only paths. Then this column is supposed to be dates, so I guess I like it and maybe format it as a big control sheet. What? Or a control sheet 3 to make it a date format. Yes, control sheet 3. It's actually control hash. It's hash variable. So that's it. So I won't do the rest. The rest is simply dates. I want you to give me sales. Dates is greater than or equal to start date. Comma, sales, this is less than. And you just build your table, your table continues 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 the same card is the new error message. That says this thing does not exist. It doesn't exist in your database. So please go and think of something else. Right? We did that one last time. Sorry. So data. Let's pretend that Lagos has what? Paths. So I can change data to paths. Now, since it has paths, hopefully it will not give me an error where I will. 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 very much. Sorry. Questions? Just let them change. So three questions. Let's go on live and watch the video. Let's go on live and watch the video. Okay. So, again, It's one thing to come to events like this. It's something that has happened to the phase. It's something that has happened to the phase. Oh, okay, I got it. One thing to come to events like this. One thing to come to events like this. to events like this, and learning is kind of difficult. But I've noticed that it's when I haven't come to my place, deadline, and I'm about to move my head. Yes. I've been like, yes. I grew up tonight, and I'm going to go to my place and get it to you, and I'll see you in a minute. But you know, where can we pay the quality of people to you? Yes, unlike it, it's not excellent. There's some problems with that as it's yours. So, quick, excellent, thank you for the question. I'll just take me to the next thing I want to say. We need to form a, we need all to join this program, because I really need to be more active in this. We are using it, right? Because what I'm working on is we should do monthly, there are not talks like this, but monthly labs. So monthly labs, when you come with your computer, and then we agree in the group what's the case study that you're going to be, maybe it's really your job, your work, but it will give you all the sensitive information. And then so if you're going to work on this, I'm going to do part for it in this lab, to come. Somebody volunteers as an expert part where it comes and teaches part where it comes. The next one, we're going to build a data model for Power BI. 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 it Power BI model for another month. So if we are 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 will 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 have a target for two MPPs by next year, clear 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 think and you do? Just shout it out. Shout it out. Three. Three. Anyone more than three? Not your colleagues. Not your colleagues. Any of one higher than three? Three. Four. Four. Four. It's not your colleagues. Four. Four. Six. I see you. Six. Wow. Okay. Who can beat six? Who can beat six? Can I introduce you? That means five, right? Well, it can't be six. Okay. Sorry, I'm putting you on the spot. Can you stand on it? You added me. No, it doesn't work. You said five. So we'll have some more competition. We're winning the last prize and then we're going to close. So we're going to continue the conversation online. Please join the group, please. Join the group, and I won't have said, isn't that valuable for all of us? Please, just if you join the group, let's start the conversation. So can we start our three competition and you get the winning prize? The competition simply means name the five people. Introduce the five people. All you need to do is introduce their name and at least you've tried your name. And you've got me in just one sentence. What about you? Okay. Sorry. Which year? Okay, which year? Who is which year? What? Okay. Okay, okay, which year? Then who? I know your name, Bob. Victoria, sorry. That's a qualify, sorry. Victoria. Yeah, where are you guys? Princess. Princess, please. The camera guy here, okay? Everything. I mean, you just can't hear it. You don't agree with your name? It's fine. That's four. Four? Can't be. Can't be. Who's can be? Are you a can be? You know, if you just get something, right? You know, if you just get something, right? Then, then, I don't know. I don't know. That's not your name. Okay. Okay, five. Can't you try? You can try, try. Just wait, just wait. Yeah, sorry. Can you? Can you? Why he mentioned the one who comes in? Yes, okay, yes, okay. Sorry, continue, okay. Can you? Are you a bummy? Are you a bummy? Yeah, I'm a bummy. Oh, nice. George. George, recently developing the princess. Princess. Chee. Chee. Oh, Chee. Oh, he's a smart boy. I don't think I'm a smart boy. I don't think I'm a smart boy. Sorry, I'm not a smart boy. He has like, did he grow up? No. No. No, no, no. No, no, no. Okay, so guess what? Both of them are getting it right. They're getting the both too. They're getting that both. Wow. Wow. Yes, yes, yes. Welcome, welcome, welcome. Please read it, it's very heavy. Thank you. Yes, yes. Thank you very much. So everybody, thank you very much for coming. And we hope that we online work with you again. 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, what's it called? Angola. Angola. What we need is this. We need volunteers for space. So they 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 has a column of 200 group. So say, okay, we volunteer space. Oh, I'm volunteering my time already. Volunteer my time. Someone says, okay, K3 and 30 people, 10, 15, 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. Okay? So we see online. Thank you very much everybody. Take a picture, take a picture. Let's take a picture. If you can sit down, you can sit down.