Ishadi lebhamuza eligqwayizayo

Sengivele ngibhale isihloko esikhulu esinemininingwane mayelana namashadi amabhamuza amile ajwayelekile, ngakho-ke ngeke ngigxile ezintweni eziyisisekelo manje. Ngamafuphi, ishadi lebhamuza (Ishadi Lebhamuza), ngendlela yalo, liwuhlobo oluhlukile lweshadi lokubonisa nokuthola ubudlelwano (ukuxhumana) phakathi kwamapharamitha ambalwa (3-4). Isibonelo sakudala ishadi elibonisa ingcebo yezakhamizi (ku-x-eksisi), ubude bempilo (ku-y-eksisi), kanye nenani labantu (usayizi webhola) emazweni amaningana.

Manje umsebenzi wethu ukukhombisa, sisebenzisa ishadi lebhamuza, ukuthuthukiswa kwesimo ngokuhamba kwesikhathi, isibonelo, kusukela ngo-2000 kuya ku-2014, okungukuthi, ukudala, empeleni, ukugqwayiza okusebenzisanayo:

Ishadi elinjalo libukeka lizenzisa kakhulu, kepha liyadalwa (uma une-Excel 2013-2016), ngokwezwi nezwi, emizuzwini embalwa. Ake sihambe isinyathelo ngesinyathelo.

Isinyathelo 1. Lungiselela idatha

Ukuze sakhe, sidinga ithebula elinedatha yezwe ngalinye, kanye nohlobo oluthile:

Qaphela ukuthi unyaka ngamunye umugqa ohlukile onegama lezwe kanye namanani emingcele emithathu (imali engenayo, iminyaka yokuphila, inani labantu). Ukulandelana kwamakholomu nemigqa (ukuhlunga) akudlali indima.

Inguqulo evamile yethebula, lapho iminyaka ihamba ngamakholomu ukuze kwakhiwe amashadi ebhamuza, ngeshwa, ayifaneleki:

Ungasebenzisa kabusha i-crosstab macro noma ithuluzi elenziwe ngaphambilini kusuka kusengezo se-PLEX ukuze uguqule ithebula elinjalo libe ukubukeka okufanele.

Isinyathelo 2. Xhuma isengezo se-Power View

Wonke umsebenzi wokwakha ishadi elinjalo elisebenzisanayo uzothathwa isengezo esisha se-Power View esivela kukhithi yamathuluzi yezobunhloli bebhizinisi (Business Intelligence = BI), esivele ku-Excel kusukela enguqulweni yango-2013. Ukuhlola ukuthi unaso yini isengezo esinjalo nokuthi sixhunyiwe, yiya ku Ifayela – Izinketho – Izengezo, khetha ezansi kwewindi ohlwini lokudonsela phansi Izengezo ze-COM Bese uqhafaza Mayelana (Ifayela — Izinketho — Izengezo — Izengezo ze-COM — Hamba):

Ewindini elivulayo, hlola ukuthi kunophawu lokuhlola eduze kwalo ukubuka kwamandla.

Ku-Excel 2013 ngemuva kwalokho kuthebhu Faka (Faka) inkinobho kufanele ivele:

Ku-Excel 2016, ngasizathu simbe, le nkinobho isusiwe kuribhoni (ngisho nomaki wokuhlola ohlwini lwezengezo ze-COM), ngakho-ke kufanele uyengeze ngesandla kanye:

1. Chofoza kwesokudla iribhoni, khetha umyalo Yenza iribhoni ngendlela oyifisayo (Yenza ngendlela oyifisayo iribhoni).
2. Engxenyeni engenhla kwesokunxele yewindi elivelayo, khetha ohlwini lokudonsela phansi Wonke amaqembu (Yonke imiyalo) bese uthola isithonjana ukubuka kwamandla.
   
3. Engxenyeni engakwesokudla, khetha ithebhu Faka (Faka) futhi udale iqembu elisha kulo usebenzisa inkinobho Ukwakha iqembu (Iqembu Elisha). Faka noma yiliphi igama, isibonelo ukubuka kwamandla.
4. Khetha iqembu elidaliwe bese wengeza inkinobho etholakele kulo ukusuka engxenyeni engakwesokunxele yewindi usebenzisa inkinobho Engeza (Engeza) phakathi kwefasitela.

   
   

Isinyathelo sesi-3. Ukwakha ishadi

Uma isengezo sixhunyiwe, ukwakha ishadi ngokwalo kuzothatha imizuzwana embalwa kuphela:

1. Sibeka iseli esebenzayo etafuleni ngedatha bese uchofoza inkinobho ukubuka kwamandla ithebhu Faka (Faka) - Iphepha elisha lombiko we-Power View lizongezwa encwadini yethu yokusebenza. Ngokungafani neshidi le-Excel elivamile, alinawo amaseli futhi libukeka njengesilayidi se-Power Point. Ngokuzenzakalelayo, i-Excel izokwakhela kulesi silayidi into efana nesifinyezo sedatha yethu. Iphaneli kufanele ivele kwesokudla Izinkambu zokubuka amandla, lapho wonke amakholomu (izinkambu) ezivela etafuleni lethu zizofakwa ohlwini.
2. Susa ukumaka wonke amakholomu ngaphandle amazwe и Isilinganiso semali engenayo yonyaka - Ithebula elakhiwe ngokuzenzakalelayo eshidini le-Power View kufanele libuyekezwe ukuze libonise idatha ekhethiwe kuphela.
   
3. Kuthebhu ethuthukisiwe umakhi (Umklamo) ukuchofoza Elinye Ishadi - Scatter (Elinye Ishadi - Scatter).

   

   Ithebula kufanele liphenduke libe yishadi. Yelule ekhoneni ukuze ilingane nesilayidi.
   

4. Hudula iphaneli Izinkambu zokubuka amandla: inkambu Isilinganiso semali engenayo yonyaka – esifundeni Inani le-Xfield Ihlala Isikhathi Esingakanani I - Ngaphakathi I-Y-valufield Population endaweni Usayizi, kanye nensimu Unyaka в I-eksisi yokudlala:

   
   

Yilokho-ke umdwebo usulungile!

Kusele ukuthi ufake isihloko, qala ukugqwayiza ngokuchofoza inkinobho ethi Dlala ekhoneni elingezansi kwesokunxele lesilayidi futhi ujabulele ukuqhubeka (ngawo wonke umqondo).

• Liyini ishadi lebhamuza nokuthi ulakha kanjani ku-Excel
• Ukubona ngeso lengqondo i-geodata kumephu ku-Excel
• Ulenza kanjani Ishadi Elisebenzisanayo ku-Excel elinamabha wokuskrola nama-Toggles