This Power BI template provides three reports that allow organizations to report on the number of calls processed by auto attendants and call queues. It also provides agent performance insights.
The Teams Auto Attendant & Call Queue Historical Report Power BI template provides the following three reports:
The Auto Attendant report shows analytics for calls coming into your auto attendants.
The Call Queue report shows analytics for calls coming into your call queues.
The Agent Timeline report shows a timeline view of agents being active in call queue calls.
These reports use data from the Voice Applications Analytics Collector (VAAC) service.
installation
The following steps assume you've already installed Power BI Desktop on your computer and that your account has the necessary permissions to access the CQD data pipeline.
Perform the following steps:
Download and save the Teams Auto Attendant & Call Queue Historical Reports V3.0.7.zip file on your computer.
Open the zip file.
Open the Teams Auto Attendant & Call Queue Historical Reports V3.0.7.pbit template file. Power BI Desktop should launch.
You'll be prompted to select the Data Source. Select the api.interfaces.records.teams.microsoft.com entry.
You'll be prompted to sign in with an account. Select Organizational account, and then select Sign in.
Select Connect, and the data will refresh.
let's do a test using a test AA and CQ :
CQ test including Two users :
When downloading the CQD zip file and extract it :
When opening it and connect using our account (must have a PowerBi licence) :
Charging ... and that's the result :
examples of incoming calls to our AA from an external number using Calling plan technologie , transfering the call to our call queue :
This can be very helpful for Teams and telephony over IP admins !
Thanks for reading .