{"id":742,"date":"2020-10-22T10:40:24","date_gmt":"2020-10-22T17:40:24","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sdk\/?p=742"},"modified":"2020-10-22T10:41:21","modified_gmt":"2020-10-22T17:41:21","slug":"visualizing-customer-sentiment","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sdk\/visualizing-customer-sentiment\/","title":{"rendered":"Analyzing Call Center Conversations with the new Azure SDK Cognitive Services Libraries"},"content":{"rendered":"

Analyzing the recorded audio, video, or chat history, as well as the average conversation time can be very helpful. We can find this kind of data in the call centers which are company hubs for customer communication. This article presents how new Azure .NET SDK client libraries (Cosmos DB, Text Analytics and Azure Storage Blobs) were used in the real project – call center conversations analyzer.<\/p>\n

Business case<\/h2>\n

Together with my team at Predica<\/a>, we needed a solution to get insights related to the recorded audio, video, and chat history from the call center owned by one of our clients. We wanted to know how many customers are satisfied and what are the most popular topics. This is why we decided to build call center conversations analysis solution with Azure cloud using services like Azure Storage, Azure Functions, Azure Cognitive Services, Azure Media Services Video Indexer, and Azure Cosmos DB.<\/p>\n

Solution architecture<\/h2>\n

The below diagram presents an implemented solution, that enables uploading PDF files with conversation history or audio\/video files of the recorded conversation.<\/p>\n

\"call-center-talks-analysis.png\"<\/p>\n

These services were used:<\/p>\n

    \n
  1. Azure Storage Account (Blob Storage)<\/a><\/strong> – to store text, audio and video files for the further analysis<\/li>\n
  2. Azure Durable Functions<\/a><\/strong> – to orchestrate analysis flow<\/li>\n
  3. Azure Cognitive Services Text Analytics<\/a><\/strong> – to analyze text and get sentiment together with topics<\/li>\n
  4. Azure Cognitive Services Form Recognizer<\/a><\/strong> – to scan PDF documents with OCR<\/li>\n
  5. Azure Video Indexer<\/a><\/strong> – to analyze audio and video content<\/li>\n
  6. Azure Cosmos DB<\/a><\/strong> – to store analysis results as JSON documents<\/li>\n
  7. Power BI<\/a><\/strong> – to visualize collected data in a form of report<\/li>\n
  8. Azure Application Insights<\/a><\/strong> – to monitor the solution and discover issues<\/li>\n<\/ol>\n

    Services choice substantiation<\/h3>\n

    Before we discuss solution implementation in detail, it is worth to talk about why we decided to use the services listed above.<\/p>\n

    Azure Storage Account<\/h4>\n

    Azure Storage Account (Blob Storage in this case) was a natural choice for a place for storing source documents. Azure Blob Storage is a cost-efficient and secure service for storing different types of documents. In our solution, we used not only text documents, but also audio and video.<\/p>\n

    Azure Durable Functions<\/h4>\n

    Initially, we thought about using Azure Web App and host API that would be responsible for orchestration. After some discussions, we made our mind to go with Azure Durable Functions. The reason behind it was simple. First, we wanted to run the analysis flow only when there is a new file uploaded on the Azure Blob Storage. Azure Functions are ideal to be used as event handlers. The second important reason was related to cost. With Azure Functions, we can reduce the cost as the first million executions are for free.<\/p>\n

    Azure Cognitive Services Text Analytics<\/h4>\n

    There are many Azure Cognitive Services available. We needed a service to analyze the content of the text document and provide information about sentiment value. It is not easy to write own processor to discover emotions for instance. We wanted to analyze the conversation script and discover some insights related to customer satisfaction.<\/p>\n

    Azure Cognitive Services Form Recognizer<\/h4>\n

    Form Recognizer is a great service that provides an easy way to extract text, key\/value pairs, and tables from documents, forms, receipts, and business cards. Initially, we wanted to use Azure Computer Vision API to scan documents with OCR but in the end, we moved with Form Recognizer. The reason behind it was simple. In the future, we have also plan to scan customer satisfaction survey forms and with Form Recognizer, it will be much easier to extract the content and validate specific values.<\/p>\n

    Azure Video Indexer<\/h4>\n

    When it comes to video analysis, Azure Video Indexer is powerful. With this service, we were able to process audio and video files and extract information about customer satisfaction using the sentiment analysis feature. Of course, this is only a small part of Video Indexer’s capabilities. It also provides a way to create translations, automatically detect language, or face detection of people in the video.<\/p>\n

    Azure Cosmos DB<\/h4>\n

    There are a few different databases available in the Azure cloud. The most popular, Azure SQL, was our first shoot when designing the architecture of the system. Clear structure, easy and secure access. There was one fact that we realized further. Our data model was not constant. We had a plan to extend it in the future and we wanted to remain flexible when it comes to data schema. This is why we decided to switch to Azure Cosmos DB. As a non-relational database, it was a perfect match. It also provides a geo-replication and easy way to manage the data using Azure Cosmos DB SDK.<\/p>\n

    Power BI<\/h4>\n

    To visualize the results we used Power BI. With this easy to use tool, we were able to create dashboards with information about customer satisfaction.<\/p>\n

    Azure Application Insights<\/h4>\n

    Monitoring and resolving issues in the solution are very important. We wanted to be sure that if an issue occurs we will be able to identify it quickly and resolve. This is why we integrated Azure Application Insights in our solution.<\/p>\n

    Data flow<\/h3>\n

    Below diagram presents the data flow in our solution:<\/p>\n

    \"call-center-talks-analysis-3.png\"<\/p>\n

    Now let’s talk about some implementation details.<\/p>\n

    Azure Cosmos DB for .NET in action<\/h2>\n

    Once text, audio, and video files are analyzed by different Azure cloud services, we store analysis results in Azure Cosmos DB. This allows us to easily connect to our data from Power BI and we can extend the data model in the future. The code snippet below shows how we implemented a service class that uses a CosmosClient<\/code> instance from the new Azure Cosmos DB client library for .NET<\/a>:<\/p>\n

        public sealed class CosmosDbDataService<T> : IDataService<T> where T : class, IEntity\n    {\n        private readonly ICosmosDbDataServiceConfiguration _dataServiceConfiguration;\n        private readonly CosmosClient _client;\n\n        \/\/Shortened for brevity\n\n        private CosmosContainer GetContainer()\n        {\n            var database = _client.GetDatabase(_dataServiceConfiguration.DatabaseName);\n            var container = database.GetContainer(_dataServiceConfiguration.ContainerName);\n            return container;\n        }\n\n        public async Task<T> AddAsync(T newEntity)\n        {\n            try\n            {\n                CosmosContainer container = GetContainer();\n                ItemResponse<T> createResponse = await container.CreateItemAsync(newEntity);\n                return createResponse.Value;\n            }\n            catch (CosmosException ex)\n            {\n                _log.LogError($\"New entity with ID: {newEntity.Id} was not added successfully - error details: {ex.Message}\");\n                if (ex.ErrorCode != \"404\")\n                {\n                    throw;\n                }\n                return null;\n            }\n        }\n    }\n<\/code><\/pre>\n
    To follow best practices related to lifetime management<\/a>, CosmosClient<\/em> type is registered as singleton in the IoC container.<\/p>\n
    Azure Storage Blobs for .NET SDK in action<\/h2>\n
    As mentioned at the beginning of the post, we used the Azure Media Services Video Indexer to analyze audio and video file content. To make it possible for the Video Indexer to access files stored in the Azure Storage, we have to add a Shared Access Signature (SAS) token to the URL that points to the blob. We created our own StorageService<\/code> using a BlobServiceClient<\/code> instance from the new Azure Storage Blobs .NET client library<\/a>. Please note that the last method is responsible for generating SAS tokens:<\/p>\n
        public class StorageService : IStorageService\n    {\n        private readonly IStorageServiceConfiguration _storageServiceConfiguration;\n        private readonly BlobServiceClient _blobServiceClient;\n\n        \/\/Shortened for brevity\n\n        public async Task DownloadBlobIfExistsAsync(Stream stream, string blobName)\n        {\n            try\n            {\n                var container = await GetBlobContainer();\n                var blockBlob = container.GetBlobClient(blobName);\n\n                await blockBlob.DownloadToAsync(stream);\n\n            }\n\n            catch (RequestFailedException ex)\n            {\n                _log.LogError($\"Cannot download document {blobName} - error details: {ex.Message}\");\n                if (ex.ErrorCode != \"404\")\n                {\n                    throw;\n                }\n            }\n        }\n    }\n<\/code><\/pre>\n
    As I mentioned above when talking about lifetime management, we followed best practices and registered our BlobServiceClient<\/code> instance as singleton in the IoC container.<\/p>\n
    Azure AI Text Analytics and Form Recognizer .NET SDK in action<\/h2>\n
    Having chat history in the form of text files, we used Azure Cognitive Services Text Analytics to analyze the content and Form Recognizer to apply OCR scanning on the documents to extract the text content. One of the great features of Text Analytics is the ability to analyze sentiment. After scanning the chat conversation, we can get sentiment analysis results that will be displayed on our Power BI dashboard. To process text files, we created TextFileProcessingService<\/em> class which uses TextAnalyticsClient<\/em> instance from the new Text Analytics .NET client library<\/a>:<\/p>\n
        public class TextFileProcessingService : ITextFileProcessingService\n    {\n        private readonly TextAnalyticsClient _textAnalyticsClient;\n        private readonly IStorageService _storageService;\n        private readonly IOcrScannerService _ocrScannerService;\n\n        \/\/Shortened for brevity\n\n        public async Task<FileAnalysisResult> AnalyzeFileContentAsync(InputFileData inputFileData)\n        {\n            if (inputFileData.FileContentType == FileContentType.PDF)\n            {\n                var sasToken = _storageService.GenerateSasTokenForContainer();\n                inputFileData.FilePath = $\"{inputFileData.FilePath}?{sasToken}\";\n\n                var textFromTheInputDocument = await _ocrScannerService.ScanDocumentAndGetResultsAsync(inputFileData.FilePath);\n                try\n                {\n                    DocumentSentiment sentimentAnalysisResult = await _textAnalyticsClient.AnalyzeSentimentAsync(textFromTheInputDocument);\n                    var fileAnalysisResult = new FileAnalysisResult();\n                    fileAnalysisResult.SentimentValues.Add(sentimentAnalysisResult.Sentiment.ToString());\n                    return fileAnalysisResult;\n                }\n                catch (RequestFailedException ex)\n                {\n                    _log.LogError($\"An error occurred when analyzing sentiment with {nameof(TextAnalyticsClient)} service\", ex);\n                }\n            }\n\n            throw new ArgumentException(\"Input file shuld be either TXT or PDF file.\");\n        }\n    }\n<\/code><\/pre>\n
    Please note that again here, we use the instance of the StorageService<\/em> class to get Shared Access Signature and make it possible for Text Analytics API to access the file stored on the Blob Storage. Again, when talking about lifetime management, we followed best practices and registered TextAnalyticsClient<\/em> instance as a singleton in the IoC container.<\/p>\n
    Form Recognizer SDK was used to apply OCR scanning on the PDF documents and to extract the text content:<\/p>\n
        public class OcrScannerService : IOcrScannerService\n    {\n        private readonly FormRecognizerClient _formRecognizerClient;\n        private readonly ILogger<OcrScannerService> _log;\n\n        \/\/Shortened for brevity\n\n        public async Task<string> ScanDocumentAndGetResultsAsync(string documentUrl)\n        {\n            FormPageCollection formPages = await _formRecognizerClient.StartRecognizeContentFromUriAsync(new Uri(documentUrl)).WaitForCompletionAsync();\n            StringBuilder sb = new StringBuilder();\n\n            foreach (FormPage page in formPages)\n            {\n                for (int i = 0; i < page.Lines.Count; i++)\n                {\n                    FormLine line = page.Lines[i];\n                    sb.AppendLine(line.Text);\n                }\n            }\n\n            return sb.ToString();\n        }\n    }\n<\/code><\/pre>\n
    We followed best practices and registered FormRecognizerClient<\/em> instance as a singleton in the IoC container.<\/p>\n
    Reporting collected data<\/h2>\n
    Below there is a fragment of Power BI dashboard with collected data:<\/p>\n
    \"call-center-talks-analysis.png\"<\/p>\n
    Full project available on GitHub<\/h2>\n
    The project described in this article is available on my GitHub under this link<\/a>. If you would like to see implementation details or play with the project yourself, feel free to fork this repository. If you want to read more about Text Analytics SDK, please read Text Analytics Service documentation<\/a> and if you are interested in reading more about lifetime management, please refer to Lifetime management for Azure SDK .NET clients <\/a> blog post.<\/p>\n
    <\/p>\n
    Azure SDK Blog Contributions<\/h2>\n
    Thank you for reading this Azure SDK blog post! We hope that you learned something new and welcome you to share this post. We are open to Azure SDK blog contributions. Please contact us at azsdkblog@microsoft.com<\/a> with your topic and we’ll get you setup as a guest blogger.<\/p>\n
    Azure SDK Links<\/h2>\n