Okuqukethwe
Ngezibuyekezo zasehlobo zango-2018, i-Excel 2016 ithole ikhono elisha elishintshashintshayo lokwengeza uhlobo olusha lwedatha kumaseli − ukwabelana (Izitoko) и Map (IJografi). Izithonjana ezihambisanayo zivele kuthebhu Idatha (Usuku) eqenjini Izinhlobo Zedatha (Izinhlobo zedatha):
What is it and what is it eaten with? How can this be used at work? What part of this functionality is applicable to our reality? Let’s figure it out.
Ifaka uhlobo olusha lwedatha
Ukuze uthole ukucaciseleka, ake siqale nge-geodata futhi sithathe ithebula elilandelayo “lokuhlola”:
Okokuqala, ikhethe bese usenza isinqamuleli sekhibhodi "ehlakaniphile". Ctrl+T noma ngokusebenzisa inkinobho Fometha njengetafula ithebhu Ikhaya (Ekhaya — Fometha Njengethebula). Bese ukhetha wonke amagama edolobha bese ukhetha uhlobo lwedatha I-Geography ithebhu Idatha (Usuku):
Isithonjana semephu sizovela kwesokunxele samagama, okubonisa ukuthi i-Excel ibone umbhalo kuseli njengegama lendawo yezwe, idolobha, noma isifunda. Ukuchofoza lesi sithonjana kuzovula iwindi elihle elinemininingwane kule nto:
Okungazange kuqashelwe ngokuzenzakalelayo kuzomakwa ngophawu lombuzo, lapho kuchofozwa, iphaneli izovela ngakwesokudla, lapho ungahlunga khona isicelo noma ufake idatha eyengeziwe:
Amanye amagama angaba nezincazelo ezimbili, isibonelo, i-Novgorod ingaba yi-Nizhny Novgorod ne-Veliky Novgorod. Uma i-Excel ingayiboni njengoba kufanele, ungachofoza kwesokudla kuseli bese ukhetha umyalo Uhlobo Lwedatha - Shintsha (Uhlobo Lwedatha — Hlela), bese ukhetha inketho efanele kulezo ezinikezwa kuphaneli engakwesokudla:
Yengeza Amakholomu Emininingwane
Ungakwazi ukwengeza kalula amakholomu engeziwe anemininingwane yento ngayinye etafuleni elidaliwe. Isibonelo, emadolobheni, ungangeza amakholomu ngegama lesifunda noma isifunda (isigaba somqondisi), indawo (indawo), izwe (izwe / isifunda), usuku okwasungulwa ngalo (idethi eyasungulwa), inani labantu (isibalo sabantu), ububanzi nobude. (i-latitude, i-longitude) ngisho negama lemeya (umholi).
Ukuze wenze lokhu, ungachofoza isithonjana se-pop-up ekhoneni eliphezulu kwesokudla sethebula:
... noma sebenzisa ifomula ezobhekisela kuseli eliseduze bese wengeza ichashazi kuyo, bese ukhetha inketho oyithandayo ohlwini lokudonsela phansi lamahinti:
... noma vele wenze enye ikholomu, uyiqambe ngegama elifanele (Population, agents njll.) ohlwini lokudonsela phansi olunamacebiso:
Uma uzama konke lokhu kukholamu hhayi ngamadolobha, kodwa ngamazwe, ungabona izinkambu ezengeziwe:
Nazi izinkomba zezomnotho (imali engenayo ngomuntu ngamunye, izinga lokungasebenzi, izintela), kanye nabantu (ukuzala, ukufa), kanye nendawo (indawo yehlathi, ukukhishwa kwe-CO2) nokunye okuningi - cishe amapharamitha angu-50 esewonke.
Umthombo walo lonke lolu lwazi yi-Inthanethi, injini yokusesha i-Bing ne-Wikipedia, engapheli ngaphandle kokulandela umkhondo - le nto ayizazi izinto eziningi zeZwe Lethu noma ikhiphe ngendlela ehlanekezelwe. Isibonelo, phakathi kwezimeya, nguSobyanin noPoltavchenko kuphela abanikelayo, futhi ubheka idolobha elikhulu kunawo wonke eZweni Lethu ... awusoze waqagela ukuthi yiliphi! (hhayi eMoscow).
Ngesikhathi esifanayo, ku-States (ngokusho kwami), uhlelo lusebenza ngokuthembekile kakhulu, okungamangazi. Futhi e-USA, ngaphezu kwamagama ezindawo zokuhlala, ungasebenzisa ikhodi ye-ZIP (into efana nekhodi yethu yeposi), ekhomba ngokusobala izindawo zokuhlala ngisho nezifunda.
Ukuhlunga ngamapharamitha angacacile
Njengomphumela omuhle oseceleni, ukuguqula amaseli abe izinhlobo ezintsha zedatha kwenza kube nokwenzeka ukuhlunga amakholomu anjalo kamuva kumapharamitha angacacile emininingwaneni. Ngakho-ke, isibonelo, uma idatha ekukholomu ibonakala njengeJografi, ungakwazi ukuhlunga uhlu lwamadolobha ngamazwe, ngisho noma kungekho ikholomu enegama lezwe ngokucacile:
Bonisa kumephu
Uma usebenzisa kuthebula amagama ezindawo ezaziwayo hhayi amadolobha, kodwa amazwe, izifunda, izifunda, izifundazwe noma izifunda, lokhu kwenza kube nokwenzeka ukwakha imephu ebonakalayo usebenzisa ithebula elinjalo usebenzisa uhlobo olusha lwamashadi. I-Cartogram ithebhu Faka – Amamephu (Faka - Amamephu):
For example, for regions, territories and republics, this looks very nice:
Yiqiniso, akudingekile ukubona ngeso lengqondo idatha kuphela ohlwini oluhlongozwayo lwemininingwane. Esikhundleni sesibalo sabantu, ungabonisa noma yimaphi amapharamitha nama-KPI ngale ndlela - ukuthengisa, inombolo yamakhasimende, njll.
Uhlobo lwedatha yesitoko
Uhlobo lwedatha lwesibili, Izitoko, lusebenza ngendlela efanayo ncamashi, kodwa lwenzelwe ukuqaphela izinkomba zesitoko:
… kanye namagama ezinkampani namagama azo afushanisiwe (amathikithi) ekuhwebeni:
Sicela uqaphele ukuthi inani lemakethe (i-market cap) linikezwa ngesizathu esithile kumayunithi emali ahlukene, kahle, le nto ayazi uGref noMiller, ngokusobala 🙂
Ngifuna ukukuxwayisa ngaso leso sikhathi ukuthi ukusebenzisa konke lokhu ekuhwebeni ngeke kusebenze kahle, ngoba. idatha ibuyekezwa kanye kuphela ngosuku, okuyinto, ezimweni eziningi, ihamba kancane kakhulu ekuhwebeni. Ukuze uthole izibuyekezo ezivamile nolwazi lwakamuva, kungcono ukusebenzisa ama-macros noma imibuzo ukushintshanisa nge-inthanethi usebenzisa i-Power Query.
Ikusasa lezinhlobo zedatha entsha
Ngokungangabazeki, lesi kumane kuyisiqalo, futhi iMicrosoft cishe izonweba isethi yezinhlobo ezinjalo zedatha. Mhlawumbe, ngokuhamba kwesikhathi, mina nawe sizoba nethuba lokuzakhela ezethu izinhlobo, ezilolelwe imisebenzi ethile. Cabanga ngohlobo, ngokwesibonelo, lokubonisa idatha mayelana nomsebenzi noma iklayenti, equkethe idatha yakhe yomuntu siqu kanye nesithombe:
Abaphathi bakwa-HR bangathanda into enjalo, ucabangani?
Noma cabanga ngohlobo lwedatha olugcina imininingwane (usayizi, isisindo, umbala, intengo) yento ngayinye noma isevisi ohlwini lwamanani. Noma uhlobo oluqukethe zonke izibalo zomdlalo zeqembu elithile lebhola lezinyawo. Noma idatha yomlando yesimo sezulu? Kungani kungenjalo?
Nginesiqiniseko sokuthi sinezinto eziningi ezithakazelisayo ezizayo 🙂
- Ngenisa izinga le-bitcoin lisuka ku-inthanethi liye ku-Excel usebenzisa i-Power Query
- Ukubona ngeso lengqondo i-geodata kumephu ku-Excel
- Iguqula amanani ngomsebenzi we-CONVERT