kohera-logo-regular.svg

R[101]

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.

161018_1
161018_2-jpg

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!

Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature

If you’re someone that works a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with an issue called “Parameter sniffing” before. Up until now, you had...

Creating maps with R and Power BI

The possibilities are infinite when it comes to creating custom visuals in Power BI. As long as you have creativity and knowledge about the right programming language, you can let...

Sending monitoring alerts through Telegram

What if you could get the ease of phone notifications for whatever monitoring alerts you need? Then we have a solution for you with the app Telegram. Some of you...

Send mails with Azure Elastic Database Jobs

The DatabaseMail feature in SQL Server and Managed Instance is widely used by many professionals. But what if you want a similar functionality in Azure SQL Database? There are options,...

Sorting matrices in Power BI

Recently I worked on a Power BI project for a client. They had a SharePoint site where they regularly published articles and wanted to pour view data into a report...

The world of data is evolving

The data landscape has changed dramatically over recent years. In the past, we mainly heard that we needed to do as much as possible “cloud-only”—but this trend has become more...