Power Bi
  • 24 Jan 2023
  • 2 Minutes to read
  • PDF

Power Bi

  • PDF

Article summary

Power Bi

Power Bi can be used to connect to Microsoft Teams Call Quality Dashboard in order to show org-wide level information for call and meeting qualities. These then can be added to a Microsoft Teams team for easy access via the Microsoft Teams client.

This information can then be used to troubleshoot and/or identify problems concerning usage of Teams to more in depth information about network issues.

It is possible to build your own Power Bi requests, or one can download Power Bi query templates for the Advanced Call Quality Dashboard (CQD) from Microsoft.

This is a collection of seven templates that can be used as a start to check different issues concerning Teams and can be further extended with other queries if needed.

Important to note when using Power Bi together with CQD information is that you need to upload Building, Network and Endpoint data to be able to filter certain results, not doing so will result in no or very broad information only without the possibility to drill through to a lower level.

For customers using Infracoms Teams DR services the most important report from that package is the CQD PSTN Direct Routing Report that can be used to identify issues for your PSTN calls that go through Direct Routing.

Graphical user interface, application  Description automatically generated

Giving possibilities for seeing calling trends identified by your SBC, determining Network issues like Packet Loss, or seeing Call End reasons.

The remaining reports can be used to identify issues in your Network regarding your users and endpoints for both P2P and Conference calls.

Following is a short description of each of those:

CQD Helpdesk Report

Enables you to investigate upstream causes of poor call quality for users.

Graphical user interface, application  Description automatically generated

CQD Location Enhanced Report 

Includes 9 reports, providing Call Quality, Building WiFi, Reliability, and Rate My Call (RMC) information with additional drill-through by Building or by User. Make sure you upload the building data to maximize your reporting experience.

Graphical user interface, application, website  Description automatically generated

CQD Mobile Device Report

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

Graphical user interface, application, Teams  Description automatically generated

CQD Summary Report

 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

Graphical user interface, application  Description automatically generated

CQD Teams Utilization Report

Shows how users in your organization are using Teams and how much. Make sure you upload the building data to maximize your reporting experience.

Graphical user interface  Description automatically generated with low confidence

CQD User Feedback (Rate My Call) Report

Shows Rate My Call data in a way that you can easily use to help support calling for your organization.

Graphical user interface, application, Teams  Description automatically generated

CQD Auto Attendant & Call Queue Historical Report

If you are using Microsoft’s own Auto Attendant and Call Queues you can use this template.

-Auto Attendant: showing analytics for calls coming into your Auto Attendants

-Call Queue: showinw analytics for calls coming into your Call Queues

-Agent Timeline: showing a timeline view of agents being active in Call Queue calls.

Graphical user interface, application  Description automatically generated



Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.