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 is now hosted on MS Downloads and can be downloaded along with all the MS Power BI templates listed here.

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)

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

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

• 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 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.

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

1. Selecting an ISP name to enable interactive filtering will result in an error. As a workaround please select the associated ASN # to activate the filter.
2. Slicers are limited to 100 entries. If you have more than 100 entires in your slicer you can leverage the search bar in the slicer. Add a * to the end of the search to return all resutls. Example: Bui* will return all the results that start with "Bui".