Automatically categorize similar text terms - AI Key Phrase Extraction

[ScottVAnderson]

I've used Key Phrase Extraction to analyze clients' feedback (unstructured data). Now, I get a list of key phrases that are similar, but aren't being combined as one. For example, one key phrase might be "day" and one might be "days", or one might be "manager" and one might be "managers" or "management". I'd like to categorize the thematically similar phrases, such that "day" and "days" would be combined to be called "Days", or "manager", "managers", or "management" would all be categorized as "management".

Is there a simple way to do this or an AI tool that would be able to group key phrases thematically?

[Anonymous · Accepted solution]

Hi @ScottVAnderson ,

You may try fuzzy matching / grouping:

How fuzzy matching works in Power Query? - Power Query | Microsoft Docs

Fuzzy Grouping in Power BI using Power Query - RADACAD

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ScottVAnderson]

I figured out how to get into Power Query online. I didn't have the option to create a new data flow with my personal Workspace, so I had to create a new organizational-level workspace, which then gave me the option to create a new data flow, and got me into the Power Query online. But, I don't understand how to connect the Power Query Online to the Power BI report that I'm trying to do the fuzzy matching on. Am I missing something really simple here?

[ScottVAnderson]

Thank you! This seems to be exactly what I need! In looking into both options, though, I'm not sure how to access the Power Query Online. In the Fuzzy Grouping video, it mentions creating a new Data Flow, but I don't see that option under my "New" heading. How do I set up or access Power Query Online?