Sentiment e-mail scanner

Just say you want to take action on e-mails that have a negative feel to it. Your doing a bad job and you're getting complaints from people but you actually don't want to see them or take action on them. With the cognitive services from Microsoft you can scan the e-mail and the AI will decide if it's a positive e-mail (1.0) or negative (0.0).

 I hooked up the sentiment scanner to my Flow to scan my e-mails in Office 365. If I got a new e-mail I would get a notification from the Flow App on my phone telling me of the score (Between 1.0 (positive) and 0.0 (negative)). Pretty cool!

 Set-up can be a little complicated especially the cognitive service. Go to: Cognitive service and log-in with you Microsoft account to subscribe for a trial license. Add the key to the Flow to enable it.


Now the fun part is the testing! So I sent myself bad e-mails:

 1. Damn Alex you are not doing good work at this moment! - Score: 0.834
2. F*** you Alex you S*** big time! - Score 0.6453
So I'm getting there but you have to be very aggressive to get the score to 0.0 hahaha. Next step I want to do is add this data to a PowerBi dashboard, cool!


 Update:

 I put the data into a PowerBI dashboard, thanks to some help from this site: PowerBI and Flow. I created the following:
  1. A workspace
  2. In the workspace I added a streaming dataset 
  3. That streaming dataset I connected to Microsoft Flow
  4. The streaming dataset I put into a dashboard to show the data visually



Don't worry all the steps are in the link "PowerBI and Flow" at the top.

Once I got the data into PowerBI I could create a Gauge showing me how the sentiment is at this moment. 


They all love me they sure do, almost a 1.00! Ok the gauge is not 100% correct but hey you get the idea. 

Comments

Post a Comment

Popular posts from this blog

Azure Information Protection (AIP)

Image
Let's start with one of my favorites (till now). Azure Information Protection (or AIP). Just imagine the following example: You are working on your Word document and you want to send this document to an external person. You e-mail that document as an attachment. The person opens this document, reads it and puts it on an USB stick to take with him. The USB stick get's lost! Now the document can have fallen into the wrong hands! Now what? OK this is a little bit of a roman but hey it could happen! Active Director Rights Management  First let us go back in time to when AIP didn't exist and there was  Active Directory Rights Management Services .  This was a server role that could be installed on Windows Server 2008 R2, it exists since Windows server 2003! Back then it was called RMS. The RMS client is available  from Windows 2000 and later. So what does RMS do? To explain in simple English: Information with RMS on it has certain policies with it  that would remain
Read more

Tiles modern UI

Image
Back in SharePoint 2013 Microsoft introduced "Promoted links" a feature which enabled users to create tiles quick and easy without any custom code. Since then I've seen Promoted links being used a lot of ways, some better than others. However creating tiles with an image in the background was always a nasty thing to do. People would use the weirdest images as background to indicate what it was, totally not user friendly. Especially the choice of the color was very "weird" you would have tiles with all sort of colors and images (see image below as an example). Promoted links always had one big problem; Scaling! It's not responsive in a way you would want to have it. Since Microsoft introduced Modern UI they have also introduced the webpart "tiles". Tiles enables the user to create custom tiles within their SharePoint site, quick and easy. Cool features of the Tiles webpart. Tiles are responsive! They resize when the screen gets smalle
Read more

Azure Active Directory (AAD)

Image
In my last post I talked about Azure Information Protection (AIP). It was a way of getting a good sense of security in the Cloud. Today I want to talk about a very important feature in Azure: Azure Active Directory (AAD). AAD is a good place to start with security. Users that are allowed or prevented from logging in is your first line of defense. In preview AAD is not something radically new. Microsoft created the Management portal om the new Azure Portal to make it look and feel like the new portal. At this moment the most users will have to use the old portal for AAD but once the new management portal is out of preview we are good to go! What has changed? So who cares? It's a new Mangement portal for AAD. To be honest nothing has really changed, Microsoft just changed the look & feel of the new portal. 3 versions There are 3 versions of the AAD: Free, Basis and Premium. See the link below to decide what versions of AAD you need. Overview AAD subscriptions F
Read more