NT Tips
At NT Analyze, we aim to stay updated with new market features regularly and support beginner developers by sharing knowledge through a series of videos called NT Tips. In each video, we focus on a hot topic in the BI field.
​
For more videos, visit our YouTube channel
Next Line Data
Merging Data from Two Different Rows into One Row:
Sometimes we need to compare data that appears in two adjacent rows. In Excel, this task is simple with formulas.
It is also possible in Power BI using Power Query.
Functions On Power BI
Have you ever needed to repeatedly duplicate several tables that are almost identical? In this video, you'll see an efficient way to accomplish this!
Fuzzy Matching
How can you match two columns that are similar but not identical?
Sometimes, we want to match two tables containing similar but not identical information. By using AI technology, you can perform a Fuzzy Matching comparison to create an 'approximate match' between the data. You can also incorporate manual matching to increase data accuracy.
How to Deal with Cells with Hebrew and English
How can you manage values in a field that contains Hebrew letters, English letters, and numbers? In this video, we use AI to identify the languages present.