QER

Welcome to the Microsoft Teams Quality of Experience Report (QER) for Power BI.

This template was created with two primary goals in mind:

1. Empower organizations to proactively identify issues that are impacting the Microsoft Teams meeting and calling expierence.
2. Enable organizations to respond quickly to escalating issues and help answer the question, "What happened during the meeting?"

The QER also hosted on MS Downloads and can be downloaded along with all the MS Power BI templates listed here.

GitHub Contents

1. QERPBI.zip - The QER Power BI teamplate. Includes relase notes and installation instructions (.docx), Microsoft Call Quality Connector (.pqx), and the template (.pbit)
2. CQD-BuildingData.xlsx - A template to help organizations create a CQD Building Data file.
3. CQD-EndpointData.xlsx - A template to help organizations create a CQD Endpoint Data file.
4. CQD-Teamplate-Rolling-Reports.zip - A collection of templates for the CQD web UI. (legacy)
5. QER-CQDv3-Templates.zip - A collection of QER templates for the CQD web UI. (legacy, commercial tenants only)

Requirements

1. Power BI Desktop - Download through Windows Store or Microsoft Downloads.
2. Microsoft Power BI Connector for CQD - Included with template download (.pqx)

Reference Material

• Using Power BI to analyze CQD data
• Microsoft Power BI Connector for CQD

This template provides the following reports

• Search – enables searching by Meeting URL, Conference ID, Subnet, or UPN.
• Meeting Health Details / Call Health Details – detailed metrics for a single meeting or P2P call.
• User Health Details – detailed metrics for a single user.
• Media Usage – general meeting and calling usage.
• Media Health – high level overview of Key Health Indicators (KHI) for overall tenant meeting and calling health.
• Media Setup – analyze media setup failures.
• Media Reliablity – 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 areas of impact in your tenant health.
• Dailies – review daily report of KHIs.
• User Feedback – review user survey feedback, also known as Rate My Call.
• Transport – identify networks that are blocking UDP.
• Devices – review the impact of audio 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 Metric Reports – three reports that display raw network metric details for jitter, packet loss, and latency in daily, weekly, and scatter plot views.

NOTE: This template is provided as-is and is not an officially supported product of Microsoft.