- 24 Jan 2023
- 2 Minutes to read
- Updated on 24 Jan 2023
- 2 Minutes to read
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.
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.
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.
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).
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
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.
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.
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.