Categories Exchange 2013

Calendar Analytics Tool

A tool that has been around for a few years now but that not many people are aware of is Calendar Analytics.

Released by Microsoft’s Business Intelligence team, this tool lets users analyse their Exchange calendar using PowerPivot for Excel. It is a time management app/tool/add-in that pulls information from Exchange and visualizes that data in a very easy to use Excel dashboard.

This free add-in allows us to:

  • Automatically retrieve time spent in calendar;

  • Drive ad-hoc analysis of our meeting times by day, by hour, by categories and business priorities;

  • View information about past meetings and future scheduled events;

  • Customize views (using slicers, DAX formulas or reference tables).

You can find more information here and the download link here.

Nuno Mota

Nuno Mota is an Exchange MVP working as a Microsoft Messaging Specialist for a financial institution. He is passionate about Exchange, Lync, Active Directory, PowerShell, and Security. Besides writing his personal Exchange blog,, he regularly participates in the Exchange TechNet forums and is the author of the book “Microsoft Exchange Server 2013 High Availability.”

Published by
Nuno Mota

Recent Posts

Azure DevOps Wiki: Manage your project documentation and collaboration

Not being able to find project documentation is way too common. Use Azure DevOps’ built-in…

2 days ago

Samsung Unpacked 2020: Galaxy S20, Galaxy Z Flip, and more

Samsung is again the first major company to roll out new smartphones in the new…

2 days ago

PhotoSquared data leak exposes users’ photos, information

PhotoSquared has experienced a data leak, mainly because the popular U.S.-based photo app failed to…

2 days ago

Moving data from an Azure VM to Storage Account with AzCopy

Here’s an elegant and modern way to move data from your Azure virtual machine to…

3 days ago

A lot not to like: Analysis of recent Facebook data breach

The effects of the recent Facebook data breach are still being felt. In this new…

3 days ago

Exchange 2019: Building an environment from scratch

Are you finally ready to take the plunge into Exchange 2019? If you are building…

3 days ago