SQLBits 2024
Fast and Efficent Text Analysis using Azure's Language Cognitive Service
We will go on a whirlwind tour of Azure Cognitive Services Language Studio, to show the wealth of tools available there, and then talking in particular about Key Word Extraction, Sentiment Analysis and Opinion Mining. We will apply these concepts through Language Studio APIs via Python on Customer Reviews data to then feed into a Power BI report to show how we can really squeeze so much more useful data out of chunks of text!
There is a lot of textual data available to us, from which there can be vast amounts of information and inferences we can extract. The problem is how can you do this, and more importantly how can this be done in a fast and efficient manner. One answer can be via using Azure's Cognitive Service offering 'Language Studio'. Language Studio is one of the Cognitive services available from Azure, it can do tasks for you via such as extracting key words from text, interpreting the sentiment of text, summarising documents and translating text on the fly. I will go into particular detail to explain how we can extract key words from text, analyse the sentiment of text and mine opinions from text. I will show this on a dataset of customer reviews, from which I will then demo via python how we can submit these customer reviews to the Language Studio APIs to get inferences and more in-depth data back, which I will feed into Power BI to display a dashboard where the data can be broken down by ratings and location etc, to visualise the art of the possible in regard to what can be an end product of analysing text-based data such as reviews.