Duration: 60 minutes
Track: BI Information Delivery
Language R for Statistical computing is powerful language for data analysis with all great features for data import from SQL environment. Using R with SQL server data will help data scientists, data analysts and data stewards prepare, explore and validate data much easier, as well as to use wide range of statistics; from uni-variate to multivariate. Session will focus on: 1) establishing the R connecting with SQL server using standard ODBC connectors and T-SQL procedures, 2) validate data with using classical statistical methods on any of your SQL transactional and master data 3) use R output in standard report (using SSRS) and bring extra information to reports. Demos in session will include exploring T-SQL procedure for establishing connection, using R to your common statistical needs and creating report (in SSRS) to visualize data. Demo will also show sentiment analysis of Twitter PASS MVP Summit 2014 event.
To access the session recording, please login or register first:
Not a PASS member? Click here to register.
BI Developer, SPAR Business Services GmbH
Tomaž Kaštrun is BI developer and data analyst at SPAR Business Services GmbH, Spar Slovenija.
His main focus are data mining, T-SQL development, programming and query optimization.
He has been... View More