About a couple of years ago, I wrote two articles about what is association rules and how we can have them in Power BI.In this post, I am going to put some more enhancements and show you how with data that is not cleaned how you can create Market Basket Analysis. these enhancements are about Read more about Market Basket Analysis in R Part 3[…]
There are always many questions about a cheat sheet to shows the existing capability for doing AI and ML in Power BI service and Desktop. In the above chart, I have summarized the capability of doing AI and ML in Power Service and Desktop for each role. I have identified three main roles in Read more about Overview of Available AI and ML capabilities in Power BI[…]
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[…]
Microsoft Machine Learning Technologies Overview Artificial intelligence and specifically Machine learning can bring lots of benefit to the business owner. Many businesses using Microsoft data platform tools for many years. Microsoft employed machine learning in creating their products such as Xbox, Bing Search and so forth for a while. However, from 2014 they start to Read more about OVERVIEW ON MICROSOFT MACHINE LEARNING TOOLS[…]
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[…]
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[…]
Databricks is an analytics service based on the Apache Spark open source project. Databricks has been used for ingesting a significant amount of data. In February 2018, there is integration between Azure and Databricks. This integration provides data science and data engineer team with a fast, easy and collaborative spark-based platform in Azure [1]. Azure Read more about Azure data Bricks – Part1[…]
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[…]
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[…]
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[…]