Analyzing Teams data over a full year

Erik Hamoen
4 min readJan 4


Photo by Ian Schneider on Unsplash

Since 2021 you can analyze your Teams data in a generated Power BI report from Microsoft. It shows you the data from the last 90 days by default, but you can edit the report and add incremental refresh to keep track of all Teams data for a more extended period! So to kick off 2023, let's have a look at my Teams statistics for 2022!

How to create your Teams data report?

In the Microsoft Teams app, go to apps and select Power BI. After adding it, you can go to Create and there is a button “Analyzing your Teams data”.

Opening the Power BI App in Teams to create your Teams data analysis

When you select that one, a new Power BI report and dataset will be added to your “My workspace”, where you can view your Teams activity up until 90 days prior. When you download the report, you can change the report to whatever you like, but also change the queries behind it. This also includes creating the incremental refresh parameters RangeStart and RangeEnd. After configuring incremental refresh, you can view your Teams data over a much longer period! So let’s see how my 2022 was, as a Microsoft Teams user!

The Report

In your Teams data report, you can view the number of meetings, the number of 1 on 1 call, and the number of sent messages. On another tab you can view the Team channels you are part of and see the number of users and, number of posts and replies, etc. Using the right-click function, you can drill-through to a detailed page of the Team, which is also accessible using the navigation menu (but it’s slightly different). Using the navigation item, you get a single select slicer to select the Team, which of course isn’t available after the drill-through.

My Acitivty in Teams
Team activity of the teams I'm part off
Detailed information about the Teams channel

The year 2022

As you might have noticed I edited the report layout a little bit. Originally there is a slicer asking about the last 7 days up until the last 90 days. But I need more! So I added a date slicer and can switch between the Relative date slicer and the between date slicer using bookmarks. How to do that, you can read it here.

Back to 2022! I selected the last 1 Years (Calendar) so I only get the latest full year:

My detailed information of Teams for 2022

In 2022 I have been in 266 meetings and 308 1:1 calls and sent 8369 messages! Now I have no idea if that’s a lot, but what I like to see, are the graphs. You can see very clearly that in January, May, and September I took some days off. No meetings, (almost) no Teams chats. Another thing to notice is that in the first quarter, I chatted less that in the other three, especially the last one. The reason for that is NOT that I don’t like to talk at the beginning of the year, but as a consultant, I sometimes have clients that give me a Microsoft Account of their company and use their Teams, while others make a Guest in their network, so you can use your own Microsoft Account. In the beginning, it was more of the first, and later in the year more of the second.

When we went to the Team Activity page, we already saw I was part of fifteen different Teams. I’m the proud owner of the Power BI Gilde (Guild) team, in which we share all our Power BI knowledge across the company.

Power BI Guild is the most active one

And even though we don’t have the most users, there are a lot of posts and replies running through this Team, and love to see that it’s my most active Team! Maybe there are more active ones around the company, but I’m not a part of that, so that will not be visible to me.

On the drill-through page, we can see that May 2022 was our busiest month. Worth a shot to try and find out what happened at that moment:

Unfortunately, the Activity summary looks a bit weird, saying that in the last 90 days, there were 270 days without posting. Interesting! But I guess that’s something we can fix in the report itself.

Finishing note

This wasn’t quite a blog to learn new stuff, but to show you what kind of information you can view about your Teams activity and how the incremental refresh helps you to get more information about it than just the standard 90 days.

Take care.