~/talk

Fast and Efficent Text Analysis using Azure's Language Cognitive Service

Talkat SQLBits 2024 · 2024-03-19..03-23· [machine-learning, web-platform]
links:none on file
slides:none on file

Uses Azure Language Studio APIs — Key Phrase Extraction, Sentiment Analysis and Opinion Mining — called from Python to send Trustpilot review rows, receive JSON, append IDs and save CSVs. Builds a Power BI model that maps keywords, sentence-level targets and sentiment so one-star reviews with positive staff comments and five-star reviews with negative product notes are surfaced. Implementation runs on the free tier for typical volumes, and the pipeline successfully extracts granular opinions and keywords for dashboarding.

AI-written summary · about

  1. 0:00Azure Language AI Services intro
  2. 2:36What is NLP
  3. 6:48Azure AI Services overview
  4. 7:33Exploring Language Studio
  5. 10:22Keyword extraction setup
  6. 12:33Sentiment mining with Python
  7. 14:46Power BI visualization
  8. 16:16Mixed sentiment analysis
  9. 18:27Word maps from text
  10. 19:31Conclusion
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.