{"id":1523,"date":"2012-12-10T09:00:00","date_gmt":"2012-12-10T09:00:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/msr_er\/2012\/12\/10\/new-tools-simplify-data-mining\/"},"modified":"2016-07-20T07:32:17","modified_gmt":"2016-07-20T14:32:17","slug":"new-tools-simplify-data-mining","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/research\/blog\/new-tools-simplify-data-mining\/","title":{"rendered":"New Tools Simplify Data Mining"},"content":{"rendered":"<p><span style=\"font-family: verdana,geneva; font-size: medium;\">In this era of big data, researchers are relying more and more on data mining to help them with their research. Researchers from nearly every field (not to mention businesses from almost every sector) are slicing, dicing, and sifting an exponentially growing mass of data, looking for patterns, trends, and insights. This is powerful stuff, and the essence of the data-intensive &ldquo;fourth paradigm&rdquo; of scientific inquiry.&nbsp;<\/span><\/p>\n<p><span style=\"font-family: verdana,geneva; font-size: medium;\">Powerful, yes, but also complex. Data mining requires numerous steps: data understanding, data cleaning, model creation, and model comparison. Fortunately, there are new tools for Microsoft Excel that make each step simpler and combine them more seamlessly.&nbsp;<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana,geneva; font-size: medium;\"><span style=\"color: #888888; font-size: small; background-color: #ffffff;\"><img decoding=\"async\" style=\"border: 0px currentColor;\" title=\"New add-ins for Microsoft Excel that simplify data mining are available to download.\" src=\"https:\/\/msdnshared.blob.core.windows.net\/media\/MSDNBlogsFS\/prod.evol.blogs.msdn.com\/CommunityServer.Blogs.Components.WeblogFiles\/00\/00\/01\/32\/81\/6428.DMAddins-2012-DataMiningClient_496.jpg\" original-url=\"http:\/\/blogs.msdn.com\/resized-image.ashx\/__size\/496x0\/__key\/communityserver-blogs-components-weblogfiles\/00-00-01-32-81\/6428.DMAddins_2D00_2012_2D00_DataMiningClient_5F00_496.jpg\" alt=\"New add-ins for Microsoft Excel that simplify data mining are available to download.\" \/><br \/><\/span><\/span><span style=\"font-family: verdana,geneva; font-size: medium;\"><span style=\"color: #888888; font-size: small; background-color: #ffffff;\">New add-ins for Microsoft Excel that simplify data mining are available to download.<\/span><\/span><\/p>\n<p><span style=\"font-family: verdana,geneva; font-size: medium;\">These tools, collectively known as the Microsoft SQL Server 2012 SP1 Data Mining Add-ins for Office (just rolls off the tongue, yes?) are the product of a joint effort between the Data Mining SQL team and the Microsoft Research <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/research.microsoft.com\/en-us\/groups\/mlas\/\" target=\"_blank\">Machine Learning and Applied Statistics group<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>.&nbsp; The tools are <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=268164\" target=\"_blank\">available for download<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>.<\/span><\/p>\n<p><span style=\"font-family: verdana,geneva; font-size: medium;\">Microsoft Data Mining Add-ins help you take advantage of SQL Server predictive analytics in Microsoft Excel and Microsoft Visio. The download includes the following components:<\/span><\/p>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><strong>Table Analysis Tools for Excel<\/strong>: This add-in provides easy-to-use tasks within Excel that utilize SQL Server 2012 data mining models to deliver quick insights on your spreadsheet data. With just a few clicks, you can analyze key influencers for a given outcome, highlight exceptions, automatically detect groups, fill in missing data, make time series forecasts, or do market basket analysis.<\/span><\/li>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><strong>Data Mining Client for Excel<\/strong>: By using this add-in, you can create, test, explore, and manage data mining models within Excel, by using either your spreadsheet data or external data that is accessible through your SQL Server 2012 Analysis Services instance.<\/span><\/li>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><strong>Data Mining Templates for Visio<\/strong>: This add-in enables you to render and share your mining models as annotatable Visio drawings.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: verdana,geneva; font-size: medium;\">This integrated, comprehensive set of tools should make life simpler for anyone with big data to mine.<\/span><\/p>\n<p><em><span style=\"font-family: verdana,geneva; font-size: medium;\">&mdash;<a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/research.microsoft.com\/en-us\/um\/people\/heckerman\/\" target=\"_blank\">David Heckerman<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, Distinguished Scientist, Microsoft Research<\/span><\/em>&nbsp;<br \/><em><span style=\"font-family: verdana,geneva; font-size: medium;\">&mdash;<a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/www.sqlserverdatamining.com\/ssdm\/Home\/MeettheTeam\/tabid\/54\/Default.aspx#Raman\" target=\"_blank\">Raman Iyer<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, Principal Group Manager (Development), SQL Server Business Intelligence, Microsoft Corporation<\/span><\/em><\/p>\n<p><strong><span style=\"font-family: verdana,geneva; font-size: medium;\">Learn More<\/span><\/strong><\/p>\n<ul>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=268164\" target=\"_blank\">Microsoft SQL Server 2012 SP1 Data Mining Add-ins for Microsoft Office<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/span><\/li>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/research.microsoft.com\/en-us\/groups\/mlas\/\" target=\"_blank\">Microsoft Research Machine Learning and Applied Statistics group<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/span><\/li>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><span style=\"font-family: verdana,geneva;\"><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/office.microsoft.com\/en-us\/excel\/\" target=\"_blank\">Microsoft Excel<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/span><\/span><\/li>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/product-info.aspx\" target=\"_blank\">Microsoft SQL Server<\/a><\/span><\/li>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/office.microsoft.com\/en-us\/visio\/\" target=\"_blank\">Microsoft Visio<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/span><\/li>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/research.microsoft.com\/en-us\/collaboration\/tools\/default.aspx\" target=\"_blank\">Microsoft Research Accelerators<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/span><\/li>\n<li><span style=\"font-family: verdana,geneva; font-size: small;\"><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" href=\"http:\/\/research.microsoft.com\/en-us\/collaboration\/focus\/cs\/default.aspx\" target=\"_blank\">Computer Science at Microsoft Research Connections<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In this era of big data, researchers are relying more and more on data mining to help them with their research. Researchers from nearly every field (not to mention businesses from almost every sector) are slicing, dicing, and sifting an exponentially growing mass of data, looking for patterns, trends, and insights. This is powerful stuff, [&hellip;]<\/p>\n","protected":false},"author":32627,"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":"","msr-author-ordering":[],"msr_hide_image_in_river":0,"footnotes":""},"categories":[1],"tags":[194584,186831,187230,186854,195275,193589,195388,187098,195612,196264,196439,196956,197290,197291,197292,197479,197716],"research-area":[],"msr-region":[],"msr-event-type":[],"msr-locale":[268875],"msr-post-option":[],"msr-impact-theme":[],"msr-promo-type":[],"msr-podcast-series":[],"class_list":["post-1523","post","type-post","status-publish","format-standard","hentry","category-research-blog","tag-add-in","tag-big-data","tag-computer-science","tag-data-mining","tag-data-intensive-science","tag-david-heckerman","tag-downloads","tag-excel","tag-fourth-paradigm","tag-machine-learning-and-applied-statistics-group","tag-microsoft-research-connections","tag-raman-iyer","tag-sql-development-group","tag-sql-server","tag-sql-server-2012-sp1-data-mining-add-ins-for-office","tag-tools","tag-visio","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":[],"related-projects":[],"related-events":[],"related-researchers":[],"msr_type":"Post","byline":"","formattedDate":"December 10, 2012","formattedExcerpt":"In this era of big data, researchers are relying more and more on data mining to help them with their research. Researchers from nearly every field (not to mention businesses from almost every sector) are slicing, dicing, and sifting an exponentially growing mass of data,&hellip;","locale":{"slug":"en_us","name":"English","native":"","english":"English"},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/1523","targetHints":{"allow":["GET"]}}],"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\/32627"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/comments?post=1523"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/1523\/revisions"}],"predecessor-version":[{"id":261774,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/posts\/1523\/revisions\/261774"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=1523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/categories?post=1523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/tags?post=1523"},{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=1523"},{"taxonomy":"msr-region","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-region?post=1523"},{"taxonomy":"msr-event-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-event-type?post=1523"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=1523"},{"taxonomy":"msr-post-option","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-post-option?post=1523"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=1523"},{"taxonomy":"msr-promo-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-promo-type?post=1523"},{"taxonomy":"msr-podcast-series","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-podcast-series?post=1523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}