Home

Analysing Data in Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-414389%22%20slang%3D%22en-US%22%3EAnalysing%20Data%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414389%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20a%20request%20from%20a%20customer%20to%20perform%20some%20advanced%20analytics%20in%20MS%20Teams.%26nbsp%3B%20On%20the%20messages%20that%20are%20being%20posted%20we%20are%20looking%20to%20perform%20sentiment%20analysis%20and%20ranking%20of%20key%20words.%26nbsp%3B%20Also%20there%20will%20be%20a%20q%20and%20A%20bot%20deployed%20in%20Teams%20and%20we%20would%20like%20to%20add%20to%20the%20knowledge%20base%20of%20the%20bot%20by%20the%20questions%20and%20answers%20posted%20in%20teams.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20would%20be%20best%20to%20perform%20these%20activities%20in%20the%20teams%20service%2C%20but%20that%20may%20not%20be%20possible.%26nbsp%3B%20Other%20option%20is%20to%20extract%20all%20the%20conversations%20in%20specific%20groups%20to%20a%20data%20lake%20and%20we%20can%20run%20our%20analytics%20there%20and%20also%20enrich%20out%20bot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-414389%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBots%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-414887%22%20slang%3D%22en-US%22%3ERe%3A%20Analysing%20Data%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414887%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F317163%22%20target%3D%22_blank%22%3E%40Henners72%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20your%20questions%20-%20the%20post%20contains%20a%20few%20things%20so%20I%20will%20break%20it%20down.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20currently%20a%20uservoice%20open%20for%20Sentiment%20Analysis%20-%20but%20this%20hasn't%20currently%20been%20picked%20up%20by%20Microsoft.%20This%20may%20take%20some%20time.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F31084927-sentiment-analysis%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F31084927-sentiment-analysis%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20was%20no%20uservoice%20for%20ranking%20Key%20Words%20as%20part%20of%20the%20analytics%2C%20but%20I%20have%20opened%20this%20request%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F37327288-ranking-key-words-in-channels-teams-tenant%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F37327288-ranking-key-words-in-channels-teams-tenant%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20terms%20of%20a%20Q%20and%20A%20Bot%2C%20this%20is%20possible%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fplatform%2Fconcepts%2Fbots%2Fbots-create%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fplatform%2Fconcepts%2Fbots%2Fbots-create%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20a%20uservoice%20here%20to%20be%20able%20to%20export%20Teams%20data%20and%20it%20is%20currently%20under%20review%20by%20Microsoft%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F16982542-backup-export-printing-archive-options%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F16982542-backup-export-printing-archive-options%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20you%20can%20build%20the%20Bot%2C%20but%20the%20challenge%20remains%20the%20enrichment%20of%20the%20bot%20with%20the%20sentiment%2C%20ranking%20of%20key%20words%2C%20or%20the%20ability%20to%20extract%20conversations.%20One%20way%20to%20possibly%20get%20around%20this%20is%20to%20use%20the%20Text%20Analytics%20API%20with%20your%20bot%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fcognitive-services%2Ftext-analytics%2Foverview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fcognitive-services%2Ftext-analytics%2Foverview%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmarcofolio.net%2Fsentiment-text-analytics-bot-framework%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmarcofolio.net%2Fsentiment-text-analytics-bot-framework%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20this%20would%20be%20a%20workaround%20as%20you%20would%20be%20doing%20enrichment%20from%20the%20Bot%20itself%20rather%20than%20from%20Teams.%20Unfortunately%2C%20it%20could%20be%20some%20time%20before%20the%20functionality%20comes%20into%20Teams%20to%20do%20your%20enrichment%20activity.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20that%20answers%20your%20question%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-423396%22%20slang%3D%22en-US%22%3ERe%3A%20Analysing%20Data%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-423396%22%20slang%3D%22en-US%22%3EThanks%20Chris.%20Would%20there%20be%20a%20way%20to%20extract%20all%20conversations%20in%20the%20Teams%20channel%20so%20that%20we%20can%20perform%20the%20analytics%20elsewhere%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-423758%22%20slang%3D%22en-US%22%3ERe%3A%20Analysing%20Data%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-423758%22%20slang%3D%22en-US%22%3ECurrently%20under%20review%20by%20Microsoft%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F16982542-backup-export-printing-archive-options%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F16982542-backup-export-printing-archive-options%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20has%20been%20asked%20for%20since%20at%20least%202017%20per%20this%20article%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Teams%2FExport-channel-conversation-to-PDF-or-Word%2Ftd-p%2F100191%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Teams%2FExport-channel-conversation-to-PDF-or-Word%2Ftd-p%2F100191%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20that%20clarifies%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Henners72
Microsoft

Hi, I have a request from a customer to perform some advanced analytics in MS Teams.  On the messages that are being posted we are looking to perform sentiment analysis and ranking of key words.  Also there will be a q and A bot deployed in Teams and we would like to add to the knowledge base of the bot by the questions and answers posted in teams.

 

It would be best to perform these activities in the teams service, but that may not be possible.  Other option is to extract all the conversations in specific groups to a data lake and we can run our analytics there and also enrich out bot.

3 Replies
Hi @Henners72

Thanks for your questions - the post contains a few things so I will break it down.

There is currently a uservoice open for Sentiment Analysis - but this hasn't currently been picked up by Microsoft. This may take some time.

https://microsoftteams.uservoice.com/forums/555103-public/suggestions/31084927-sentiment-analysis

There was no uservoice for ranking Key Words as part of the analytics, but I have opened this request

https://microsoftteams.uservoice.com/forums/555103-public/suggestions/37327288-ranking-key-words-in-...

In terms of a Q and A Bot, this is possible

https://docs.microsoft.com/en-us/microsoftteams/platform/concepts/bots/bots-create

There is a uservoice here to be able to export Teams data and it is currently under review by Microsoft

https://microsoftteams.uservoice.com/forums/555103-public/suggestions/16982542-backup-export-printin...

So you can build the Bot, but the challenge remains the enrichment of the bot with the sentiment, ranking of key words, or the ability to extract conversations. One way to possibly get around this is to use the Text Analytics API with your bot

https://docs.microsoft.com/en-gb/azure/cognitive-services/text-analytics/overview
https://marcofolio.net/sentiment-text-analytics-bot-framework/

So this would be a workaround as you would be doing enrichment from the Bot itself rather than from Teams. Unfortunately, it could be some time before the functionality comes into Teams to do your enrichment activity.

Hope that answers your question

Best, Chris
Thanks Chris. Would there be a way to extract all conversations in the Teams channel so that we can perform the analytics elsewhere?
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies