O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required