Overview
Explore the power of R for statistical computing in SQL Server environments in this 57-minute conference talk. Learn to establish R connections with SQL Server using ODBC connectors and T-SQL procedures, validate data using classical statistical methods, and integrate R output into standard reports. Discover how to leverage R for common statistical needs, visualize data in SSRS, and perform sentiment analysis on social media data. Gain practical insights through demonstrations on connecting R with SQL Server, applying statistical techniques to transactional and master data, and creating informative reports that incorporate R-generated insights.
Syllabus
24 Hours of PASS: Understanding and Visualizing Data using R in SQL Server
Taught by
PASS Data Community Summit