This is a follow up on my last blog post covering automated teams voice assignment for users. This time I will cover how the mentioned routine has been expanded to do reporting in PowerBI to show evolution and distribution throughout the lifetime of the service.
After running my routine of automated voice assignment in Teams for a while, I felt the need to have an overview of the solution and how it evolved.
I used some experience from the project of reporting license usage for Microsoft 365 to expand the Teams routine. Lets dive into some details.
The report can also show on a map where users are located:
By adding a table of usernames and a search functionality, it is easy to find persons. This table will also be filtered by clicking on the graphical elements. In this way we can also add filters for operators - this is done by adding logos in a Chiclet Slicer. When clicking on the operator logo, the data shown in the report will be filtered accordingly. The report has also been equiped with a TimeLine filter where the usage can be filtered to a given period or point in time.