BI and Analytics with SQL Server and R

Level 300 – Advanced
Type Full-day
Speaker Tomaz Kastrun
Price Early Bird 130€ Until 16th of august
Regular 150€ after 17th of august
Location Microsoft Danmark – Kanalvej 7, 2800 Lyngby

tomazThis session is for Data Analyst and business people who would like to learn more on SQL Server and R integration, what R has to offer and what are practices for creating the environment to start working on statistics and predictive analytics.

This one-day pre-con will be demo based and users will be able to play along. It is encouraging to bring your own laptop and code along. You will need a laptop running SQL Server 2016 (Enterprise or Developer edition) and Visual studio 2015 Community edition (with RTVS installed). Script will be available upon session; datasets will be distributed on session (Adventureworks/WideWorldsImporters/Sales or CRM data).

Participants will walk away with understanding how R in SQL Server works, basic knowledge in R and understanding in Algorithms for Predictive analytics available in Revoscale R library.

In this session, you’ll learn:

Module 1: 9.00  – 10.00 Introduction to powerful duo R and SQL Server – Introduction to R, Integration to R and SQL Server, architecture and how to efficiently use  both. (Module: 70% presentation; 30% Demo; 0% hands-on)

(10 min break)

Module 2: 10:10 – 11.20 Knowing R – we will cover some basics on R language, using data frames, lists, importing and exporting data and covering different libraries.  (Module: 30% presentation; 70% Demo/hands-on)

(10 min break)

Module 3: 11.30 – 12.30 Knowing statistics –  from general statistics to multivariate statistics for data analysing and complexity reduction. Algorithms for prediction analytics (Decision trees, Naive Bayes, Regression) and text mining.  (Module: 60% presentation; 40% Demo/hands-on)

(30 min Lunch break)

Module 4: 13.00 – 14.20 Using RevoScale – We will cover what revoscale is offering for parallel and distributed workload between R Engine and SQL Server. We will perform different algorithms for statistics and for predictive analytics and compare them to previous approaches. (Module: 50% presentation; 50% Demo/hands-on).

(10 min break)

Module 5: 14.30 – 15.30 Visualizing Data –   Data preparation, data visualization. Using SSRS, Power BI, R libraries and third party tools for data presentation. Covered by this module will also be vertical presentation of data flow in a company and how (Module: 50% presentation; 50% Demo/hands-on)

(10 min break)

Module 6: 15.40 – 16.15 Story completing – cases from the field. Using CRM Data and predictions within SQL Server, Creating and using Basket analysis, Classification of customers to monitoring and performance analysis for DBA and system administrators. (Module: 100% Demo)


Tomaž Kaštrun  is BI developer and Analyst with more than 15 years of experience working with MS SQL Server and and 15 years of experiences on statistics and predictive analytics. He is a frequent SQL Server community speaker, blogger, delivering sessions on local user group meetings, PASS or Microsoft related events (PASS, 24HOP, SQLSaturday) and publishing articles related to SQL Server.
He is working for Spar ICS GmbH / Spar Slovenija d.o.o. and is vivid coffee drinker.


Microsoft Danmark – Kanalvej 7, 2800 Lyngby


Ticket Type Price Cart

Leave a Reply

Your email address will not be published. Required fields are marked *