- Ukusebenzisana phakathi kokuphathwa kwethebula le-Excel kanye namandla okubona asebenzisanayo e-Power BI.
- Izindlela zokuxhuma ezizenzakalelayo zisebenzisa i-OneDrive, i-SharePoint, kanye nokulayisha ngqo amamodeli anencazelo.
- Amakhono okumodela e-DAX athuthukisiwe kanye nokuhlanza idatha kusetshenziswa i-Power Query.
- Ukushicilela nokusabalalisa imibiko eguquguqukayo nge-Power BI Service kanye nama-Microsoft Teams.
Uma usebenza ngedatha nsuku zonke, uyazi ukuthi i-Excel ifana nomuntu osebenza ngakwesokudla ehhovisi; ithembekile, iyaguquguquka, futhi wonke umuntu uyazi ukuthi isetshenziswa kanjani. Kodwa-ke, kufika isikhathi lapho amathebula angenamkhawulo namashadi angaguquki ehluleka, ikakhulukazi lapho udinga ulwazi ukuze ushintshe futhi usabele ngesikhathi sangempela phambi kwamehlo omphathi wakho noma ithimba lakho.
Yilapho i-Power BI ingena khona. Akuhloselwe ukuthatha indawo ye-Excel, kodwa kunalokho ukuyinika amandla amakhulu. Ngokuhlanganisa womabili amathuluzi, ungasuka kuspredishithi esilula uye ohlelweni oluphelele lwezobunhloli bebhizinisi , lapho idatha icutshungulwa khona ku-Excel kodwa iboniswe efwini ngamadeshibhodi asebenzisanayo noma ubani angawafinyelela kusuka kudivayisi yakhe yeselula noma kusiphequluli sewebhu.
Kungani kuhlanganiswa i-Power BI ne-Excel?
Nakuba i-Excel ibusa kakhulu ekuhleleni idatha ngefomethi yethebula nokwenza ukuhlaziywa okusheshayo, i-Power BI yenzelwe ngqo i-Business Intelligence. Inzuzo enkulu ukuthi ungasebenzisa isakhiwo esihlelekile se-Excel bese usihlanganisa namakhono okubuka athuthukisiwe e-Power BI , okwenza ukwenza izinqumo kube okubonakalayo nokushesha kakhulu.
Ngokuxhumanisa la mazwe amabili, ungakhohlwa ukuthumela amafayela njalo ngemizuzu emihlanu. Izibuyekezo ezizenzakalelayo zisho ukuthi uma ushintsha ingxenye yedatha kuthebula lakho le-Excel, ishadi elisefwini lizobuyekezwa cishe ngokuzenzakalelayo. Ngaphezu kwalokho, i-Power BI ingaphatha inani elikhulu ledatha elingabangela i-Excel ukuthi iphahlazeke, okukuvumela ukuthi uhlanganise imithombo yangaphandle njengedathabheyisi ye-SQL noma i-Google Analytics kalula.
Izindlela zokuxhuma idatha yakho ye-Excel efwini
Ukuze umlingo usebenze, sidinga kuqala ukunquma ukuthi idatha ihamba kanjani. Uma amafayela akho aku- OneDrive noma ku-SharePoint , inqubo ilula. Kusuka ku-Power BI Desktop, mane nje uye ku-"Thola idatha," khetha indlela yefu, bese ulungiselela izibuyekezo ezizenzakalelayo. Lokhu kuqinisekisa ukuhamba komsebenzi okubushelelezi ngaphandle kwamaphutha enziwe ngesandla.
Uma ukhetha ukungasebenzisi isofthiwe yedeskithophu, ungasebenzisa i -Power BI Service ngqo kusiphequluli sakho. Lapha ungangenisa amafayela kusuka kukhompyutha yakho yasendaweni noma kusuka efwini. Unezinketho ezimbili eziyinhloko: layisha incwadi yokusebenza (ukuze uyibuke njenge-Excel Online kodwa unekhono lokunamathisela izinto kumadeshibhodi) noma uthumele imodeli , edala isethi yedatha eyisihluthulelo ongakha kuyo imibiko kusukela ekuqaleni.
Nakuba kungenzeka ukushicilela amafayela endawo, ukuthuthela efwini kuyisisombululo esifanele. Ukushicilela ifayela lendawo kuhilela ukungenisa idatha ngokwehlukana, okudinga ukuthi uphinde ushicilele inguqulo ebuyekeziwe isikhathi ngasinye lapho wenza izinguquko, ngaphandle kokuthi ulungiselela izibuyekezo ezihleliwe ngesango.
Ukuguqula idatha eluhlaza ibe yizithombe ezibonakalayo ezinomthelela
Uma uxhumano seluqalile, ingxenye ejabulisayo iyaqala: umklamo. Ngaphambi kokudala ishadi, kunconywa kakhulu ukusebenzisa i-Power Query . Leli thuluzi likuvumela ukuthi uhlanze amatafula akho, ususe ama-duplicate, futhi ushintshe amafomethi ngaphandle kokushintsha ifayela lokuqala le-Excel, ukuqinisekisa ukuthi isisekelo sombiko wakho sihlanzekile futhi siyavumelana.
Ukuze udale amashadi, mane uhudule amasimu kusuka kuphaneli yedatha uye ku-canvas. Uma ufuna ukuhlaziya inzuzo ngezwe, vele ulahle amasimu "ezwe" kanye "nenzuzo" kumephu, bese i-Power BI izodweba ngokuzenzakalelayo amabhamuza alingana nenani . Ukuze uthole ukuthinta kobungcweti, ungangeza iziqeshana zedatha, ezivumela abasebenzisi ukuhlunga ulwazi ngosuku noma isigaba ngokuchofoza okukodwa.
Uma udinga izibalo ezingakwazi ukusingatha amafomula e-Excel ajwayelekile, yilapho i-DAX (Izincazelo Zokuhlaziywa Kwedatha) ingena khona . Nge-DAX, ungakha amamethrikhi ayinkimbinkimbi, njengokushintsha kwamaphesenti nyanga zonke noma ukubikezela, uguqule ideshibhodi yakho ibe ithuluzi lokuhlaziya ezezimali elithuthukisiwe , hhayi nje ukubonakaliswa kwamaspredishithi akho.
Ukuthuthukiswa komsebenzi kanye nokubambisana kwebhizinisi
Amandla angempela alolu hlelo ayabonakala uma wabelana ngemiphumela. Akusekho sidingo sokuthumela okunamathiselwe okukhulu kwe-imeyili. Ungashicilela umbiko wakho ngesevisi ye-Power BI bese wabelana ngesixhumanisi esiqondile , noma okungcono nakakhulu, ushumeke ideshibhodi ngqo esiteshini se -Microsoft Teams . Ngale ndlela, lonke ithimba lingaxhumana nedatha ngesikhathi sangempela.
Kulabo abadinga ukuhlaziywa okujulile, i-Power BI ivumela ukuthekelisa okuphambene . Ungakhetha ukubona okuthile bese ukhiphela idatha efingqiwe emuva ku-Excel ngefomethi ye-.xlsx noma ye-.csv. Lokhu kulungele uma udinga ukwenza ukuhlolwa okuningiliziwe noma ukubala okuthile kusethi encane yedatha i-Power BI eseyikuhlungile kakade.
Ukuze ugweme ukuhlola ideshibhodi njalo ngehora, ungasetha izexwayiso ezihlakaniphile . Uma i-metric ebalulekile, njengezindleko zanyanga zonke, idlula umkhawulo obekwe kuspredishithi yakho yesabelomali, i-Power BI izokuthumelela isaziso esizenzakalelayo. Lokhu kuvumela ukuphathwa kwebhizinisi okusebenzayo , okukuvumela ukuthi usabele ngokushesha kunoma yikuphi ukungahambi kahle.
Izicelo ezisebenzayo ekusebenzeni kwansuku zonke kwenkampani
Ekuthengiseni, lo msebenzi uvame ukusetshenziswa ukuqapha ukusebenza komkhiqizo ngokwesifunda. Ideshibhodi esebenzisana nayo ivumela umphathi ukuthi abone ngemizuzwana ukuthi yisiphi isitolo esiya sehlisa ijubane futhi alungise isu lempahla ngaphandle kokulinda ukuvalwa kwenyanga.
Kwezokuthutha, ukuxhumana phakathi kwe-Excel ne-Power BI kubaluleke kakhulu ekulawuleni isitokwe. Ngokuzenzakalela ukufundwa kwamafayela abaphakeli, izinkampani zingalindela ukugcwaliswa kabusha komkhiqizo futhi zigweme ukuphela kwesitoko, zibone ngeso lengqondo izitayela zesidingo ngemifanekiso nangokulula.
Umnyango wezezimali uphinde uzuze ngokudala ukuqhathanisa phakathi kwesabelomali esihleliwe ku-Excel kanye nokusetshenziswa kwangempela kwemali. Besebenzisa amashadi ebha ahlanganisiwe kanye nama-KPI agqanyisiwe, bangabona ukuphambuka kwesabelomali futhi bathathe isinyathelo sokulungisa ngaphambi kokuba inkinga ikhule.
Ukuhlanganiswa okuphelele kwala mathuluzi kukuvumela ukuthi uguqule isiphithiphithi samaspredishithi sibe umthombo owodwa weqiniso , lapho ukuhlanzeka kwe-Power Query, ukumodelwa kwe-DAX, kanye nokusebenzisana kwefu kuhlangana khona ukuze kwenziwe ukuphathwa kwedatha kube ngochwepheshe futhi kuqondiswe ukwenza izinqumo ezihlakaniphile kunoma iyiphi inhlangano.
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.