@liberrenaudm
Thanks very much for the kind words. It’s great to hear that you’re finding my Challenge entries helpful. I’ve actually been really energized by the number of questions and requests I’ve gotten from members about learning and using R in conjunction with Power BI. As a result, I’ve proposed to @sam.mckay that we create an R Code Showcase section on the forum, similar to the M Code Showcase that @Melissa initiated to house all the great information being provided on PQ/M.
As foundational building blocks of this section, I am researching two questions and putting together lists of recommended resources for both:
-
for people with little or no statistical background, what are the best resources for learning the key concepts necessary to conduct, interpret and report the results of appropriate statistical testing and analyses?
-
for people already with a good foundational statistical background, what are the best resources for learning R within the context of using it as an adjunct to Power BI? I think that last part is important, because learning it for use within Power BI is quite different than learning R on its own. What I mean by that is that in the former case, you can short-circuit learning a lot of the intermediate and advanced R data handling techniques, and instead rely largely on Power Query to do the heavy lifting in your data prep/data cleaning.
I’m also working on finishing up the first video in a series I’ll be doing on “Beginning R for Power BI Users”. This will start from the point of assuming you have a sound statistical foundation, but no knowledge of R, and will present a simplified approach for getting up to speed really quickly in R using concepts and tools you already know from Power BI.
So, this is a very long-winded way of saying that I don’t yet have a good answer to your question, but I’m working hard to provide one soon. Stay tuned…
- Brian
P.S. in addition to my challenge entries that you mentioned, you may also want to look at my entry in Challenge #2, which was the deepest dive I’ve done so far in the challenges on Power BI/R integration. The thing I found really interesting about this particular challenge was the number of key questions where someone likely could have come to the wrong conclusions looking only at the Power BI analyses without incorporating the appropriate statistical tests to determine if the relationship/trends observed were statistically significant.