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.
2022-05-27 (first published: 2017-10-16)
5,504 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.
2022-05-27 (first published: 2017-10-16)
5,504 reads
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)
8,326 reads
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,241 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.
2019-10-04 (first published: 2017-10-02)
2,810 reads
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,634 reads
In prediction, accuracy is key. But it's not all it's cracked up to be as we will explore.
2017-09-07
1,034 reads
We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.
2017-08-18 (first published: 2015-12-15)
7,739 reads
A look into clustering to detect outliers in R. An extension on univariate statistical tests to include multivariate data.
2017-07-05
2,952 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
3,764 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
3,535 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...
By James Serra
There were a number of data platform announcements at Microsoft Build yesterday that I...
Is there a way to continuously log account changes? For SQL accounts log for...
Comments posted to this topic are about the item Starting on Monday
I need to gather the starting position of the keyword "sql" from a sql...