Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition

CHAPTER 11Basic Text Analytics

Words empty as the wind are best left unsaid.

—Homer

IN THIS CHAPTER, YOU WILL

• Learn how to search for keywords in textual columns and apply this technique as a simple topic detection method

• Learn how to load an external list of keywords and apply them dynamically in the search

• Use a Cartesian product or a custom function to search for keywords

• Use Table.Buffer and List.Buffer to improve the performance of keyword detection reports

• Learn several methods to split words, ignore common words, and count word occurrences in your analysis

• Learn how to prepare your textual data and load it in a Word Cloud custom visual in Power BI

This chapter shows how to use Power Query to gain fundamental insights into textual feeds. ...