PowerBI offers a really convenient way to consume the insights that are modelled by a data scientist or other analyst that is literate in R.
The problem I faced with using R-Studio was that of making it available for consumption. I would ideally want users to pull the data rather than have to push the results of a script to them. RStudio does provide a nice looking solution to this with Shiny, but it requires some work – both to setup and to learn.
PowerBI on the other hand, takes next to no time to get started, and has a very small learning curve. Your dashboard can be deployed to the cloud and consumed without being restricted by geography.
I just did the following:
I created a new model in PowerBI.
I then used the R Script option in the Get Data menu (R must be installed on your machine):
I took the script I used in the previous blog post, removed the outputs (since I’m handling that from PowerBI), and pasted it into the R Script dialogue box:
The Navigator box comes up, and turns each data frame into a data set.
Just select the dataset you want to work with and click “Load”
The dataset is now available to be consumed in a PowerBI report/dashboard
Now you’ve got all the visualization niceties you need to make a quick dashboard.
I took the opportunity to take a look at the new TimeBrush visualization in the Visuals Gallery. This allowed me to make a simple line graph interactive with regards to the period:
Here’s the full data period: