In SQL Server and Power BI suites, you can find nearly anything you need for analysing your data. SQL Server 2016 closes one of the last gaps - support for statistics beyond basic aggregate functions and support for other mathematical calculations. This is done with support for the R code inside SQL Server database Engine. This session goes beyond showing the basics, i.e. how to use R in the Database Engine and Reporting Services reports; it shows and explains also some advanced statistical and matrix calculations.
SSRS , BI , Power BI , R
Presented by Dejan Sarka at SQLBits XV
Slide Deck 1.4 MB