Inofungidzirwa nguva yekuverenga: 9 minuti
Zvichitaurwa zviri nyore, tafura yepivot inyanzvi yekuongorora data inoshandiswa kupfupisa mahombe e data uye kupindura mibvunzo yaungave unayo nezve data. Inowanikwa mumaspredishiti maapplication akadai seMicrosoft Excel uye Google Sheets. Iyo inzira ine simba kwazvo yekuronga data rako.
Heino fananidzo yekutsanangura zvirinani zvinoitwa netafura yepivot:
Ngatimbofungidzirai tine chirongo chemaswiti:
Uye tinoda kunzwisisa: vangani zvihwitsi zvitsvuku zviripo?
Ndezvipi zvihwitsi zviri muruvara rumwe norumwe?
Ndezvipi zvihwitsi zviripo muchimiro chimwe nechimwe?
Imwe nzira yekuita izvi ndeyekuverenga nemaoko rimwe nerimwe. Izvi zvinogona kutora nguva yakareba.
Nzira yakanakisa yekuwana mhinduro kugadzira tafura yepivot.
PivotTables inzira yekuronga patsva uye kupfupisa seti yakaoma yedata mutafura imwe, iyo inotibvumira kuwana nyore mapatani kana mhinduro kune chero mibvunzo yatingave nayo nezve data set. Neimwe nzira, tiri kuunganidza akati wandei akasiyana mune dataset. Ichi chiito chinozivikanwa zvakare sekuunganidza data.
Pane nzira dzakati wandei dzekuunganidza aya candies:
Muchidimbu, izvi ndizvo zvinoitwa netafura yepivot. Mapoka data uye inobvumidza iwe kuti uite maverengero akadai sekuverenga uye kupfupisa data.
PivotTables anoshandiswa kupfupisa uye kurongazve huwandu hukuru hwe data mutafura iri nyore-kunzwisisa iyo inotibvumira kutora mhedziso dzakakosha.
Shandisa makesi / mienzaniso yematafura epivot muhupenyu chaihwo:
MaPivotTables anoshandisa mabasa akaita seSUM uye AVERAGE kukurumidza kuwana mhinduro kumibvunzo iyi.
Kana watarisana nehuwandu hwakawanda hwe data, zviri nyore kunzwa kuremerwa. Apa ndipo panopinda matafura epivot. PivotTables haisi chishandiso chete; iwo akakosha sosi mune chero data analyst's arsenal. Ngatione kuti nei uchifanira kufunga kuzvishandisa:
Matafura epivot auya kure kubva pakaunzwa. Nepo vazhinji vachibatanidza izwi rekuti "pivot tafura" neMicrosoft Excel, mamiriro anhasi anopawo mamwe mapuratifomu akabatanidza nekuvandudza mashandiro ane simba aya.
Sarudza iyo data yaunoda kuongorora muPivot.
Pamusoro, tinya Insert -> PivotTable -> Kubva Tafura/Range.
Kune 4 mabhokisi: mafirita, makoramu, mitsetse uye kukosha. Pano iwe unogona kugadzirisa zvakare zvakasiyana-siyana kuti uwane mhinduro dzakasiyana.
Kuti unoaronga sei zvinoenderana nemibvunzo yaunoda kupindura.
Mubhokisi re "values", mushure mekukwevera shanduko mukati maro, unogona kusarudza kuverenga kwaunoda kushandisa. Inonyanya kuzivikanwa ndeye SUM uye AVERAGE.
Sezvo isu tichida kuwana huwandu hwese kutengesa pano, isu tichasarudza SUM.
Kana iyo tafura yepivot yagadzirwa, unogona kuronga data kubva kumusoro kusvika pasi nekudzvanya-kurudyi tafura -> rongedza -> rongedza rakakura kusvika kudiki.
Kugadzira tafura yepivot muGoogle Sheets kwakafanana neExcel.
Tanga nekuvhura spreadsheet muGoogle Sheets uye kusarudza data rako rese.
Unogona kukurumidza kusarudza data rese nekudzvanya kona yekuruboshwe yespredishiti kana nekudzvanya CTRL + A.
Enda kuInsert -> PivotTable:
Iwe unogona kugadzira tafura yepivot mune pepa idzva kana mune pepa riripo. Kazhinji zviri nyore kuiisa mubepa idzva, asi zvinoenderana nezvinodiwa nemunhu.
Pane nzira mbiri dzekugadzirisa PivotTable muGoogle Sheets:
1. Kushandisa nzwisiso dzinotaurwa nehungwaru hwekugadzira
2. Kushandisa zvaunopinza
Unogona kuita zvese uchishandisa kurudyi rwetafura yepivot yauchangobva kugadzira:
Dzvanya "Wedzera" kuti ugadzire tafura yako yepivot. Zvakafanana neExcel, iwe unogona nemaoko kuwedzera zvinoshanduka mu "mitsara, makoramu, kukosha uye mafirita".
Zvino zvawagadzira tafura yepivot, unoziva sei kuti ndeipi bhokisi rekuisa imwe neimwe shanduko? Mitsara, makoramu, kukosha kana mafirita?
Heino nzira yekushandisa imwe neimwe:
Kana iwe uchingobata chete nemhando imwe yemhando, hazvina basa kuti ndeipi yaunoshandisa. Zvose zvichava nyore kuverenga.
Asi kana tichida kufunga nezve 2 zvinhu panguva imwe chete, semuenzaniso kutengesa kunogadzirwa mu "purovhinzi" uye ne "genre", ipapo iwe uchafanirwa kusanganisa uye kuenzanisa uye kuona kuti ndeipi inoshanda zvakanyanya. Edza kuisa imwe mumitsara uye imwe mumakoramu uye ona kana iwe uchida inobuda tafura yepivot.
Hapana mutemo wakatarwa wekusarudza kupi kwekuisa shanduko yega yega. Isa iyo nenzira iyo iri nyore kuverenga iyo data.
Ercole Palmeri
Coveware neVeeam icharamba ichipa cyber kubira chiitiko mhinduro masevhisi. Coveware ichapa forensics uye kugadzirisa kugona…
Kufanofungidzira kugadzirisa kuri kushandura chikamu cheoiri & gasi, nemaitiro matsva uye akasimba ekutarisira zvidyarwa.…
Iyo UK CMA yakapa yambiro nezvemaitiro eBig Tech mumusika wehungwaru hwekugadzira. Ikoko…
Chirevo che "Case Green", chakagadzirwa neEuropean Union kuti chiwedzere kushanda nesimba kwezvivakwa, chapedza hurongwa hwayo hwemutemo ne…