Export data from Power Query to Local Machine or SQL Server using R scripts

There is always a discussion on how to store back the data from Power BI to local computer or SQL Server Databases, in this short blog, I will show how to do it by writing R scripts inside Power Query.   First how to Store Files to PC To store data back to a file Read more about Export data from Power Query to Local Machine or SQL Server using R scripts[…]

R In Azure Data Lake- Part1- Sample Data

Azure Data Lake store is one of the components in Microsoft cloud, that helps the developers, data scientists and analyst to store any data size, shape, and speed. Azure Data Lake is optimized for processing large amounts of data; it provides parallel processing with optimum performance. In Azure data lake we can create hierarchy data Read more about R In Azure Data Lake- Part1- Sample Data[…]

Road Map to use Microsoft ML tools

I normally work with most of the Microsoft tools for the aim of doing machine learning. I came up with a roadmap that shows what option for machine learning we have with Microsoft tools in Data Platform. this roadmap is not completed yet, I need to update it one later with some tools such azure Read more about Road Map to use Microsoft ML tools[…]

R Chart into SSRS (Show Chart in SSRS)-Part 3

In the last post, I have shown how you able to install an external package like ggplot2 in ML services and also you see how we can use data in SQL Server to create a chart in R studio. In this post, I am going to show you how to create a chart in SQL Read more about R Chart into SSRS (Show Chart in SSRS)-Part 3[…]

R Chart into SSRS (ggplot2 package in SQL Server 2017)-Part 2

“In the last post, you have seen how we can create a chart by importing data from SQL Server 2017. By doing this, we have a reliable code for drawing chart. Now, we sure our codes work fine, we can put the codes in SQL Server 2017. In this post, I am going to show Read more about R Chart into SSRS (ggplot2 package in SQL Server 2017)-Part 2[…]

R Chart into SSRS (get data from SQL and create ggplot chart in R)-Part 1

In this and next post, I am going to show you how to connect to SQL Server to get data from there, then create a table chart using ggplot2 package inside SQL Server 2017 and then show the chart in SSRS. there are multiple steps for that we need to follow Get data and create Read more about R Chart into SSRS (get data from SQL and create ggplot chart in R)-Part 1[…]

Azure ML Package-Publish a Web service from R-Part2

In the last post, I have explained, how to use AzureML package with the aim of exploration of Azure ML studio experiments and datasets inside R studio environment. moreover how we can use this package to upload a dataset from R studio into Azure ML has been shown. In this post, I am going to Read more about Azure ML Package-Publish a Web service from R-Part2[…]

Run R codes in Azure ML

  There is a possibility to run R codes and Python in Azure ML.  In this short post, I am going to show you how we can run an R codes to show some charts in Azure ML with ggplot2 package. I have a dataset about the dairy product in the USA. this dataset holds Read more about Run R codes in Azure ML[…]

Azure ML Package-Part1

Azure ML Package is another Microsoft related package that allows you to upload and download datasets to and from AzureML, to interrogate experiments, to publish R functions as AzureML web services, and to run R data through existing web services and retrieve the output. Azure ML in R studio The first step- Installation First, you need Read more about Azure ML Package-Part1[…]

Microsoft SQl Server ML Services: RevoScaleR Package

  RevoScaleR Package RevoScaleR is packages created by Revolution Analytics (own by Microsoft) with the aim of importing, transforming, and analyzing data at scale. There are different categories of functions for the data store, imports and save as, data transformation, draw some charts such as histogram, line and so forth, descriptive analysis, predictive analysis, package Read more about Microsoft SQl Server ML Services: RevoScaleR Package[…]