New Artificial Intelligence capabilities in Power BI Desktop

yo what's up I'm Adam I'm Sarina and we are gonna dive into the new AI capabilities inside a power bi desktop stay tuned if you're finding us for the first time be sure to hit that subscribe button to stay up to date with all the videos from both Patrick and myself Serena thanks for joining me can you tell us a little bit about what you do with the power bi product team yeah sure so I'm part of the AI team in power bi so we work on a lot of cool stuff that is coming out now we have we're doing Auto ml we have these text analytics and vision things I'm showing today lots of AI visuals so that's what we work on ooh that's exciting that's all the fun stuff that everyone wants to play with so all right so set the stage for us what what is the the challenge that people face and why would they even look at something like this inside of power bi desktop yeah sure so you know sometimes in maybe you have a lot of data that is mostly numbers and you can get useful insights from them but sometimes you also might have some rich text data that can be super useful like comments that people leave or you know how employee happiness kind of survey kind of things and right now it's very hard to get some useful insight out of that so that's what you can now do in power bi desktop awesome all right so enough of all this talking let's head over to your laptop and see it in action ok so I have this data set here with some data about Seattle rentals so people are renting out their place in Seattle and I can see some things about the listing prize and how much is it occupied and also I can see that people are actually leaving reviews lots of reviews for all these different places in Seattle but if I if I want to know more about why places are doing well or not and by people are hit being happy with their rental then I really need to dive into what are people saying right because the numbers don't really tell us that we need to see what their comments are about it and arrive from that yeah correct so that's what I'm going to do in an power query so I'm just opening my query here and you can see the data that I have so let's have a look at this reviews data so overall these listings they're older the people who visit and will stay there can leave comments and so I have all the comments here in in just a flat simple table and now what I to get some more insight in in what people are saying and without having to read through all of it I'm just gonna go in here and use the text analytics okay so that's new so that's that's new as of the November 2019 power bi desktop right yeah so you can hit it from the home page or you can add a column and then they're over here as well awesome is this a preview feature so do we need to turn it on to start or is it just there it is a preview feature so we'll be in a preview settings and that's all three of them so we use text analytics and vision which are pre-trained models from edge your cognitive services and then we also allow you to connect to Azure machine learning models but in this case for the comments I'm just gonna do text analytics for now so well that opens up you'll see the library of all the functions that are that are in there today so today you can do you can detect the language of text you can extract key phrases or topics that are most common common in the text and then you can also score a sentiment so we're gonna start with that one right now I already selected the comments column so it's that is in my selected text over here it's also telling me that I'm gonna get a score from 0 to 1 0 being most negative and 1 being most positive and then if I want if I know the language I can put the language code in here but I don't have to do that so if I don't do that I can power bi will just detect the language for me now one thing about these the ái insights is that it uses power bi premium and so we actually used run the model on your premium capacity while you're in power bi desktop and that is kind of a new new concept I can actually select the premium capacity here so I just selected this one and so if I want to change it I can do that right here in in this UI okay so I'm gonna run it and then going back to the table you'll see now that once this is done it's now going through all the comments and just scoring that sentiment of the pre with the pre trained model and just in a few seconds you see that now I have this dis sentiment score that's awesome didn't there was just a few clicks and we got it yeah it's super simple I don't have to build this on my own model I can just use this one in power I love it so this is similar like we've had this in power bi data flows but now we're bringing this to power bi desktop to make it beyond data flows yes correct so yeah we want to just offer it to every Power bi user wherever you are in power bi so so now it's both in power Cree online and in your queries alright so we've we've got that sentiment score now what do I do with that yeah so now I can now I have a score instead of all that text that I have to retry can now start using that in my report and so I already also did the keyphrase extraction and vision so it's the same thing couple of clicks so I'm just gonna close this for a second and back to my reports so now all of the sudden is this data becomes much more interesting because they can see like how what is actually the sentiment of all these listings in in Seattle how is that sentiment progressing over time I could look at specific neighborhoods where there mmm higher percentage of positive reviews for just negative reviews so for instance there's some area over here that seem to as if code that has a lot of high percentage of negative reviews but it is going up so you know that way I can really just keep a track on on what is happening in in this city and for these rentals that's really cool now similarly I can also use the image tagging for for some analysis so people have so with these listings people post pictures of the place that they rent out and so I've done some image tagging on that to see what is the top and what are the topics that people have on those pictures and of course there's gonna be a lot in common because it's all like the indoors of houses and stuff like that but you know maybe there's something interesting here so I've just plotted like the the positive neutral and negative comments over here and I'm gonna filter on the negative to see if there's anything that can be that we can learn from these images so I can see what the most common tags are over here and then I can also I plotted the tags that are related to lower sentiment and so the thing the two things that come up on top are gardens and plants so I'm just gonna select those as well and see what these comments are about and so and so you see that there's a couple of listings coming up that have pictures of the outside and that people are saying like it's very old it was under construction there's all these like things a little little outdated not happy about so you know this is just a first first glance but maybe when people are not posting pictures of the inside of their house but the i'ts outside then you know maybe there's something in the inside that you don't want to see nice so it just allows you to just dig in deeper and get more meaning out of that actual data which is awesome all right Serena that's amazing and I love that this is now in power bi desktop I just want to remind everyone make sure you update to the November 2019 release to get these features and it does require premium for all of what you showed know so only for detects analytics and vision for the azure ml capabilities you just have to share at your male models with yourself or people and it will show so it just uses that Azure ml resource and whatever is there okay that's good to know all right so I want to pass this off to you what do you guys want to see in terms of AI capabilities and power bi desktop we showed you what's already there so is there something else that you would want let us know down in the comments below we want to hear it if you like this video be sure to give it a big thumbs up smash it if you so desire if it's your first time here hit that subscribe button and as always from both myself Patrick and Serena thank you so much for watching keep being awesome and we'll see you in the next video

Channel: Guy in a Cube

Views: 58,398

Rating: 4.9163313 out of 5

Keywords: power bi, power bi ai, power bi ai capabilities, power bi ai tutorial, power bi artificial intelligence, power bi desktop, power bi desktop ai, power bi desktop artificial intelligence, power bi desktop tutorial, power bi desktop tutorial for beginners, power bi desktop update - November 2019, power bi for beginners, power bi key phrases, power bi sentiment, power bi sentiment analysis, power bi training, power bi tutorial, power bi tutorial for beginners

Id: FsK8OYagidY

Length: 9min 19sec (559 seconds)

Published: Thu Nov 14 2019