Microsoft app analyzes your busy schedule

27.04.2011
In an effort to demonstrate the versatility of its PowerPivot business intelligence technology, Microsoft has released a free add-on application to Microsoft Office that analyzes the contents of a user's Microsoft Exchange calendar.

This can aggregate and analyze the meeting data that resides in a user's Microsoft Exchange Schedule.

With this tool, users could find out how many meetings they attend during any given period of time, and how much time is being spent in these meetings.

With proper configuration, it can even reveal if the person is spending enough time in the right kinds of meetings, that Microsoft posted on YouTube about the add-on.

The analysis is presented on a dashboard, which can be accessed from within Microsoft Excel. Users can also do ad-hoc analysis, though a personalized analysis would require the user to add detailed tags onto each meeting that is scheduled.

The app was built from Microsoft PowerPivot, which is itself an Excel add-on that allows users to create their own business intelligence applications.