Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold

After a long wait, in the October 2018 release of Power BI Desktop we saw the fuzzy matching feature added finally. Yay! Have you ever wanted to match two tables together but not on exact matches, but also on a threshold of similarity? if your answer to this question is yes, then this feature is ...

Read More

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

Quick DAX : Word count

Posted by on Oct 13, 2018 in DAX, Power BI | 7 Comments

Here is a technique you might consider if you need to split text down to individual words.  This could be used to help count, rank or otherwise aggregate the words in some longer text.  The approach detailed here uses spaces as a delimiter and will not be tripped up if multiple spaces are used between ...

Read More

Analytics in HDInsight

  Azure HDInsight is an open-source analytics and cloud base service. Azure HDInsight is easy, fast, and cost-effective for processing the massive amounts of data. There are many different use case scenarios for HDInsight such as extract, transform, and load (ETL), data warehousing, machine learning, IoT and so forth. The main benefit of using HDInsight ...

Read More

Fun with DAX – Minesweeper

Posted by on Oct 4, 2018 in DAX, Power BI | 4 Comments

The latest addition to my recent series of DAX based games is the classic Minesweeper game.  This is the game where you are presented with a 9 x 9 matrix of squares.  There are 10 hidden mines and you can either step on a square or place a flag where you think there might be ...

Read More

Data Science Virtual Machine

  Data Science Virtual Machine (DSVM) is a virtual machine on the Azure cloud that is customized for doing data science. DSVM has some pre-configured and pre-install tools that help users to build the AI applications. DSVM will assist data science team to access a consistent setup. In this post, a brief introduction to DSVM ...

Read More

Cognitive Services in Power BI

Microsoft Cognitive services are collections of API and services that help developers to create more smart applications and reports.  By using Cognitive services, developers able to add intelligence features such as face recognition, emotion recognition, text analytics and so forth into their applications. Cognitive Services Overview There are different cognitive services available that you can ...

Read More