README.md

page_type	languages	products
sample	python	azure-synapse-analytics microsoft-graph-data-connect-api power-bi

Relationship Mesh Solution Accelerator with Microsoft Graph Data Connect and Azure Synapse Analytics

Building strong relationships with customers is very important to improve customer retention, loyalty and revenue. Insights about the strength of relationship with customers and their key contacts will enable the teams to take required actions to manage and improve the interactions at different stages in a customer engagement life cycle.

This solution accelerator helps developers with all the resources needed to build a Relationship Mesh Solution that gives a summary view of all the key accounts and also a detailed view of interactions at individual account level.

Prerequisites

To use this solution accelerator, you will need access to an Azure subscription, Microsoft 365 account and Microsoft Graph Data Connect(MGDC) enabled. If you do not have this please follow the Prerequisites Guide. While not required, a prior understanding of Microsoft Graph Data Connect, and Azure Synapse Analytics will be helpful.

For additional training and support, please see:

1. Azure Synapse Analytics
2. Microsoft Graph Data Connect
3. Power BI

Getting Started

Start by deploying the required resources to Azure. The button below will deploy Azure Synapse Analytics, Azure Data Lake Storage, Azure Key Vault and its related resources:

• Go to the Deployment guide to set up your Azure resources for this solution.

Architecture

The architecture diagram below details what you will be building for this Solution Accelerator.

Power BI Dashboards

The summary dashboard shows all high priority accounts, their connectivty scores, and accounts that need attention.

The detail dashboard shows top contacts at an account, a network of sellers and external contacts and an event tracker.

License

MIT License

Copyright (c) Microsoft Corporation.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE

Note about Libraries with MPL-2.0 and LGPL-2.1 Licenses

The following libraries are not explicitly included in this repository, but users who use this Solution Accelerator may need to install them locally and in Azure Synapse to fully utilize this Solution Accelerator. However, the actual binaries and files associated with the libraries are not included as part of this repository, but they are available for installation via the PyPI library using the pip installation tool.

Libraries: chardet, certifi

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.

When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.

Data Collection

The software may collect information about you and your use of the software and send it to Microsoft. Microsoft may use this information to provide services and improve our products and services. You may turn off the telemetry as described in the repository. There are also some features in the software that may enable you and Microsoft to collect data from users of your applications. If you use these features, you must comply with applicable law, including providing appropriate notices to users of your applications together with a copy of Microsoft's privacy statement. Our privacy statement is located at https://go.microsoft.com/fwlink/?LinkID=824704. You can learn more about data collection and use in the help documentation and our privacy statement. Your use of the software operates as your consent to these practices.