- Overview
- Installing Pre-reqs
- Synapse Pipeline Template
- PBI Report Template
- Feedback & Considerations
The purpose of ONA is to harness information flows and team connectivity to unlock productivity, innovation, employee engagement and organizational change. This solution template enables customers to leverage ONA metrics from M365 data and analyze the networks within.
The template leverages four data sets:
- AAD Users (BasicDataSet_v0.User_v1)
- Teams Chats (BasicDataSet_v0.TeamChat_v1)
- Outlook Emails (BasicDataSet_v0.Message_v1)
- Outlook Calendar (BasicDataSet_v0.CalendarView_v0)
The later 3 are used to extract interactions from user-to-user activity. More calculation details are available here
After you follow these steps, you will have a Power BI dashboard related to Organizational Network Analysis, like the one shown below.
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 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 Blob Data Contributor
Custom deployment - Microsoft Azure here
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.
As a pre-requisite, ensure that the required packages are installed by following the Synapse Pipeline Installation instructions
-
Download the ONA pipeline template .zip from here
-
In the Synapse Studio, select the fourth icon on the left to go to the Integrate page. Click on the "+" icon to Add new resource -> Import from pipeline template, and select the downloaded template
- Create the new linked services required by this pipeline
-
Provide the parameters of the Linked Service
a. Select Authentication Type = Service Principal b. Use the storage account name (starting with "onastore"), for Service Principal ID use the Application (client) ID), and for Service Principal key use the value from the secret of the application certificate. See screenshots below
c. Test Connection and then click on Create
- Repeat the linked Service creation steps for the source linked service and select "Open Pipeline"
- Navigate to the Develop page (third icon on the left) -> ONA and ensure the notebook is attached to the onasynapsepool
- Click on "Publish All" to validate and publish the pipeline
- Review the changes and click Publish
- Verify that the pipeline has been successfully published
Configure the Synapse Pipeline Package required as described here
- Trigger the pipeline
- Provide the required parameters. Use one month per pipeline run. Use date format 'YYYY-MM-DD'. Use the Storage Account created in the resource group (simply replace with the storage account name created in the resource group or to get the URL, navigate to the resource group -> storage account -> Endpoints -> Data Lake Storage -> Primary endpoint) If required, change the flags if only certain datasets should run
- Congratulations! You just triggered the MGDC pipeline! Once the admin consents to the request the data will be processed and delivered to your storage account
- You will see the data in the storage account
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
Feedback is welcome here
The following considerations apply:
- There may be updates performed regularly to fit for adjustments and fixes
- The network graph visualizations in the Power BI template are limited to 1500 nodes