 Hello everybody, and let's say hi to you. This is Excel and Power BI webinars from D Brown Consulting. I hope everyone's here. Just put your hands up. If you can hear me, click, click. I think I can see people stepping into the room. Please close the door behind you when you get in. So this is welcome to our business intelligence webinar. Today we're going to talk about business intelligence with Microsoft Cortana. So what is Cortana? That's what we're going to talk about today. So I can see a request. So if you have a request, you want to say hello. I'd like to say at least hello to one or two people before we start. So if you could just put your hands up, just click on the hand tool so that I can activate the speech. So we could say hello. So I'm David. I'll be taking you to on this webinar on business intelligence with Microsoft Cortana. So I just want to explain what Cortana is and how it affects Power BI and how it kind of enhances Power BI. So that's what we'll be talking about today. So as I said, I'm David. I'm the founder and managing partner of D Brown Consulting. I'm also a consultant to the World Bank and I've been using Excel and all the related technologies for more than 20 years. And Power BI is such a wonderful addition to Excel. And yes, when I say Excel, yes, Power BI is in Excel and it's also Power BI desktop and it's also in separate service. But all the technology of Power BI was built on Excel to use Excel. It's called Power Pivot in Excel, Power Query, there's Power View, there's Power Maps. There's also some Power Power tools in Excel currently. And that technology is also in Power BI and that's Power BI desktop. So today we'll be using mostly Power BI desktop to do the demo. But everything you do, you build a model in Power BI, it's actually the same thing in Excel. Except for what we're going to do today called Q&A. So a little bit about us, the sponsors of this talk is D Brown Consulting. And D Brown Consulting, we do three main things, training, consulting, and payroll. But our focus is on the analysts. So everything we do is focused around the analysts. Who is the analyst? You have a reporting analyst, data analyst, financial analyst, sales analyst, anything analyst. We have analysts in your name. We have a course for you or we have a solution for you. And I would like you guys to pop over to officetraininghub.com. That's our online training hub. And there you'd be able to do some free courses. We have free courses in Excel. We're soon going to have a free course in PowerPoint and free course in Word. And we probably have also a free course in Power BI soon. And of course there are other paid courses, but you could at least enjoy the free ones now. And that's officetraininghub.com. Right. These are our partners. We have a partner on Microsoft and we also partner financial modeling Institute for those that like modeling or those that do modeling. There's another webinar that starts at 11 o'clock today. So that's just purely on financial modeling. So we're going to be talking about debt today as 11 o'clock today. So if you're interested, just type in the chat and someone will be able to type a link for you to register for the modeling webinar, which comes after this one. And also we have partners on Microsoft and the data analytics partners and also partner with ATD, ATDB in association for talent development. For those that like talent development or HR and L and D stuff. We also have another webinar starting at 2 o'clock today. That's talking about talent development. So quite a few webinars today. All right. So those are our sponsors for courses. These are the courses we do at D Brown Consulting. These are the classroom courses. We do business intelligence, Excel for business, financial analysis, Office 365 and financial modeling. So those are our core. And if you look at them, you see that every single course is required by the analysts. That's why we say we are the analyst training hub. So that's us. Another thing we do of course is our online courses and our online courses on office training hub.com. So if you pop on over there, you would see our online courses. We have a competency model for analysts, a very detailed competency model. If you're interested in that, send us an email. We'll send you the competency model. That means, okay, what should an analyst know? What are the things an analyst should know? We have eight pillars and analysts should kind of cover his knowledge of skills should cover eight pillars. You can send you that if you want. Just pop us an email at training at D Brown Consulting.net and we'll send you the competency model. You can send that to your HR or L and D. Right. Super. So I think we can get started. What is Cortana Power BI and Cortana? How do they work together? Q and A in Power BI desktop, which is kind of a bit like machine learning and intelligence. Then we'll do a demo on Power BI desktop. We'll look at the same thing online and see how that works. Then we do another demo on the exceptions to the rule of this part, Q and A. Q and A, when Q and A doesn't really work the way it should, there's something called synonyms. We should train the system to understand that something is also called something else. Synonyms is like doing some grammar lessons for Power BI. We give it some small grammar lessons. Then a revenue for April updates. So review of our April updates for Power BI. What exactly did Power BI do in April? What are the updates for April and then how you can sign up for our Power BI course in May? So those are the things we have. Excellent. So let's get started. But before we do, I would like to know exactly how many people here even know what Cortana means. So can you answer this question? So I have a question on the poll. Have you used Cortana before? Okay. Quite a few. This says 100% of us here have used Cortana. That's interesting. So we have a very educated field here. That's cool. All right. Let me see. All right. So if you've all used Cortana, let's ask you another question. Let's reset the poll. So what modern Excel tools do you use regularly? What are the modern tools you use regularly? Power Pivot, do you use Power Query? Do you use Power View? Do you use Power Maps? Do you use none of the above? So these are all the power tools. Power Pivot, Power Query, Power View, Power Maps and none of the above basically you don't use any of them. Now for those that use Office 365, there's quite a lot of updates to Excel as well. I'll probably show you one or two if we have time. But let's move on to the slides. So let's just keep moving on. So what exactly is Cortana? I'm sure some of us that have Apple iPhones, we have something called Siri. So Siri is, I mean, Siri is supposed to be your assistant. Let me see if I can get Siri up here. So let me ask Siri a question. Let me see. What is Cortana? I'm asking Siri actually this question. Let's see if you can hear what Siri has to say. Yeah, Siri, what is Cortana? Let's ask Siri what's Cortana. I thought so. Oh, she thought so. So this is me talking to Siri. I want to ask Siri. So I'm asking some machine learning algorithms. What another machine learning algorithm is. So let's see what Siri has to say. Siri, what is Cortana? Here's what I got. Yeah, read it. Siri, I don't think Siri. That's Apple and Microsoft are not really talking that much. So Siri, instead of Siri talking and telling me exactly what Cortana is, Siri decided to send me a kind of a list from the internet saying Cortana is a virtual assistant created by Microsoft for Windows 10, Windows 10 mobile and Windows 10 phone. And it invokes a smart speaker, Microsoft's band, Xbox, Windows, Mixed Reality, Amazon Alexa. And soon it will actually invoke Amazon Alexa. And Alexa is Amazon's own Siri, Amazon's own Cortana and Apple's own Cortana. Apple's own Siri. So all these are kind of AI and assistants and they all use AI and machine learning. So yeah, that's what Siri told me Cortana is, which is kind of straight to the point. That's true. So Cortana is a virtual assistant that kind of sets reminders, recognizes natural voice without keyboard input and can answer questions using information from the Bing search engine. So that's what Cortana really is, which is cool, not bad at all. So let's even see something else. What else can we hear about Cortana? So let me play you this video. Let's play. Hey Cortana, play my show playlist. Playing chill. Will I need an umbrella for my day tonight? That's probably not necessary. What's my day look like? When's my meeting with the investors? Remind me to go to the jewelry store on Saturday. Okay. What time does the sunset in Dominica? Sunset in Dominica is at 6.01 p.m. Anniversary is June 6th. Sure thing. So that was Cortana. And that's Microsoft Cortana. I'll send you the link to that if you want to watch that again. So yes, is that assistant? So we just talk and it works. I mean, if you see Elon Musk and his cars as well, I mean, you don't need to do anything. The car just works. So it's as if we're making all humans disabled, right? Disabled, we just need to talk. But no, this is just technology getting better and better. And one nice thing is this is going to work with Power BI. So it currently does already, but soon you'll be able to do something. What's the total sales for whatever and Cortana will go to Power BI and actually ask Power BI those information. So you say Cortana, what was the total sales last yesterday compared to last year, same period last year. And Cortana goes to Power BI gets that information and shows you that information on your laptop or wherever else you wanted to show you. So that's where the technology is leading and that's why Microsoft is really way high up there when it comes to the Gartner report. I'll talk about the Gartner report in a minute. So here you could say, I'm Cortana, ask me a question and you could say what set reminders for times, places and people use natural language searches for files on your system identify a song, search the web with Google or even Bing really instead of and then or another search engine which is Bing. Bing is the default search engine for Microsoft perform calculations and conversions, track flights, find facts, check the weather, get directions, set alarms, launch programs, send emails, create calendars and events and chat. So it's good if you download and start using Cortana you have Office 365 and start getting used to using it and it's quite cool. I mean you go and read a little bit of stuff about Alexa which is the Google, Amazon has, Google has, Apple has Microsoft have so it's and all these systems will be talking to each other. Cortana will talk to Alexa, Alexa will also talk to Siri. So it's getting more and more interesting. Yeah, but if you also read about AI, there's some fears or AI by Elon Musk and some other people like that is also good to know what are the dangers of this technology but the fact is once the technology is in good hands like Microsoft, at least you know they're being used well but others could get a hold of it, right? But not being a prophet of doom but it's also good to know what are the negatives of this and try and avoid them especially when you're in your business as well. So Power BI and Cortana. What do we expect for Power BI and Cortana? So as I mentioned already is kind of a simple thing you talk to Cortana, you ask Cortana a question. Cortana now has that link to Power BI and basically asks the question to Power BI or most likely types the question in something like Q&A to Power BI and once it types the question as Q&A to Power BI then of course your reports now come out and you see your reports. So that's going to be the link. It's going to be seamless. So you could basically say you're talking to your system and it's bringing out your reports in Power BI but the link is Cortana. And this is happening now. This is already up and running and it's just going to get better and better and better. As Cortana learns you understand what you want. You probably at the point is you probably know what you want before you do because of routines. So that's cool. Now if you look at the latest Gartner report now the Gartner report they're a research company that evaluates many things, many IT related stuff. So this is their own report on BI and if you look at it to the left, if you look to the left and going up from the left is the ability to execute. How good are these products in execution? And then from the left going to the right is completeness of vision. Do they have their vision? Is it very clear? So for those that kind of have a little, the execution is not as good and their vision is not fully formed. That's the box to the bottom left, bottom left box. And you could see names that you could know. Oracle is there, who else could you know? Locker, Information Builder, well. So those guys have quite a bit to do. They call them the niche players. The challengers are the ones that have a very good execution but the vision is not fully formed. Micro strategy is there. The bottom right are those whose vision is pretty clear but execution is not as good. So SAS is there. I'm sure you know Salesforce. But then the real big players, the top guys are the leaders. The leaders are the ones who execute well. That's going from bottom to top and also have good vision. Their vision for what it is they plan for the future is very clear. And you can see Microsoft's vision is completely formed, almost completely formed because it Microsoft's right to the right-hand side. And Tableau, which is then the biggest competitor, is vision is not as clear as Microsoft but the execution is kind of similar, a little notch higher but Microsoft's execution is also excellent and this is all Power BI. So you could replace Microsoft with Power BI. And for me, really working with Excel for like 22 years, Power BI is just amazing because one of the missing pieces for me is when you do this wonderful report in Excel, how do you share this report with your audience? How do you share it? Most people share by email. So what ends up happening in your organization is you have thousands and thousands of Excel files all over the place. If your IT, I always tell IT this, that if your IT does a star.xls search on your entire office database, they will see probably 100,000 files Excel, which means this 100,000 versions of the truth all over the place. It's not good to share documents that way because send an email to 10 people. That means 10 people have 10 Excel files. Then those 10 people kind of do some amendments and create another 10 Excel files. So which one is the latest? So what you should do, try and get this as a practice, don't share Excel files by email. Instead, publish your Excel file on Power BI.com. So when you publish it on Power BI.com, any updates you make to that file will be updated on Power BI.com and everybody will get access to it. So that's how to work. To me that's the best way to work. Now with Q and A, that's just another ball game completely. With Q and A, what that means is you can ask Excel, you can ask Excel a question through Power BI or you can ask Power BI directly a question about your data model. So I'm not going to go through the data model. We're just going to do a demo. So I'm just going to go and ask Excel or ask Power BI a question through Q and A. So let's see how that works. So I'm going to quickly go into the demo for Power BI. Cool. So I'm going to share my screen and you'll see that I have Power BI up. One second. Let me just set that up. This is Power BI desktop. All right, guys. So here we have Power BI. So this is Power BI desktop. I know quite a few of us here already use these tools. I hope. Let me just quickly check with you guys. How many of us here know about this tool? So I know how deep I should go. So what I would like to know is what business intelligence tools do you currently use before I continue this demo? Can you answer this question what business intelligence tools do you use currently? All right. So it seems like quite a few of us here use Power BI and Power Pivot. So we have quite an educated field here, which is excellent. So if you look at this, so I have a data model. That means you guys know already what a data model is. So let's have a look at it. All right. So if I go to my view, if I go to modeling you have your, of course your home tab, your view tab, your modeling tab, and then your help tab. That's typical. Now they've added a few stuff here for April, but let's go to the actual relationship view. So if you check the relationship view, just to have a look at the data model and understand our data model. Let's do that. Click there. So this is our data model. I have my line of business files, my model, this is just a model code and model name, the store list of stores. If I go to the table here, you could see store. Let's see what it looks like. So we have store key, store itself, the market, and then we have region. So the store key is obviously very important. If you know, we look up very well, the store, this is probably what you look up to try and get information in another table. You have your line of business. So I have my line of business code and I have my line of business itself, copier sales and printer sales, parts and sales service plan. Then let's see another table. I have model, the model, what's the model? Well, these are the products I'm selling. So this is the model code and this is the model name. So Xerox, Xerox ultra copy, HP LaserJet, printer repair. So these are all the products that I sell. Right. And then of course, we have a calendar. It's very important you have a calendar. For those that know Power Pivot or Power BI in general, you need to use a calendar at all times, right? We need to use a calendar. Cool. So let's see that. Let me end the poll. You have about 63% of us use Power BI. 25% use Power Pivot and then others, 13% use others. So the 13% that use others, please move on to Power BI. Well, let's see. We'll show you a few stuff here to convince you. Yeah. So let's quickly get back to this. Okay. Cool. So here I am. And this is just my data. So this is my calendar. We need the calendar to do all sorts of analytics. So we have your data there and what do you do normally when you build a data model is you need to understand all the connections. So you're connecting your dimension files, which I have up here. You're connecting your dimension files to your fact file. Your fact file is where the data really resize the data that grows every day. Your sales data is in your fact file. So this is my fact file. And typically when you build a fact file, you have to build it pretty smart. So what we call the lowest granularity. You need to build it with the lowest granularity in mind. And what do I mean by that? So here I have revenue and then I have units sold. This is sales on a daily basis. The most important field I think is your dates. So this is your dates. You sold this in. And then this is the model. What did you sell? This is the product you sold. So this is the code for the product. That's model. Then we have line of business. Okay. So what line of business ID is this product? Now this may not be necessary because line of business, the model itself may tell you the line of business that is if it's a one to one relationship. That means if every time this model, this is the line of business, but sometimes a model can be used for different lines of business. So it's not a one to one relationship. So you have to have line of business as a separate line. Then store because he store ID. So these are the stores I sold. So this is the lowest granularity for geography for me. So based on my store, I could know, okay, this store is in one particular location. Let's say Abuja or, and then because we know it's in Abuja, that means it is in the north because we know it's in the north because it's in Nigeria and then it's in Africa. And that's how you get the lowest level of granularity for your store. Some people even go down to store address and then they go to local government and stuff. So that's geography. So this is your core. One key thing is when you're building a data model, try as much as possible to make your fact file as slim as possible. And don't have too many things there. So for example, this model, you don't need to have model name, model manager, just have model and then connect model to another table called the dimension file that will give you more details, which is what we have here. So this is our data model. Everybody connected to our fact file down here. Now if you notice our fact file has formula. So these are all our DAX. DAX is the language of Power BI. DAX is the language of Power Pivot. And if you want to be an excellent user of Power BI, you need to learn DAX. DAX is a very important language. Just take it like Excel. If you go to Excel, you need to learn formulas. You need to learn functions. And the nice thing about Microsoft is they made this thing almost close to Excel, kind of similar to Excel. So if you're building a formula in Excel and you're now building DAX, it's similar. It's similar. You have easy for you to transit. It's easier for you to understand how that works. So now if I come to my report, let's now see if we can do a report. Let's say I want to do a report on revenue. So a typical report, let's come to our visuals. We'll just do a simple report. I click on a chart. So this is my chart. And I want to do a report on revenue by state or let's say revenue by region. So I go to my fields here. I pick revenue. So I go to my fact file. Let me expand that a bit. So there's so many calculations we've done here. So let's say revenue sum. So revenue sum, okay, click that or click out. It gives me, I have to click on the visual. You want to click on the visual first and then you tick revenue sum. So that's revenue sum for the entire period. Let's slice it by something. Let's slice it by store. So store, we have region and store. So I'm going to tick region. And here we go. We have revenue sliced by region. Not bad. That's fine. So revenue slice by region. Okay. Well, what period is this? Well, we'll check, but let me change the visual. You can come here. I can click on the visual and then I can change it something else. Let's say I'm a tree map. I always like the stream app visual. So you decide, okay, what visual do I think is cool? But what about if I want to say, okay, revenue sum for what years do we have? Let's quickly glance at the years we have. What years of information? Let's say 2015. So now I want to say revenue sum for 2015. And I really don't want to create a chart. I just want to ask, I was just going to ask Power BI question, modeling. If you check out, sorry, your home tab, you'll see something called ask a question. So this is actually new. This came in, I think a month or two ago. You couldn't do this before. You couldn't ask Power BI desktop a question. You had to go online. You have to go to the online version to ask a question. Now you can ask the question directly at one Power BI desktop. So I click ask a question. That's one way to do it. And then you see this ask a question box to the bottom. That's one way to ask a question. Another way to ask a question if I delete this, I just double click, just double click the canvas. So let me minimize this so you can see bigger. Double click any white space in the canvas, double click. And it's ready to ask a question. So we said revenue. Let's just say revenue sum by region or 2015. So once we've done that, so I just said revenue sum by region for 2015, it came out and we can say maybe as a tree map. Let's see if that works. Wow. So look at that. So revenue sum 2015 as a tree map and it brings out our chart. So let's see, do we have 2014 data? Let's check 2014. As a tree map. Data is similar for 2015 and 2014. Not good for analytics. So that's how easy it is to just write a question. But then sometimes you run into a problem because for you, you know your model. So if I look at my model here, I know that whoever built this model decided to call sales revenue, right? So revenue is called revenue. So you have revenue sum, revenue sum last month. And as much as possible when you build your model and you're naming your DAX, try and name it very smartly. So don't just say revenue. So when you're using Q&A, Q&A understands what you're saying. So there's revenue year to date, revenue year to date, LI. What about if you don't want to use revenue, let's say, let's come here. Let's do another Q&A. Let me delete this. It's just delete, delete. So I want to do the same report, but instead of calling a revenue, somebody had called it sales. So I double click here and say sales. Sales by region. Sales by region for 2015. Now, unfortunately, nothing is happening. Why is nothing happening? Can you guys type in your chat? I like us to, any ideas? What's going on? Why isn't this working? Someone should tell me. So type in the chat. What do you think is going on here? Why isn't it working? So it isn't working because Q&A doesn't know what sales means. Q&A understands revenue, but it doesn't understand sales. So to make it more intelligent, so to say, we need to go and tell it that revenue is the same thing as sales. Right? We need to do that. So we need to just tell him, hey, revenue is kind of the same thing as sales guy. So please just use that. So let's say, okay, hold on a second. Let me minimize this. So here we have this. You can see I have some synonyms and some synonyms. I've typed out all sorts of synonyms here. So revenue, somebody else can call it total sales, can call it sales, can call it total sales. So we ask someone to give us all the synonyms, all the way people type out things. How do they type things out so that we can use the type, what they've typed in our report? So we need to train Power BI to understand that revenue, some is also total revenue, is also sales, is also total sales. How do we do that? Well, the way you do that is you come to the relationship view. You click on this relationship view to the left. You click on relationship view. And once you get to relationship view, under the modeling section, you have something called synonyms. So if I click synonyms, click on synonyms. So what synonyms does is first of all, you click on the visual, see this fact file, click on synonyms. So for fact file, I want synonyms for fact file. Now you can click on any of these tables and say kind of program the synonyms. Well, here I want to program synonyms for the fact file. So to the right, you will see a tab and synonyms. So I'll go down to, let's say revenue sum, and then I'll put a comma there and now start typing all the other names for revenue, like sales, total, sales, right? I put another comma. Let's say sales, sales, total. Let's even leave that. I've just put two synonyms, right? Total sales and sales total. So those are synonyms to revenue sum. Now if I come to my report and double click, and then I say total sales. Now it makes sense. Total sales by region. So you can imagine your manager, right? Your manager or your MD, all he wants to do is learn about this Q&A and he calls it sales. So just total sales by region, yeah? As a free map. Yeah, and that's it. Comes out. So synonyms are very key. So when you're planning your data model, when you're planning to build your Power BI reporting tool, make sure you understand all the different ways that people call this. Maybe do a survey. Do a survey in your company. How, what kind of reports? What are the different ways you name these things? Revenue. Like for example, transaction counts. I don't think people call things transaction counts. Let's go down to, I think there's somewhere where we count the transactions. Transaction counts. So we can say, let's just say quantity. No quantity, more customers. Customer purchases or, can someone tell me in the chat, I think is a good name for transaction count. We know what we mean by transaction count. Can you type a synonym you think you could use in the chat? So what do you think we should use? For synonyms for transaction counts. Let's just say, maybe just count. Count, let me even just say count. No, no, no. Count doesn't make sense. How many transactions do you have? Sales, walk-ins. Walk-in. Let's say walk-in. So I guess when there's a transaction, you saw somebody walked in, maybe. Number of repeat purchases. No repeat purchases. Repeat purchases is someone that bought and now came back to buy, but some people will just buy once. So transaction being that someone has walked in, there's a transaction. Accountants in the house. Give me some names. Some nice synonyms. Let's say walk-in. Let's see what walk-in does to our report. Let's come in here. Let me create another page here and just see. How many walk-ins? Walk-in for 2015. Let's see. So walk-in for 2015, we had 21,000 walk-ins. So 21,000 transactions. So synonyms are super, super excellent. And this will help Cortana understand your business more because of the synonyms now. So you could say, hey, how many walk-ins to our business? You don't need to remember that it's called transaction count. So this is a big, big game changer, really. It's amazing what this simple synonym stuff could do. So just any time you remember another synonym, come to the actual DAX and type one of the steps. You go to your relationship view. You click on this synonym icon and that's it. Now language-wise is mostly English. We speak, of course, English. And you have this linguistic schema. This is a more programmatic way of programming your synonyms. But I won't go into that. This synonyms button here is so much easier and quite simple. And that will help your Q&A be excellent. Really cool. All right. Any questions? Just jump, pop it on the chat. But that's really what I wanted to talk about today. Mostly is the synonyms, which is excellent. And you can do all your reporting. And we'll go online. Let me see if I can just quickly go online as well and show you this. How do we build this report? This is a waterfall chart. And we could build it with Power BI with Q&A quite easily. All you need to do, this is revenue, year on year, percentage, variance by year and month. So Power BI is not powerful. Revenue, year on year, performance, variance. So revenue, year on year, percentage, variance. So revenue, year on year, Y-O-Y, percentage, variance, that revenue. So you can go year on year, percentage, variance. I store 2015 as a waterfall, something like that. You'll get used to typing out all sorts of complex stuff like that to try and deliver or build reports. And then if you use synonyms very wisely, then you will be just as natural as someone asks for this. Your manager asks for this. Can you give me a blah, blah, blah, blah? That thing he said, go and create it as synonyms there. And your reports will come out. He probably won't need to ask you. He'll just type it himself. So let me show you something else very quickly. We have updates in April. So I'm just going to play a few minutes of it. And then I will close that. I'll just give you quite a quick few minutes. And what I advise you do is go to YouTube and be subscribed to Power BI channel on YouTube. Also subscribe to our own channel on YouTube as well. So in fact, let me tell you one thing you could also do. There is actually a training on this next month that we have in the Brown Consulting. Very, very cool course on Power BI. So it'll be nice if you can join us and learn a few things in the course. Let me pull that out for you. So it's, I'll first of all pull out the, there's a report to mission in modern Excel we have online. So report to the mission, become a master in report automation. So I'll just leave that offer up for you and you could click on it and join us next month. But let me quickly go online and see if I can see Power BI. Just go online to Power BI for you. One second, let's quickly get back to slides and then I'll go online and see Power BI online. All right guys, so this is our Pog group. I know quite a few of us haven't registered for this Pog group. So it'd be nice if you, if you can go. I know a lot of us were in the Meetup group, but the Pog group is a bit different. The Pog group allows you to at least get notification for all these webinars, as well as ask questions. So you can really ask questions and get answers on Power BI on our Pog group. So this is for Nigeria, especially for Nigeria. Let me type out the link for you on, on the chat so they can join the Pog group. So it's Power BI user group is www.pbiusergroup.com slash Lagos. So this for Lagos. So I want you guys to click on it and join. So if you check on the chat, you'll see pbiusergroup.com slash Lagos. So just join our Pog group and let's grow the Pog group and keep on asking any questions on Excel and Power BI you ever have. Just come here and ask it and we'll answer that for you. Now this is our online Power BI. I think I'm not sure if we've published this report yet, but this is Power BI online. And with Power BI online, of course you can still use Q&A. So you see this ask a question there. You could use that at any time to ask any question. So I could say the same sales by something and you get an ask a question on Q&A. So here again is revenue, right? So revenue and then the same thing you did in synonyms. You can do that as well online. So that's just a quick show. Revenue by, let's say revenue by what? Revenue by store, revenue by product. No, let's say by state. Okay, we don't have state in this database. Let's say revenue by customer. That's going to be a very big report. That's too many customers really. So revenue by customer, maybe revenue by customer city. Revenue by city. Customer city is coming up as a chart city. Let's just say revenue by city. It's going to come up as a map. And this is in the US and there's some revenue somewhere in Africa as well. So of course this is the Bing service pulling out a map. And so we can do all this in Power BI desktop as well. So I kind of prefer you build everything in Power BI desktop and then you now publish it online. So that's really, I think the way to go. Right. Excel users. Sorry. There's not much Excel for you today. It's mostly Power BI and Q and A is a key thing. Want to show you and also synonyms, how to use those synonyms. So anybody have any questions? Just type in the questions and then I'll answer one or two questions before we leave. So type on any question you have on the chat. And if you want to, I could actually release your mic for you. So prior to this, did you all know about Q and A as in how many of you knew about Q and A prior to this? But of course synonyms is new. So maybe you didn't know about synonyms. How many of us knew about Q and A in Power BI? You have a very intelligent group. Hello. What's dead was synonyms. So try out synonyms. I think synonyms are very powerful. So just try them out. Okay. Now everybody knew about it. Try synonyms synonyms. Very powerful. All right. Any other questions, questions for me? Nobody's asking me questions. I joined in our Power BI user group. And let me go online to our website. You'll see that we have Office Training Hub. You could do some free courses on Office Training Hub. So advise you do this free course here, especially those that like Excel. So if you go to officetraininghub.com, you'll see this free Excel course. Very powerful one. And for those doing financial modeling, you'll have another webinar in the next one hour. You could join us for that. And yeah. So go to officetraininghub.com. And then next month, we have Power BI, we have a Power BI training for you next month. And so if you pop us an email at train.debronconsulting.net, we have a three day Power BI course. So you come to our website. We go to training. You go to courses. So we have a Power BI course. Coming up in project business intelligence. It's a report and analytics in Power BI. That's our course on Power BI. So in three days, you learn how to build a data model. You learn some very cool DAX and stuff, but that's happening in May. We'll put that up for you immediately, but that's happening in May. So it's a three day course, detailed course on Power BI. Okay. So hope to see you then. So this is what you're going to learn in the Power BI course. And if you're using Power BI, this is what you need to know. You need to know Power Query. Power Query is like your best friend. Power Query gets the data for you and automates that process of updating that data, which is the most tedious thing in anybody's reporting repertoire. You get your data, you need to update it every month. So Power Query automate that for you. Then you would also learn, this is our course next month. So our course next month, starting on the fifth. So actually our course next month is from the seventh to the ninth. Next month, seventh to ninth of May. And that's our power reporting and analytics with Power BI. So you will also learn how to use the data model, build a data model. You will learn the M language. Yeah. So yeah, we're going to put the course online. Yeah. So send you that course, Timothy and evaluation context is very important thing called evaluation context. So if you, if you can take, you take a phone and take a picture of this screen. So if you're using Power BI, you need to know all these things. You need to know how to working with budget data, fact file, dimension files, Excel and Power BI. You need to know the linkages, their relationships, custom visuals, time intelligence formulas, variance formulas, anchor formulas, calculated columns, advanced concepts, dashboards, Power BI dot com, how to use it, the DAX language itself, calculate function, one of the most important functions in DAX is the calculate function. Standard visuals and the relationships. So these are all the skill sets you need to know to be able to use Power BI properly. And this is what you'll learn in the course next month. So join us next month and also go do our free courses online and watch out for all the free courses, additional free courses we're going to bring up. So guys, I hope you enjoyed this short webinar and we hope to see you in the financial modeling for those joining us and the talent development webinar later. So thank you very much guys and we'll see you soon.