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)
7,053 reads
Nick Burns
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)
10,525 reads
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,611 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)
3,058 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,949 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
1,314 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,980 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
3,944 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
5,665 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
4,132 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
T-SQL Tuesday #202: The Two Outages I Won't Ever Forget
By ReviewMyDB
My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages....
Forums
Performance Regression After Upgrading from SQL Server 2016 to 2022
Hello everyone, Last week we performed an upgrade of our SQL Server instance, moving...
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers