We’ve heard from many of you that you want to sync your Windows Live personal calendar with your Microsoft Office Outlook work calendar. Some of you have already downloaded the Microsoft Office Outlook Connector and can now view and edit your Windows Live Calendar in Outlook. But we’ve gotten a few questions, so we thought we’d post answers to your most frequent questions here.

Q. Can I use the Outlook Connector to access my Outlook calendar in Windows Live?

No; at this time, you can only use it to view and edit your calendars from Windows Live Calendar in Outlook. You won’t be able to see your Outlook calendar from within Windows Live.

Q. What is the Outlook Connector?

Outlook Connector is a free add-in that helps you access and manage your Windows Live e-mail, calendars, and

contacts from within Outlook. It works with Microsoft Office Outlook 2007 or Outlook 2003. For more detailed info about the Outlook Connector, check out this recent post on the Outlook team blog.

Q. Where do I get the Outlook Connector?

To download a free version of the Outlook Connector, go to the Microsoft Office Outlook Connector website.

Q. How can I get help with the Outlook Connector?

If you need help getting started with the Outlook Connector visit the support page for using Hotmail in Outlook on the Office Online website.

Thank you for using Windows Live Calendar!

The Windows Live Calendar team

It’s that time again! The Hotmail team has been hard at work since our last release in the fall, and we’ve got a bunch of new features coming out… and we’re rolling them out now! Your Hotmail account has seen a number of awesome changes in the past few months - we’ve introduced a great new look and we’ve made everything faster

and easier to use. The new stuff we’ve added came from the feedback you sent in, and we hope you like what you see so far.

If you haven’t seen any changes yet, you will soon! Until then, here’s a quick preview of just a few things to expect: ¹

More room for messages. We’ve moved the banner ad from the top of the screen to the side so you can see more messages listed in your inbox.

Ever growing storage. Our storage grows with you – You start with 5 GB of storage, and it automatically increases as you need it. So you don’t have to worry about whether to keep a message or delete it. ²

Info at your fingertips. Making plans with friends and family is easy. When you’re writing a message, it’s just one click to add local maps, direction, movie times, and more. We’re trying this out in the US and the UK to get feedback for now, but more places are on the way.

A little more social. Open your Hotmail to the Today page to see what's new with the people you know, like the latest stuff they’ve posted on blogs, Twitter or Flikr.

A new way to get Hotmail on your phone. POP3 technology is available to Hotmail users in a bunch of countries for free now, so it’s easy to add Hotmail to the e-mail program on your phone. Check out this blog to find out more.

More style. Choose from more themes and edit your email signature in HTML.

Don’t forget to drop us a message to let us know what you think - we love getting feedback on how to make Hotmail even better. Or if you have any questions, mosey on over to the new Hotmail Online Solutions Center

and get answers from our agents, fast.

Thanks for using Windows Live Hotmail!

Sincerely,

The Hotmail team

¹ Some of these features are still making their way out. If you don't see one of these features yet inside your Hotmail account, you will over the coming weeks.

² We've designed Hotmail storage to grow with you, but at a reasonable pace. That means you should have plenty of storage unless you suddenly want to store the planet Jupiter on Hotmail, in which case we'll send you a nice e-mail asking you to please not try to store planets on Hotmail (although gradual storage of planets, moons, and asteroids is ok).

I was reading the Guardian (a UK newspaper) online today and saw that they have just launched something called Open Platform, basically a set of tools that allow you to access and build applications on top of their data and content. The thing that really caught my eye was the Data Store, which makes available all of the numeric data they would usually publish in tables and graphs in the paper in Google Spreadsheet format. Being a data guy I find free, interesting data irresistible: I work with data all day long, and building systems to help other people analyse data is what I do for a living, but usually I'm not that interested in analysing the data I work with myself because it's just a company's sales figures or something equally dull. However give me information on the best-selling singles of 2008 or crime stats for example, I start thinking of the fun stuff I could do with it. If you saw Donald Farmer's

fascinating presentation at PASS 2008 where he used data mining to analyse the Titantic passenger list to see if he could work out the rules governing who survived and who didn't, you'll know what I mean.

Given that all the data's in Google Spreadsheets anyway, the first thing I thought of doing was using Panorama's free pivot table gadget to analyse the data OLAP-style (incidentally, if you saw it when it first came out and thought it was a bit slow, like I did, take another look - it's got a lot better in the last few months). Using the data I mentioned above on best-selling singles, here's what I did to get the gadget working:

1. Opened the link to the spreadsheet: http://spreadsheets.google.com/pub?key=phNtm3LmDZEP4i_r7RdVhUg
   
   
2. Followed the link at the very bottom of the page to edit the page.
3. On the new window, clicked File/Create a Copy on the menu to open yet another window, this time with a version of the data that can be edited (the previous window contained only read-only data)
4. Right-clicked on column J and selected Insert 1 Right, to create a new column on the right-hand side.
5. Added a column header, typed Count in the header row, and then filled the entire column with the value 1 by typing 1 into the first row and then dragging it down. I needed this column to create a new measure for the pivot table.
6. Edited the 'Artist(s)' column to be named 'Artist' because apparently Panorama doesn't like brackets
7. Selected the whole data set (the range I used was Sheet1!B2:K102) and then went to Insert/Gadget and chose Analytics for Google Spreadsheets. It took me a moment to work out I had to scroll to the top of the sheet to see the Panorama dialog that appeared.
8. Clicked Apply and Close, waited a few seconds while the cube was built, ignored the tutorial that started, spent a few minutes learning how to use the tool the hard way having ignored the tutorial, and bingo! I had my pivot table open. Here's a screenshot showing the count of singles broken down by gender and country of origin.

Of course, this isn't the only way you can analyse data in Google spreadsheets. Sisense Prism, which I reviewed here a few months ago, has a free version which can connect to Google spreadsheets and work with limited amounts of data. I still have it installed on my laptop, so I had a go connecting - it was pretty easy so I won't go through the steps, although I didn't work out how to get it to recognise the column headers as column headers and that polluted the data a bit. Here's a screenshot of a dashboard I put together very quickly:

Lastly, having mentioned Donald Farmer's Titanic demo I thought it would be good to do some data mining. The easiest way for me was obviously to use the Microsoft Excel data mining addin: there are two flavours of this: the version (available here) that needs to be able to connect to an instance of Analysis Services, and the version that can connect to an instance of Analysis Services in the cloud (available here; Jamie MacLennan and Brent Ozar's blog entries on this are worth reading, and there's even a limited web-based interface for it too). Here's what I did:

1. Installed the data mining addin, obviously
2. In the copy of the spreadsheet, I clicked File/Export/.xls to export to Excel, then clicked Open
3. In Excel, selected the data and on the Home tab on the ribbon clicked the Format as a Table button
4. The Table Tools tab having appeared on the ribbon automatically, I then pressed the Analyze Key Influencers button
5. In the dialog that appeared, I chose Genre from the dropdown to try to work out which of the other columns influenced the genre of the music
6. Clicked I Agree and Do Not Remind Me Again on the Connecting to the Internet dialog
7. Added a report comparing Pop to Rock

Here's what I got out:

From this we can see very clearly that if you're from the UK or under 25 you're much more likely to be producing Pop, Groups are more likely to produce Rock, and various other interesting facts.

So, lots of fun certainly (at least for a data geek like me), but everything I've shown here is intended as a serious business tool. It's not hard to imagine that, in a few years time when more and more data is available online through spreadsheets or cloud-based databases, we'll be doing exactly what I've demonstrated here with that boring business data you and I have to deal with in our day jobs.