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,800 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,800 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,234 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,306 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,890 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,734 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,111 reads
We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.
2017-08-18 (first published: 2015-12-15)
7,831 reads
A look into clustering to detect outliers in R. An extension on univariate statistical tests to include multivariate data.
2017-07-05
3,406 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
4,625 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,891 reads
One of the nice things about the Microsoft Connector for Oracle is that it...
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Hi everyone My SQL query is close to 1000 lines with 17 separate calcs...
Hi folks I would like to get your views about partitioning a huge table...