In this article, I am going to introduce a few concepts of how to set up and get started with R and RStudio to perform machine learning workloads. It has always been the heat of the discussion on whether to choose Python or R for performing Machine Learning analysis. In my opinion, both the languages excel in their own space and there is no point-to-point comparison between the two directly. Mathematicians and statisticians like to work within the R environment, while programmers choose to work with Python.
Read more »R
Fuzzy joins in SQL Server Machine Learning using R scripts
March 16, 2021In this article, we will discuss the Fuzzy joins in the SQL Server Machine Learning using R scripts.
Read more »Web Scraping for SQL Machine learning using R scripts
December 14, 2020In this article, we will explore Web Scraping using R Scripts for SQL Machine Learning.
Read more »Import data from PDF files using R Scripts SQL Server
December 8, 2020In this article, we will read and import data from a PDF file using the R scripts SQL Server.
Read more »Import and Export data using R and SQL Server
December 3, 2020Data professionals get requests to import, export data into various formats. These formats can be such as Comma-separated data(.CSV), Excel, HTML, JSON, YAML, Tab-separated data(.TSV). Usually, we use SQL Server integration service ETL packages for data transformations, import or export data.
Read more »Working with images in SQL Machine Learning using R scripts
November 27, 2020In the article, An overview of SQL Machine Learning with R scripts, we learned the R services integration with SQL Server 2019. We also explored a few useful external packages.
Read more »An overview of SQL Machine Learning with R scripts
November 25, 2020In this article, we will focus on SQL Machine Learning using R scripts and the use of external packages.
Read more »How to create geographic maps in Power BI using R
August 1, 2019Introduction
This is the fifth article of a series dedicated to discovering geographic map tools in Power BI.
Read more »How to use JSON data in Azure Machine Learning
November 9, 2018Azure Machine Learning (also known as Azure ML) is cloud-based machine learning solution of Microsoft. Microsoft Azure Machine Learning is a fully-managed cloud-based service that provides the ability to create and train predictive analytic solutions. Another advantage of Azure ML is that you can access and easily make changes anywhere in machine learning models with help of Microsoft Azure Machine Learning Studio.
Read more »How to use JSON data in SSRS
November 6, 2018In this article, we will explore the concept of using JSON data in SQL Server Reporting Services (SSRS). This usage concept will include a different approach than the usual methodologies because we will take advantage of SQL Server R service support.
What is JSON?
JSON is an abbreviation for JavaScriptObjectNotation. The main purpose of JSON data was to provide data transfer between server and web applications for JavaScript but today’s JSON is the most popular data interchange format. JSON offers two advantages to us. These are; light-weight text based format easily readable by humans. Currently, JSON is not only used in JavaScript applications, it is also used in all popular software programing languages like JavaScript, C++, C#, Perl, Java, Python, Php etc.
Read more »Machine Learning Services – Configuring R Services in SQL Server
October 25, 2018The R language is one of the most popular languages for data science, machine learning services and computational statistics. There are several IDEs that allow seamless R development. Owing to the growing popularity of the R language, R services have been included by Microsoft in SQL Server 2016 onwards. In this article, we will briefly review how we can integrate R with SQL Server 2017. We will see the installation process and will also execute the basic R commands in SQL Server 2017.
Read more »How to create advanced analytics using Power BI and R scripts
February 27, 2018In this article, we will discover how to find the associations and hidden patterns in a dataset. The tool we will use for this is Power BI and not use any statistical functions or calculation.
Explanation
Power BI is one of the most powerful business intelligence solutions in the market. A cloud-based, user-friendly interface and basic development abilities provide this solution to be more convenient for people to use.
As you may know, Microsoft now supports R script in SQL Server and Power BI. R script support opens magical gates of statistics world to Power BI. Custom Visual offers very useful and interesting visual components for Power BI. In this store, many useful visualizations have been created by Microsoft or the community itself. Some of these visuals use R script infrastructure and this feature allows us to create advanced visual analytic in Power BI. Only a Power BI account is enough to connect and download theses visuals. We will use these visuals in our examples.
Read more »How to plot a SQL Server 2017 graph database using SQL Server R
January 3, 2018A few years ago, one common business case I came across in my professional career that required modelling of data into a many-to-many entity relationship type was the representation of a consultants and their projects. Such a business case became a many-to-many entity relationship type because whilst each project can be undertaken by several consultants, consultants can in turn be involved in many different projects. When it came to storing such data in a relational database engine, it meant that we had to make use of bridging tables and also make use of several self-joins to successfully query the data.
Read more »R script word-cloud in SQL Server Report Builder
November 28, 2017What is R
R is a very popular data programing language. R is especially used in data analysis, statistics calculations, predictions, data mining and machine learning. R is used by data scientist, economist, genetic scientists, and statisticians. R has very wide usage in real life. Healthcare, finance, marketing, and manufacturing are some of them.
Read more »How to Merge and Split CSV Files Using R in SQL Server 2016
February 21, 2017Introduction
From time to time, we may encounter the following scenarios when dealing with data processing:
Read more »How to Import / Export CSV Files with R in SQL Server 2016
February 9, 2017Introduction
Importing and exporting CSV files is a common task to DBAs from time to time.
Read more »