{"id":3786,"date":"2017-02-10T09:24:38","date_gmt":"2017-02-10T08:24:38","guid":{"rendered":"https:\/\/sii.pl\/blog\/?p=3786"},"modified":"2023-08-28T15:44:05","modified_gmt":"2023-08-28T13:44:05","slug":"inne-spojrzenie-na-dane-czyli-power-map-w-excel-2016","status":"publish","type":"post","link":"https:\/\/sii.pl\/blog\/inne-spojrzenie-na-dane-czyli-power-map-w-excel-2016\/","title":{"rendered":"Inne spojrzenie na dane, czyli Power Map w Excel 2016"},"content":{"rendered":"\n<p><span style=\"color: #000000; font-family: Calibri;\">Chc\u0105c przygotowa\u0107 atrakcyjn\u0105 prezentacj\u0119 oraz maj\u0105c do dyspozycji dane zmieniaj\u0105ce si\u0119 w czasie i przestrzeni, warto pokusi\u0107 si\u0119 o&#8230;skorzystanie z dodatku Power Map w celu ich wizualizacji w przestrzeni tr\u00f3jwymiarowej. Dane tak z tabel, jak r\u00f3wnie\u017c dane pochodz\u0105ce z modelu danych programu Excel w \u0142atwy spos\u00f3b mo\u017cna rozlokowa\u0107 na szczeg\u00f3\u0142owych mapach Bing.<\/span><wp-block data-block=\"core\/more\"><\/wp-block><\/p>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">W celu rozpocz\u0119cia pracy z Power Map nale\u017cy upewni\u0107 si\u0119 i\u017c jest on dodany w obszarze dodatk\u00f3w: <\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM1.png\"><img decoding=\"async\" width=\"840\" height=\"198\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM1-e1485354979575.png\" alt=\"Add-ins\" class=\"wp-image-3789\"\/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Oraz czy aktywne s\u0105 dodatki analizy danych:<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM2.png\"><img decoding=\"async\" width=\"615\" height=\"488\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM2.png\" alt=\"Enable Data Analysis ass-ins\" class=\"wp-image-3790\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM2.png 615w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM2-300x238.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Po upewnieniu si\u0119 i\u017c dodatek jest zainstalowany, a narz\u0119dzia danych s\u0105 aktywne, przechodzimy do zgromadzonych danych i ze wst\u0105\u017cki wybieramy przycisk Mapy 3D.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM3.png\"><img decoding=\"async\" width=\"593\" height=\"442\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM3.png\" alt=\"Open 3D Maps\" class=\"wp-image-3791\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM3.png 593w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM3-300x224.png 300w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Dodatek otwierany jest w oddzielnym oknie. Znajdziemy tam opcje pozwalaj\u0105ce na mi\u0119dzy innymi zarz\u0105dzanie kolejnymi elementami prezentacji, opcje map, dodatkowe elementy (wykresy 2D, pola tekstowe, legendy) jak r\u00f3wnie\u017c opcje umo\u017cliwiaj\u0105ce moderacj\u0119 czasu i widoku okna edycji.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM4.png\"><img decoding=\"async\" width=\"840\" height=\"488\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM4-e1485355039536.png\" alt=\"&quot;&quot;\" class=\"wp-image-3792\"\/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Warto zwr\u00f3ci\u0107 uwag\u0119 na elementy edycji warstw danych po prawej stronie. Narz\u0119dzie umo\u017cliwia nam zaprezentowanie wielu warstw danych w kilku wersjach wizualizacji. Dodatkowo mo\u017cemy skorzysta\u0107 z kilku sposob\u00f3w lokalizacji naszych danych na mapach: wsp\u00f3\u0142rz\u0119dne geograficzne, nazwa miasta, regionu, stanu, kraju czy tez numer kodu pocztowego.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM5.png\"><img decoding=\"async\" width=\"318\" height=\"548\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM5.png\" alt=\"&quot;&quot;\" class=\"wp-image-3793\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM5.png 318w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM5-174x300.png 174w\" sizes=\"(max-width: 318px) 100vw, 318px\" \/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">W wersji MS Excel 2016 dodatkowo warto wspomnie\u0107 o filtrowaniu danych z mo\u017cliwo\u015bci\u0105 agregacji, kt\u00f3rego zdecydowanie brakowa\u0142o w poprzedniej wersji dodatku.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM6.png\"><img decoding=\"async\" width=\"290\" height=\"329\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM6.png\" alt=\"&quot;&quot;\" class=\"wp-image-3794\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM6.png 290w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM6-264x300.png 264w\" sizes=\"(max-width: 290px) 100vw, 290px\" \/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Po wprowadzeniu istotnych dla nas danych w kolejnych polach (lokalizacja, miara, kategoria, czas) mapa nabiera rumie\u0144c\u00f3w.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM7.png\"><img decoding=\"async\" width=\"840\" height=\"462\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM7-e1485355080221.png\" alt=\"Mapa \u015bwiata z kolorowymi punktami\" class=\"wp-image-3795\"\/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">W tym momencie warto przejrze\u0107 opcje dotycz\u0105ce mapy, np. doda\u0107 etykiety, zmieni\u0107 wygl\u0105d, znale\u017a\u0107 konkretn\u0105 lokalizacj\u0119 lub wskaza\u0107 obszary niestandardowe.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM8.png\"><img decoding=\"async\" width=\"840\" height=\"500\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM8-e1485355100983.png\" alt=\"&quot;&quot;\" class=\"wp-image-3796\"\/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Narz\u0119dzie pozwala r\u00f3wnie\u017c na zmian\u0119 motywu. Wyb\u00f3r nie jest zbyt bogaty, jednak zdecydowanie zmienia odbi\u00f3r ca\u0142o\u015bci.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM9.png\"><img decoding=\"async\" width=\"840\" height=\"461\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM9-e1485355172231.png\" alt=\"&quot;&quot;\" class=\"wp-image-3797\"\/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Istotnym elementem w prezentacji danych na mapie okazuje si\u0119 r\u00f3wnie\u017c prezentacja ich na poziomie r\u00f3\u017cnych warstw. Kolejne warstwy mog\u0105 odnosi\u0107 si\u0119 do czynnik\u00f3w, na kt\u00f3re maj\u0105 wp\u0142yw dane umieszczone w pierwszej warstwie. W ten spos\u00f3b \u0142atwiej zauwa\u017cy\u0107 korelacj\u0119 miedzy naszymi danymi w r\u00f3\u017cnych aspektach.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM10.png\"><img decoding=\"async\" width=\"840\" height=\"432\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM10-e1485355192772.png\" alt=\"&quot;&quot;\" class=\"wp-image-3798\"\/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Wspomnijmy r\u00f3wnie\u017c, \u017ce nie ogranicza nas tu na pewno konieczno\u015b\u0107 prezentowania danych w jednym widoku. W zale\u017cno\u015bci od naszych potrzeb, mo\u017cemy przygotowa\u0107 ich dowoln\u0105 liczb\u0119. Wystarczy doda\u0107 kolejn\u0105 scen\u0119 korzystaj\u0105c z odpowiedniej opcji na wst\u0105\u017cce narz\u0119dzi.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM11.png\"><img decoding=\"async\" width=\"535\" height=\"374\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM11.png\" alt=\"Zak\u0142adka New Scene\" class=\"wp-image-3799\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM11.png 535w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM11-300x210.png 300w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Sceny mo\u017cemy podda\u0107 kilku zmianom oferowanym przez narz\u0119dzie. S\u0105 to czas trwania sceny, efekty wy\u015bwietlania, zakres czasu, z kt\u00f3rego dane chcemy zaprezentowa\u0107 oraz pr\u0119dko\u015b\u0107.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM12.png\"><img decoding=\"async\" width=\"597\" height=\"546\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM12.png\" alt=\"Scene Options - Effect\" class=\"wp-image-3800\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM12.png 597w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM12-300x274.png 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Opr\u00f3cz prezentacji naszych danych z poziomu dodatku Power Map, narz\u0119dzie oferuje nam utworzenie pliku wideo. Mamy do wyboru trzy opcje zapisu w zale\u017cno\u015bci od jako\u015bci nagrania:<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span style=\"color: #000000; font-family: Calibri;\">Presentations &amp; HD Displays (1080p),<\/span><\/li>\n\n\n\n<li><span style=\"color: #000000; font-family: Calibri;\">Computers &amp; Tablets (720p),<\/span><\/li>\n\n\n\n<li><span style=\"color: #000000; font-family: Calibri;\">Quick Export &amp; Mobile (360p).<\/span><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM13.png\"><img decoding=\"async\" width=\"658\" height=\"467\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM13.png\" alt=\"Create Video\" class=\"wp-image-3801\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM13.png 658w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM13-300x213.png 300w\" sizes=\"(max-width: 658px) 100vw, 658px\" \/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">O czym warto tu r\u00f3wnie\u017c wspomnie\u0107 to mo\u017cliwo\u015b\u0107 dodania \u015bcie\u017cki d\u017awi\u0119kowej.<\/span><\/p>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Sam zapis trwa chwil\u0119, w zale\u017cno\u015bci od rodzaju nagrania i ilo\u015bci scen.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM14.png\"><img decoding=\"async\" width=\"680\" height=\"245\" src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM14.png\" alt=\"Creating Video status post\u0119pu\" class=\"wp-image-3802\" srcset=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM14.png 680w, https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PM14-300x108.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/a><\/figure>\n\n\n\n<p><span style=\"color: #000000; font-family: Calibri;\">Warto zapozna\u0107 si\u0119 z narz\u0119dziem Power Map i by\u0107 \u015bwiadomym jego mo\u017cliwo\u015bci oraz efekt\u00f3w ko\u0144cowych, kt\u00f3re mo\u017cemy za jego pomoc\u0105 osi\u0105gn\u0105\u0107.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/PowerMap_Demo2.mp4\"><\/video><\/figure>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;3786&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;11&quot;,&quot;greet&quot;:&quot;&quot;,&quot;legend&quot;:&quot;0\\\/5 ( votes: 0)&quot;,&quot;size&quot;:&quot;18&quot;,&quot;title&quot;:&quot;Inne spojrzenie na dane, czyli Power Map w Excel 2016&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} ( {votes}: {count})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 11px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 18px; height: 18px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 14.4px;\">\n            <span class=\"kksr-muted\"><\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Chc\u0105c przygotowa\u0107 atrakcyjn\u0105 prezentacj\u0119 oraz maj\u0105c do dyspozycji dane zmieniaj\u0105ce si\u0119 w czasie i przestrzeni, warto pokusi\u0107 si\u0119 o&#8230;skorzystanie z &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.pl\/blog\/inne-spojrzenie-na-dane-czyli-power-map-w-excel-2016\/\">Continued<\/a><\/p>\n","protected":false},"author":98,"featured_media":3809,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"image","meta":{"_acf_changed":false,"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","inline_featured_image":false,"footnotes":""},"categories":[1316],"tags":[421,459,458],"class_list":["post-3786","post","type-post","status-publish","format-image","has-post-thumbnail","hentry","category-development-na-miekko","tag-bi","tag-excel-2016","tag-power-map","post_format-post-format-image"],"acf":[],"aioseo_notices":[],"republish_history":[],"featured_media_url":"https:\/\/sii.pl\/blog\/wp-content\/uploads\/2017\/01\/10-\u2014-kopia.png","category_names":["Development na mi\u0119kko"],"_links":{"self":[{"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/posts\/3786"}],"collection":[{"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/users\/98"}],"replies":[{"embeddable":true,"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/comments?post=3786"}],"version-history":[{"count":2,"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/posts\/3786\/revisions"}],"predecessor-version":[{"id":23841,"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/posts\/3786\/revisions\/23841"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/media\/3809"}],"wp:attachment":[{"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/media?parent=3786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/categories?post=3786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sii.pl\/blog\/wp-json\/wp\/v2\/tags?post=3786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}