Lesson Learned #482: Identifying Potential Duplicate Statistics
Some time ago, we encountered a support case where a customer experienced significant delays in updating auto-created and user-created statistics. I would like to share the insights gained from this experience, including the underlying causes of the issue and the potential solutions we identified and implemented to address the problem effectively.
MS Teams Get-CsCallQueue Statistics field is blank again...
We has been using the Get-CsCallQueue cmdlet that comes in the Teams module to get the Number of Calls In Queue statistic for our call queues. As of a few days ago, this field has been coming back blank for all our queues. Does anyone know what causes this? A search of the web shows other people have had this issue over the last few years but I don't know if there is a solution on our end or if it is some change in Azure that is causing it.Reporting Meeting Room Statistics with PowerShell and the Microsoft Graph
This article explains how to use the Microsoft Graph API and PowerShell to extract meeting data from the calendars of room mailboxes to generate statistics. The idea is that you can use the data to figure out how busy meeting rooms are in a world when hybrid working might make the idea of a conference room less attractive. https://practical365.com/report-room-mailbox-statistics/
Meeting Statistics Excel
Hi, I have an issue concerning statistics in Microsoft Teams, I administrate a school with different students and classes, and they need to have every connection time and duration of every class they're doing. There is an "HR guy" who's job is to monitor theses information. Right now I know two options to have this information : - The first one is to go to the teacher's user page in the Teams Administration Center, then go to call history, and click on the meeting I want to see, (see screenshot1) this method is not ergonomic because when the "HR" guy match the students presence and delay, the names are disordered and when a student have a disconnection, we need to add every connection time one by one and it makes it very long when you have multiple class and lots of disconnections. - The second way would be that at the end of a class, the teacher need to go to the attendee list and download the attendee list so he can get an excel of who disconnected when and order people by name (see screenshot2), which solve my two problems said earlier, but the method to get that excel file is to complicated and some teacher might forget to do it, I would need to have this excel file by anytime. So, do you know any better and simpler way to do that ? Thank you for any advice. Gabriel
Statistical models in Excel
Hi Guys, I am trying to see how I can build a simple statistical model in Excel. Let's say I have 10 salespeople. For each of them, they have sold X amount of the year. I want to see the relationship between data I've collected about their differing sales experience, industry experience, calls, demos and see whether there is a correlation in positively affecting their sales performance for that year. I haven't used statistical modeling in Excel very much. Does anyone have an indication how I can set it up in Excel? Any tips would be huge. Many thanks in advance.
