Dashboard Gallery

Microsoft Teams

The IT department at Purdue College of Science had an immediate need for a dashboard to visualise key metrics related to their usage of Microsoft Teams for their online classrooms. This dashboard keeps track of the number of and which teams that are empty and the total number of teams which allows them to pinpoint issues with the data load to create the teams or update issues. The dashboard also monitors for empty class sections to help identify issues with the class selection process.

Daniel Parrott, Purdue University


Microsoft Teams classrooms are created for each Division and Section of specific courses as defined by the Office of the Registrar. Given the large number of sections, and since the creation of the Microsoft Teams accounts is problematic, the College of Science wanted to monitor for additions, deletions, changes, etc. of the Teams classrooms. Specifically, the biggest problem they were facing was trying to identify unused Teams classrooms and watch for their inadvertent deletions.


Using the Microsoft Teams module for PowerShell, Danny was able to optimise and stack his commands and run the scripts on schedule on a Windows server. Through the use of the native PowerShell tile in SquaredUp, Danny was able to read the results of the scheduled scripts and visualise key metrics on a SquaredUp dashboard, using simple scalar and grid visualisations.

Dashboard walk-through

The top left most column shows the total number of Teams they are monitoring, and then splits into two columns. The left column shows the number of unowned Teams and which Teams are empty, while the right column shows the same for the sections that are unowned or empty. These are important to ensure that the correct classes have been specified and to ensure that the teams are properly populated.

Scripts and data sets to steal

Microsoft Teams Dashboard
Download Dashboard Server Free

Dashboard anything
for free

3 users. Unlimited dashboards. Free forever.