Imagine that you are a shop owner. These are the questions that you may want to answer: “When arranging the shelves in the store, what should be placed close to what?” “ For the online shopping application, what products will be recommended for our customers?” “ Which products should be…

❓ Why R in Power BI? Microsoft Power BI supports two different languages, M language and DAX (Data Analysis Expression). However, it is sometimes more convenient to use R for the data preparation process since R has an R package, a set of useful functions that eliminate the need for writing codes from scratch. Moreover, data…

❓ What is clustering? Clustering is the method of identifying similar groups of data in a dataset in such a way that objects in the same group (called a cluster) have the same property. Clustering is unsupervised learning since a label is not required for each object. Use cases for clustering include: Anomaly detection…

❓ What is the recommendation system? When online platforms are growing, customers are more likely to buy products online. Companies are trying to understand their customers and utilize customer data to gain more profit. Implementing a recommender system can provide personalized offers. …

Get to know a Sanket chart The Sankey chart is a beautiful visualization used to illustrate a flow of data from multiple levels and to multiple destinations. The things being connected are called nodes and the connections are called links. The Sankey plot is usually used to show website/application traffic among the pages. There are several…

What is the NLP? The objective of NLP (Natural Language Processing) is to make computers understand the text and spoken words in much the same way human beings can. NLP applies statistical, machine learning, and deep learning models to large text data to comprehend the speaker’s or writer’s intent and sentiment. Usually, the input…

You have completed machine learning model training in Python. Then, you want to implement that model and use the model prediction in the Power BI dashboard. This article will tell you how to do that. Azure Machine Learning is the formal way to integrate machine learning in Power BI. However…

❓ Why text data preprocessing is important? The objective of NLP (Natural Language Processing) is to make computers understand the text and spoken words in much the same way human beings can. NLP applies statistical, machine learning, and deep learning models to large text data to comprehend the speaker's or writer’s intent and sentiment. The input data…

What is subquery? A subquery is a small SQL query inside a larger query. That is a SELECT statement nested by a large SELECT statement. The subquery can be easily noticed by parenthesis: (). Subquery benefits Allow you to use the results of the inner query in the outer query. Easy to understand and adjust…