{"id":235421,"date":"2013-05-23T10:15:00","date_gmt":"2013-05-23T10:15:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/inside_microsoft_research\/2013\/05\/23\/new-ways-to-visualize-your-data\/"},"modified":"2017-07-18T12:37:41","modified_gmt":"2017-07-18T19:37:41","slug":"new-ways-to-visualize-your-data","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/research\/blog\/new-ways-to-visualize-your-data\/","title":{"rendered":"New Ways to Visualize Your Data"},"content":{"rendered":"

Posted by Rob Knies<\/span><\/p>\n

\"Histogram (opens in new tab)<\/span><\/a><\/p>\n

If you are feeling hungry, you go to the kitchen. If you\u2019d like to take a swim, you head to a swimming pool. If you want to catch a movie, you\u2019re bound for a theater.<\/span><\/p>\n

And, Danyel Fisher (opens in new tab)<\/span><\/a> says, if you\u2019re interested in data, you open Excel (opens in new tab)<\/span><\/a>.<\/p>\n

\u201cExcel is where data lives,\u201d says Fisher, a researcher with the Visualization and Interaction for Business and Entertainment (opens in new tab)<\/span><\/a> (VIBE) team at Microsoft Research Redmond (opens in new tab)<\/span><\/a>. \u201cWhen people have data to organize, in any form, it usually passes through Excel at some point\u2014sometimes, just as a quick way to look at it, and sometimes, with tools like Flash Fill (opens in new tab)<\/span><\/a> and charting and sorting\u2014that\u2019s where it stays.<\/p>\n

\u201cData visualizations are incredibly powerful and fun ways for users to understand their data.\u201d<\/p>\n

Excel users\u2014and they are legion\u2014are about to find out. On May 23, Fisher and his colleagues, including Roland Fernandez (opens in new tab)<\/span><\/a>, principal research software-design engineer, published three new data-visualization tools to Apps for Office, a new channel where people can download free apps for the new Office (opens in new tab)<\/span><\/a>. Those embeddable apps will let Excel users experiment with new data visualizations using their own data.\u00a0Everything you need to know about the new tools can be found here. (opens in new tab)<\/span><\/a><\/p>\n

Offerings from Apps for Office are available at the Office Store (opens in new tab)<\/span><\/a>\u2014just click \u201cadd\u201d to download an app, then start Excel and locate the new app under the Insert tab. Such apps, which can be used in Word (opens in new tab)<\/span><\/a>, Excel,
\nOutlook (opens in new tab)<\/span><\/a>, PowerPoint (opens in new tab)<\/span><\/a>, and Project (opens in new tab)<\/span><\/a>, can help with tasks such as translations, connecting with social media, managing finances, or visualizing data. The apps, which can be offered for free or sold, are web-based, written with HTML and JavaScript, and can use web protocols such as OAuth and REST. And the apps are easy to build and publish (opens in new tab)<\/span><\/a>.<\/span><\/p>\n

VIBE has been exploring new visualization types as part of its work to develop new ways to display and interact with large amounts of data. The new downloads represent a first wave of this research.<\/p>\n

\"Histogram (opens in new tab)<\/span><\/a>Histogram (opens in new tab)<\/span><\/a>, which last month became VIBE\u2019s first visualization release, shows the distribution of data via a bar graph of data-point frequency. Such visualizations commonly are used by scientists, and this add-in makes it much easier to create them in Excel.<\/p>\n

\u201cHistograms are basic visualizations that many people like to use for basic analytics,\u201d Fisher says. \u201cWe wanted to make them easy and lightweight for users.\u201d<\/p>\n

A related app, Histogram 2D (opens in new tab)<\/span><\/a>, examines the distribution of two values with a visualization also known as a density plot.\"Histogram (opens in new tab)<\/span><\/a><\/p>\n

\u201cIt gives the frequencies of two different variables,\u201d Fisher says. \u201cThat is a really useful analytic technique.\u201d<\/p>\n

\"Treemap (opens in new tab)<\/span><\/a>A third download, Treemap (opens in new tab)<\/span><\/a>, has an interesting history.<\/p>\n

\u201cIn 2008,\u201d Fisher recalls, \u201cwe released a Treemapper app for Excel, which allowed users to install an Excel add-in to create treemaps. While it was fairly common to have special apps that would allow a user to create treemaps based on disk usage, it was pretty hard to create a treemap based on your own data. We got a lot of positive feedback on that\u2014from teams inside Microsoft and from outside.\u201d<\/p>\n

The Treemapper code grew stale over time, though, and had to be retired. The new Treemap app brings such functionality back to Excel, assisting with data organized hierarchically.<\/p>\n

\"Streamgraph (opens in new tab)<\/span><\/a>The final visualization tool now available for download might be the most eye-catching. Streamgraph (opens in new tab)<\/span><\/a> examines data volume over time, such as tracking how many people are employed in specific economic sectors over a predetermined span of time.<\/p>\n

\u201cSteamgraph is one of the most beautiful visualization techniques to merge in the last decade,\u201d Fisher says. \u201cWhen you have sliding temporal data like this, it\u2019s a great way to see data that changes over time.\u201d<\/p>\n

There is, of course, a research agenda that benefits from the work\u2014beyond the satisfaction of delivering useful, appealing visualizations to Excel users.<\/p>\n

\u201cFirst,\u201d Fisher says, \u201cwe\u2019re learning about how people interact with these tools. We\u2019re collecting minimal, anonymous telemetry information to learn what we did right\u2014and what we did wrong. Telemetry can help us find where people are crashing or giving up and what things work for them.<\/p>\n

\u201cSecond, we\u2019re getting a real-world test of our original idea. We proposed an idea for an ecosystem of visualizations in Excel. It\u2019s valuable for a researcher to find out whether a proposal like that makes sense\u2014and to see how it changes over time.\u201d<\/p>\n

In the end, though, while the researchers get what they need to advance their research studies, Excel users get new ways to examine their data.<\/p>\n

\u201cThere\u2019s been a lot of user-interface design work,\u201d Fisher concludes. \u201cIt\u2019s a little less common for users to work with these more complex data visualizations, and we\u2019re trying to learn what seems to work best for people.\u201d<\/p>\n","protected":false},"excerpt":{"rendered":"

Posted by Rob Knies If you are feeling hungry, you go to the kitchen. If you\u2019d like to take a swim, you head to a swimming pool. If you want to catch a movie, you\u2019re bound for a theater. And, Danyel Fisher says, if you\u2019re interested in data, you open Excel. \u201cExcel is where data […]<\/p>\n","protected":false},"author":30766,"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,"footnotes":""},"categories":[194453,194474],"tags":[200491,201201,186454,187098,195597,201841,201843,196463,203115,203121,203183,203323,203407,203579,204061,204339,204341,204479,204515,204657],"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-235421","post","type-post","status-publish","format-standard","hentry","category-data-science","category-data-visulalization","tag-apps-for-office","tag-danyel-fisher","tag-data-visualization","tag-excel","tag-flash-fill","tag-histogram","tag-histogram-2d","tag-microsoft-research-redmond","tag-office","tag-office-store","tag-outlook","tag-powerpoint","tag-project","tag-roland-fernandez","tag-streamgraph","tag-treemap","tag-treemapper","tag-vibe","tag-visualization-and-interaction-for-business-and-entertainment","tag-word","msr-research-area-data-platform-analytics","msr-locale-en_us"],"msr_event_details":{"start":"","end":"","location":""},"podcast_url":"","podcast_episode":"","msr_research_lab":[],"msr_impact_theme":[],"related-publications":[],"related-downloads":[],"related-videos":[],"related-academic-programs":[],"related-groups":[578422,144794],"related-projects":[],"related-events":[],"related-researchers":[],"msr_type":"Post","byline":"","formattedDate":"May 23, 2013","formattedExcerpt":"Posted by Rob Knies If you are feeling hungry, you go to the kitchen. If you\u2019d like to take a swim, you head to a swimming pool. If you want to catch a movie, you\u2019re bound for a theater. And, Danyel Fisher says, if you\u2019re…","locale":{"slug":"en_us","name":"English","native":"","english":"English"},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/235421"}],"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\/30766"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/comments?post=235421"}],"version-history":[{"count":2,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/235421\/revisions"}],"predecessor-version":[{"id":401501,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/235421\/revisions\/401501"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=235421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/categories?post=235421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/tags?post=235421"},{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=235421"},{"taxonomy":"msr-region","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-region?post=235421"},{"taxonomy":"msr-event-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-event-type?post=235421"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=235421"},{"taxonomy":"msr-post-option","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-post-option?post=235421"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=235421"},{"taxonomy":"msr-promo-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-promo-type?post=235421"},{"taxonomy":"msr-podcast-series","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-podcast-series?post=235421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}