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.
Speakers
Lewis Prince's other proposed sessions for 2026
AI Beyond the Hype; Practical Solutions for Real Businesses - 2026
Automating Multilingual Document Translation with Microsoft Fabric and Azure AI - 2026
Demystifying AutoML; Building Machine Learning Models with Azure - 2026
Responsible AI in Practice for the Microsoft Data Platform - 2026
Understanding the Complete Data Journey: From Business Problem to Prediction in Microsoft Fabric - 2026
Unlocking Insight from Text Using Azure AI Language Studio - 2026
Using Microsoft Copilot Studio to Build Chatbots That Answer Questions and Take Action - 2026
Lewis Prince's previous sessions
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!
Copilot Studio: Guiding Your Chatbot Takeoff with AI Aviation!
I will talk you through how I created the Copilot chatbot for the SQLBits website.
The SQLBits Website ChatBot with Copilot Studio: How I built the chatbot for this events website)
I will talk you through how I created the Copilot chatbot for the SQLBits website.