{"id":312,"date":"2013-06-25T09:50:51","date_gmt":"2013-06-25T14:50:51","guid":{"rendered":"http:\/\/www.sqlfreelancer.com\/blog\/?p=312"},"modified":"2014-03-07T09:58:36","modified_gmt":"2014-03-07T15:58:36","slug":"microsofts-new-3d-data-visualization-bi-product-power-map","status":"publish","type":"post","link":"https:\/\/www.sqlfreelancer.com\/blog\/microsofts-new-3d-data-visualization-bi-product-power-map\/","title":{"rendered":"Microsoft&#8217;s new 3D data visualization BI product &#8211; Power Map"},"content":{"rendered":"<p>Microsoft has introduced a new BI product that will provide 3D data visualization using Bing Maps. This product is still in beta and is codenamed &#8220;GeoFlow&#8221; but should be out late 2013 or early 2014. This preview will allow you to plot geographic and temporal data visually, analyze that data in 3D, and create visual tours. It is a really cool product and I can&#8217;t wait to use it in a business atmosphere.<\/p>\n<p>In this post, I&#8217;ll discuss the prerequisites and how to install &#8220;GeoFlow&#8221; and I&#8217;ll give an introduction on how to use this feature.<\/p>\n<p>Prerequisites:<\/p>\n<ul>\n<li>Requires Microsoft Office Professional Plus 2013 or Office 365 ProPlus<\/li>\n<li>Supports 32-bit or 64-bit machines<\/li>\n<li>Requires Windows 7, Windows 8, or Windows Server 2008R2 (requires .NET Framework 4.0)<\/li>\n<li>Requires internet access<\/li>\n<\/ul>\n<p>Installation<\/p>\n<p>Download and install the preview from <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=38395\" target=\"_blank\">Microsoft Download Center<\/a> (make sure Excel is closed while installing)<\/p>\n<p>Open Excel and &#8220;Maps&#8221; will appear as a new item in the &#8220;Insert&#8221; tab of the Excel ribbon:<\/p>\n<p><a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-313\" alt=\"SQL Freelancer SQL Server Excel GeoFlow Power Map BI\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map.png\" width=\"550\" height=\"154\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map.png 550w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-300x84.png 300w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><br \/>\n<\/a>Now that &#8220;GeoFlow is installed, we can begin using the new feature.<\/p>\n<p>For this tip, I&#8217;m using the AdventureWorks2012 database and the result set from the following query imported into Excel:<\/p>\n<div>\n<pre>  SELECT  \r\n  OrderDate, \r\n  ShipDate, \r\n  AddressLine1, \r\n  City, \r\n  PostalCode, \r\n  StateProvinceCode\r\n  FROM [AdventureWorks2012].[Sales].[SalesOrderHeader] soh\r\n  JOIN [AdventureWorks2012].[Person].[Address] ps ON soh.ShipToAddressID = ps.AddressID\r\n  JOIN [AdventureWorks2012].[Person].[StateProvince] psp ON psp.StateProvinceID = ps.StateProvinceID\r\n  WHERE StateProvinceCode = 'CA'<\/pre>\n<\/div>\n<p><a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-314\" alt=\"SQL Freelancer SQL Server Excel GeoFlow Power Map BI\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-1.png\" width=\"620\" height=\"514\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-1.png 620w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-1-300x248.png 300w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/a><br \/>\nOnce you have the data in Excel, click on the &#8220;Insert&#8221; tab on the Office ribbon and click Map. You should now see the &#8220;GeoFlow&#8221; globe:<\/p>\n<p><a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-315\" alt=\"SQL Freelancer SQL Server Excel GeoFlow Power Map BI\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-2.png\" width=\"624\" height=\"322\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-2.png 624w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-2-300x154.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><br \/>\nThere are a few tabs you can use right away in the ribbon bar. Under the &#8220;Map&#8221; item you can change Themes and add Map Labels. I like to enable the Map labels so I can see a more detailed version of the map. You can also zoom in and out and move the map using the arrows and +\/- buttons in the bottom right corner of the map.<a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-316\" alt=\"SQL Freelancer SQL Server Excel GeoFlow Power Map BI\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-3.png\" width=\"624\" height=\"440\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-3.png 624w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-3-300x211.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><br \/>\nOn the right side you see the &#8220;Layer&#8221; pane. This is where you will choose your geography visualizations. For this example Ill select &#8220;PostalCode&#8221; under the range section and since we know that this column stores zip codes we&#8217;ll map it to &#8220;Zip&#8221; under the Geography section:<\/p>\n<p><a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-317\" alt=\"SQL Freelancer SQL Server Excel GeoFlow Power Map BI\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-4.png\" width=\"334\" height=\"558\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-4.png 334w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-4-179x300.png 179w\" sizes=\"auto, (max-width: 334px) 100vw, 334px\" \/><\/a><\/p>\n<p>Once the fields are selected, click Map It.<\/p>\n<p>You might notice that 86 records were updated meaning that there are 86 unique zip codes in California and it placed a marker on each zip code:<\/p>\n<p><a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-318\" alt=\"SQL Freelancer SQL Server Excel GeoFlow Power Map BI\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-5.png\" width=\"621\" height=\"466\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-5.png 621w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Map-5-300x225.png 300w\" sizes=\"auto, (max-width: 621px) 100vw, 621px\" \/><\/a><br \/>\n<a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/2963\/microsofts-new-3d-data-visualization-bi-product--geoflow\/\" target=\"_blank\">Click here to view the rest of this post.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft has introduced a new BI product that will provide 3D data visualization using Bing Maps. This product is still in beta and is codenamed &#8220;GeoFlow&#8221; but should be out late 2013 or early 2014. This preview will allow you to plot geographic and temporal data visually, analyze that data in 3D, and create visual [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30,73],"tags":[35,106,59,66,33,112],"class_list":["post-312","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-power-map","tag-bi","tag-business-intelligence","tag-development","tag-excel","tag-maps","tag-power-map"],"_links":{"self":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=312"}],"version-history":[{"count":1,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/312\/revisions"}],"predecessor-version":[{"id":319,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/312\/revisions\/319"}],"wp:attachment":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}