RobertYoung (7/30/2013)

---

PHYData DBA (7/30/2013)

---

Phil Factor (7/30/2013)

---

@wim.bekkens

Thanks for that.

For a simple example, take a look at this series that is now coming out on Simple-talk. It walks you through an example application that involves using R to report KPIs in a SQL Server database.

Creating a Business Intelligence Dashboard with R and ASP.NET MVC: Part 1[/url]

Creating a Business Intelligence Dashboard with R and ASP.NET MVC: Part 2[/url]

Phill,

R was cool but unless you are working at the NIS isn't it dated?

When compared to some of the newer and highly maintained Graphical Stat Display tools such as the free Sigma Plot MySystat http://www.systat.com/MystatProducts.aspx R feels like an amber screen from the 80's.

Don’t get me wrong. It was awesome and I used it.

Now there are IMHO better tools that require less heavy lifting.

If anyone is interested in a free large scale Database solution used by Netflix, Twitter, eBay, reddit, Cisco, etc... http://cassandra.apache.org/ 😎

<sermon>

For the Point and Click crowd, I suppose SAS/SPSS/MiniTab/Excel and the like feel "modern". In terms of implementing (cutting-edge) stats, R has no peer. And, it's taking market share from all of the closed-source alternatives. As I mentioned earlier, Oracle has followed in the footsteps of Postgres with its integration strategy. RStudio does a good job of integrating the necessary bits of R. No Point&Click as yet, however. And not likely, either. The momentum in R is toward R as programming language, rather than R as stat command language. Julia is the current front runner. As such, integrating into the sql/database engine, rather than variations on ODBC from RStudio/etc. is the way forward.

</sermon>