 Good morning. Good afternoon and good evening everybody and welcome to another deep round consulting webinar series This is our webinar series on Excel and Power BI. We do this every third Thursday of the month from 9 a.m. To like 9 45 a.m. And Today we're going to be talking about top 10 Power BI updates in 2019 Quite a lot of updates in 2019 We're just trying to it's kind of difficult for us to go through and pick 10 So that's what we're going to talk about today top 10 power be a update in 2019 so let's get started. Let's jump right into it and Just a quick intro to me. I am David Brown. I'm the managing partner of the brown consulting I'm also an international consultant to the World Bank and a Microsoft MVP on data analytics So on the data platform. So this is this is me You can see my handle you can follow me on Twitter the brown analyst and you have all my videos on YouTube You can see that link there. So join me and let's just jump straight into it those updates for 2019 Well, you can also join our power be a user group because we have quite a lot of Resources online if you go to meet up.com go to meet up.com you can look at look us up as Nigeria modern Excel and power BI User group that's on meet up.com right you also have the financial modeling meet up group So if you just go to meet up.com, you can also just look for financial modeling so here we're more than 4,000 members now and it's growing and we do meet ups. We also have we also Managing the Nigerian modern excel and power be a user group on the power BI I'll go the power BI use groups on PBI user group comm slash Lagos So if you go www dot PBI user group comm Slash Lagos and that's where you get us. So that is the Nigerian modern excel and power be a user group great Just a quick word about our sponsors So we have deeper on consulting sponsoring this webinar and of course, this is a power be a user group Power be a user group webinar and as I said, it's every third Third Thursday of the month and we also actually have a live meet up every third Saturday of the month Yes, so live meet up different venues and stuff probably show you the link at the end of the webinar You can actually type in the chat and then we show you the link as well. We'll just share that link with you Great. So jumping straight in Top 10 power BI update in 2019 As I said, it was quite challenging to decide which top 10 was going to be the top 10 So we decided we're going to go every single month of updates So in January typically they don't do any updates in January And they start the update process in February So February let's jump straight in there. So this was February 2019 So this was what the updates that they had in February 2019 So reporting the updates to the new filter pane So the filter pane there was some really interesting updates more filter pane formatting and stuff like that Very good updates to the filter pane cross highlighting in single points In line charts cross highlighting to us. We think that was kind of the best we saw in February, so I'm going to quickly highlight that. There was also water up on titles Update default visual interaction to cross filter rounded corners for visual borders. That was very nice I always like rounded corners Analytics the key influencer visual was actually released that could have been the best But I'm going to leave that and just give you a sneak peek actually key influencer visuals Just something else is an AI visual Insight questions with Q and a another AI visual Auto-generated suggestion questions in Q and a explorer too many wonderful things in In in February. I think they just left all sorts of stuff to put in in February That was to start the year off with the bank kind of stuff So custom visuals there were some custom visuals released custom visuals quite a lot of custom visuals And then you had the data connectors every single month. They're lots of data connectors So solving monkey is one big one that was added in February 2019 So quite a lot of updates in in in February. So what did we pick? So in the February we picked Cross highlighting in a single point in a line chart. What do we mean by that cross highlighting a single point in a line chart? So that's what we picked for February And here it is if you have a line chart just Create a typical line chart. Yeah, just create a typical line chart And what that means is if you look at this dot, we can now click on that dot and it cross highlights everything So for this particular dot in March where the revenue was about 8.4 billion You can cross highlight just that dot and like clicking March. So you don't need to have a visual You don't need to have January to December as a slicer. You could actually go into the chart and kind of slice by point Point by point and it's going to slice by month Of course, if you click it again, it just goes off. You click it once it goes on click it again and then of course you could have your Different visuals that you put on the slicer. So you you have your tool tips So those tool tips if I come to this visualization here if I click on this visual And then I click on here you would see tool tips tool tips is on And tool tips are able to show that tip of a revenue sum, right? So you could click here And just click up here and you have the visuals you can drop more things into this tool tip Section and then you could have more context for various tools, right? Various visuals very cool very cool stuff. So that was February. That's our pick for February. What about March? So in March March 2019 another set of updates We had a single select slicer single select slicer. You had heat map supports for big maps. You have cross highlighting Small filter pane improvements and then analytics Q&A recommendations for improving results Show dates as a hierarchy now generally available They kind of released that the year before but it was in beta form So quite a lot of updates right pdp in pdf connector now supporting tables spanning multiple pages This is this was big. This was really big But we had to pick one right so pdf connector, I mean you could you could Use pds data and pdfs and he could use power bi to connect to those data. It's really wonderful stuff in March So what did we pick for March? What did we pick? We picked single select slicer, right single select slicer Yes, and oh, what does that mean? What does single select slicer mean? So typically when you have a slicer here, look at this you can click on north Northwest right and you see everything kind of filtered to northwest and here you could do multi selects You could click a hold your control key And click to do multi select. So this is like a multi selecting But sometimes you don't want your users to have that option at all. You just want them to do single select So what you do if I click on this visual, which is a simple typical slice of visual I'll come in here come into this Come into the formatting then under selection controls. They added this button here called single select So this single select here if you click on this single select You'll see that we can now just click one at a time. Just a single select, right? So if I remove that single select, then you could do your multi select And in the multi select actually here you have multi select with control, you know I held the control key you can actually switch that off So they can't do multi select with control is the tick So you just tick tick tick for multi select which kind of is better instead of control, right? So you could use control or not control show select all option So if I click on that select all option, you have that select all option. I click select all right Or not so just a bit like excel, isn't it? So I kind of like the single select so single select This just makes kind of forces you to only select one at a time So it depends on how you want to do your reports. It just gives us various options for our slicer So this slicer you could decide a single select multi select multi select to control multi select with No control all sorts of stuff really good stuff. So that was our pick for March Let's see. What did April have to offer? So April a lot a lot of stuff on April this analytics you have drilled through across reports This was really good, but he had key influencer visual now supporting continuous analysis for numeric targets key influencer Again, it's a huge resource another AI visual quite a lot of stuff here Filter pain was a big one filter pain improvements. So lots and lots of improvements on filter pain We just have to give it to filter pain filter pain was just superb filter training improvements if I go to the april Get the april. Let's see. I'm going to pick Okay, let's see. What was this this a renegade some renegade visual here. So let me just delete that Okay, so if I come into april supporting the filters, so you have filter pain What was that they they actually improved the filter come to view here You can't see the filter pain here have to go to view and then I can click on this filter pain. So Quite a lot of improvements to the filter pain in that month. Let's let's recap. So what were the improvements? They had filter pain improvements included support for full filter pain editing You had ability to rename filters filter pain scales with the report page Restrict of the restrict ability to change filter types improve filter pain accessibility. So Those were all the improvements. So if you look at the filter pain here We could drag this is filter on this page filter on all pages You could drag stuff there. So I could say okay come I want to filter Right now I have my regions here. This is my regions. I could decide, do you know what? Let's bring regions in if I take my store D store. I'm going to pick regions and drop it in here So filter this page by region Click there So filter this page by region if I pick north central You'll see that it filters the report. So it's just north central here I can so I can decide, you know what? I'm going to pick this north central And I'm going to lock it. You can see that I'm going to lock it here. So I'm locking it And that way if I click this and I hide my filters So I've kind of locked it in and that's just north central. Nothing anyone can do about it, right? So if I if I come back, how do I get my filter back? You come into view And you pick the filter Then you come here And I can unlock it. But if I click on this Let's say north and north central and lock or I can just unlock it to allow people to edit, right? Basic filters advanced filters and the other thing I can see filter on all pages. I can decide, you know, I'm going to take this And you're going to drop it here. Let me just kind of Bring it take it out and let's come and take maybe Let's say model Let's take model name and put it here So what this means is that this filter is on all pages So that means every single page here is going to be affected by this almost like a universal filter, right? So if I click on ad hoc services So if I go to another sheet, maybe or another page and I call it sheet or like excel so another page, let's say February ad hoc services So it's technically filtered by ad hoc services, right? That's what it means is ad hoc services Yeah, look at that So this ad hoc services affects every single page. So once you click it, it just affects every page And that's that's filtered. So quite a lot of updates for filter This filter pain in editing and improvements were really good in april. So that's what wins our Our best update for april Great. So what about may so what happened in may so what do you guys think of the update so far? Which do you prefer type it in the chat type it in the chat. Let me recap so we had In february The february update was cross highlighting on a single point Single point cross highlighting, right? That means I can go to my chart and pick a single point and it will kind of cross highlight the entire Report right cross highlight the entire report really cool. So that was february March we saw that we picked single select slicer, right single select slicer Being that you could come here and change your slicer from what it was multi-select before you come in here You click on selection control And then you switch on single select. Yeah, this was single selector. They added in there, right? Previously it was multi-select and I can see multi-selected control I hold my control key. So it depends on your users what your users want, right? So which do you prefer of the two? So I've just shown you this too which you have the Point on your line chat that you can select Or the single point on your slicer that you can select Or in april the big improvements to the filter pane out of these three type in the chat, which you think Works best or which you think was the best. I think the filter the improvements of filter were really really cool all right, so that april that's like Technically first quarter all this one month after after first quarter the first three months So let's see what happened in me. What happened in me? So in may these are the things that happened. We had performance analyzer pane. Now, this is big performance analyzer Even though it didn't pick it. I think it's worth a mention performance analyzer pane was huge This is it here if I go to view now if I click this drop down here, this is how I used to look before You also these are improvements to the ui So if I click on the performance analyzer, I know it wasn't chosen It's not part of analysis But you could click on start recording and then analyze how what the what's the performance or power bi right? What's the performance? How well Is is it doing what it should be doing right? How well is it running this visual? So you see all this analysis on how quickly these visuals run right you click on text box You see okay this visual how it ran it ran pretty well Let's see text box doesn't have any any DAX if I click on this one, right if I click on this, let's see how this Analyze let's check a line chart. So if I click on this line chart, you can see it has some DAX The DAX took 29 milliseconds. Very tiny If I click on the copy query I'll be able to copy whatever the DAX query is and go past it somewhere and check it out This is cool. This is big performance analyzer Well, we didn't pick it. We had to vote right so we didn't really pick it performance analyzer, but please check it out So, what did we pick? What did we pick? So that was our may right? What did we pick for the may updates? Let me close performance analyzer minimize this minimize this So these are all the updates. I love performance analyzer. It's extremely good when you're deploying a power bi We're doing a deployment a power bi deployment Yeah, it's it really shows you what is making things slow How do we improve our DAX? Right. What about the filter pane improvements sorting filter cards theme supports with continuous improvements in filter panes table and matrix keyboard navigation line data label position control kpi visual indicator text size control Analytics key influencer visual improvements. These were really big improvements. Binning support formatting options mobile support Then modeling updates to the all selected DAX function. I think we had to update certain things that probably we're not working too well Visualizations always good new and better and better visualizations and data connections more data connection connectors So out of here, we chose the key influencer visual So we chose a clean influencer visual and that was our main top visual for that month key influencer visual formatting options So if I go to may Demo, what is the key influencer visual? Well, let's see. What is influencing certain metrics in your data? Key influencer is actually an AI visual. This is it here As you look at it here key influencer if I click on it So this is key influencer visual. Let me just make it big here So this does a lot of regression, right? If you like statistics, you will love this because it goes through all your data and tries to explain things Very important visual. So if I come let's bring in some data. Let's click on this. Let's see And what I want to analyze. Let's say I'm analyzing budget variants, right budget variants So here I just selected a Metric I just selected a metric called budget variance. So see what the key influencer visual did. I just take this Say is what influences budget variants to increase or decrease, right? What influences budget variants to increase or decrease? So let me choose a decrease So what influences budget variants to decrease great And of course there's no data here. So let's pick some things. Let's pick something. Let's say What influences to increase for Let's put some dates. Let's put large data and say dates where it's a date I don't want to group these dates. I'm just going to date itself. Just the date Let's say store, let's say region, let's say state Let's say So you see right now it's not analyzing anything because there's not enough data You need a lot of data for it to analyze. I'm going to put store name as well So it's is gathering all the data and just like statistics you need A critical mass of data for it to really do some analysis that makes sense So I put region state and store name. Let me add some more data. Let's say Model name, right? Okay. That seems to be enough for now. Good. So you see so I've analyzed I've added I want to know what influences budget variants to decrease Yeah, so budget variance to decrease the budgets and actual budget variance to decrease From region state store and model And what did it come up with it says? When the average of budget variance decreases by 7.59 or when the model name is General repairs, okay? So When the model name is general repairs the average of budget variance decreases by 7.59 So just model. So this This is general repair. So general repair seems to be Where the major increase decreases in in budget variances are coming from, right? All right, it's interesting So if I click this then you see further analysis here budget variances So it breaks it down into bins. So what the updates they did is Binning things that they kind of increased or improved the way they could bin things Okay If I click on only show values that are influencers. So these are the main influencers general repairs Motherboards printer repairs on this and yeah, so we could go a step further and go to top segments What are the top segments that are really influences? So you have segment one You have the average of budget variance in the population count So 98.53 percent on the segment one if I click in segment one, it's up to see what that's all about So you can now see some more analysis about segment one and the overall performance And segment one contains 124 data points 13.9 of the entire data In segment one the average budget variance is 98.53 negative This is 6.54 units lower than the overall average variance Okay, so If it's what when a budget variance more likely to be lowered about high when is budget variance more likely to be high Right, let's see that so it's running the analysis going to and doing the same regression again doing it all from scratch again And this doesn't look too interesting. Let's go back to key influencer And I say, okay, what influences budget variance to increase let's say decrease right less influences it to decrease Let's see what influences to decrease quite a lot more things And he sees analyzing there. So we could you could be on this for all all day I mean, there's so much interesting stuff going on there. We don't have that much time. So let's move on So that was our may update right our may update So the may update just to recap by click on this hopefully it comes up It's coming up. Don't crash on me, please. Right. This is quite a heavy file. So It's kind of dragging. Okay. So those are your performance analyzer And what we picked was the key influencer visual improvements, right? That was our me. That was our may updates So what about june? What's happened in june? Let's quickly jump into june June june updates. What can what can we say about june? So june formatting options? So if I go to may Demo, what is the key influencer visual? Well, let's see. What is influencing certain metrics in your data? Key influencer is actually an AI visual This is it here as look at it here key influencer So I click on it. So this is key influencer visual. Let me just make it big here So this does a lot of regression, right? If you like statistics, you will love this because it goes through all your data and tries to explain things Very important visual. So if I come let's bring in some data. Let's click on this. Let's see And what I want to analyze. Let's say I'm analyzing budget variants, right? Budget variants So here I just selected a Metric I just selected a metric called budget variants. So see what the key influencer visual did. I just take this says What influences budget variants to increase or decrease? Right? What influences budget variants to increase or decrease? So let me choose a decrease. So what influences budget variants to decrease great And of course there's no data here. So let's pick some things. Let's pick something. Let's say What influences to increase for Let's put some dates. Let's put large data as a date. So where's the date? I don't want to group these dates. So I'm just showing date itself just the date Let's say store. Let's say region. Let's say state. Let's say So you see right now, it's not analyzing anything because there's not enough data You need a lot of data for it to analyze. I'm going to put store name as well So it's gathering all the data and just like statistics, you need A critical mass of data for it to really do some analysis that makes sense So I put region state and store name. Let me add some more data. Let's say Model name, right? Okay. That seems to be enough for now. Good. So you see so I've analyzed I've added I want to know what influences budget variance to decrease. Yeah, so budget variance to decrease So budget is an actual budget variance to decrease from region state store and model And what did it come up with it says? When the average of budget variance decreases by 7.59 or when the model name is general repairs, okay, so When the model name is general repairs the average of budget variance decreases by 7.59 so just model. So this This is general repair. So general repair seems to be Where the major increase decreases in in budget variances are coming from. All right, all right. It's interesting So if I click this then you see further analysis here budget variances So it breaks it down into bins. So what the updates they did is Binning things they kind of increased or improved the way they could bin things Okay If I click on only show values that are influencers. So these are the main influencers general repairs motherboards printer repairs on this and yeah So we could go a step further and go to top segments. What are the top segments that are really influencers? So you have segment one you have the average of budget variance in the population count So 98.53 percent on the segment one if I click in segment one, it's off to see what that's all about So you can now see some more analysis about segment one and the overall performance And segment one contains 124 data points 13.9 of the entire data In segment one the average budget variance is 98.53 negative This is 6.54 units lower than the overall average variance Okay, so If it's what when a budget variance more likely to be lowered about high when is budget variance more likely to be high Right, let's see that. So it's running the analysis going doing doing the same regression again doing it all from scratch again And this doesn't look too interesting. Let's go back to key influencer And I say, okay, what influences budget variance to increase? Let's say decrease, right? Let's influence it to decrease Let's see what influences to decrease quite a lot more things And he sees analyzing there. So we could you could be on this for all all day I mean, there's so much interesting stuff going on there. We don't have that much time. So let's move on So that was our may update right our may update So the may update just to recap by click on this hopefully it comes up It's coming up. Don't crash on me, please. This is quite a heavy file. So It's kind of dragging. Okay. So those are your performance analyzer And what we picked was the key influencer visual improvements, right? That was our may those are may updates So what about june? What's happened in june? Let's quickly jump into june June june updates. What can what can we say about june? So june Click and Hopefully come up come up come up come up So i'm jumping straight to july. Okay, I guess we didn't we jumped june. We skipped june Let's just skip june not much time. So july what happened here icon sets for table and matrix percentage support for conditional formatting by rules New filter pane is not generally available with filter pane. I showed you the other time. That was the beta Analytics count for key influencer visual There are lots of improvements. So what did we pick or what was our pick for july? We picked data colors support when using play axis on scatter plot Now there was just I think a small snag when it came to scatter plots But scatter plots are one of our most favorite or favorite visuals. It's really really Super visual because it kind of tells a story What is scatter plot does is you have two variables and trying to say one variable explains another variable, right? So for example revenue and transactions is a classic one You have revenue to the left here and then you have transactions here. So you have transactions you have revenue Right and we're saying as revenue goes up. We're hoping that transaction goes up So if you look at this visual here, this is north east. I had to hover over these things to see what they were So this is north east and they have 34 transactions and 65 million error in sales So if I play my axis you could see them Moving pretty nice, right? I pause but the support what changed really I think is the legend So we had a legend. I mean you could switch on the legend and you see the legend come up here which we didn't have Couldn't switch off or on or whatever the legend now can switch it on and off and that's it here up there So that was the improvement for the scatter plot and scatter plot is a really favorite visual of ours. So that was really nice so that was the updates for July that's our pick august what happened in august so august We had not too much updates. We had grouping visuals filter painting migration icon style picker for icon conditional formatting conditional formatting And then key influence. I again had measure support general availability quite a few things here. So What was our pick? Pick was grouping visuals. So grouping visuals I'll show you another visual to see how we group visuals, right? So grouping visuals. I'll just come to this visual here And if I click this visual and I click this visual Let's assume I have so many more visuals and I just want to align them and take them work on them at the same time You could click this hold your control and click this and right click Then you see group and you group now. They are one visual and I can kind of drag All of them at the same time. See that I can just click and drag Yeah, I can drag them all together Right and that's grouping visuals pretty cool It can always on group as well. Just right click group on group Right. So that was good, especially if you haven't looked so many visuals to manage and you need to kind of Align them and do all of them at the same time. So that was grouping visuals. So yeah, that was our pick for august And let's move on to Yeah, so what's the next one september? So quite a few more Um improvements color and text classes in themes New default themes. I think this this was big. In fact, that was our pick new default themes Although they had a new function a new DAX function In september, which is remove filters and convert for the DAX lovers. This was really really good You had to you really know more complex DAX computation or create a how will I call it create create Lots of functions together to be able to do this effect But this was this this kind of improved your DAX writing Skills right new filters to kind of help you out remove filters and convert Data preparation copy to clipboard from beta profiling also pretty good. You check that out online Direct query support generally available also very good Power app visual now generally available. That's super power apps We're going to be doing quite a lot of power apps in our meetups this year So watch out lots of power apps in our meetups this year and power automate. So what did we pick? We picked new default themes new default themes because it's so much easier to use new default themes So that was our pick new default themes. Okay, and on pin visuals. What does that mean on pin visuals? Okay So new default themes you can get that right here in view if you go to view up here See view you click here and these are the new default visuals I can click on one of the themes and it kind of updates your themes you click on themes If I had many colors, you would have seen the effect. I don't really have bars or colors You'd have seen that effect there. So these are your new default themes and of course you have your browse Browse for themes if you can go online and browse for themes or I I can pick themes here, but really let's leave that and Yeah, you could do if you're new Jason you could you could get exports your theme you could How to create themes I can click on that you'll see how to create themes if you just pop up a video online for you to see or it's actually documentation online from Microsoft on how you actually Report or manage themes so that documentation. Let me just pop it here for you to have a look So this is it once you click that this is how Different documentation on using themes if you go to docs.microsoft.com You'll be able to go there or just click it directly and you see Read all about it and see how do you create your own nice wonderful themes to make things easier, right? Very cool. Very very cool. It's quite a long documentation but it's worth reading Because once you create a theme you manage it all your reports will be standard Beautiful and that you learn a little bit of Jason because you need that code But there's lots of templates for you to use here So read it. How did I get here? Let me remind you I went to Down here for the view view tab click here There on the view tab I clicked on the drop down for themes all the second system seems to be misbehaving This tool is quite heavy Slow down guys slow down. Good. All right There we go. It's still there. Okay. Good. So here how to create themes That's what you click once you click that it's going to open the microsoft documentation and creating themes And that's how you get them great. So that was for september themes. Then what about on pinning visuals? What do we mean by that if I go to visualization? right These are your standard visuals and many at times people You don't use certain visuals like this pie chart this pie chart is terrible Don't use pie charts pie charts. You can always get a better chart than a pie chart So right click this pie chart and say hey i'm on pinning this visual. I don't want it anymore So it's going to on pin this is going to remove pie chart from here And it's just going to add to almost like a custom visual. Look at the warning It says you're about to remove this visual from the visualization pane to use this visual in the future You'll need to restore default visuals. So you click okay And guess what pie chart is going to leave here and it's going to join this guy here. Just watch Hopefully move on move move Yeah, it's taking a while to play pie chart doesn't want to move Just give it a few seconds Pie chart off you go Um pie chart is pretty stubborn You see you on pin the visual and the guy refuses to go click. Okay. He's supposed to move out And now he moves out guys in there So now he moves out. Look at the pie chart there So you could right click and right click and on pin all the visuals you really don't want to use or you don't use Regularly so you kind of declutter this place, right? And of course you still have your custom visuals So your custom visuals you could click here and then pick custom visuals that come down here Right, so that's on pinning visuals really good But if you want to get your pie chart back, you need to click on these three dots here And then say restore default restore default visuals, right? Delete custom visuals import custom visuals import from file all sorts of stuff perfect So that was your september pick from us. What about october? What do they have for us in october? What do they have from microsoft for power bi? So another long list of updates On reporting they had automatic page refresh for direct query preview really nice This is on a preview. It's not generally available as at then the new q&a visual. This was really big the new q&a visual Improved user experience for q&a a lot of stuff on q&a natural language improvements for q&a q&a tooling Support for sses and azure as including rls this q&a I mean you could just see there's so much stuff on q&a power apps visuals now included by default New xvis visual that's xvis Our friends from xvis, but well, guess what of course we had to pick q&a. I mean q&a was just A huge improvement. So the new q&a visual was was was it right? So what were the improvements quite a lot you could could read about it But how do you use q&a? You just go to your Page and double click you double click the q&a visual will appear And that's it coming up. Yeah q&a. So I can make this a bit bigger so we can see this right So this q&a, right? So it kind of suggests things for you based on your data is giving you suggestions on how you can write your q&a And yeah, so you just you're just right. So let's take one of the suggestions. So let's just do ours, right? What is sales by region right by region For which year is that you can see it's giving me various states. Let's say 20 You don't know what data this is 2014 you have data for 2014. Yeah, okay. Good. So that's my q&a So what is sales by region 2014? Let me say as a pie chart, I don't like pie charts, but let's just say pie Chart right No, did I remove pie chart? Can you see that? I've removed pie chart. So it's not there anymore. So no pie charts for me, which is good So as a map Can you do region by map but regions? I'm not too sure we'll do a map Let's see map. Let's say matrix matrix visual is nice Well, it did actually it did by map, but let's go to matrix choose matrix so it's Sleeker better Nice, sir. This is it. So this is this your visual. Yeah, not bad at all All right, so that's the new q&a visual you could also click on this cog for settings for the q&a visual and then see lots more things review questions You want to review question people have asked fixed and fixed misunderstandings So when you're reviewing you're trying to see okay someone asked a question and gave a different answer How do we improve that you want to teach the machine learning algorithm? You want to keep teaching it to understand What you what's best? What are the things that you think are best? Understanding you better as a person or a group of people and the terms that people use you're teaching q&a Right managing managing terms manage the terms and definitions you've taught q&a Right and help so you could click on this and you basically goes online goes to the documentation online And youtube and plays a video to kind of help you out on Understanding how to use these things. So it's really really good stuff excellent stuff, right? So let me close that Great, so that was your q&a review questions teach q&a lots of stuff lots of stuff And then of course if you like the visual if I close this you can always pin the visual right? You like this visual you could always click on this and say turn the q&a Result into a standard visual once you click it this becomes a standard visual You put it somewhere else and you can come into your blank space and double click again to do a new q&a Right, I just double click and I do my new q&a and we go go on right ask another question And then you'll be able to create your own custom visual. I mean create a beautiful visual with another q&a, right? let me see I need Sales by model All right Okay, I didn't spell that well sales Sales, okay. I know sales by model. It's not bad. I'm not sales by model Right, and I like this one as well. So here's go. I know sales by model And then we reduce the size of this So you just play around with your q&a. I like this I pin it and and you just go ahead and that's it So q&a big improvements for q&a in october. What about november? so november We had modern ribbon preview. So november big thing was the modern ribbon But they were kind of more big things you had the decomposition tree visual as well as a preview Then conditional formatting button formatting conditional format button formatting Visualizations new interest in visuals zoom chart drill down waterfall charts and stuff But this this this too, right? We're super big modern ribbon preview. That's what you're looking at right now This is the modern visual a modern ribbon everything here. That is the modern ribbon big big improvements I can minimize the ribbon now and then I could actually go to view And see the filter see I can activate the filter pane I can deactivate the filter pane selection pane performance analyzer under view help had so many more things So I can kind of minimize this so this was a big big improvement I mean the ui is getting better and better text box ask a question buttons shapes images Everything that you insert. So what they're really trying to do right is almost make it look like excel powerpoint and An office right they're making it almost look like office eventually. I can predict this for you under home You're going to see some formatting stuff So if you want to format see click on something you just be able to format it almost like office right now So it's getting better and better the ui. They're doing a lot of work on the ui, right? So that was um Really I just cut out the back the november pick for us was the modern ribbon for sure The modern ribbon super excellent and that's what you have up here, right the modern ribbon makes it easier It's more intuitive And it just looks better and more professional the the product is getting mature really nice So what about december our last one? What about december? What was there in december? again quite a lot of Stuff in december customizing current theme export current theme setting table columns or matrix value to the custom url kpi's New decomposition tree formatting and stuff, but really How we will pick I mean there was a new function two quarter. I haven't even tried I wouldn't use that. Hmm. I need to check that out loads more analytics inside and lots of lots of interesting stuff so Reporting what did we pick? It has to be a decomposition tree So the decomposition tree Was really something what do we mean by the decomposition tree? So let me do a quick demo So here's the decomposition tree. This is how it looks. It looks like a tree branches out and stuff So why do you pick it is another Of their ai visuals, right? Any visual you see with this kind of tiny bulb is an ai visual So lots of ai so if I click on the decomposition tree, this is it here, right? Any one of you has used this in powerpoint powerpoint. There is this um transition called morp No, that's some super transition And that's is it a bit a bit morphe like morphe, right? So this is your decomposition tree Let's do some analysis. Let's say we want to decompose. What let's pick a metric. Let's pick a metric let's say lots of metrics lots of metrics revenue transactions Distinct count annual sales. Let's just say annual sales, right? So annual sales Uh, oh, what did I pick? This is not decomposition tree. This is key influencer. Let's go is this the decomposition tree here decomposition tree Yep, so I'm analyzing analysis. Yeah, look at it. So this is analysis. How are we going to break annual sales? Let's break it by categories, right? So you have a metric first and then you want to break it Reported by hierarchy. So let's pick a region first. So if I pick region So this is region. I just selected region. So if you click on this plus sign It's going to give us the composition of a region, right? Let's click don't click click Click out. Oh, let me slow down Click. Yeah, there we go. So north east south east southwest and everything Then let me bring in a region. Let's say state, right? So pick state So if I pick state and I pick this click on this So by saying that we have annual sales for north east And I click on this plus sign. Let's say high value What's the high value? So this is these are the States on the north east. You have your region your state annual sales is highest when state is Gombe. All right, that's good Okay, it's highest when state is Gombe And and then I guess is lowest when state is Borno, right? All right, and then states we can say, okay, do you know we also want Let me pick Model name Right. So model names of this state in particular. What was the lowest value? So model name, right and these are all the Values for products. Yeah, I'm zooming in and out with my mouse This is me zooming in and out and then I can go put something else there So zoom in and out And of course is all cross highlights and you could cross highlight stuff Have this here and then you use it to kind of cross highlight other things as well You click on this this decomposes that this decomposes that This is really good. I mean, this is super super good. Gombe had the highest and these are all the percentage sales for all the rest Go play with this. It's beautiful really beautiful I guess anyone in HR would think you could create an organogram with this. It looks like an organogram Right. So that was december right so guys we've gone through 10 plus one bonus right 11 Oh, let's say 10 we left one month out. So it's 10 So it's really 10. Those are our 10 10 best best best visuals So please go online go to our online go www.officetraininghop.com you see lots of trainings there We're developing training free trainings for power bi free training for power apps and stuff They're going to be loading onto this website very soon. There's a free excel training there right now So go to www.officetraininghop.com go enjoy that And if you also want to learn a lot about power bi we have a reporting and analytics of power bi course Go check it out dbrown consulting net and learn power bi with us Right. So this was a webinar from our monthly webinar series This is our top 10 power bi updates in 2019 And i'm david brown and i'm really glad to kind of share this with you Please type in the comment below which was your best visual for the entire thing. What was your best? I think I think I love the decomposition visual But there's so many So many more right? I mean the decomposition tree Then you have excel and power bi webinar series That's us meet us again every third thursday of the month from 9 a.m to 9 45 a.m Any questions anyone want to type in the chat any questions you have just type it out in the chat You want to have the link to register for the webinars and the link is there Join the link there and if you want to register for our other webinars We have webinars in financial modeling and we also have live meetups every third saturday of the month We're going to share the link as well there Third Saturdays of the month. All right. So thank you everybody for joining us for another dbrown consulting power bi and excel webinar series This was a webinar on the top 10 power bi update in 2019 great See you again next month same time Hope you enjoy your break and everybody's enjoying their break of course and we'll see you again next month. Thank you guys I'll just hang around a little bit on the chat and just chat with a few of you And thank you. See you next month. Bye. Bye