In stephlocke/RMSFTDP: R in the Microsoft Data Platform

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "README-"
)

The SQL Server BI world has been kind of static for a long time, now they’re bringing out a funky new platform and they’re putting R everywhere. This hands-on pre-con will take you through the fundamentals of working with R and then show how it can easily be integrated into the Microsoft stack.

Contents

• R + Microsoft
• Getting started with R
• Data manipulation fundamentals
• Getting data from SQL Server into R and vice versa
• Data visualisation basics
• Interactive data visualisations
• Making predictions with R & Azure ML
• Using R in SQL Server - overcoming SQL limitations and making predictions
• High end dashboards with PowerBI & R

Objectives

• Knowing enough R to comfortably do basic data analysis
• Understand how R impacts the new Data Platform
• Practical experience of working with R in the Data Platform

Prerequisites

Attendees should be comfortable writing SQL and will ideally having coded a bit in other languages previously. Attendees will need a laptop with: - R - R Tools (if using Windows) - SQL Server ODBC Driver 13 - An IDE + Rstudio + Visual Studio plus Visual Studio R Tools

stephlocke/RMSFTDP documentation built on May 30, 2019, 3:36 p.m.