- Ukuhlanganiswa okuhlangene phakathi kokuphathwa kwethebula le-Excel kanye namandla okubona e-Power BI ukuze kuthuthukiswe ukuhamba komsebenzi.
- Izindlela zokuxhuma ezisebenziseka ngezindlela eziningi zisebenzisa i-OneDrive, i-SharePoint, kanye nokulayisha kwasendaweni ukuqinisekisa ukutholakala kwedatha.
- Amakhono okumodela athuthukisiwe asebenzisa i-DAX kanye nokuhlanza idatha nge-Power Query ukuguqula ulwazi olungavuthiwe lube ukuqonda.
- Ukuvumelanisa okuzenzakalelayo kanye nokushicilelwa kwamafu ukuze kube lula ukubambisana kwebhizinisi ngesikhathi sangempela.
Ngiyaqiniseka ukuthi kuye kwenzeka kuwe: unespredishithi se-Excel esiyigugu ngokwedatha, kodwa uma kukhulunywa ngokwethula imiphumela kumphathi wakho noma eqenjini lakho, amashadi ayasilela futhi akukho ukuxhumana. Yilapho-ke inhlanganisela yamasu e-Excel ne-Power BI, i-duo enamandla evela ku-Microsoft ekuvumela ukuthi usuke ematafuleni alula uye kumaphaneli okulawula amahle kakhulu atholakala noma kuphi emhlabeni.
Esikhundleni sokukhetha ithuluzi elilodwa noma elinye, indlela ehlakaniphile kakhulu ukusebenzisa okuhle kakhulu kwemibili. Nakuba i-Excel isalokhu iyinkosi engaphikiswana ngayo ukuhlelwa kolwazi lwethebula Ngezibalo ezisheshayo, i-Power BI ithatha ukuhlaziywa kobuhlakani bebhizinisi iye kwelinye izinga, okusivumela ukuthi sixhumanise imithombo eminingi futhi sikhiqize imiboniso elandisa indaba ecacile ngesimo sebhizinisi lethu.
Ukusebenzisana phakathi kwe-Power BI ne-Excel: Kuhlanganisani?
Kalula nje, i-Power BI empeleni iyipulatifomu yokuhlaziya eyenzelwe guqula idatha eyinkimbinkimbi ibe amadeshibhodi asebenzisanayoIkhono layo lokuxhumanisa imithombo ehlukahlukene yolwazi livumela izinkampani ukuthi zinganciki kufayela elilodwa, kodwa kudatha ehambisanayo evela efwini, kudathabheyisi ye-SQL, noma kuzinhlelo zokusebenza zangaphandle ukuze zithole umbono womhlaba wonke.
I-Excel, yona, iyithuluzi elisetshenziswa kakhulu ekuphathweni kwedatha ehlelekile. Ngokuhlanganisa kokubili, sithuthukisa isitoreji esihleliwe samaspredishithi... Ukumodela kwe-Advanced Power BI, ukwenza ngcono izinqubo zomsebenzi kanye nokususa imisebenzi ephindaphindayo yokukopisha nokunamathisela idatha.
Izinzuzo zangempela zokuxhumanisa amathuluzi womabili
Akukhona nje kuphela ukwenza ibukeke inhle kakhulu; ukuhlanganisa la mathuluzi kuletha izinzuzo ezibonakalayo zokusebenza. Elinye lamandla yi- ukufinyelela emithonjeni yedatha ecebilengoba i-Power BI ingamunca ulwazi oluvela kumasevisi efu bese ihlangana kalula nesakhiwo osuvele usiphethe ku-Excel.
Ngaphezu kwalokho, i ukuzenzekela kwesibuyekezo Kusindisa impilo yangempela. Khohlwa ukuthumela amafayela ngesandla njalo ngoMsombuluko; uma uxhumano selusethiwe, idatha ivuselelwa ngokuzenzakalelayo, okukuvumela ukuthi usebenze njalo ngenguqulo yakamuva yolwazi. Lokhu kuhunyushwa kube ukwehla okukhulu komkhawulo wephutha abantu ngokwenza kube lula ukulungiselela imibiko.
Ngokuphathelene nokufinyeleleka, ukushicilela imibiko efwini kuvumela noma yiliphi ilungu leqembu, noma ngabe likuphi, ukuthi liyifinyelele. Hlola ama-KPI kusuka kuselula yakho noma ithebhulethi, okukhuthaza isiko lokwenza izinqumo ngokusekelwe kudatha yangempela hhayi ekuqondeni.
Indlela yokuxhuma amafayela akho e-Excel efwini le-Power BI
Kunezindlela eziningana zokufaka idatha yakho ku-Power BI, kuye ngokuthi ifayela lakho ligcinwe kuphi. Uma usebenzisa I-OneDrive yokusetshenziswa komuntu siqu noma kwebhizinisiInqubo ibushelelezi kakhulu: mane nje uye ku-"Thola idatha" ku-Power BI Desktop, khetha i-Excel, bese uzulazula uye kwisitoreji sakho samafu. Okungcono nakakhulu, ungavumela izibuyekezo ezizenzakalelayo ukuqinisekisa ukuhamba komsebenzi okuqhubekayo.
Uma inkampani yakho isebenzisa I-SharePointLe ndlela ishintsha kancane. Kulesi simo, kusetshenziswa i-URL yomtapo wolwazi wedokhumenti. I-Power BI izohlaziya ifolda, futhi ungahlunga ifayela elithile olidingayo. Le ndlela ilungele amaqembu abelana ngamafolda omsebenzi ofanayo futhi adinga umthombo wedatha ophakathi.
Kulabo abakhetha ukungasebenzisi inguqulo yedeskithophu, Isevisi ye-Power BI (kuwebhu) Iphinde ikuvumele ukuthi ungenise amafayela ngqo kusuka ku-OneDrive noma ku-SharePoint Online, okudala ukugeleza kwedatha okusheshayo ngaphandle kwesidingo sokufaka isofthiwe eyengeziwe kukhompyutha yakho.
Kusukela kuthebula kuya kugrafu: Ukudala imibiko exhumanayo
Uma idatha isiku-Power BI, umlingo uyaqala. Isinyathelo sokuqala ukungenisa, lapho ukhetha khona amathebula noma amathebhu e-Excel aneza ngempela inani. Icebiso lochwepheshe ukubheka Umhleli wombuzo ukuhlanza idatha, ukususa amakholomu angadingekile, noma ukushintsha amafomethi, ukuqinisekisa ukuthi imodeli ilungiselelwe ngaphambi kokuqala ukudweba.
Ukwakha ideshibhodi kulula kakhulu: mane uhudule amasimu kusuka kuphaneli yedatha uye ku-canvas. Ungakhetha phakathi amashadi ebha, amamephu okushisa noma ukusabalalisaUkwenza ngokwezifiso imibala namalebula ukuze umyalezo ucace ngokushesha. Ungakhohlwa ukwengeza abahlukanisi bedatha (abasiki)okuyizona ezivumela umsebenzisi ukuhlunga ulwazi ngosuku, isifunda noma umkhiqizo ngokuchofoza okukodwa.
Ukuze kuqedwe isigaba sokuklama, kuyalulekwa ukuhlela ulwazi emakhasini amaningi uma umbiko umude kakhulu bese wengeza izinto ezibonakalayo njengezithombe noma umbhalo ochazayo. Uma konke sekuhleliwe, mane uchofoze Shicilela ukuze ulayishe umsebenzi ku-Power BI Service bese wabelana ngawo nenhlangano yakho.
Ukuqhathanisa amakhono: i-Excel vs i-Power BI
Kubalulekile ukuqonda ukuthi abancintisani, kodwa bayasizana. I-Excel ayihlulwa uma sibhekana nayo amavolumu edatha alinganiselayo (kufika kumigqa eyisigidi) futhi sidinga ukwenza izibalo ezithile noma ukuhlaziya okusheshayo. amathebula e-pivot ku-excel Zinhle kakhulu, yize ukuxhumana kwazo kulinganiselwe futhi imibiko ivame ukungaguquguquki.
Ngakolunye uhlangothi, i-Power BI yenzelwe i-Big Data. Ayinawo umkhawulo ofanayo wemigqa, futhi ukwakheka kwayo kwamafu kuvumela... phatha ulwazi oluningi ngaphandle kokuqandisa ikhompyutha. Ngenkathi ku-Excel isibuyekezo sivame ukuba senziwe ngesandla, ku-Power BI sinjalo kuhlelwe futhi kuzenzakalelayo.
Esigabeni sokuhlaziya okuthuthukisiwe, i-Power BI yethula ulimi I-DAX (Izinkulumo Zokuhlaziywa Kwedatha)Nakuba i-Excel isebenzisa amafomula avamile, i-DAX ikuvumela ukuthi udale izilinganiso eziyinkimbinkimbi kakhulu kanye nokuhlaziywa kwethrendi yesikhathi okungaba yikhanda elibuhlungu ngempela ukulisebenzisa usebenzisa amaseli namakholomu kuphela.
Izici ezithuthukisiwe kanye nezindaba zempumelelo yebhizinisi
Ukuhlanganiswa kweqiniso kubonakala ekusebenzeni kwenkampani kwansuku zonke. Isibonelo, ku- umnyango wokuthengisaUngahlanganisa idatha kusuka kusizindalwazi se-SQL kanye ne-Google Analytics ibe yishidi le-Excel, bese usebenzisa i-Power BI ukubona ngeso lengqondo imbuyiselo yokutshalwa kwezimali kwemikhankaso kudeshibhodi eyodwa esebenzisanayo.
Kwezokuthutha, kuvamile kakhulu ukusebenzisa Umbuzo Wamandla ukuhlanganisa amafomethi avela kubahlinzeki abahlukene ngaphambi kokulayisha idatha ku-Power BI. Lokhu kuvumela ukulawulwa okunembile kwesitoko futhi kwenza... lindela ukushoda kwesitoko ukuhlaziya izitayela zesidingo ngokubona.
Umnyango wezezimali nawo uyazuza kulokhu kuhlanganiswa. Bangaklama izabelomali ku-Excel bese bezixhumanisa nedeshibhodi ye-Power BI ukuze qhathanisa ukusetshenziswa kwemali kwangempela nokusetshenziswa kwemali okuhleliweUma izexwayiso zisethiwe, uhlelo lungazisa ngokuzenzakalelayo ithimba lezezimali lapho izindleko zidlula umkhawulo omisiwe, kuvinjelwe izimanga ekupheleni kwenyanga.
Ukushicilela okuqondile kanye nokuthunyelwa kwedatha
Kusukela kunguqulo ka-2016 kuqhubeke, i-Excel ivumela Shicilela izincwadi ngqo ku-Power BI ngaphandle kokusebenzisa uhlelo lokusebenza lwedeskithophu ngokudingekile. Unezinketho ezimbili eziyinhloko uma uchofoza okuthi "Shicilela": Layisha noma ThumelaUma ukhetha ukulayisha, ifayela liziphatha ngendlela eliziphatha ngayo ku-Excel Online; uma ukhetha ukuthumela ngaphandle, idatha iguqulwa ibe yimodeli ye-semantic ye-Power BI, okukuvumela ukuthi udale imibiko enamandla kakhulu.
Kungenzeka futhi ukwenza okuphambene nalokho: Thumela idatha kusuka ku-Power BI kuya ku-ExcelLokhu kuwusizo kakhulu uma udinga ukwenza ukuhlaziywa okuningiliziwe kwethebula elithile noma wabelane ngedatha ekhishwe nomuntu ongenalo ilayisensi ye-Power BI. Mane nje uye kumachashazi amathathu ku-visualization bese ukhetha ukuthumela kufomethi ye-.xlsx noma i-.csv.
Ukuze konke lokhu kusebenze njengewashi, isihluthulelo ukuvumelanisa isikhathi sangempelaNgokusebenzisa i-Excel Online kanye ne-Power BI Service, izinguquko ezenziwa umhlaziyi kuspredishithi zibonakala cishe ngokushesha kudeshibhodi, okususa isidingo sokuthumela amafayela nge-imeyili njalo uma kukhona ukuguqulwa.
Ukwazi kahle la mathuluzi kuvumela noma yimuphi uchwepheshe ukuthi asuke ekubeni umphathi wedatha olula aye ekubeni uchwepheshe wezobunhloli bebhizinisi, okwenza ulwazi lugeleze kalula lusuka kuseli ye-Excel luye esikrinini sabaphathi, okuqinisekisa ukuthi zonke izinqumo zamasu ziyaziswa. isekelwe yidatha yamuva futhi kucace bha.
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.