Pattern Recognition via Principal Components Analysis
We'll look at using principal components analysis to help visualise your data and detect underlying structure or patterns.
2019-10-25 (first published: 2017-09-12)
5,683 reads
Nick Burns
Moving beyond principal components analysis
Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.
2019-10-11 (first published: 2017-09-19)
2,040 reads
Real-time moving averages for IoT with R
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.
2019-10-04 (first published: 2017-10-02)
2,532 reads
Loading Data using R and PowerBI
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.
2019-09-20 (first published: 2017-10-16)
4,781 reads
Configuring R Services in SQL Server 2016
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,532 reads
The Shortcomings of Predictive Accuracy
In prediction, accuracy is key. But it's not all it's cracked up to be as we will explore.
2017-09-07
899 reads
Analysing Sales Patterns: R + SQL Server
We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.
2017-08-18 (first published: 2015-12-15)
7,576 reads
Machine Learning for Outlier Detection in R
A look into clustering to detect outliers in R. An extension on univariate statistical tests to include multivariate data.
2017-07-05
2,006 reads
Scoring Outliers in Non-Normal Data with R
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
2,270 reads
Scoring Outliers with R
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
2,104 reads
Blogs
Daily Coping 2 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting
By Will Assaf
Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...
MVP for Another Year 2020-2021
By Tim Radney
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...
Forums
Unusual use of the WHERE clause
I am working an exercise problem where the solution provided has a WHERE clause...
How to get the SSAS Server administrators in MDX query?
Hello, Is there any way to get the list of server administrators from SSAS...
Upgrading from SQL Server 2012 to SQL Server 2017 - Any Tips or Gotchas
We are running SQL Server 2012 SP4 Standard Edition on Windows Server 2012 R2...
Ask SSC