{"id":22200,"date":"2020-01-21T13:43:02","date_gmt":"2020-01-21T12:43:02","guid":{"rendered":"https:\/\/www.microsoft.com\/en-gb\/industry\/blog\/?p=22200"},"modified":"2020-01-29T10:04:10","modified_gmt":"2020-01-29T09:04:10","slug":"how-to-using-powerbi-shape-map-tool","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-gb\/industry\/blog\/cross-industry\/2020\/01\/21\/how-to-using-powerbi-shape-map-tool\/","title":{"rendered":"How to visualise geospatial data by location to inform better decision making"},"content":{"rendered":"
Organisations produce so much data these days that it can be difficult to manage and make sense of it all \u2013 especially for those who aren\u2019t data scientists. But using data visualisation helps communicate data insights in a way that makes it easy for everyone in the business to understand data and its importance.<\/p>\n
Data visualisation can be used to provide more insight than traditional descriptive statistics can\u2019t. It can also be used to see distinct patterns and observations that won\u2019t be immediate if you wade through data line-by-line.<\/p>\n
This allows companies to gather and quickly act on their data. Faster, informed decision making makes organisations more responsive in an increasingly competitive market.<\/p>\n
I\u2019ve put together a very short tutorial on how to use the PowerBI preview tool called Shape Map to help you visualise data across regions. Shape Maps are unique in its ability to use custom maps based on TOPOJSON files. It distinguishes the different regions of the map by using different colours in a way that’s easy on the eye.<\/p>\n
Once you have PowerBI go to Options by clicking on File<\/strong>, then Options and settings<\/strong>, then finally Options<\/strong>:<\/p>\n <\/p>\n Clicking on Options will lead to the window as seen below. Ensure that Shape Map Visual<\/strong> is ticked<\/strong>. Once this is done, restart<\/strong> PowerBI for the changes to take effect.<\/p>\n <\/p>\n All set! You should now see the Shape Map icon in your Visualisation tab.<\/p>\n In a new PowerBI window click on Get Data<\/strong> and select Text\/CSV.<\/strong><\/p>\n <\/p>\n Once the select file dialog appears, choose the provided file countydata.csv.<\/strong><\/p>\n <\/p>\n Click on Transform Data<\/strong> on the new window.<\/p>\n <\/p>\n Now rename<\/strong> the top two columns to County<\/strong> and Value<\/strong> as shown below. Once you’ve done that click Save<\/strong> and Apply.<\/strong><\/p>\n <\/p>\n On the Visualizations<\/strong> pane select<\/strong> the Shape Map<\/strong> icon – the one that has a red ring<\/strong> around it in the below picture:<\/p>\n <\/p>\n You will end up with something plain looking like this.<\/p>\n <\/p>\n Not very eye-catching is it? Let’s fix that, shall we!<\/p>\n On the fields<\/strong> pane, select County<\/strong> and Value.<\/strong><\/p>\n <\/p>\n Now under the Format<\/strong> tab in the Visualizations<\/strong> pane, select Add Map<\/strong> and choose<\/strong> the uk-counties.json<\/strong> file from whatever directory you saved it in. Your subsequent pane should look something like this:<\/p>\n <\/p>\n Your Shape Map should be complete. As specified by the data source, the following counties are represented in the map; Bedfordshire<\/strong>, Berkshire<\/strong> and West Midlands<\/strong>. I highly recommend you add<\/strong> more county<\/strong> and subsequent values<\/strong> in the CSV<\/strong> file to make the map look more distinct<\/strong>.<\/p>\n <\/p>\n This map will help you visual data in a way that will help your business make more informed decisions, gains actionable insights, and quickly respond to a competitive market.<\/p>\n Special thanks to Matthew Stephen.<\/p>\n Jalal Uddin is a Cloud Solution Architect Intern at Microsoft, UK. He is passionate about empowering customers to learn how to use data to discover actionable insights to be more productive, more profitable, and more competitive. Jalal is completing a Computer Science Degree at Aston University.<\/p>\n","protected":false},"excerpt":{"rendered":" Data visualisation can be used to provide more insight than traditional descriptive statistics can\u2019t. This allows companies to make faster, informed decisions in an increasingly competitive market.<\/p>\n","protected":false},"author":585,"featured_media":22983,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"categories":[1],"post_tag":[639,160,636,307],"content-type":[],"coauthors":[1128],"class_list":["post-22200","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cross-industry","tag-analytics","tag-blogger-series","tag-data","tag-power-bi"],"yoast_head":"\nImporting Sample Data<\/h2>\n
Shape Map Visual<\/h2>\n
<\/h2>\n
About the author<\/h2>\n