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?
Highlighted
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies