Azure Synapse Analytics and Azure Purview Work Better Together

Azure Synapse Analytics and Azure Purview Work Better Together

This article is contributed. See the original author and article here.

Data warehouse, data integration, and big data analytics together are continuing to grow at planetary scale in enterprises. Azure Synapse Analytics provides limitless analytics services to query data using different compute engines and programming languages. Azure Synapse workspaces allow the data engineering, machine learning, and BI projects to coexist without creating silos in experiences, processes, and tools. As data continues to explode and be used, it’s more important than ever to fully govern the data.


The Azure Purview integration in Azure Synapse provides a comprehensive data governance solution with a single pane of glass for all analytics workloads. Organizations can run a variety of analytics projects and put data to work much more quickly, productively, and securely, generating insights from all data sources. The embedded data discovery experience in Azure Synapse powered by Azure Purview further increases data agility and time to insights.


In this blog, you will learn how to govern your Azure Synapse workspace by connecting to Azure Purview for automated data discovery and classifications in the Purview Data Map. You can further use the Purview Data Catalog to search enterprise data and use contextual gestures to build analytics workloads.


Register and scan in Azure Purview


Purview data source administrators can start by registering an Azure Synapse workspace under a collection of the Purview Data Map. Admins can choose to register individual workspaces or simply register the Azure Subscription containing all Azure Synapse workspaces. With a few clicks, a recurring scan can be set for automated data discovery of technical metadata and classifications. Azure Purview can support 200-plus classifications that look for sensitive and PII data while scanning. The admin can configure specific databases of a workspace and credentials managed in Azure Key vault for secured connection while scanning. Creating a private endpoint is supported for scanning Azure Synapse workspaces behind VNET. Read more details on how to register and scan Azure Synapse Analytics workspaces.


ChandruS_0-1637701221356.png


 


Register Azure Purview from Azure Synapse workspace


Azure Synapse contributors can register an Azure Purview account by navigating to Manage > External connections > Azure Purview. With a single click, the Azure Synapse workspace is integrated with Azure Purview for data governance. Azure Purview helps discover all data across your organization, track lineage of data, and create a business glossary wherever it is stored: on-premises, across clouds, in SaaS applications, and in Microsoft Power BI. Read step-by-step documentation to Connect Synapse workspace to Azure Purview.


ChandruS_1-1637701221377.png


 


 


Select a Purview account from the dropdown or enter the resource URI manually and click apply. To connect a Purview account behind VNET, read how to Access a secured Azure Purview account.


ChandruS_2-1637701221387.png


 


Once registration is complete, the connection and integration status are shown in the details section.


ChandruS_3-1637701221401.png


 


 


Search and use enterprise data


The search box in the Azure Synapse workspace menu bar is now powered by Azure Purview for the Data, Develop, and Integrate sections. Start typing the keyword in the search bar to let Purview’s intuitive search automatically complete and match the asset by relevance on name, classification, labels, contacts, and more.


ChandruS_4-1637701221410.png


 


Search results are displayed in a dedicated tab for Purview. The familiar search result page experience of Purview is retained inside the Azure Synapse workspace.


ChandruS_5-1637701221423.png


 


With a few clicks, narrow down the search results to exact assets in Purview.


ChandruS_6-1637701221431.png


 


Time to insights with contextual gestures


In the asset details page, Azure Synapse users can perform a variety of contextual gestures to connect for further analytics. Depending on the asset type discovered, users can use the following gestures:



  1. SQL Script experiences to query top 100 rows or create external table

  2. Notebook experiences to create a Spark table or load to DataFrame

  3. Data integration experiences such as new linked service, integration dataset, and development dataflows.


ChandruS_7-1637701221441.png


 


 


ChandruS_8-1637701221450.png


 


Data producers can directly edit the asset from the Azure Synapse workspace and curate by adding business glossary, description, classifications, and contact details.


ChandruS_9-1637701221456.png


 


 


Automated data lineage from Azure Synapse


Data lineage from Azure Synapse are automatically pushed to the connected Purview account for copy and data flow activity. Detailed documents are available for Metadata and lineage from Azure Synapse Analytics.


The lineage metadata is pushed to Purview in real time at the end of each pipeline run. It includes granular details such as column lineage, pipeline run status, row count, and additional metadata.


ChandruS_10-1637701221466.png


 


Lineage status is available from the pipeline run monitoring page of the Azure Synapse workspace.


ChandruS_11-1637701221475.png


 


 


Get started with Azure Purview today 



  • Quickly and easily create an Azure Preview account to try the generally available features.

  • Read quick start documentation on how to connect an Azure Synapse workspace to an Azure Purview account

Use intelligence to transform routing of service delivery requests

Use intelligence to transform routing of service delivery requests

This article is contributed. See the original author and article here.

Any call center that uses unified routing to manage and assign incoming support requests is going to notice gains in efficiency. The core routing capabilities in Dynamics 365 Customer Service use skill matching and priority to help determine assignments. However, bringing intelligence to the challenge of efficient routing can move you closer to world-class service.

With the unified routing release in April of 2021, we introduced intelligent skill finder as the first capability related to intelligent work classification. It empowers organizations to identify which skills are required by the agent to address an incoming work item. AI models are trained to understand the skills required to address customer inquiries, and then a match is made to agent skills, helping to assign the calls to agents. In this new release, we’re adding two more capabilities to intelligent work classification: customer sentiment identification and effort estimation for routing. These capabilities will enable organizations to harness state-of-the-art AI to improve customer satisfaction and reduce resolution times.

Understanding customer needs with sentiment identification

Matching agents to calls based on skills is a basic capability in unified routing. What if you could also gauge customer sentiment based on keywords, and then route calls to agents best able to handle those various emotions?

Let’s better understand this with a scenario. Imagine Contoso Coffee is operating a support center and has implemented unified routing. They recently had a high volume of unhappy customers, and they brainstormed about how best to use their existing staff to address these concerns. Contoso Coffee realizes that customer sentiment could be used as a signal to influence call routing; some agents are better at managing unhappy customers. Contoso decides to adopt sentiment prediction in unified routing. They take a few simple steps:

  1. Contoso’s admin opts into the feature and tries it out using the Dry Run tool, where the admin can test phrases specific to their organization and view the sentiment prediction.
  2. The admin set up a skill for managing work items predicted to include low (unhappy) sentiment, and that skill is assigned to their agents who have the right training to handle it.
  3. The admin configured a rule to predict sentiment, and it attaches the low sentiment management skill to work items when sentiment is low.
  4. The dry run option is used to start testing out the rule, with work items assigned based on the score.
  5. Now, once the rule is in production, new work items predicted to have low sentiment have a higher priority to be matched to agents with the appropriate management skillset.

As a result, Contoso Coffee was able to address the spike in unhappy customers, leveraging their agents to maintain customer satisfaction.

Learn more about using customer sentiment in classification in this short video introduction:

This embed requires accepting cookies from the embed’s site to view the embed. Activate the link to accept cookies and view the embedded content.

This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use.

Read more in the documentation about using sentiment prediction-based model in work classification.

Estimate effort to increase assignment efficiency

A key contributor to an effective contact center is understanding how long it will take to address support requests. Organizations do not have a simple way to understand how much time it will take agents to address incoming work items. Effort estimation replaces manual processes with the use of AI. This intelligence interprets the issue and uses historical support data to generate a work estimate.

Highlights of this capability include:

  • For training, a business admin can specify which work items to train on and define effort for their organization.
  • Use the dry run experience to test out the model on customer data and view real effort estimations prior to integrating into the routing process.
  • Add it to existing routing capabilities such as route to queue rules.
  • Review diagnostics for insight into how the work item was routed using effort estimations.
  • Train multiple custom models based on individual customer data.

Learn more about effort-based routing in this short video introduction:

This embed requires accepting cookies from the embed’s site to view the embed. Activate the link to accept cookies and view the embedded content.

This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use.

Read more in the documentation about using the effort estimation model in unified routing.

Matching required skills to agents

In any contact center, each agent will have a different set of skills to offer, and organizations should use those skills appropriately to best address customer requests. To maximize agent potential, it is critical for any organization to understand the skills required to address a work item and identify the agent that is best suited to address it. Intelligent skill finder takes the guesswork out of this by using AI to predict the skills required to address an incoming work item, and then matching those required skills to corresponding agents.

Highlights of this capability include:

  • For training, a business admin can specify which work items to train.
  • Use it with skill-based routing.
  • Models can improve over time based on the agent feedback loop.
  • Review diagnostics for insight into how the work item was routed using skill predictions.
  • Train multiple custom models based on individual customer data.

Next steps

Visit the Dynamics 365 Customer Service Community Forum to share your thoughts.

This blog post is part of a series of deep dives that will help you deploy and use unified routing at your organization. See other posts in the series to learn more.

The post Use intelligence to transform routing of service delivery requests appeared first on Microsoft Dynamics 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

The 5-Minute Recap: Everything new with Security, Compliance, and Identity on Microsoft Learn

This article is contributed. See the original author and article here.

Welcome to our new monthly blog series featuring the latest Security, Compliance, and Identity content updates on Microsoft Learn! This is our first post, and we’re highlighting recently released updates, including a new learning path we launched during Cybersecurity Awareness Month. Starting in January, we’ll highlight new learning paths, modules, and other content updates we make each month to give you the skills you need on your learning journey.


 


Read on to check out some of the latest updates from our Security, Compliance, and Identity portfolio.


 


Introduction to cybersecurity


Knowing the fundamentals of cybersecurity is a first step toward protecting against cyberthreats. Our new learning path—Describe the basic concepts of cybersecurity—delivers foundational knowledge about cybersecurity concepts including cryptography, authentication, and authorization, along with exploring ways to protect yourself and your business from cyberattacks.


 


AZ – 500: Microsoft Azure Security Technologies


This four-part series of learning paths will equip you with the knowledge you need to take Exam AZ-500.



This learning path will teach you how to secure Azure solutions with Azure Active Directory, implement hybrid identity, deploy Azure AD identity protection, and configure Azure AD privileged identity management.


 



This learning path will teach you how to lock down the infrastructure and network resources that are running in your Azure environment.


 



This learning path will teach you how to deploy and secure Azure Key Vault, configure application security features, implement storage security, and configure and manage SQL database security.


 



This learning path will teach you how to configure and manage Azure monitor, enable, and manage Azure Security Center, and configure and monitor Azure Sentinel.


 


You can take Exam AZ-500: Microsoft Azure Security Technologies once you have completed the learning path to earn a certification.


 


Microsoft Endpoint Configuration Manager


Microsoft Endpoint Configuration Manager—which is part of Microsoft Endpoint Manager—helps you protect the on-premises devices, apps, and data that the people at your organization use to stay  productive. Our newest module, Understand co-management using Microsoft Endpoint Configuration Manager, provides an in-depth look at how to enable co-management based on the implementation path that best suits your organization. You’ll also:



  • Learn about the benefits of co-management

  • Understand the co-management prerequisites

  • Learn about paths to implement co-management


 


We’re excited to hear how you use these updated resources on your journey to certification!

Evaluation Lab: Expanded OS support & Atomic Red Team simulations

Evaluation Lab: Expanded OS support & Atomic Red Team simulations

This article is contributed. See the original author and article here.

Microsoft Defender for Endpoint’s Evaluation Lab is an environment that allows security teams to seamlessly test their defense against threats. We are excited to share that the Evaluation Lab now supports adding Windows 11, Windows Server 2016, and Linux devices. In addition, we’d also like to announce a new partnership with Red Canary’s open-source simulation library, Atomic Red Team! 


 


NOTE: Both updates are only available in the Microsoft 365 Defender portal at security.microsoft.com.


 


Expanded OS support


The evaluation lab now supports the following operating systems: Windows 10, Windows 11, Windows Server 2019, Windows Server 2016 and Linux (Ubuntu). To create a new device, simply select it within the “Add device” wizard. The new device will automatically be onboarded with no required additional steps.


 


Yaniv_Carmel_2-1637601415372.png


 


Once created, you can connect to the device via RDP (Windows) or SSH (Linux). You can connect to a Linux device using any SSH client.


 


Yaniv_Carmel_3-1637601415380.png


 


Atomic Red Team simulations


Powered by Red Canary, Atomic Red Team is an open-source library of tests that security teams can use to simulate adversarial activity in their environments. Atomic tests are simple – each test is mapped to a single MITRE ATT&CK® technique or sub-technique, most of them have no prerequisites, and many come with easy-to-use configuration and cleanup commands.


Evaluation Lab users can now use Atomic Red Team simulations to evaluate Microsoft Defender for Endpoint’s detection capabilities against both Windows and Linux threats. The simulations are provided as script files, so that security teams can choose to run them in the Evaluation lab or any other testing environment of their choice.


 


Yaniv_Carmel_4-1637601557153.png


 


The first simulation, 2021 Threat Detection Report, executes tests according to Red Canary’s latest report of top Windows techniques associated with confirmed threats, as compiled from roughly 20,000 confirmed threats detected across customer environments.


 


The second simulation, Linux techniques, is a collection of simple tests compiled to allow security teams to evaluate Microsoft Defender for Endpoint’s detection capabilities against common Linux persistence, discovery, and defense evasion techniques.


 


We’re looking forward to you trying out the Evaluation Lab updates. Let us know your thoughts and feedback in the comments below or through the feedback tool in the portal!

Use intelligence to transform routing of service delivery requests

The most important customer experience metrics (that you’re not tracking yet)

This article is contributed. See the original author and article here.

Marketing professionals go to great lengths to understand customers. Detailed personas are written to identify the motivations, interests, and buying patterns of prospects and customers. But all too often, these personasand their resulting customer journeysare informed by data points important to the organization, not the customer. You cannot claim to be customer-centric, customer-first, or customer-obsessed if all the data you track is company-centric.

You may be thinking your organization is ahead of the customer journey curve here. After all, you’re already tracking customer-centric metrics such as net promoter score, customer satisfaction score, and customer effort score. But take a second look. These key performance indicators (KPIs) still ultimately measure benchmarks important to the organization, not the customer.

Go beyond KPIs with customer performance indicators

Nobody is arguing that an organization shouldn’t have a robust set of KPIs focused on measuring the fulfillment of important company objectives. But your toolbox of performance indicators doesn’t have to end thereand neither do the possibilities for the customer journey. Rather, take things to a whole new level by also measuring the fulfillment of customers’ objectives and optimizing the journey with the help of Microsoft Dynamics 365 Marketing.

Customer performance indicators (CPIs) quantify and measure outcomes that are desired by customers. These outcomes could include time savings, cost savings, convenience, flexibility, a sense of security, or any number of other outcomes customers deem valuable in the context of your product or service. There’s no cookie-cutter set of CPIs; they will vary widely across industries, organizations, products, and regions.

Consider the scenario of a retailer whose shoppers especially value speed. Acknowledging their shoppers’ priorities along with the need to balance services with expectations, the retailer tracks customers’ wait-time for curbside pick-up. They discover that wait times occasionally go beyond customer expectations. In response, the retailer implements a new feature that sends a flash promotional offer to high-value customers, when they are on their way during busy periods, for a complimentary drink redeemable from the in-store bar when they switch to in-store pickup. It’s a personalized gesture that acknowledges the retailer fell short of expectations but is trying to do its best to make it up to the customer. By optimizing the metrics that reflect what is important to the customer, the retailer can positively impact a whole host of KPIs, from customer satisfaction and customer loyalty to sales revenueand more.

Where KPIs end and customer performance indicators begin

There is a strong correlation between CPIs and KPIs. As illustrated by our retailer example, meeting the objective of a CPI is likely to boost associated KPIs. In fact, CPIs have been identified as powerful predictors of growth. Similarly, declining CPIs are likely to drag down associated KPIs.

CPIs also uncover insights about KPIs. Take customer satisfaction as an example. A high customer satisfaction score (a common KPI) indicates that an organization is doing something well. And while that’s critical information, this KPI on its own may not be able to provide visibility into what that something is. Or whether that something is even important to the customer. But a set of CPIs designed to measure desired customer outcomes such as personalized touches or chat availability can identify where the strongest correlations lie between what is important to the customer and what is important to the company.

CPIs and KPIs have a lot in common. They both measure performance, they both demonstrate progress toward an intended result, and they both impact the bottom line. For this reason, they can be difficult to distinguish from one another.

In the following table, we identify a few common KPIs. Alongside each KPI, we list one or more CPIs that could be used to enhance the understanding or performance of the associated KPI.

KPI CPI How CPI supports KPI
Customer lifetime value Value customer receives Customer lifetime value can be increased if there’s focus on ensuring there is a minimum, measurable value provided to the customer as well. For example, a loyalty card program could strive to save customers at least $100 a year.
Customer satisfaction score

In-person customer touches

Online chat availability

Do your customers value personalized, dedicated attention or the ability to quickly query representatives via informal chat applications? Understand the type of service interactions the customer values and implement CPIs to ensure you’re meeting expectations.
Product return rate

Ease of product return

Expense of product return

Is product return rate low because the product is superior or because the return process is unwieldy or expensive? By additionally tracking and optimizing the return experience of customers, you’ll have greater insight into the reasons behind your product return rate.
Quote to close ratio Quote turnaround time There are many factors influencing quote to close ratio. Find out what your customers valuewhether it be fast quote turnaround, flexible pricing plans, or something elseand start measuring it.

 

Find your customer performance indicators

What outcomes do your customers value? When you have the answer to that question, you can focus on delivering those outcomes. Every CPI identified, quantified, and measured brings new discoveries, new opportunities, and new levers to pull. Every CPI optimized is one more personalization you can bring to the customer journey, from brand voice and quote delivery to product bundling and customer service availability.

In short, it’s not enough to measure what’s important to your organizationnot if you want to optimize the customer journey and exceed customer expectations. You must also measure what’s important to your customers.

Learn how Dynamics 365 Marketing helps your organization optimize the CPIs that lead to elevated experiences.

The post The most important customer experience metrics (that you’re not tracking yet) appeared first on Microsoft Dynamics 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.