BizIntelligence.TV

The One Stop for everything Business Intelligence related

Conquer Your Calendar: Use PowerPivot To Analyze Your Time

Conquer Your Calendar: Use PowerPivot To Analyze Your Time

  • Comments 30

Today we are very excited to release a free tool utilizing PowerPivot for Excel, Calendar Analytics.  Calendar Analytics is a time management application that pulls information from Exchange and visualizes that data in a very easy to use Excel dashboard.  We are releasing this application in honor of Administrative Professionals' Day, but this application is not geared exclusively to high level executives and their administrative assistants.  This new BI tool was developed as part of a continuing effort to show individuals and organizations that business intelligence can be utilized by everyone; not just CIOs and top level executives.  Watch this very special episode of BITV and learn how the Calendar Analytics idea came about as well as an overview of the application.  Then download the application and tell us what you think!

Download Calendar Analytics

PowerPivot is required to run Calendar Analytics.  You can download this free add-on here

Take the latest poll:  How do you maximize your time?

Join the BI TV LinkedIn Group to stay up-to-date with all the new releases

Follow BI TV on Twitter

Leave a Comment
  • Please add 2 and 7 and type the answer here:
  • Post
  • Useful Tool &  Article.  Interesting to note that MS is not using MS Videos for these clips.

  • I get "ERROR: Communication", "Autodiscover service could not be contacted. Please ensure that your internet connection is working"  when i try to get data with "Refresh Calendar" button in excel! I'm connected to LAN, my outlook 2010 is running and i have internet connection (via proxy)! How does email-discovery of this tool work? What are the prerequisites regarding firewall ports, permissions...

  • Cool tool, if I could get it to work.  After clicking "Refresh Calendar" according to the instructions, I type in my emial address(s) etc. and then it gives me the hour glass for a bit which then pops a dialog box "ALERT: Incomplete Calendar Download" and then a listing of each date that it did not download, which is representative of all of the dates in the date range that I originally selected.

  • I'm getting different kinds of communication errors from it telling me it skipped every day on my calendar to saying the Autodiscover service could not be contacted.  Either way...it doesn't seem to want to connect to my calendar.

  • @JJ78 and @Robert Stevens - The application uses Exchange Web Services to download the calendar items. Is your email server and Exchange Server, do you know what version it is? Thanks.

  • @JJ78 and @Robert Stevens - The application uses Exchange Web Services to download the calendar items. Is your email server and Exchange Server, do you know what version it is? Thanks.

  • @Danny Sands -- We've seen this intermittently if the connection to Exchange Web Services drops. Can you please try again, or try a smaller time period? Thanks.

  • We're going to start posting information on known issues here: social.technet.microsoft.com/.../calendar-analytics-for-powerpivot-known-issues.aspx

  • @Chris Yes, we are running EX2007 and i can use RPC/HTTPS to connect outlook from outside. EWS is a optional exchange 2007/2010 feature? Is there any way to test EWS in general, maybe browsing the EWS-URL direct with browser? Exchange+active EWS should be added to "system requirements" on downloadpage!

  • Would like to give this a go but cannot because I don't use Exchange. I do however use Hotmail which supports ActiveSync so I don't see a reason why this *wouldn't*. Is this a deliberate limitation?

    Given this consumes calendar data it would be nice if you supported the open format for calendar data - iCalendar (en.wikipedia.org/.../ICalendar). Any reason why you didn't do that?

    Regards

    JT

  • @Chris Castillo:  Yep, tried many times with as little as one day in the date range with same result...

  • Thanks all for the comments and questions on the application.

    We have a technet wiki to help you with support @ social.technet.microsoft.com/.../calendar-analytics-for-powerpivot-known-issues.aspx

    Also, full conditions and instructions are posted @ www.microsoft.com/.../details.aspx

  • SK - thanks for the feedback - we're happy you like the application!  

    Regarding where we host videos, we try to accomodate as many options as possible for our viewers.  We publish videos on multiple standards such as Flash, Silverlight or others.

    As an example, you'll find the silverlight version of the above @ www.microsoft.com/.../71b66999-acae-4ad2-8499-15caa635baec

  • I’m experiencing the same error as described above by Danny Sands:

    “After clicking ‘Refresh Calendar’ according to the instructions, I type in my email address(s) etc. and then it gives me the hour glass for a bit which then pops a dialog box ‘ALERT: Incomplete Calendar Download’ and then a listing of each date that it did not download, which is representative of all of the dates in the date range that I originally selected.”

    It doesn’t date range or number of people doesn’t matter. We have another working solution which uses Exchange Web Services to collect calendar information from our Exchange 2010 server.

    Calendar Analytics functions as expected when connecting to Office 365.

    I’m living in Norway; can this be a date format issue? (I’ve English Excel.)

  • I have the same issue as Danny & John.

    Changing my regional settings didn't do it for me, so I don't think format can be the problem.

Page 1 of 2 (30 items) 12