Use Power BI to analyze CQD data for Microsoft Teams

New in January 2020: Download Power BI query templates for CQD. Customizable Power BI templates you can use to analyze and report your CQD data.

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

CQD Helpdesk Report.pbit Integrating building and EUII data, this report is designed to let you drill up 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 Re-imagining 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 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 PSTN Direct Routing Report.pbit Provides insights specific for PSTN calls that go through Direct Routing. To learn more, read Using the CQD PSTN Direct Routing Report.
CQD Summary Report.pbit 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. 9 new reports:

- Quality Overall
- Reliability Overall
- RMC (Rate My Call) Overall
- Conference Quality
- P2P Quality
- Conference Reliability
- P2P Reliability
- Conference RMC
- P2P RMC

(New!) CQD Teams Utilization 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.
CQD User Feedback (Rate My Call) Report.pbit Shows 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