How to get Microsoft Teams call quality data from Power BI?

I often get this question these days during Covid-19. We all have the same situation, whatever is our job, we are at home trying to work as efficient as possible to make sure that everything is on track. Business continues virtually, so is the education! The new way of things work brought us new kind of challenges such as auditing and monitoring the meetings. Most of our workspace activities (chatting, meeting, screen sharing, file sharing etc.) are running on Microsoft Teams now, often company’s departments responsible of auditing are looking for solutions to get more data from Microsoft Teams.

To help addressing many of the questions, Microsoft released Call Analytics and Call Quality Dashboards (CQD).

Call Analytics is available in the Microsoft Teams admin center to see detailed information about the devices, networks, and connectivity related to the calls and meetings for each user in a Microsoft Teams tenant account.
Call Quality Dashboard data is available with many dimensions and measurements to analyze and customize on Power BI with a provided connector and templates. All we need to do is:

  1. Download Power BI query templates for Microsoft CQD from GitHub here.
  2. Create a new folder called “Power BI Desktop under Documents folder.
  3. Create a new folder called “Custom Connectors” under Power BI Desktop folder. Final destination should be Documents\Power BI Desktop\Custom Connectors.
  4. Extract CQD-Power-BI-query-templates.zip and copy MicrosoftCallQuality.pqx under Documents\Power BI Desktop\Custom Connectors.

Now, it’s time to enable custom connector extensibility settings in Power BI Desktop and run Call Quality Dashboards.

Developers like us can enable new data sources with custom data extensions called custom connectors.  To be able to use non-certified custom connector, Data Extensions settings should be enabled to allow any extension to load.

In Power BI Desktop, select File > Options and settings > Options > Security.

Under Data Extensions, select (Not Recommended) Allow any extension to load without validation or warning

Select OK, and then restart Power BI Desktop.

When Power BI Desktop restarted, click on “Get Data” and Select “More.”

Microsoft Call Quality Connector should appear under Online Services.

Select “Microsoft Call Quality (Beta)” and click Connect.

Microsoft Call Quality Connector requires Azure Active Directory Global Admin Consent to retrieve the data from tenant.

Login with a Global Admin account and admit the consent.

After the login, click connect and select connection settings as DirectQuery.

As a result, you will see long list of data under the fields. Select any field, drag and drop to the page to test the data. Feel free to build your own dashboard by adding some visualizations.

You may also leverage from the built-in dashboards available under CQD-Power-BI-query-templates.zip.

Feel free to test any of the dashboards listed above.

Make sure to edit permissions by clicking Data source settings under Transform Data and sign in with your global admin account.

CQD Teams Utilization Report is shown below as an example.

Call Quality Dashboards are quite useful for tracking call counts per month/day, even drilling down by conference or user for more information. Also, it is easy to customize if you are looking for something different.

Keep in mind that CQD is to get more insights about the calls, so it doesn’t contain Microsoft Teams details for tenant such as team names, member/owner names, policy information etc. To get Microsoft Teams tenant data and use it in Power BI, we will need to build our own custom connector by using Microsoft Graph API. I will create a separate post to walk you through on that.

I hope you enjoy reading the post. Looking forward to get your comments.

Cheers!

Build AI-powered virtual assistant for healthcare with almost no code!

Have you ever heard about the Microsoft Healthcare Bot service that provides AI-based virtual assistance to support healthcare organizations? If yes, you already knew how easy it is to build and deploy the service with minor customization to adapt in your organization. In fact there is no doubt, it was the rescue for many scenarios during Covid-19 outbreak where many of us still benefit from it when we need quick answers to our questions about our health conditions. Well, If you never heard of Microsoft Healthcare Bot service before, I am here to take you through the hints that you would take a look before you go ahead and try the service.

  1. What is the Microsoft Healthcare Bot service exactly?
    It’s a chatbot which has built-in healthcare intelligence with a language understanding model based in medical terminology. Let’s drill down a little bit! It means that we don’t need to build the entire medical content in AI service, it comes with an industry knowledge which can serve millions of users at once.
  2. How can I build the conversation flow the way I want?
    Healthcare Bot Service provides a Management Portal where you can build your conversations with “no code”. You can create new dialogs, drag and drop to the editor to build the dialog flow and customize it however you want!

    undefined
  3. Where can I start?
    Visit Azure Portal and Create your first the Healthcare Bot.

    undefined

    Check out Healthcare Bot Service Management Portal and build your first scenario by using drag and drop scenario editor.

    undefined

Go ahead and try the service in couple of minutes and share your experience with the community! Feel free to ask your questions under the post. Let’s discuss what went well, what didn’t go well.