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[…]

Power BI and Azure ML make them work with Power Query

In this blog post, I am going to show how to use the Azure ML web service in Power BI (Power Query). First Step: You need to create a model in Azure ML Studio and create a web service for it. The traditional example in Predict a passenger on Titanic ship is going to survived Read more about Power BI and Azure ML make them work with Power Query[…]

Azure data Bricks – Part2

In the last post, I have explained how to work with Azure Databricks. In this post, I will show: 1- Upload data in Azure data Lake Store 2- get data from Azure Data Lake Store into Azure Data Bricks 3-clean Data with Scala language 4- visualizes with R language 5- Predictive Analysis with R In Read more about Azure data Bricks – Part2[…]

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[…]

Create Custom Visual with R and JSON- Part3

In this post, I am going to show you how we can create most comprehensive Custom visual. In the last two posts published in July 2017 (post1 and Post 2). Some notes before I am going to complete the last two posts. 1- We able to declare some custom input like X, Y, Legen and Read more about Create Custom Visual with R and JSON- Part3[…]

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[…]