- Ukusebenzisana phakathi kokuguquguquka kwamaspredishithi kanye nekhono lokubona elithuthukisiwe le-Business Intelligence.
- Izindlela zokuxhuma ezizenzakalelayo ngezinsizakalo zamafu ezifana ne-OneDrive ne-SharePoint.
- Ukuguqula idatha engaguquki ibe amadeshibhodi ashukumisayo kusetshenziswa i-DAX kanye ne-Power Query.
- Ukuthuthukisa ukwenziwa kwezinqumo zenkampani ngokushicilelwa kwemibiko exhumanayo nefinyelelekayo.
Uma uke waba nomuzwa wokuthi amaspredishithi akho ayasilela uma kukhulunywa ngokuveza imiphumela, kungenzeka ukuthi kungenxa yokuthi uzama ukuphoqa i-Excel ukuthi yenze into eyayingaklanyelwanga yona. Nakuba kuyithuluzi lokugcina lokuhlela idatha, lapho sidinga ulwazi ukuze siphile futhi sixhumane , yilapho i-Power BI ingena khona, ibe ngumlingani ofanele wokuthatha noma yikuphi ukuhlaziya iye ezingeni elilandelayo.
Umlingo uyenzeka uma siyeka ukubona lezi zinhlelo zokusebenza ezimbili njengezinto ezihlukene bese siqala ukuzisebenzisa njengohlelo lobuhlakani bebhizinisi oluhlanganisiwe . Akukhona ngokushintsha esinye ngesinye, kodwa mayelana nokusebenzisa isakhiwo sethebula le-Excel nokusithuthukisa ngamakhono okwenza amamodeli nokubona ngeso lengqondo efu le-Microsoft, ngaleyo ndlela sifeze umsebenzi osheshayo nowobungcweti.
Ukusebenzisana phakathi kwe-Excel ne-Power BI: Zihambisana kanjani?
I-Power BI, ngokuyisisekelo, iyisikhungo esinamandla sokuhlaziya idatha esenzelwe ukuxhumanisa imithombo eyahlukahlukene, ukuguqula ulwazi, nokulwethula ngendlela enolwazi futhi ephelele. amashadi namadeshibhodi ashukumisayoUmgomo wayo ukuvumela noma iyiphi inkampani ukuthi yenze izinqumo ngokusekelwe ebufakazini obubonakalayo hhayi nje ekuqondeni, ekukhipheni
I-Excel isalokhu iyindinganiso yegolide yokuphathwa kwedatha okuhlelekile kanye nokuhlaziywa kokufunwa. Inzuzo yangempela yokuzixhumanisa ukuthi ungalondoloza ukulula kokufakwa kwedatha ngenkathi udlulisela ukubonakala kanye nokucutshungulwa kwenqwaba ku-Power BI. Le nhlanganisela ivumela amaqembu ukuthi akhiqize imibiko esezingeni eliphezulu ngaphandle kokufunda izilimi zokuhlela eziyinkimbinkimbi.
Izinzuzo zangempela zokuxhumanisa amathuluzi womabili
Uma uxhumanisa i-Excel ne-Power BI, uyeka ukubhekana nezinamathiselo ze-imeyili bese udlulela endaweni yokubambisana yesikhathi sangempela . Enye yezinzuzo ezinkulu ukufinyelela emithonjeni yedatha eqinile kakhulu, njengoba i-Power BI ingahlanganisa ispredishithi yakho ye-Excel nezizindalwazi ze-SQL noma izinsizakalo zewebhu, okucebisa ulwazi olutholakalayo.
Ngaphezu kwalokho, ukuzenzekela kwezibuyekezo kuyashintsha umdlalo. Akusekho ukuthumela nokungenisa amafayela njalo ngoMsombuluko; idatha igeleza ngokuzenzakalelayo, okunciphisa kakhulu ingozi yamaphutha abantu. Ngokufanayo, ikhono lokwenza ukuhlaziya okubikezelayo kanye nokulingisa liba namandla kakhulu ngenxa yenjini yokumodela ye-Power BI.
Indlela yokuxhuma amafayela akho e-Excel efwini le-Power BI
Ukuze konke kusebenze kahle, kungcono ukuthi amafayela akho angagcinwa ku-hard drive yekhompyutha yakho, kodwa efwini. Kunezindlela ezintathu eziyinhloko zokwenza lokhu:
- Kusuka ku-OneDrive: Lena indlela eqondile kakhulu. Ku-Power BI Desktop, iya kokuthi "Thola idatha," khetha i-Excel, bese uzulazula uye kufolda yakho ye-OneDrive (kungaba eyomuntu siqu noma eyenkampani). Lokhu kuvumela ukuvumelanisa kwenzeka ngokuzenzakalelayo.
- Kusukela ku-SharePoint: Uma usebenza endaweni yeqembu, kungcono ukusebenzisa i-URL yomtapo wezincwadi we-SharePoint. Usebenzisa isixhumi esithi "SharePoint Folder", i-Power BI ifunda amafayela abanjwe futhi ikuvumela ukuthi... hlunga idokhumenti eqondile udinga ini
- Isevisi ye-Power BI: Uma ungafuni ukufaka uhlelo lwedeskithophu, ungangenisa idatha ngqo kusuka kusiphequluli sakho kuwebhusayithi ye-Power BI Service, ukhethe i-OneDrive noma i-SharePoint Online. dala ukugeleza kwedatha ngokushesha.
Kusukela kuthebula kuya kugrafu: Ukudala imibiko exhumanayo
Uma idatha isixhunyiwe, inqubo yokuklama ilula kakhulu. Isinyathelo sokuqala ukuhlanza idatha nge-Query Editor, lapho ungahlanza futhi ulungise khona inani elikhulu ledatha , ususe amakholomu angadingekile, ushintshe amafomethi edethi, noma ususe amakhophi aphindaphindiwe. Kuphela uma idatha "ihlanzekile" lapho uchofoza khona u- Vala & Faka isicelo ukuze uqale ukuklama.
Ku-canvas ye-Power BI, ungahudula amasimu kusuka kuspredishithi sakho se-Excel uwayise ezinhlotsheni ezahlukene zokuboniswa. Uma ufuna ukuqhathanisa izigaba, ishadi lebha lifanelekile; uma ufuna ukubona izitayela ngokuhamba kwesikhathi, iya ngqo kumashadi omugqa . Ukuze wengeze ukuthinta kokugcina, kubalulekile ukufaka izisiki , okuyizinkinobho ezivumela abasebenzisi ukuhlunga ulwazi ngosuku, isifunda, noma umkhiqizo ngokuchofoza okukodwa.
Ukuhlaziya Okuthuthukisiwe: Amandla e-DAX kanye ne-Power Query
Uma ufuna ukusuka ekubeni umsebenzisi ojwayelekile uye ekubeni uchwepheshe, udinga ukwazi kahle i-Power Query kanye ne-DAX. I-Power Query iyithuluzi lokuguqula idatha elisusa isidingo sokushintsha ifayela lokuqala le-Excel, lisebenza njengesihlungi esihlakaniphile esilungiselela ulwazi ngaphambi kokuba lufike embikweni.
Ngakolunye uhlangothi, i-DAX (Izincazelo Zokuhlaziywa Kwedatha) ulimi lwefomula ye-Power BI. Nakuba i-Excel isebenzisa imisebenzi evamile, i-DAX ikuvumela ukuthi udale izindlela eziyinkimbinkimbi zokubala izitayela , njengokuqhathanisa ngokuzenzakalelayo ukuthengiswa kwale nyanga nesikhathi esifanayo ngonyaka odlule. Lokhu kubalulekile eminyangweni yezezimali edinga ukunemba kwezibalo ekubikezelweni kwayo.
Umehluko obalulekile kanye namacala okusetshenziswa enkampanini
Kubalulekile ukungadideki amathuluzi. I-Excel ayinqobeki ekuhlaziyeni okusheshayo, ukubalwa okukodwa , kanye nokulinganisela amavolumu edatha (khumbula ukuthi inomkhawulo womugqa). Ngakolunye uhlangothi, i-Power BI yenzelwe i -Big Data , ekuvumela ukuthi uphathe izigidi zamarekhodi ngaphandle kokuthi uhlelo luphahlazeke, ngenxa yokwakheka kwayo okuthuthukisiwe.
Emisebenzini yansuku zonke yebhizinisi, lokhu kuhunyushwa kube izinhlelo zokusebenza eziqondile kakhulu. Isibonelo, ithimba lokuthengisa lingasebenzisa i-Excel ukuqopha ukuthengiswa kwansuku zonke kanye ne-Power BI ukudala ideshibhodi ye-KPI lapho i-CEO ingabona khona ngesikhathi sangempela ukuthi yisiphi isitolo esenza kahle kakhulu. Ekuphathweni kwempahla, isetshenziselwa ukuqapha amazinga esitokwe nokulindela ukugcwaliswa kabusha komkhiqizo ngokusekelwe ezindleleni zomlando ezibonwe ngamehlo.
Ukushicilelwa kanye nokuphepha kwamadeshibhodi
Uma umbiko usulungile ku-Power BI Desktop, isinyathelo esilandelayo ukuchofoza inkinobho ethi Shicilela ukuze uwulayishe ku-Power BI Service. Ukusuka lapho, umbiko uguquka kusuka kufayela eliku-PC yakho ube ikhasi lewebhu eliyimfihlo elitholakala kunoma yisiphi isiphequluli noma idivayisi yeselula.
Uma wabelana, asikho isidingo sokuthumela ifayela nge-imeyili (ngaleyo ndlela kugwenywe isiphithiphithi sezinguqulo "zokugcina_v2_copy"). Mema abasebenzisi ngamakheli abo e-imeyili bese uphatha izimvume . Ukuze uthole idatha ebucayi, kunconywa ukusebenzisa ukuphepha kwezinga lomugqa (i-RLS) , okuqinisekisa ukuthi umthengisi esifundeni saseNyakatho angabona idatha evela esifundeni sakhe kuphela hhayi evela esifundeni saseNingizimu.
Ukuhlanganiswa kwala mathuluzi kuvumela noma yimuphi uchwepheshe ukuthi aguqule idatha eyisicefe ibe indaba ebonakalayo ekhangayo . Ngokuhlanganisa ukuguquguquka kwe-Excel namandla okuhlaziya kanye nokufinyeleleka kwe-Power BI efwini, amabhizinisi afinyelela ukuguquguquka kokusebenza okuphezulu, okwenza ulwazi lugeleze kalula futhi izinqumo zisekelwe kudatha esesikhathini neqinisekisiwe.
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.