Calendar Analytics Tool

by [Published on 25 Oct. 2016 / Last Updated on 25 Oct. 2016]

This tip presents the Calendar Analytics tool that allows users to analyse their Exchange calendar using PowerPivot for Excel.

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.


See Also

The Author — Nuno Mota

Nuno Mota avatar

Nuno is an Exchange MVP working as a Senior Microsoft Messaging Consultant for a UK IT Services Provider in London. He specializes in Exchange, Lync, Active Directory and PowerShell.