Skip to content

Latest commit

 

History

History
60 lines (33 loc) · 3.65 KB

README.md

File metadata and controls

60 lines (33 loc) · 3.65 KB

Entity Sentiment Analysis template

Overview

The purpose of ESA is to track what topics people are discussing in internal communications and how they're discussing them. With this tool, you'll be able to detect potential security conflicts, monitor reception to particular events, and gather company-wide sentiment surrounding important concepts. This solution template enables customers to leverage ESA metrics from M365 data and analyze the entities and sentiments therein.

This template leverages a Contoso emails and teamschat datasets, as well as a completed Entity and Sentiment Analysis dataset based on a public Enron emails dataset.

After you follow these steps, you will have a Power BI dashboard related to Entity Sentiment Analysis, like the one shown below.

Installing Pre-reqs

If you do not have an MGDC app, please proceed to the detailed documentation here

If you already have an MGDC app and its secret, the automated deployment to Azure helps setup the required resources in 5 minutes.

The link below sets up the Azure resource group for the template, which are:

  • Create an Azure Cognitive Services (ACS) Language Resource
  • Create a Synapse Workspace
  • Create a Spark Pool for the Synapse workspace
  • Create a storage account for the extracted data
  • Grant permission to the Synapse workspace & the MGDC Service Principal to the storage account as Storage Blob Data Contributor

Custom deployment - Microsoft Azure here

Deploy Environment in Azure

Provide Storage Blob Data Contributor access to the user who is developing the solution. The Synapse workspace should already have access with the automated deployment.

Synapse Pipeline Template

  1. Download the ESA pipeline template .zip from here

  2. Follow the Synapse Pipeline Integration instructions to integrate the pipeline.

  3. After completing the Pipeline Integration and running the pipeline, you will see the data in the storage account

PBI Report Template

For setup instructions and usage, please refer to the documentation here

Download the pre-created PowerBI security report that can generate insights from data that is produced using Synapse pipeline in azure storage locations.

Link to download PowerBI template here