What is the buzz about ‘R’? What is R, how can I use it, where do I use it, how do I start? I had all the same questions about it, the first time I heard of it. That’s why to explain what the possibilities are in R and what you can use it for.


But first, what is R?

R is a programming language, just like you have C, Java, VB, etc. The main difference with other languages is that R is invented to do statistical computing. It’s actually nothing new at all, it has been used by statisticians and data miners for over twenty years for developing software and data analysis. Another interesting thing: R is maintained by the Free Software Foundation. In other words, R is free of charge and the source code is available for everyone. You can imagine a lot of plugins have been developed for R throughout these years, which makes the number of possibilities it has now humongous.


How can I use it?

You can use R to do statistical calculation on any available data, such ass correlations, chance, decision trees, etc. Since numbers are not always easy to understand, there are a lot of plugins that can be loaded to chart this data. You can see some examples below.


Where do I use it?

Big Data or Small Data, it doesn’t matter. You can use R on almost all the data you have, keeping in mind that you know what you are doing of course. You need to understand some basic statistics to start with, so you can try out some things.


What is the purpose?

Why would you want to use R on your data? R allows you to find interesting facts in your data. When do people buy a second car? Is there a relation between the weather and selling ice-cream? When will there more traffic?


What tools do I use?

You can start using R with RStudio. It’s a free of charge tool that includes everything you need. However, since I am a Microsoft BI Consultant, I can’t stop myself from advertising Microsoft of course. Microsoft implemented R since in SQL Server & Power BI in SQL Server 2016, and that is just awesome! Because of that, the possibilities of SQL & Power BI increased by a huge number.


How do I start?

In my next blog I will start with explaining the basics of R. What data types do you have, how do you keep data together? I’ll keep on writing some posts about R and each time I’ll explain something more.

I hope you R ready for it!

Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
SQL Server security on server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...
Power BI Desktop is een prachtige tool om snel data-analyses te kunnen uitvoeren. Je connecteert op een databron, importeert en...
dba image
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there...
How do you link an SCD Type 2 table in Power Query?
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to...