MS Teams QER 4.8 - Call Quality Dashboard Power BI Data - Email Subscriptions

Hello All

Hope you are doing great  Today we are going to see, how to publish the QER 4.8 - CQD data in to PowerBI online from PowerBI desktop and how to subscribe the template to automate the email to send the CQD report to our Support admin persons

Prerequisites 

• You need PowerBI Pro licenses
• you need a member of Team administrator role

CQD - Call Quality Dash Board 

The Microsoft Call Quality Dashboard (CQD) - https://cqd.teams.microsoft.com - shows call and meeting quality, at an org-wide level, for Microsoft Teams

QER File  QER.pbit

The Quality of Experience Report (QER) template empowers customers to proactively identify issues that are impacting the Teams meeting and calling experience before they escalate. 

Reports are also provided to enable administrators to respond quickly to escalating issues and help answer the question, "What happened during the meeting?"

This template provides the following reports:

Search – enables searching by Meeting URL, Conference ID, Subnet, or UPN.

Meeting Health Details – detailed metrics for a single meeting.

User Health Details – detailed metrics for a single user.

Media Health – high level overview of Key Health Indicators (KHI) for overall tenant meeting and calling health.

Media Setup – analyse media setup failures.

Media Reliability – analyze media reliability issues.

Audio/Video/Sharing Health – review mid-level KHIs for audio, video, or sharing health.

Audio/Video/Sharing Health Details – review detailed metrics on audio, video, or sharing health.

VPN – review the impact of VPN on meeting health. (Estimated or Mapped VPN)

Top 10 Reports – identify problem areas in your tenant.

Dailies – review daily report of KHIs.

Usage – general meeting and calling usage.

User Feedback – review user survey feedback, also known as Rate My Call.

Transport – identify networks that are blocking UDP.

Devices – review the impact of devices.

Clients - review client focused metrics.

Building Data – review the building data file in CQD.

PSTN Health and User Details – two reports that provide a high level summary as well as individual user health for PSTN based calls.

Network Metrics – two reports that display raw network metric details for jitter, packet loss, and latency.

I believe, you have already install the latest version of PowerBI desktop

Download the later QER file and keep it in any location

 

Open the QER V4.8. PBIT file in PowerBI Desktop

Select the template you want to subscribe in email and click publish

Save it at your desired location as PBIT file

Then , finally select your workspace in power-bi and Save It

Now open the powerBI online using, app.powerbi.com

select your workspace and open the QER file as Report file 

Select the Subscribe to Report

Select Add New Subscription

Enter the email address which you want to receive the report

Select the Time 

In more option, you may choose the subject and Templates etc 

Click save once its completed

You will started receive email from powerBI QER Subscription 

Sample Email 

I believe this topic is helpful for our day to day task for Teams admin. Happy learning 😊