Mukati
Kana kambani yako iine mapazi kutenderera nyika kana kutengesa kwete chete mukati meMoscow Ring Road, ipapo munguva pfupi kana gare gare iwe uchatarisana nebasa rekuona nekuona nhamba yedata kubva kuMicrosoft Excel (kutengesa, maapplication, mavhoriyamu, vatengi) pamepu yenzvimbo. maererano nemaguta chaiwo nematunhu. Ngatitarisei nekukurumidza nzira huru dzekuona geodata iripo muExcel.
Nzira 1: Inokurumidza uye Yemahara - Bing Mepu Chikamu
Kutanga kubva ku2013 vhezheni, Excel ine yakavakirwa-mukati app chitoro, kureva kuti zvakakwanisika kutenga, kudhawunirodha nekuisa mamwe mamodule uye maadd-ons ane mabasa asipo. Chimwe chezvikamu izvi chinongokubvumidza kuti utaridze nhamba yedata pamepu - inonzi Bing Mepu uye, iyo inonyanya kunaka, ndeyemahara. Kuti uiise, vhura iyo tab Isa - Chitoro (Isa - Hofisi Mapurogiramu):
Mushure mekuisa chikamu, mudziyo une simba une mepu unofanirwa kuoneka papepa. Kuti uone ruzivo rwako pamepu, iwe unofanirwa kusarudza renji ine geodata wodzvanya bhatani Ratidza Nzvimbo:
Kana zvichidikanwa, muzvirongwa (giya icon mukona yekurudyi yechikamu), unogona kushandura mavara uye rudzi rwemachati anoratidzwa:
Izvo zvakare zvinogoneka kukurumidza kusefa maguta, uchiratidzira chete iwo aunoda (funnel icon mukona yepamusoro yekurudyi yechikamu).
Iwe unogona nyore kusunga kwete kumaguta chete, asiwo kune zvimwe zvinhu: matunhu (semuenzaniso, Tula dunhu), nzvimbo dzinozvimiririra (semuenzaniso, Yamalo-Nenets) uye marepublic (Tatarstan) - ipapo denderedzwa remufananidzo richaratidzwa pakati penzvimbo. Chinhu chikuru ndechekuti zita riri patafura rinoenderana nezvinyorwa pamepu.
Total in pluses yeiyi nzira: nyore kusununguka kuita, otomatiki kusunga pamepu, marudzi maviri emachati, kusefa kuri nyore.
В nezvayakaipira: unoda Excel 2013 neInternet access, haugone kusarudza matunhu nematunhu.
Method 2: Flexible uye Yakanaka - Mepu Tarisa muSimba Rekuona Mishumo
Dzimwe shanduro dzeMicrosoft Excel 2013 dzinouya neine simba reshumo yekuona kuwedzera-in inonzi Power View iyo inobvumira (pakati pezvimwe zvinhu, uye inogona kuita zvakawanda!) Ratidza data pamepu. Kuti uite iyo yekuwedzera, vhura iyo tab yokuvaka (Mugadziri) uye tinya bhatani COM yekuwedzera-in (COM yekuwedzera). Muhwindo rinovhurwa, tarisa bhokisi riri padyo nePower View uye tinya OK. Mushure mezvose izvi manipulations pane tab Insert (Isa) unofanira kuva nebhatani Power view.
Iye zvino iwe unogona kusarudza huwandu neiyo sosi data, tinya pane iyi bhatani - pepa idzva richagadzirwa mubhuku rako (zvakanyanya kunge slide kubva kuPower Point), uko data rakasarudzwa richaratidzwa muchimiro chetafura:
Unogona kushandura tafura kuita mepu yenzvimbo zviri nyore uchishandisa bhatani The Card (mepu) Tab Constructor (Dhizaini):
Chengetedza zvakanyanya kune panhizha yakarurama Power View minda - pairi, kusiyana nemamepu ekare eBing, nekukweva mazita emakoramu (minda) kubva patafura yekutangira negonzo uye nekuadonhedza munzvimbo dzakasiyana-siyana, unogona kunyatsogadzirisa inozoitika geo-kumiririra:
- Kunzvimbo Locations (Nzvimbo) zvakakosha kukanda mutsara kubva patafura yezvinyorwa zvine mazita enzvimbo.
- Kana iwe usina koramu ine zita, asi kune makoramu ane makongiresi, saka anofanirwa kuiswa munzvimbo. Longitude (Longitude) и nzvimbo (Latitude), maererano.
- Kana munzvimbo ruvara (Ruvara) donhedza zvinhu, ipapo bubble rega rega richave, mukuwedzera kune saizi (inoratidza iyo yakazara purofiti muguta), yakatsanangurwa muzvidimbu nezvinhu.
- Kuwedzera munda kune imwe nzvimbo mira or Horizontal multipliers (Vaparadzi) ichakamura kadhi rimwechete kuita akati wandei nendima iyi (mumuenzaniso wedu, nekota).
Zvakare pane iyo mamiriro tab inoonekwa kumusoro Maitiro (Magadzirirwo) unogona kugadzirisa iyo mepu kumashure (ruvara, b / w, rondedzero, satellite maonero), mavara, mazita, ngano, nezvimwe.
Kana pane data yakawanda, ipapo pane tab Power view unogona kugonesa special Sefa nzvimbo (Masefa), uko uchishandisa akajairika mabhokisi ekutarisa iwe unogona kusarudza kuti ndeapi maguta kana zvinhu zvaunoda kuratidza pamepu:
muunganidzwa mune pluses: nyore kushandisa uye kuchinjika kwekugadzirisa, kugona kupatsanura kadhi rimwe mumapoka akati wandei.
Mune downsides: Power View haisi kuwanikwa mune ese Excel 2013 zvigadziriso, hapana mamwe marudzi emachati kunze kwebubble uye pie machati.
Nzira 3: Inodhura uye nyanzvi - Power Mepu yekuwedzera
Iyi yakasarudzika COM yekuwedzera kune yakanyanya kuomarara kesi kana iwe uchida yakaoma, inyanzvi-inotaridzika, ine animated kuona kwehuwandu hukuru hwe data pane chero (kunyangwe mepu yakasarudzika), uye nevhidhiyo yemaitiro ekuchinja nekufamba kwenguva. . Padanho rekusimudzira, yaive nezita rekushanda GeoFlow, uye yakazonzi Power Mepu. Nehurombo, iyo yakazara vhezheni yeiyi yekuwedzera inongowanikwa kune vatengi veiyo yakazara vhezheni yeMicrosoft Office 2013 Pro kana Office 365 bhizinesi vanyoreri vane Bhizinesi Intelligence (BI) chirongwa. Nekudaro, makomuredhi kubva kuMicrosoft anopa tarisiro yeiyi yekuwedzera kudhawunirodha "kutamba" mahara, izvo zvatinovatenda.
Link yekurodha Power Mepu Preview kubva kuMicrosoft Download Center (12 Mb)
Mushure mekurodha nekuisa iyo yekuwedzera, iwe unofanirwa kuibatanidza pane iyo tab Mugadziri - COM Wedzera-Ins (Mugadziri - COM Yekuwedzera) yakafanana nePower View kubva mundima yapfuura. Pashure paizvozvo, pane tab Insert bhatani rinofanira kuoneka The Card (mepu). Kana isu zvino tasarudza tafura ine sosi data:
... uye tinya bhatani reMepu, tobva taendeswa kune imwe hwindo reMicrosoft Power Mepu yekuwedzera-mukati:
Pasina kupinda mune zvakadzama (izvo zvinokwana kudzidziswa kwakasiyana kwehafu yezuva), saka misimboti yekushanda nemepu yakafanana neiyo muPower View inotsanangurwa pamusoro:
- Saizi yemakoramu inotarwa neiyo source table column (Revenue), yatichakanda mumunda urefu mupaneru yekurudyi. Nheyo yekuverenga, sematafura epivot, inogona kushandurwa mune yekudonha-pasi runyorwa rweminda:
- Kuti utsanangure chikamu chega chega chekutengesa kune chimwe chigadzirwa, unofanirwa kuzadza munda chigadzirwa kunzvimbo chikamu (Chikamu).
- Unogona kushandisa marudzi akasiyana emachati (mabhawa machati, mabhubhu, kupisa mepu, nzvimbo dzakazadzwa) uchishandisa mabhatani ari parudyi:
- Kana iyo sosi data ine koramu ine mazuva ekutengesa, saka inogona kukandwa munzvimbo nguva (Nguva) - ipapo iyo axis yenguva ichaonekwa pazasi, iyo iwe yaunogona kuenda mune yakapfuura-ramangwana uye woona maitiro mune dynamics.
Iyo "wow nguva" yePower Mepu yekuwedzera inogona kunzi iyo yekupedzisira kurerutsira yekugadzira ane animated vhidhiyo wongororo zvichienderana nemamepu akagadzirwa. Zvakakwana kugadzira makopi akati wandei echiitiko chazvino kubva kumakona ekuona akasiyana uye zviyero zvakasiyana - uye iyo yekuwedzera inozogadzira otomatiki animation ye3D yekubhururuka yakatenderedza mepu yako, ichitarisa kunzvimbo dzakasarudzwa. Vhidhiyo inokonzeresa inozochengetwa zviri nyore mu mp4 fomati sefaira rakaparadzana rekuisa, semuenzaniso, pane Power Point slide.
Nzira 4. Bubble Chart ne "File Refinement"
Iyo yakanyanya "yakabatana purazi" nzira yezvose zvakanyorwa, asi kushanda mune ese mavhezheni eExcel. Gadzira bubble chati (Bubble Chart), dzima matemo ayo, gidhi, ngano ... kureva zvese kunze kwemabhuru. Wobva wagadzirisa nemaoko nzvimbo yemabhuru nekuisa iyo yakambodhawunirodha mufananidzo wemepu yaunoda pasi pedhiyagiramu:
nezvayakaipira yeiyi nzira iri pachena: refu, dreary, yakawanda yebasa remaoko. Uyezve, kubuda kwemasaini emabhubhu idambudziko rakasiyana kana paine akawanda awo.
zvayakanakira mukuti iyi sarudzo ichashanda mune chero shanduro yeExcel, kusiyana nenzira dzinotevera, uko Excel 2013 inodiwa. Uye hapana Indaneti inodiwa.
Method 5: Wechitatu bato maapplication uye ma-add-ons
Kare, pakanga paine akati wandei ma-add-ons uye plug-ins yeExcel ayo aibvumira, neakasiyana madhigirii ekureruka uye runako, kuita kuratidzwa kwedata pamepu. Ikozvino ruzhinji rwacho rwakasiiwa nevagadziri, kana muchikamu chekunyarara kufa - zvakaoma kukwikwidza nePower Mepu 🙂
Pakati pevakapona vakakodzera kutaurwa:
- MapCite - zvichida ane simba kupfuura ose. Inokwanisa kusungirirwa pamepu nemazita enzvimbo dzekugara, matunhu, matunhu nemakongiresi. Inoratidza data semapoinzi kana mepu yekupisa. Inoshandisa Bing Mepu sehwaro. Anoziva otomatiki kukanda mepu yakagadzirwa muPower Point mharidzo. Yemahara vhezheni yekuyedza inowanikwa kurodha, iyo yakazara vhezheni inodhura $99/gore.
- Esri Maps - yekuwedzera kubva kuEsri iyo zvakare inobvumidza iwe kurodha uye kuongorora geodata kubva kuExcel pamepu. Zvirongwa zvakawanda, marudzi akasiyana emachati, anotsigira . Pane yemahara demo vhezheni. Iyo yakazara vhezheni inoda kunyoreswa kune iyo ArcGis mepu sevhisi.
- MapLand- imwe yekutanga yekuwedzera-iyi pane ino musoro, yakagadzirirwa Excel 97-2003. Iyo inouya neseti yemepu muchimiro cheiyo graphic primitives, iyo iyo data kubva papepa inosungirirwa. Mamwe makadhi anofanira kutengwa. Demo yemhando dzakasiyana dzeExcel iripo kurodha, iyo Pro vhezheni inodhura $299.