Type something to search...
How to analyze incoming calls in Teams with CQD

How to analyze incoming calls in Teams with CQD


Définition

Microsoft’s Teams Call Quality Dashboard (CQD) is a powerful tool designed to help administrators monitor and improve the quality of phone calls within their organization. The Power BI template allows you to generate historical reports on the number of calls handled by auto attendants, call queues and agent performance.


Prerequisites

Power BI Desktop

  • Power BI Desktop must be installed.

Administrator role

  • An account with the Global Administrator, Teams Administrator, or Teams Communications Administrator role to retrieve data.

Step 1 : Download the CQD templates for Power BI

Download the CQD templates via https://www.microsoft.com/download/details.aspx?id=104623.


Step 2 : Retrieve data

Open the downloaded .pbit file by double-clicking it. Power BI should launch.

Click professional Account.

image

Enter your Microsoft 365 administrator account, then click Sign In.

image


Step 3 : Access the data

Auto Attendant

The report presents the analysis of incoming calls to auto attendants. You can filter which auto attendant resource account you want to retrieve the data on.

image


Call Queue

The report presents the analysis of incoming calls to call queues. You can filter which call queue resource account you want to retrieve the data on.

image


Agent Timeline

The report presents a time-series analysis of call handling by agents in call queues. You can filter the data by which agent and call queue resource account you want to view.

image

info

Data will be available for all calls 28 days and younger, with a 30-minute delay before analysis is available.

Conclusion

You now know how to retrieve and analyze incoming calls in Teams via CQD models for Power BI.


Sources

Microsoft Learn - Teams history reports

Microsoft Store - Power BI Desktop


Did you enjoy this post ? If you have any questions, comments or suggestions, please feel free to send me a message from the contact form.

Don’t forget to follow us and share this post.

Related Posts

How I resolved dropped Teams calls

How I resolved dropped Teams calls

Introduction A customer contacted me to tell me that he was having an issue with his Microsoft Teams telephony. Outgoing calls are being cut off even before the audio connection is establis

Read More
Pricing update for Teams telephony licenses

Pricing update for Teams telephony licenses

Introduction Microsoft recently announced a price increase for several Teams telephony licenses, effective April 1, 2025. This pricing update reflects the continued innovation and increased

Read More
The SMS messages will be native in Teams

The SMS messages will be native in Teams

Introduction Microsoft Teams continues to evolve, offering comprehensive communication and collaboration solutions. Among its features, SMS integration allows Teams users to easily communic

Read More
Microsoft Teams Call Quality Data (CQD) QER v5.0 !

Microsoft Teams Call Quality Data (CQD) QER v5.0 !

Introduction Microsoft Teams continues to evolve, providing high-quality communication and collaboration experiences. The Quality of Experience Report (QER) v5.0 is a significant update

Read More
Import the DigiCert Root G2 certificate into a Ribbon SBC

Import the DigiCert Root G2 certificate into a Ribbon SBC

Introduction Since the arrival of Teams Direct Routing telephony, TLS certificates used by Microsoft servers are linked to the following root certification authority :Common Certificate

Read More
Import the DigiCert Root G2 certificate into an Audiocodes SBC

Import the DigiCert Root G2 certificate into an Audiocodes SBC

Introduction Since the arrival of Teams Direct Routing telephony, TLS certificates used by Microsoft servers are linked to the following root certification authority :Common Certificate

Read More
How to configure callback in a Teams queue

How to configure callback in a Teams queue

Definition Callback in Teams allows callers in a queue to be called back after a certain time rather than waiting until an agent becomes available.Prerequisites **Licenses r

Read More
How to handle duplicates in Teams directory search

How to handle duplicates in Teams directory search

Introduction Microsoft recently announced a significant optimization for the search by name and extension functionality in its Teams auto attendants. You have probably already had this case

Read More
How to inventory Direct Routing numbers in Teams

How to inventory Direct Routing numbers in Teams

Introduction Microsoft Teams continues to evolve to offer ever more effective communication and collaboration solutions. To make life easier for administrators, Microsoft has announced the

Read More
Debugging Teams calls via the SIP ladder

Debugging Teams calls via the SIP ladder

Introduction Microsoft Teams continues to evolve to offer ever more advanced communication and collaboration solutions. Among the features arriving very soon, we find the possibility of obt

Read More
How to analyze Direct Routing calls via the SIP ladder

How to analyze Direct Routing calls via the SIP ladder

Introduction I wrote an article last February to announce the upcoming release of the SIP ladder to analyze Teams Direct Routing calls from the Microsoft Teams Admin Center. The feature is

Read More
How to enable LDAP routing in an Audiocodes SBC

How to enable LDAP routing in an Audiocodes SBC

Introduction LDAP (Lightweight Directory Access Protocol) routing over an SBC (Session Border Controller) allows calls to be managed using information stored in an Active Directory.

Read More