{"id":2659,"date":"2014-02-26T18:00:46","date_gmt":"2014-02-26T17:00:46","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=2659"},"modified":"2020-09-04T09:42:45","modified_gmt":"2020-09-04T07:42:45","slug":"power-view-zobrazeni-dat-na-mape","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/power-view-zobrazeni-dat-na-mape\/","title":{"rendered":"Power View – show data on a map"},"content":{"rendered":"

<\/p>\n

Excel 2013 comes with addin\u00a0PowerPivot and PowerView. PowerPivot is used to prepare the data model<\/em> and the subsequent creation of PivotTable\u00a0where the classic Excel is not enough. It enables eg. creating of relationships between tables and can have even more\u00a0records. But this article is about PowerView<\/strong> tool, which serves as presentation addin for data whether from the PowerPivot or classic tables. It can display both charts\u00a0and\u00a0very popular world map with a graphical representation of values for a specific location. Look at it, how can such a map from a single table to be created.<\/p>\n

Source file can be downloaded here<\/a>.<\/p>\n

Firstly, stand in the source table and activate the Insert tab, click Power View<\/strong> (see Figure. 1).<\/p>\n

\"Power<\/a>
Fig. 1:Power View activation<\/figcaption><\/figure>\n

A new sheet\u00a0with the default name Power View 1 creates. Click in the area shown in Power View to activate the Design<\/strong> tab. Cou can\u00a0change the view of the data to table, chart\u00a0or a map. Click the Map<\/strong>. On the right side we see the list of fields, like in\u00a0PivotTables, a list of columns from the source table. To display data on a map move\u00a0column with locations eg. recipient country to the Location section. The numerical value of the sum, as shown Freight (Dopravn\u00e9)<\/em> field, move to the section Size. The display changes on the world map (see Figure. 2). There you can use your mouse or locator buttons to zoom in and scroll view. The color section can contain fields for differentiating color, is therefore a form of filtering. Colorful “pie” then shows in the location of each share amounts by Transfer company (P\u0159eprava)<\/em>.<\/p>\n

\"Power<\/a>
Fig. 2: Power View map<\/figcaption><\/figure>\n

Using the\u00a0Layout<\/strong> tab\u00a0we can set different types of\u00a0map as road or air, to show a legend, title of map and data labels. The section Filters<\/strong> can continue to filter results, as seen in Fig. 3. From the perspective of global reports, this tool is very interesting and as you can see, the setting is not extremely difficult. If this guide has helped you, become a fan on Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n

\"Power<\/a>
Fig.\u00a03 : Power View\u00a0filters<\/figcaption><\/figure><\/p>\n","protected":false},"excerpt":{"rendered":"

Excel 2013 comes with addin\u00a0PowerPivot and PowerView. PowerPivot is used to prepare the data model and the subsequent creation of PivotTable\u00a0where the classic Excel is not enough. It enables eg. creating of relationships between tables and can have even more\u00a0records. But this article is about PowerView tool, which serves as presentation addin for data whether […]<\/p>\n","protected":false},"author":1,"featured_media":2662,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3],"tags":[10,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2659"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=2659"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2659\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/2662"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=2659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=2659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=2659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}