Use Power BI to analyze CQD data for Microsoft Teams

The Quality of Experience (QER) template is now available in the Power BI query templates for CQD download. The QER is a powerful reporting template that supersedes the original CQD Power BI query templates released in 2020. While the original templates will remain available for demonstration purposes, they're no longer supported or updated and we recommend customers switch to the QER template which will continue to receive updates. Note that this doesn't apply to the CQD Teams Auto Attendant & Call Queue Historical Report.

For Call Quality Dashboard (CQD) reports in Teams, if you'd rather use Power BI to query and report your data, download our CQD Power BI templates. When you open the templates in Power BI, you'll be prompted to sign in with your CQD admin credentials. You can customize these query templates and distribute them to anyone in your organization who has a Power BI license and CQD admin permissions.

Before you can use these PBIT files, you'll need to Install the Power BI Connector for Microsoft CQD using the MicrosoftCallQuality.pqx file included in the download.

Make sure you have the right CQD access role to access the Power BI reports.

Pbit Description
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 – analyze 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.

  • This template is provided on an as-is basis, and supersedes the deprecated templates as indicated below.
    QER MTR.pbit Part of the Microsoft Teams Optimized Experiences report package, this template is optimized for analyzing quality and reliability for Microsoft Teams Rooms (Windows & Android) deployments, and includes the following reports:
  • MTR Overview
  • MTR Network
  • MTR Device Health Details
  • MTR Meeting Health Details
  • QER PS.pbit Part of the Microsoft Teams Optimized Experiences report package, this template is optimized for analyzing Microsoft Teams Phone System deployments, including those environments using Direct Routing, and includes the following reports:
    Direct Routing Reports
  • SBC Overview
  • SBC Details
  • User Details by SBC

  • Phone System Reports
  • PSTN Overview
  • PSTN User Overview
  • PSTN User Details
  • PSTN Clients
  • PSTN Devices
  • CQD Teams Auto Attendant & Call Queue Historical Report.pbit This template provides the following three reports:

  • Auto Attendant – showing analytics for calls coming into your Auto Attendants.
  • Call Queue – showing analytics for calls coming into your Call Queues.
  • Agent Timeline – showing a timeline view of agents being active in Call Queue calls.

  • To learn more, read Auto Attendant & Call Queue Historical Report.
    CQD Teams Usage Report.pbit Shows how users in your organization are using Teams and how much. Make sure you upload the building data to maximize your reporting experience. To learn more, read Use CQD Power BI report to view Microsoft Teams utilization.

    Legacy templates

    The following templates are deprecated and no longer maintained. We recommend moving to the newer Quality of Experience (QER) templates going forward.

    Pbit Description
    CQD PSTN Direct Routing Report.pbit
    (Deprecated)
    Example template that provides insights specific for PSTN calls that go through Direct Routing. To learn more, read Using the CQD PSTN Direct Routing Report.
    CQD Helpdesk Report.pbit
    (Deprecated)
    Integrating building and EUII data, this template demonstrates how to build a report to enable drill through from a single user to find the upstream root cause of poor call quality for that user (for example, the user is in a building that's experiencing network problems).
    CQD Location Enhanced Report.pbit
    (Deprecated)
    This example template re-imagines the CQD SPD location reports. Includes 9 reports, providing Call Quality, Building WiFi, Reliability, and Rate My Call (RMC) information with additional drill-thrus by Building or by User. Make sure you upload the building data to maximize your reporting experience.
    CQD Mobile Device Report.pbit
    (Deprecated)
    This example template provides insights specifically tuned towards mobile device users, including Call Quality, Reliability, and Rate My Call. View mobile network, WiFi network, and mobile operating system reports (Android, iOS).
    CQD Summary Report.pbit
    (Deprecated)
    A demonstration of how CQD combined with Power BI can provide better visualizations, improved presentation, increased information density, and rolling dates. These reports make it easier to identifier outliers. Drill into call quality by location with an easy-to-use interactive map. Nine new reports:

    - Quality Overall
    - Reliability Overall
    - RMC (Rate My Call) Overall
    - Conference Quality
    - P2P Quality
    - Conference Reliability
    - P2P Reliability
    - Conference RMC
    - P2P RMC
    CQD User Feedback (Rate My Call) Report.pbit
    (Deprecated)
    Demonstration of a Power BI report using Rate My Call data in a way that you can easily use to help support calling for your organization. Cross-reference with verbatims to identify end user education opportunities.

    Tip

    Once you've set up your Power BI reports for CQD data, add them as a tab to a channel. After you select + in a channel, select Power BI and then find your report. To learn more, read Embed report with the Power BI tab for Teams. Remember, only people with a Power BI license and CQD admin credentials can access these reports.

    Dimensions and measures available in Call Quality Dashboard

    Stream Classification in Call Quality Dashboard

    Set up Skype for Business Call Analytics

    Use Call Analytics to troubleshoot poor call quality

    Call Analytics and Call Quality Dashboard