Microsoft R, Data Science and Power BI

yo Adam Saxon here with Guyana cube I am joined by mr. buck woody the famous the infamous I think infamous is closer alright we are gonna take a look at a little data science a little power bi and maybe how they can be better together stay tuned [Music] if you're finding us for the first time be sure to hit that subscribe button to stay up to date on all the videos from both Patrick and myself and with that buck how you doing man good how are you long we've been trying to get we do this for a while yeah you know what I I'm still telling you you've got to learn advanced statistics it's just it's something you've got to learn to do I am NOT a math guy no come on and in fact I went through this statistics thing and support right I started reading they went through all of the different things and I get to something it says something about stochastic and yeah of course I've I'm like I gotta go look that up I'm I was lost I'm gonna show you how easy it is to do statistics over a set of data and derive some meaning from that Oh what do you sound that sounds wonderful yeah it sounds delightful yeah okay awesome okay so we get started yeah we what we need notepad right that's all we do yes notepad is fine but let's use a little tool we call our our car my passion olya we're a pageant Microsoft has a copy of the open source R that we maintain and it's Microsoft are open it's got some slight improvements over the regular R and then of course the Microsoft R we have built into the Microsoft ml server is even more powerful but I've just got the regular old everyday garden-variety are open here and I'm gonna show you and we'll have a link down in the description below from where you can go grab this right absolutely for our it's free download it use it tutorials lots of stuff fun language to learn and I'm gonna show you how easy it is so here we go your mom first of all you can see here on the screen I've got this this one word and scum and scum but it sounds that sounds mind-blowing no you know it is I'll show you watch this okay control our I Ron and on the right hand side there's a series of sets of data we've got data I work with data there you go built right in don't write in we'd have to load it so thinking you've loaded it from Excel or sequel server or the web or something like that all right now ants come was this guy a long time ago he was around when I was a kid like in the 1800's he invented this weird data set no one really knows where he got it but you can take a look here we've got X values and why so X 1 is 10 X 2 is 10 X 3 is 10 X 4 is 10 then we got y1 that's 8 and then 9 and then 7 and then 6 and so these are a lot of numbers and and there's so many here that I can't really kind of put them all in my head so you know what let's just go get a couple of the libraries I'm just gonna go get statistics regular old statistics and I'm gonna go get graphics and look one that yeah graphics are awesome so that's all I've done there nothing's kind of like loading something so that's done it's almost like we're gonna start Star Wars in the arc there you go now we can start playing it we got our data and we've got some libraries to work with it and there's a function called summary it's part of stats and it gives us the typical summary statistics that a data scientist you know smart guy like myself would use to do these sorts of things so let's tell it well let's take a look at what we got here how easy that was the minimum is here the first quartile the max and so on the things that are really interested in because these means see the means yeah you know one of x1 is 9 X 2 is 9 well X 3 is 9 X 4 is 9 the mean of Y 1 is 7 5 7 5 7 what those doesn't all the same they're all the same so I'm gonna tell you that these data sets look a lot to me okay like they're like right now in my you know data scientist brain bus mark on right and I'm thinking this stuff is all the same this data even though it looks varied it's the same represents the same stuff so I gotta make sure that's true though ok so I just do a few simple things we're just gonna do a do it a little bit of magic here we call it we call this this is the technical term magic magic magic got it all right here we go so we control our that one and that one and that one and that one and that one and that one and that one and that one and that one and there we go Oh easy-peasy now let's take a look at what we got here so we got some degrees of freedom here the sums the mins the max the squares and again these guys all look the same don't worry about what the numbers are they're looking the same yeah and in fact we've got some simple things we can do we've got supply supply is like apply Oakland sequel it's very similar that okay no big deal with that and all I want to do is get the the mods and the coefficients and basically this is just showing me how similar the data is that's all okay let's do it okay we come down here control our okay good we see that do you remember the intercept and the slope from algebra I do remember that line goes up like this in it and the x-intercept okay remember that I did that okay look three three it's the same three three and the X's are the almost identical here that once again I'm telling you as a data scientist that this is just these guys are exactly the same you can trust me I I can but maybe maybe there's a little more to this well I mean the numbers are right there at why don't why don't we throw why don't we visualize this a little bit well you can visualize an R I mean I'll teach you that you know in power bi desktop we can do the same thing you can do our entire be if you are in power bi no no I are sorry Ken why don't why don't we switch over here let me let me show you there's a little power bi icon on the bottom let me go get over this okay we're gonna we're gonna teach buck the clicks I've already got an R visual setup for you if you look over on the visualization side there's that nice little it just creates a visual and you get this nice script editor okay very cool why don't we just paste your script in there and see what it does you're saying I can just paste the R script that I just did anything you just it's basically gonna add one thing though okay I want to look at the visualization and I'm sure you have very nice graphics in here but I ARS got built-in graphics so I'm just gonna paste that will it render the are stuff in the window what not only find out but I want you guys let's just see what power bi could show you I mean let me let me explain um so what I'm gonna do here is I'm gonna set up some parameters you can see and see the 4i and one through four that's just my data set the end scums thing that we just did this is exactly the same script I had before it's exactly something we do one difference I'm adding this plot see the plot function right there yes that plot function let me just double click it so you can see which one time it's just gonna put things in red orange and so on and and things in blue and give us some titles it's telling it like how to it's a graphics that you have in power bi but instead of setting properties I'm doing it in the command is that yeah because you don't necessarily know that our visuals are gonna do what needs to be done right right okay again I just don't trust it okay let's just we're just gonna sit yeah so there's a little Run button though right here okay good I see it i'm gonna click run script' and okay I've got something wrong here one minute this let me see which data set Sam I know that's the ants come data set I am using you know what I'm seeing what I know what you're seeing okay don't don't okay mr. data scientist looks totally different yeah that you know it seems it seems that but let me show you again I just want you to I can trust my numbers there's my numbers they're nice and hard do this they look the same they look the same but when we actually visualize it it's a little different there actually it's a it's dramatic dramatically different yeah there's my slopes and and my intercepts but wow those lay out really different maybe maybe a picture is worth a thousand stats there you go I don't know I don't know well you know what I've learned something here today I may I may have to start checking out this Rubio's got a little bit of stuffing or bi and you know because we had the our engine installed so that's what let's power bi desktop so it's actually running the our enjoys just running the RS part of it yeah I see well now that makes more sense now now I actually used the plot features that are in our but I would bet if I gave you this data set you could do the same thing in power bi or maybe some small babies yeah we could do that so while we do this if if you guys can visualize that take this data and visualize it in something outside of the our visualization plotting techniques once you let me know down in the comments below show me some maybe do it published a web and let us see it all right well if you know stats and are and you've done some stats or are items inside a power bi yeah leave us some comments down in the bottom and let's check that out awesome alright guys 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 Patrick and Adam and Buck thank you so much for watching keep being awesome and we'll see you in the next video

Channel: Guy in a Cube

Views: 21,122

Keywords: R Open, microsoft r open, microsoft r open tutorial, power bi r, power bi r script, power bi r visual, power bi r visuals tutorial, power bi, power bi desktop, power bi desktop for beginners, power bi desktop tutorial for beginners, power bi reports, power bi tutorial for beginners, rstats, r script

Id: yj3rZTwJZaA

Length: 9min 27sec (567 seconds)

Published: Tue Oct 23 2018

Reddit Comments

[u/Octogenarian]

I consider myself a smart guy but I learned literally nothing from that video. “Here’s some code we’re not going to explain, using some data we’re not going to explain, that returns some results in R that we’re not going to explain, and now we’re going to copy and paste that code we didn’t explain/you don’t understand into PBI to create graphs and pretend it just blew your mind. “

So what? What’s it do? What’s it for? Give me a use case that presents a problem and how this solves that problem.

Less acting, more plain talk, imo.

[u/tonguexp]

R and Pyton have been used for statistics a very long time. However they do have difficulty showing results visually.

The point here is the same code someone may use in R can be used in Power BI with better visuals.

If you want to learn R, go for it. It is very useful to validate data quality and comparison. Would suggest resources other than Power BI gurus.