Power BI demo - Creating Effective Graphs with Microsoft R Open

Established Member
3019 Views
Highlighted
Established Member
Posts: 149
Registered: ‎06-28-2015

Power BI demo - Creating Effective Graphs with Microsoft R Open

[ Edited ]
This demo is a companion to the excellent white paper and sample project: Creating Effective Graphs with Microsoft R Open, by by Naomi B. Robbins and Joyce Robbins:
 
 
In this demo file I have implemented the R scripts and Graphs shown in that white paper using Power BI, to showcase it's R Integration features. The pages in this report correspond to the Chapters in the white paper.
 
Where text/CSV files were used in the white paper, I have replaced the R code to load them with data from a Power BI Query. This gives an opportunity to demonstrate Power BI's interactive filtering, where Slicers or other visuals can be selected to filter and dynamically generate R graphs.
 
In my opinion Power BI represents a great platform to host R graphs/visualizations, and mash up R data integration scripts with Power BI data integration.
 
The example below shows 4 R graphs all controlled by a single Power BI slicer, with no extra code required:
 

EffectiveGraphsMRO doc sample Power BI.png

Mike Honey - Manga Solutions
www.mangasolutions.com
Attachment
Attachment
Attachment
Established Member
Posts: 149
Registered: ‎06-28-2015

Re: Power BI demo - Creating Effective Graphs with Microsoft R Open

Prerequisites (The sample .pbix files will not work without these prerequites completed)

1. Install R Engine

Power BI Desktop does not include, deploy or install the R engine. To run R scripts in Power BI Desktop, you must separately installR on your local computer. You can download and install R for free from many locations, including the Revolution Open download page, and the CRAN Repository.

 

2. Install the required R packages.

Download the R script attached to this message and run it to install all required packages on your local machine. 

 

Required R packages:

stats, lattice, MASS, ggplot2, tidyr, HH, dplyr, micromapST


Tested on:

CRAN 3.3.1, MRO 3.3.1, Power BI Desktop 2.38 (August 2016)

 

Legal Disclaimers:

Terms of Service and Third Party Programs.

 

Mike Honey - Manga Solutions
www.mangasolutions.com
Established Member
Posts: 149
Registered: ‎06-28-2015

Re: Power BI demo - Creating Effective Graphs with Microsoft R Open

[ Edited ]

Screen shots of my pages for:

 

2. Direct Comparisons

 

EffectiveGraphsMRO doc sample Power BI - Section 2 Direct Comparisons.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3. Distributions

 

EffectiveGraphsMRO doc sample Power BI - Section 3 Distributions.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

4. Trends over time

 

EffectiveGraphsMRO doc sample Power BI - Section 4 Trends over time.png

Mike Honey - Manga Solutions
www.mangasolutions.com
Established Member
Posts: 149
Registered: ‎06-28-2015

Re: Power BI demo - Creating Effective Graphs with Microsoft R Open

Screen shots of my pages for:

 

 

5. Relationships

 

EffectiveGraphsMRO doc sample Power BI - Section 5 Relationships (cont).png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

EffectiveGraphsMRO doc sample Power BI - Section 5 Relationships.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

6. Percents

 

EffectiveGraphsMRO doc sample Power BI - Section 6 Percents (cont).png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

EffectiveGraphsMRO doc sample Power BI - Section 6 Percents.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

7. Special Cases

 

EffectiveGraphsMRO doc sample Power BI - Section 7 Special Cases.png

Mike Honey - Manga Solutions
www.mangasolutions.com
Frequent Visitor
Posts: 4
Registered: ‎05-10-2016

Re: Power BI demo - Creating Effective Graphs with Microsoft R Open

Thanks,

it's a great help for me to learn how to use R with Power BI.

 

Great work.

Moderator
Posts: 40
Registered: ‎08-10-2016

Re: Power BI demo - Creating Effective Graphs with Microsoft R Open

This is an amazing work.  If you consider to convert some of your R-visuals to R-powered-custom visuals, out team will be happy to assist you.  Almost all of these visuals are great candidates for the PBI Gallery ! I tested the support for R-packages in service, all of the  packages beside "micromapST" are already supported.

 

The visibility of R-powered custom visuals in gallery is greater and it is not limited for R-users. 

Occasional Visitor
Posts: 1
Registered: ‎02-12-2017

Re: Power BI demo - Creating Effective Graphs with Microsoft R Open

Hi Mike,

 

I've a question that is more related to Integration Architecture between PowerBI and HDInsight. Let's assume that my data is stored in Azure Storage Account or Data Lake STorage, and I have also HDInsight cluster running Microsoft R Server. In PowerBI, I need the R visual script to work on a massive amount of data stored in Data Lake Storage and run using Microsoft R Server, then it returns a relatively managebale dataset to be visualised. 

 

Is this architecture attainable?

 

Thanks.

Is