SQLBits 2019
An R primer for SQL folks
A walk-through on what is possible analyzing your data with the "R" language.
You heard about the “R” language and it’s growing popularity for data analysis. Now you need a walk-through on what is possible analyzing your data? Then this session is for you:
You’ll get a short introduction how R came to be, and what the R ecosystem looks like today. Then we will extract sales data from different companies off a Navision ERP database on SQL Server.
Our data will be cleaned, aggregated and enriched in the RStudio environment. We’ll generate different diagrams on-the-fly to gain first insights.
Finally we’ll see how to use the Shiny framework to display our data on a map, interactively changing our criteria, and showing us where the white spots really are.
You’ll get a short introduction how R came to be, and what the R ecosystem looks like today. Then we will extract sales data from different companies off a Navision ERP database on SQL Server.
Our data will be cleaned, aggregated and enriched in the RStudio environment. We’ll generate different diagrams on-the-fly to gain first insights.
Finally we’ll see how to use the Shiny framework to display our data on a map, interactively changing our criteria, and showing us where the white spots really are.
Speakers
Thomas Hütter's other proposed sessions for 2026
Window functions in SQL Server - brush up your skills - 2026
Thomas Hütter's previous sessions
A journey through the Tidyverse
An introduction to the philosophy of tidy data and the collection of R packages called Tidyverse that help to treat your data appropriately. Including lots of demos from ingesting to cleaning to visualizing your data.
An R primer for SQL folks
A walk-through on what is possible analyzing your data with the "R" language.
50 ways to show your data
„A picture is worth a thousand words“ - compelling visualizations beyond the usual bar, line or scatter plots, produced with the help of the ggplot2 package and friends.