{"id":283376,"date":"2013-04-11T06:00:20","date_gmt":"2013-04-11T13:00:20","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/research\/?p=283376"},"modified":"2016-08-25T14:35:48","modified_gmt":"2016-08-25T21:35:48","slug":"geoflow-takes-data-3-d-drive","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/research\/blog\/geoflow-takes-data-3-d-drive\/","title":{"rendered":"GeoFlow Takes Data for a 3-D Drive"},"content":{"rendered":"

In November, during the SharePoint Conference 2012 (opens in new tab)<\/span><\/a>, attendees received a Public Preview of project codename \u201cGeoFlow\u201d for Excel, the latest business-intelligence (BI) functionality to be integrated (opens in new tab)<\/span><\/a> with Microsoft Excel 2013 (opens in new tab)<\/span><\/a> later this year. As an Excel add-in, GeoFlow provides interactive, 3-D geospatial and temporal data visualizations. It enables information workers to discover and share new insights from data through rich, 3-D data on a globe and fluid, cinematic guided tours\u2014virtual cinematography moving through data.<\/p>\n

With dynamic data exploration that turns rows and columns of spatiotemporal data into rich 3-D maps, the term \u201cadd-in\u201d really doesn\u2019t do justice to the technology behind GeoFlow, a preview of which is available for download (opens in new tab)<\/span><\/a>. Take a look under the hood, and you\u2019ll see stars. That\u2019s because the research that led to GeoFlow began with Microsoft Research\u2019s WorldWide Telescope (opens in new tab)<\/span><\/a> (WWT) research project, which visualizes terabytes of imagery and data from the astronomy community. Launched in 2008, the WorldWide Telescope application always was meant to be more than a tool that gives young astronomers an observatory in a PC. It enabled seamless panning and zooming through the universe, connecting them with stories and images from multiple sources over the Internet to deliver an immersive experience.<\/p>\n

But even while Curtis Wong (opens in new tab)<\/span><\/a>, principal researcher at Microsoft Research Redmond (opens in new tab)<\/span><\/a>, was busy giving talks about WWT (opens in new tab)<\/span><\/a>, he had further ambitions in mind for the technology.<\/p>\n

\"GeoFlow

GeoFlow visualization of global city population<\/p><\/div>\n

\u201cWith the dramatic growth in geospatial and temporal data,\u201d Wong says, \u201cwe wanted to explore new tools that could help us understand the large-scale temporal and geospatial trends that affect businesses. The goal always has been to bring dynamic, interactive data visualization to the business world. Yes, we built a gigantic virtual telescope, but to do so, we had to build an engine that could visualize the universe. If we can visualize the universe, we can visualize almost anything else.\u201d<\/p>\n

The notion behind WWT was the ability to drive a virtual camera into the visualization space, give the user control over space and time, and create \u2018movies\u2019 with narratives that tell a story about the data that could be shared with others to communicate insight.<\/p>\n

\u201cThis is very different from what has been done before,\u201d Wong explains, \u201cpartly because most representations of the sky or universe had low-resolution imagery or computer-graphic representations of the sky. In WWT, we created a 3-D virtual universe where you could zoom into anywhere on a Terapixel (opens in new tab)<\/span><\/a> view of the night sky and see images of objects from the Hubble, Chandra, and Spitzer space telescopes\u2014or others that are presented in the sky at the correct scale and orientation. Users were also able to explore the 3-D universe\u2014to fly out to see the rings of Saturn in great detail or exit the solar system smoothly as you pull out past the local stars and leave the Milky Way to see the large-scale structure of the universe, with a million galaxies. That visualization of the million galaxies in the Sloan Digital Sky Survey is accurate enough to show the relative size, color, and shape of each of the galaxies. Beyond that, you could drill into any one of them, get detailed information about that galaxy, red shift, or spectrum, and download that data to Excel.<\/p>\n

\u201cWWT enabled people to create guided tours of the universe by driving a virtual camera though the solar system for sharing with others. WWT has many guided tours done by astronomers, astrophysicists, educators, and even kids. These guided tours are interactive at any time, enabling full exploration \u2018to stop and look around\u2019 anytime you want to pause the tour.\u201d<\/p>\n

With the telescope successfully launched, Wong began reaching out to product groups at Microsoft and discussing how 3-D geospatial data visualization could enhance their current capabilities. Scott Ruble, principal program manager lead for Microsoft Excel, immediately saw how an engine that could visualize the universe could give Excel the most advanced BI capabilities on the market.<\/p>\n

\"GeoFlow

GeoFlow visualization of U.S. power stations<\/p><\/div>\n

\u201cMicrosoft Research did a great job pioneering 3-D visualizations,\u201d Ruble says. \u201cThe work they did with WorldWide Telescope showed real business applicability. Not only did the project help illustrate the value and real future potential of 3-D visualization, it significantly reduced our risk in productizing the capability.\u201d<\/p>\n

That took awhile to build a full head of steam.<\/p>\n

\u201cWe started out with a very small team,\u201d Wong recalls. \u201cThen, in June of 2011, we got the green light to go into product development, and from there on, it grew slightly bigger, with a program manager from Office, as well as developers and designers from the Startup Business Group and a lot of hard work. There was work to define functionality more clearly and to ensure that the user experience would be in line with the rest of Office and Excel.\u201d<\/p>\n

In parallel with the product-development efforts, Wong worked with Jonathan Fay (opens in new tab)<\/span><\/a>, architect and engineer for WWT, to prototype various data-visualization capabilities using a special, private build of WWT.<\/p>\n

\u201cWe would prototype functionality in WWT,\u201d Wong recalls, \u201cand then we would show that to the product-development team and say: \u2018Here\u2019s how specific functionality could work. Here’s what it’s supposed to do,\u2019 which is a really insightful complement to a written specification. We showed them, for example, how to create a guided tour. That helped the program managers with writing feature specifications and helped the development team understand the functionality before building it into GeoFlow. But don\u2019t think that made their jobs easy, because the process of building a real product is at least an order of magnitude more complicated than a research prototype, for so many reasons.\u201d<\/p>\n

\u201cSometimes research requires a long-term view,\u201d Wong says. \u201cWWT was a project that gave the research work a focus on a real problems and access to data and imagery, and it also contributed something valuable to the study of astronomy: a unified visualization of everything, accessible to everyone. But soon after the launch, we set a very deliberate goal: that we needed to guide the work in a way that it would ultimately find a home within one of the product groups.\u201d<\/p>\n

It also looks as though GeoFlow will be finding homes with happy customers, as well, if feedback from an early user (opens in new tab)<\/span><\/a> is any indication.<\/p>\n

\u201cThank you for providing us access to the GeoFlow software,\u201d the user wrote. \u201cWe just completed a demonstration of the technology to a utility, overlaying household energy-consumption projections on top of household information. The spatial presentation of this data was a huge success. We and the customer are looking forward to the formal release of this software!\u201d<\/p>\n","protected":false},"excerpt":{"rendered":"

In November, during the SharePoint Conference 2012, attendees received a Public Preview of project codename \u201cGeoFlow\u201d for Excel, the latest business-intelligence (BI) functionality to be integrated with Microsoft Excel 2013 later this year. As an Excel add-in, GeoFlow provides interactive, 3-D geospatial and temporal data visualizations. It enables information workers to discover and share new […]<\/p>\n","protected":false},"author":39507,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"categories":[194474],"tags":[210848,210857,210863,187154,210839,195225,186454,210818,210836,210851,196069,193636,210860,210815,210845,210854,210842,197820],"research-area":[13563],"msr-region":[],"msr-event-type":[],"msr-locale":[268875],"msr-post-option":[],"msr-impact-theme":[],"msr-promo-type":[],"msr-podcast-series":[],"class_list":["post-283376","post","type-post","status-publish","format-standard","hentry","category-data-visulalization","tag-3-d-maps","tag-3-d-universe","tag-3-d-visualizations","tag-astronomy","tag-business-intelligence-bi","tag-curtis-wong","tag-data-visualization","tag-geoflow","tag-geoflow-for-excel","tag-geospatial-data","tag-jonathan-fay","tag-microsoft-excel-2013","tag-scott-ruble","tag-sharepoint-conference-2012","tag-spatiotemporal-data","tag-temporal-data","tag-virtual-cinematography","tag-worldwide-telescope-wwt","msr-research-area-data-platform-analytics","msr-locale-en_us"],"msr_event_details":{"start":"","end":"","location":""},"podcast_url":"","podcast_episode":"","msr_research_lab":[199565],"msr_impact_theme":[],"related-publications":[],"related-downloads":[],"related-videos":[],"related-academic-programs":[],"related-groups":[],"related-projects":[170492,169909],"related-events":[],"related-researchers":[],"msr_type":"Post","byline":"","formattedDate":"April 11, 2013","formattedExcerpt":"In November, during the SharePoint Conference 2012, attendees received a Public Preview of project codename \u201cGeoFlow\u201d for Excel, the latest business-intelligence (BI) functionality to be integrated with Microsoft Excel 2013 later this year. As an Excel add-in, GeoFlow provides interactive, 3-D geospatial and temporal data…","locale":{"slug":"en_us","name":"English","native":"","english":"English"},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/283376"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/users\/39507"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/comments?post=283376"}],"version-history":[{"count":8,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/283376\/revisions"}],"predecessor-version":[{"id":283457,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/283376\/revisions\/283457"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=283376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/categories?post=283376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/tags?post=283376"},{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=283376"},{"taxonomy":"msr-region","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-region?post=283376"},{"taxonomy":"msr-event-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-event-type?post=283376"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=283376"},{"taxonomy":"msr-post-option","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-post-option?post=283376"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=283376"},{"taxonomy":"msr-promo-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-promo-type?post=283376"},{"taxonomy":"msr-podcast-series","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-podcast-series?post=283376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}