- I-Power Query iyithuluzi eliyinhloko ku-Excel lokungenisa, ukuguqula, nokuhlanganisa idatha evela emithonjeni eminingi, ithuthuke ngenguqulo entsha ngayinye yesofthiwe.
- Inika amandla kokubili ukuhlaziywa okuyisisekelo nokuthuthukisiwe, ukuhlanganisa ukusebenza ne-Power Pivot kanye nokwenza lula ukumodeliswa kwedatha nokudala ubudlelwano obuzenzakalelayo.
- Okuhlangenwe nakho komsebenzisi kuyathuthuka ngokwengezwa kwamawizadi, amadeshibhodi, nokuhambisana kuzo zonke izinguqulo ezinkulu ze-Excel, nakuba kukhona umehluko phakathi Windows y Mac.
- Izinguquko zakamuva kanye nezidingo zobuchwepheshe zibalulekile kulabo abafuna ukusebenzisa amandla aphelele Ombuzo Wamandla ekuhambeni komsebenzi wabo wokuhlaziya idatha.
Ukuhlaziywa kwedatha nge-Excel kuthuthuke kakhulu eminyakeni yamuva nje , kwaba yikhono eliyisisekelo kochwepheshe kuzo zonke izinhlaka. Ngaphakathi kwalesi simo, i-Power Query ivelele njengenye yamathuluzi aguquguqukayo futhi anamandla kakhulu okungenisa, ukuguqula, nokuphatha idatha , okwenza abasebenzisi bakwazi ukusebenza ngolwazi oluvela emithonjeni eminingi futhi bakhe kalula amasethi edatha ayinkimbinkimbi. Ukuhlanganiswa kwayo ezinguqulweni ezahlukene ze-Excel kanye nokuthuthukiswa okuqhubekayo kokusebenza kwayo kuphawule inguquko endleleni esisebenza ngayo namaspredishithi.
I-Mastering Power Query imele intuthuko ebalulekile ekusebenzeni kahle nasekujuleni kokuhlaziywa kwakho . Ngezinguqulo zayo ezahlukahlukene kanye nokuhlanganiswa ne-Power Pivot kanye ne-Power BI, ivule iminyango yokuhlaziywa okuthuthukisiwe, ukumodela idatha, ukudala ubudlelwano okuzenzakalelayo, kanye nokukhiqizwa kwemibiko yobungcweti. Ngezansi, sethula umhlahlandlela obuyekeziwe noningiliziwe ohlanganisa izici, ukutholakala, ukuvela komlando, kanye nezici zobuchwepheshe ezibalulekile ukukusiza ukuthi uthole okuningi ku-Power Query ku-Excel futhi uthuthukise ukuhlaziywa kwakho uye ezingeni elilandelayo.
Iyini i-Power Query futhi iyini indima yayo ku-Excel?
I-Power Query ubuchwepheshe be-Microsoft obuhlanganiswe ne-Excel obuvumela abasebenzisi ukuthi bangenise, baguqule, bahlanganise, futhi bahlanze idatha evela emithonjeni eyahlukene ngaphandle kokudinga ulwazi oluthuthukisiwe lokuhlela . Ngaphambilini, i-Power Query ibilokhu iwumgogodla wokucubungula idatha kanye nokwenza amamodeli ngaphakathi kwe-Excel ngenxa yesikhombikubona sayo esinembile kanye nekhono lokwenza imisebenzi yokulawula idatha ephindaphindwayo ibe ngokuzenzakalela.
Nge-Power Query, ungaxhuma amafayela, izizindalwazi , amawebhusayithi, kanye nezinsizakalo zamafu, okwenza kube lula ukuqoqa ulwazi olufanele kungakhathaliseki ukuthi ifomethi noma ubunzima bunjani . Ngaphezu kwalokho, ikuvumela ukuthi ulolonge leyo datha ngokusebenzisa izinguquko eziningi: ukushintsha izinhlobo zedatha, ukuhlukanisa amakholomu, ukuhlunga, ukuhlunga, ukuhlanganisa amathebula, noma ukwengeza izibalo ezenziwe ngokwezifiso—konke kusuka ku-interface yesithombe elula ukuyisebenzisa.
Ukuvela nokutholakala Kombuzo Wamandla kuzinguqulo ezihlukene ze-Excel
Umlando we-Power Query ku-Excel ungowethuluzi eliye lakhula futhi landisa amakhono alo ngenguqulo ngayinye. Ku-Excel 2010 kanye no-2013 ye-Windows, i-Power Query yethulwa ekuqaleni njengesengezo samahhala abasebenzisi abangasilanda futhi basisebenzise ngesandla. Impumelelo kanye nokuthandwa kwayo kwaholela ekuhlanganisweni kwayo kwendabuko ezinguqulweni ezilandelayo.
Kusukela ku -Microsoft 365 , i-Excel 2016, kanye ne-Excel 2019 ye-Windows , i-Power Query ibilokhu iyingxenye ebalulekile yemenyu ethi 'Idatha', isebenza njengendlela eyinhloko yokungenisa nokuguqula idatha. Lokhu kuthathe indawo yabathakathi bokungenisa abadala ngolwazi oluvuselelwe, olubonakalayo, nolunamandla, okwenza inqubo ibe lula kakhulu kokubili kubasebenzisi abasafufusa kanye nochwepheshe.
Ngokuphathelene ne -Excel ye-Mac , indaba ihlukile kancane. Nakuba ukuhambisana kufike kamuva, kusukela ngo-2019 izici zengezwe ukuze kubuyekezwe imibuzo evela kumafayela ajwayelekile kanye nezizindalwazi ezifana ne-TXT, i-CSV, i-JSON, i-XML, kanye ne-SQL Server, ngaphezu kwekhono lokusebenza ngama-range namathebula ngaphakathi kwencwadi yokusebenzela uqobo. Ukuhlanganiswa kuyaqhubeka nokuthuthuka, yize ezinye izici zingakahambisani ngokuphelele nenguqulo ye-Windows.
Izici eziyisisekelo nezithuthukisiwe zokuhlaziya idatha nge-Power Query
Uhla lwamathuluzi okuhlaziya e-Excel luvela emazingeni amabili: izici eziyisisekelo nezithuthukisiwe . Noma yimuphi umsebenzisi obhalisele i-Microsoft 365 noma ilayisensi yokuthenga kanye ye-Office 2016 usengakwazi kakade ukufinyelela imisebenzi eyisisekelo efana namathebula e-pivot, izisiki, amashadi, kanye nokudalwa kwamamodeli edatha alula.
Isihluthulelo ukuthi, selokhu kwafika i-Power Query, kulula kakhulu ukungenisa, ukuhlanganisa, nokuguqula idatha evela emithonjeni ehlukene, kususwe imisebenzi yesandla nephindaphindayo eyayithatha isikhathi esiningi ngaphambili . Ithuluzi lingathola ubudlelwano phakathi kwamathebula , lengeze amaqoqo esikhathi, futhi, lihlanganiswe ne-Power Pivot, likuvumela ukuthi udale izindlela zokulinganisa nge-DAX (Izincazelo Zokuhlaziywa Kwedatha), okwenza kube lula ukubala okuthuthukile kanye nokukhiqizwa kwama-KPI.
Kubasebenzisi bebhizinisi noma labo abasebenzisa izinguqulo ezithuthukisiwe kakhulu (i-Microsoft 365 Enterprise, i-Office 2019 Professional noma i-Professional Plus, noma amalayisense e-Excel 2019 azimele), izici eziyinkimbinkimbi kakhulu ziyafakwa : ukuxhumana nemithombo yedatha yenkampani kanye ne-big, ukuhlela imodeli yedatha ethuthukisiwe, ukudalwa kwezigaba, ama-KPI, kanye nokubambisana ngemibuzo eyabiwe.
Ukubonisana Kwephaneli & Ukuxhumana nosizo oluthuthukisiwe
Izinguqulo zakamuva ze-Excel ziye zaphawuleka ngokunikeza isikhombikubona esilula kakhulu sokuphatha imibuzo . Iphaneli ethi "Imibuzo Nokuxhumana" yenza kube lula ukubuka nokuhlela yonke imithombo yedatha exhunywe encwadini yokusebenzela, okwenza kube lula ukubuyekezwa nokuhlela.
Ukwengeza, izangoma zokungenisa idatha, ezitholakala kuthebhu ethi "Idatha" ngaphansi kweqembu elithi "Thola & Guqula Idatha", zihlelwe kabusha futhi zathuthukiswa, okukuvumela ukuba ukhethe umthombo oyifunayo ngokuchofoza okumbalwa nje futhi wenze izinguquko ezilula noma eziyinkimbinkimbi ngokuya ngezidingo zephrojekthi ngayinye.
Ukusetshenziswa okusebenzayo kokuhlaziywa kwedatha nge-Power Query
Ngenxa yamandla ayo nokuguquguquka kwayo, i-Power Query isetshenziswa emikhakheni eminingi nasezimweni zobungcweti. Kusukela ekufundiseni eyunivesithi kuya ekwelulekeni kwe-R&D, ukuhlela amadolobha, kanye nentuthuko yezomnotho, ikhono lokucubungula idatha eningi nokudala amamodeli athuthukile seliyisidingo sokwenza izinqumo eziqhutshwa idatha.
Ochwepheshe abanolwazi ngezibalo, izinhlelo, noma ukuhlaziywa kwebhizinisi basebenzisa i-Power Query ukuze benze imisebenzi ibe ngokuzenzakalela, bahlanze izizindalwazi, badale imibiko ethuthukisiwe, noma bahlanganise ulwazi oluvela kumapulatifomu ahlukene (njengamafayela e-CSV, izizindalwazi ze-SQL, izinsizakalo zewebhu, njll.). Ukusetshenziswa okujulile kwe-Excel ocwaningweni nasebhizinisini kuholele ekushicilelweni kwezihloko, izincwadi, kanye nezethulo zesayensi ezisekelwe ekuhlaziyweni kwedatha kusetshenziswa i-Power Query namathuluzi ahlobene nayo.
Ukuqeqeshwa, ukwakhiwa kwamandla kanye nezinsiza ezikhona
I-Learning Power Query iya ngokuya ifinyeleleka ngenxa yokutholakala kwezifundo ezikhethekile nezamahhala, kokubili ku-inthanethi kanye nobuso nobuso. Izinketho zokufunda nge-elekthronikhi kanye nokufunda ibanga zivumela abasebenzisi ukuthi bathole amakhono ngesivinini sabo , ngokusekelwa kochwepheshe kanye nokufinyelela izinsiza zobuchwepheshe ezisezingeni eliphezulu.
Kusukela kumadokhumenti e-Microsoft kuya ezifundweni ezinikezwa amanyuvesi nezinkampani zokubonisana, ezinye izindlela ziyahlukahluka futhi zihambisana namazinga ahlukene okuhlangenwe nakho. Lolu hlu olubanzi lwezinketho zokuqeqesha lubonisa ukubaluleka kwaleli thuluzi empilweni yobungcweti neyezemfundo.
Izinzuzo ezibalulekile zombuzo wamandla kunezindlela zendabuko
Uma kuqhathaniswa nomsebenzi wesandla wesikhathi esidlule, lapho ukuguqulwa ngakunye kwakudingeka kuphindwe kumashidi amasha noma kumaskripthi e-VBA, i-Power Query inikeza izinzuzo ezicacile :
- Inqubo ezishintshayo: Izinguquko nokuxhumana kuyarekhodwa futhi kungabuyekezwa ngokuchofoza okukodwa.
- Ukwehluka: Kulula ukusebenza ngenani elikhulu ledatha nemithombo eminingi ngaphandle kokuncipha okuphawulekayo noma iphutha lomuntu.
- Ukuvumelana nezimo: Ivumela imisebenzi elula, njengokuhlanza itafula lokuthengisa, ukuya emisebenzini ethuthukisiwe njengokwenza amamodeli edatha ahlobene noma ukusebenzisa imisebenzi eyinkimbinkimbi ye-DAX.
- Ukuhlanganiswa: Ukusekelwa kwe-Power Pivot kanye ne-Power BI kukhulisa amandla okuhlaziywa kwe-multidimensional kanye nokuboniswa kolwazi.
Izinto okufanele uzicabangele ngaphambi kokuqala
Nakuba i-Power Query iyithuluzi elisebenziseka kalula, kunezimfuneko ezibalulekile ngaphambi kokuthi uqale ukuyisebenzisa :
- Qiniseka ukuthi unenguqulo ehambisanayo ye-Excel futhi, ye-Windows, une-NET Framework ebuyekeziwe kanye ne-WebView2 efakiwe.
- Qinisekisa ukuthi imithombo yedatha ofuna ukuyisebenzisa isekelwa inguqulo yesistimu yakho yokusebenza Yombuzo Wamandla.
- Buyekeza ulwazi lwakho ngezikhathi ezithile; Izici nokuhambisana kungashintsha unyaka nonyaka.
- Uma uthutha izincwadi ezindala, hlola imibuzo ephelelwe yisikhathi noma izixhumi eseziphelelwe yisikhathi (njenge Facebook noma Ikhathalogi Yedatha).
Umbhali oshisekayo ngomhlaba wamabhayithi nobuchwepheshe ngokujwayelekile. Ngiyathanda ukwabelana ngolwazi lwami ngokubhala, futhi yilokho engizokwenza kule bhulogi, ngikubonise zonke izinto ezithakazelisayo kakhulu ngamagajethi, isofthiwe, ihadiwe, izitayela zobuchwepheshe, nokuningi. Inhloso yami ukukusiza ukuthi uzulazule emhlabeni wedijithali ngendlela elula nejabulisayo.