Power BI demo - Creating Effective Graphs with Microsoft R Open

Question

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:&nbsp;https://github.com/nbrgraphs/mro&nbsp;&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;The example below shows 4 R graphs all controlled by a single Power BI slicer, with no extra code required:&nbsp;

mike_honey · Answer

Prerequisites (The sample .pbix files will not work without these prerequites completed)1. Install R EnginePower 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&nbsp;for free from many locations, including the Revolution Open download page, and the CRAN Repository.&nbsp;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.&nbsp;&nbsp;Required&nbsp;R packages:stats,&nbsp;lattice,&nbsp;MASS,&nbsp;ggplot2,&nbsp;tidyr,&nbsp;HH,&nbsp;dplyr,&nbsp;micromapSTTested on:CRAN 3.3.1, MRO 3.3.1, Power BI Desktop 2.38 (August 2016)&nbsp;Legal Disclaimers:Terms of Service and Third Party Programs.&nbsp;

mike_honey · Answer

Screen shots of my pages for:&nbsp;&nbsp;5. Relationships&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6. Percents&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7. Special Cases&nbsp;

kavasimihaly · Answer

Thanks,it's a great help for me to learn how to use R with Power BI.&nbsp;Great work.

mike_honey · Answer

Screen shots of my pages for:&nbsp;2. Direct Comparisons&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3. Distributions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4. Trends over time&nbsp;

boefraty · Answer

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