Conquer Your Calendar: Use PowerPivot To Analyze Your Time
[view:https://www.youtube.com/watch?v=iT6OX0ZNanA]
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!
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
Comments
Anonymous
April 27, 2011
Useful Tool & Article. Interesting to note that MS is not using MS Videos for these clips.Anonymous
April 27, 2011
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...Anonymous
April 27, 2011
The comment has been removedAnonymous
April 27, 2011
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.Anonymous
April 27, 2011
@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.Anonymous
April 27, 2011
@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.Anonymous
April 27, 2011
@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.Anonymous
April 27, 2011
We're going to start posting information on known issues here: social.technet.microsoft.com/.../calendar-analytics-for-powerpivot-known-issues.aspxAnonymous
April 27, 2011
@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!Anonymous
April 27, 2011
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 JTAnonymous
April 27, 2011
@Chris Castillo: Yep, tried many times with as little as one day in the date range with same result...Anonymous
April 27, 2011
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.aspxAnonymous
April 27, 2011
The comment has been removedAnonymous
April 27, 2011
The comment has been removedAnonymous
April 27, 2011
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.Anonymous
April 27, 2011
The comment has been removedAnonymous
April 27, 2011
Great blog and video AND tool. I will promote to my customers and my network.Anonymous
April 28, 2011
We have Exchange server 2010, does Calendar Analytics require SP1?Anonymous
April 30, 2011
I would love to this and an other Time/Life Management principles incorporated into the next version of Outlook ... making tasks richer, calendars more meaningful ... this specifically ... nice work. Can't wait to try it out.Anonymous
May 02, 2011
Hi there, as some other users have already posted, i'm getting all the time the "Autodiscover Service could not be contacted..." problem. Using EX2007, Outlook2010, using the company LAN, same ID for Win/Mailbox. Any help? Thanks. Best Regards NFAnonymous
May 02, 2011
Hello all, As a reminder, there is a wiki that has been started to assist you with issues you are having with Calendar Analytics: social.technet.microsoft.com/.../calendar-analytics-for-powerpivot-known-issues.aspx Thanks!Anonymous
May 04, 2011
Like others, I'm having the "ALERT: Incomplete Claendar Download" error. We're using Exchange 2007, fully patched. Are there any additional steps I should be taking as a server administrator to make sure that EWS is set up and working as required? Outlook Anywhere and Outlook Web Access are set up and working.Anonymous
May 04, 2011
I wonder if this add-in will be working with Exchange SErver 2003?Anonymous
May 05, 2011
Same for me, Incomplete Calendar Download Could you provide a solution?Anonymous
May 12, 2011
Hi, I have a BPOS account (not Office 365 at this time). Does this tool may works with my account ? If yes, do I need to specify my password like an Office 365 account ? (I tried but it does not works). Thanks.Anonymous
January 17, 2012
The comment has been removedAnonymous
February 28, 2012
Dear Sir, I am doing my last semester of Masters in Computer and System Sciences, from Stockholm University, Sweden. So I have to do the thesis project in the area of Business Intelligence. And I'm searching any interesting research question for doing thesis on that. So in that regard can you please tell me any open research question or any challenges or any idea for me so that i can start my thesis on that. I can be reached anytime via email at arsh-leg@dsv.su.se or my cell phone, +46720374744. Thank you for your time and consideration. I look forward to speaking with you about this.Anonymous
May 22, 2012
If you are looking in support ofsupport of on-site hardware and software repairs/maintenance, servers contemporarytemporary or go along withng with offerr, wine waiteraiter parts, wine waiteraiter support, go along withng with offerr laptops and desktops, or merelyly data backups and security we will be able to encounterunter your needs.IT solution in support ofsupport of you and your problem You will be able to conferenceerence to solitaryitary of our friendly rodith the purpose of the purpose of is pleaseded to help you and churn outut an IT solution. Our skilled IT technicians are openid you with your amount of equipment, foodlementation making us a terrificfic place to operateerate in support ofsupport of your networking projects. . Please visit our positiontion and knowing many more in support ofsupport of Miki proAnonymous
July 19, 2012
I get "ERROR: Communication", "Autodiscover service could not be contacted. Please ensure that your internet connection is working", too. I'm on MS Office 2010 and Outlook 2010. I'm in the office on my LAN. Outlook is working. I can connect to my Outlook email through OWA as well. We don't have Autodiscover turned on for security reasons.Anonymous
November 20, 2013
Calander does not link. Am I using correct alias? My email address without the @company.com? Also, the "Update All' under PivotTable does not highlight so I cannot click on it. Perhaps it is related to the Alias problem. Any suggestions? Thanks