R Services provides in-database analytics in SQL Server 2016. In this article we step through configuring R Services and get you started with in-database analytics.
2018-05-28 (first published: 2016-01-27)
4,476 reads
I'm not a fan of R visuals in PowerBI. I recently learned I can use R to load data and native PowerBI visuals to display the data. Here's how.
2017-10-16
950 reads
Computing an average over all your data is easy, but what if your data arrives incrementally and you need to be able to compute real-time averages on the fly? That's what we are going to look at.
2017-10-02
588 reads
Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.
2017-09-19
587 reads
We'll look at using principal components analysis to help visualise your data and detect underlying structure or patterns.
2017-09-12
1,491 reads
In prediction, accuracy is key. But it's not all it's cracked up to be as we will explore.
2017-09-07
831 reads
We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.
2017-08-18 (first published: 2015-12-15)
7,371 reads
A look into clustering to detect outliers in R. An extension on univariate statistical tests to include multivariate data.
2017-07-05
1,203 reads
Using R to detect outliers is relatively easy, but most methods assume your data is normally distributed. How do you handle skewed datasets?
2017-06-29
1,252 reads
What is normal? More to the point, what is abnormal? We will look at using R to score outliers in a typical monitoring dataset.
2017-06-19
1,168 reads
This is something I touched on back in 2017 a little after the Live...
In my home lab I have an Ubuntu virtual machine that runs both SQL...
By Arun Sirpal
I am not sure when this became available but for Azure SQL Database 150...
Comments posted to this topic are about the item Is Data the Future of...
I am looking for a good solution for automating the deployment of SSIS packages...
Hi Hope to explain this correctly I have some XML data that can vary...
Ask SSC