❓ 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…

RegEx or Regular Expression is one of the crucial tools in text analysis. However, in Power BI, it is not easy to implement RegEx with existing Power BI tools. In this article, I will describe a way to implement RegEx in Power BI with the help of Python! What is RegEx? Regular expressions…

Power BI is a powerful tool for visualizing data. Many visualization tools have already been provided, so you can just drag and drop data fields to create beautiful plots. However, when it comes to text data such as customer feedback or Twitter posts, it might not easy to visualize and…

Get to know a word cloud Word cloud is an elegant way to visualize text data. The more words appear in the data, the larger size of those words in the word cloud. A word cloud can effectively convey important information in a colorful way. There are several ways to create a word cloud such as…

🚀 The Book in 3 Sentences The best startup guideline book Cover most dimensions that startup founders should know Several articles from a Paypal founder. 🎨 Impressions Fun reading. The content in this book might not new since it was referenced by many articles but it is still a great book that contains information about the startup environment. 🙍‍♂️ Who Should Read It? …

This article is for those who are familiar with SQL and want a quick SQL reminder. SQL Query example These are SQL keywords you should know and how to use them. blue words = SQL keywords red words = Read detail more below AGG aggregate functions such as COUNT(), MAX(), MIN(), SUM(), AVG() Conditions WHERE…

Computer vision is a field of artificial intelligence (AI) that enables computers and systems to derive meaningful information from digital images, videos, and other visual inputs — and take actions or make recommendations based on that information. (Source: https://www.ibm.com/) Machine learning is like a computer brain that extracts information from…

❓ Why does model deployment matter? After finishing machine learning model training, it is time to illustrate how the model work. You can send your code or a model pickle file for others to run but it might not be convenient, especially for your client who is not familiar with coding. …