Advanced data analytics does not live only in the realm of data scientists. The necessary tools now exist in SQL Server 2016 to perform advanced analytical analysis with R. This session aims to demystify data science by showing how to create advanced analytical functions and display the results. These techniques can be applied to perform in-depth analysis on practical things like improving database monitoring. The ability to create predictive models for server performance load, determining when disk space will be required, and impact analysis of performance tuning tasks are some of the examples which will be covered in this session.

Session Goals:

• Learn how to code applications in R to provide data insight and data visualizations for use within SQL Server.
• Develop and understanding of some of the algorithms used in data science and how to apply them.
• Extend the functionality of SQL Server by integrating R code to provide insight into the performance of SQL Server.
• Understand different ways to visualize the results, including storing within SQL Server, creating SSRS reports and visualizing in Power BI.
• Introduction to Data Science concepts.
• Application of Data Science algorithms in R.
• SQL Server R Internals and Integration.
• Modifying SQL Server to optimally perform and monitor R Code.
• In depth walkthrough of SQL Server running R
• Introduction to Linear Regression.
• Application of linear regression to determine storage space usage over time within SQL Server.
• Predictive and Prescriptive Analysis techniques.
• Application of predictive and prescriptive analysis through analysis of DMVs.
• Common visualization techniques used in data science.
• Demonstration of how visualizations are used in evaluating data algorithms.
• Configuration and methods for displaying visualizations within SQL Server, providing reports in SSRS and Power BI.

Session Agenda:

• Introduction to Data Science concepts.
• Application of Data Science algorithms in R.
• SQL Server R Internals and Integration.
• Modifying SQL Server to optimally perform and monitor R Code.
• In depth walkthrough of SQL Server running R
• Introduction to Linear Regression.
• Application of linear regression to determine storage space usage over time within SQL Server.
• Predictive and Prescriptive Analysis techniques.
• Application of predictive and prescriptive analysis through analysis of DMVs.
• Common visualization techniques used in data science.
• Demonstration of how visualizations are used in evaluating data algorithms.
• Configuration and methods for displaying visualizations within SQL Server, providing reports in SSRS and Power BI.

Presenter - Ginger Grant:

Ginger Grant started working in business intelligence for a number of industries including transportation, insurance, and healthcare. Looking for answers in data led to advanced analytics and data science, where she currently creates systems to provide solutions to data questions. An active member of the data community, she is a Microsoft VTSP and MVP in Data Platform and regularly blogs at DesertIsleSQL.com.

A Note from the Organizer:

This event is affiliated with SQL Saturday Cleveland 2017, which is also held at Hyland Software on 2/4/17. Please visit our event site at http://www.sqlsaturday.com/595/EventHome.aspx for more information or to register to attend. You do not need to attend SQL Saturday to be able to attend this precon event.