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)
6,843 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)
6,843 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)
9,895 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,409 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,929 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,792 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,166 reads
We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.
2017-08-18 (first published: 2015-12-15)
7,885 reads
A look into clustering to detect outliers in R. An extension on univariate statistical tests to include multivariate data.
2017-07-05
3,683 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
5,153 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
4,008 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Comments posted to this topic are about the item Do you listen to music...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers