Forum Discussion

ScottVAnderson's avatar
ScottVAnderson
Frequent Visitor
4 years ago
Solved

Automatically categorize similar text terms - AI Key Phrase Extraction

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?

Need Help

3 Replies

    • ScottVAnderson's avatar
      ScottVAnderson
      Frequent Visitor
      4 years ago

      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?

    • ScottVAnderson's avatar
      ScottVAnderson
      Frequent Visitor
      4 years ago

      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?