Kuyini ukukhetha kwakho?
Imvamisa, ukusetshenziswa kwezinhlelo ze-BI ezibizayo neziyinkimbinkimbi kungathathelwa indawo amathuluzi alula futhi angabizi kakhulu, kodwa asebenza kahle impela. Ngemva kokufunda lesi sihloko, uzokwazi ukuhlola izidingo zezibalo zebhizinisi lakho futhi uqonde ukuthi iyiphi inketho elungele ibhizinisi lakho.
Yiqiniso, zonke izinhlelo ze-BI zinezakhiwo eziyinkimbinkimbi kakhulu futhi ukuqaliswa kwazo enkampanini akuwona umsebenzi olula, odinga inani elikhulu lemali yesixazululo kanye nabadidiyeli abaqeqeshwe kakhulu. Kuzodingeka uphinde ubuyele ezinsizeni zabo ngokuphindaphindiwe, ngoba konke ngeke kuphele ngokuqaliswa nokuthunywa - esikhathini esizayo kuzodingeka ulungise ukusebenza, uthuthukise imibiko emisha nezinkomba. Kufanele kucatshangelwe ukuthi uma uhlelo luphumelela, uzofuna abasebenzi abaningi ngokwengeziwe ukuthi basebenze kulo, futhi lokhu kusho ukuthenga amalayisense abasebenzisi angeziwe.
Esinye isici esibalulekile sezinhlelo zezobunhloli bebhizinisi ezithuthukile isethi yemisebenzi eminingi, eminingi yayo ongeke uyisebenzise, ββkodwa uzoqhubeka nokuzikhokhela njalo uma uvuselela amalayisensi akho.
Izici ezingenhla zezinhlelo ze-BI zikwenza ucabange ngokukhetha enye indlela. Okulandelayo, ngiphakamisa ukuqhathanisa isisombululo kusethi ejwayelekile yemisebenzi lapho ulungiselela imibiko usebenzisa i-Power BI ne-Excel.
Power BI noma Excel?
Njengomthetho, ukuze kwakhiwe umbiko wokuthengisa wekota, umhlaziyi ulanda idatha kumasistimu okubalwa kwezimali, ayiqhathanise nezinkhombandlela zakhe futhi ayiqoqe esebenzisa umsebenzi we-VLOOKUP abe ithebula elilodwa, ngesisekelo okwakhiwa ngaso umbiko.
Ixazululwa kanjani le nkinga kusetshenziswa i-Power BI?
Idatha evela emithonjeni ilayishwa ohlelweni futhi ilungiselelwe ukuhlaziywa: ihlukaniswe ngamathebula, ihlanzwe futhi iqhathaniswe. Ngemuva kwalokhu, imodeli yebhizinisi iyakhiwa: amatafula axhunywe komunye nomunye, izinkomba zichazwa, futhi kwakhiwa ama-hierarchies angokwezifiso. Isigaba esilandelayo wukubona ngeso lengqondo. Lapha, ngokuhudula nokulahla kalula izilawuli namawijethi, ideshibhodi esebenzisanayo iyakhiwa. Zonke izici zixhunywe ngemodeli yedatha. Lapho uhlaziya, lokhu kukuvumela ukuthi ugxile olwazini oludingekayo, uluhlunge kukho konke ukubuka ngokuchofoza okukodwa kunoma iyiphi ingxenye yedeshibhodi.
Yiziphi izinzuzo zokusebenzisa i-Power BI uma kuqhathaniswa nendlela evamile engabonakala esibonelweni esingenhla?
1 - Ukuzenzakalela kwenqubo yokuthola idatha nokuyilungiselela ukuze ihlaziywe.
2 - Ukwakha imodeli yebhizinisi.
3 - Ukubona ngeso okungakholeki.
4 β Ukufinyelela okuhlukene emibikweni.
Manje ake sibheke iphuzu ngalinye ngokwehlukana.
I-1 - Ukuze ulungiselele idatha yokwakha umbiko, udinga ukuchaza inqubo uma ixhuma kudatha futhi iyicubungule, futhi ngaso sonke isikhathi lapho udinga ukuthola umbiko wesikhathi esihlukile, i-Power BI izodlulisa idatha ngenqubo edaliwe. . Lokhu kwenza ngokuzenzakalelayo iningi lomsebenzi ohilelekile ekulungiseleleni idatha ukuze ihlaziywe. Kodwa iqiniso liwukuthi i-Power BI yenza inqubo yokulungisa idatha isebenzisa ithuluzi elitholakala kunguqulo yakudala ye-Excel, futhi ibizwa ngokuthi. . Ikuvumela ukuthi uqedele umsebenzi ku-Excel ngendlela efanayo.
I-2 - Isimo siyafana lapha. Ithuluzi le-Power BI lokwakha imodeli yebhizinisi liyatholakala ku-Excel - lokhu .
3 - Njengoba mhlawumbe usuqagele, ngokubona ngeso lengqondo isimo siyefana: Isandiso se-Excel - ubhekana nalo msebenzi nge-bang.
4 - Kusele ukuthola ukufinyelela kumibiko. Izinto azihambi kahle lapha. Iqiniso liwukuthi i-Power BI iyisevisi yamafu efinyelelwa nge-akhawunti yomuntu siqu. Umlawuli wesevisi usabalalisa abasebenzisi ngamaqembu futhi usethe amazinga ahlukene okufinyelela kumibiko yalawa maqembu. Lokhu kufeza ukuhlukaniswa kwamalungelo okufinyelela phakathi kwabasebenzi benkampani. Ngakho-ke, abahlaziyi, abaphathi nabaqondisi, lapho befinyelela ekhasini elifanayo, babona umbiko ngombono ofinyeleleka kubo. Ukufinyelela kungase kukhawulelwe kusethi ethile yedatha, noma kuwo wonke umbiko. Kodwa-ke, uma umbiko usefayilini le-Excel, khona-ke ngemizamo yomphathi wesistimu ungazama ukuxazulula inkinga ngokufinyelela, kodwa lokhu ngeke kufane. Ngizobuyela kulo msebenzi uma ngichaza izici zengosi yebhizinisi.
Kuyaqapheleka ukuthi, njengomthetho, isidingo senkampani samadeshibhodi ayinkimbinkimbi futhi amahle asikhulu futhi kaningi, ukuhlaziya idatha ku-Excel, ngemuva kokwakha imodeli yebhizinisi, abasebenzisi amandla e-Power View, kodwa sebenzisa i-pivot. amatafula. Bahlinzeka ngokusebenza kwe-OLAP okwanele ukuxazulula izinkinga eziningi zezibalo zebhizinisi.
Ngakho-ke, inketho yokwenza ukuhlaziya kwebhizinisi ku-Excel ingase yanelise izidingo zenkampani emaphakathi enenani elincane labasebenzi abadinga imibiko. Kodwa-ke, uma izidingo zenkampani yakho zifisa kakhulu, ungajahi ukuphendukela kumathuluzi azoxazulula yonke into ngesikhathi esisodwa.
Ngiletha ekunakekeleni kwakho indlela esebenza kahle kakhulu, ozothola ngayo eyakho, ephethwe ngokugcwele, uhlelo oluzenzakalelayo lokukhiqiza imibiko yokuhlaziya yebhizinisi ngokufinyelela okulinganiselwe kuyo.
I-ETL ne-DWH
Ezindleleni okuxoxwe ngazo ngaphambilini zokwakha imibiko yebhizinisi, ukulayisha nokulungiselela imininingwane ukuze ihlaziywe kwenziwa kusetshenziswa ubuchwepheshe be-Power Query. Le ndlela ihlala ifaneleka ngokuphelele futhi isebenza kahle inqobo nje uma ingekho imithombo eminingi yedatha: uhlelo olulodwa lokubala kanye nezincwadi zereferensi ezivela kumathebula e-Excel. Kodwa-ke, ngokwanda kwenani lezinhlelo zokubala, ukuxazulula le nkinga usebenzisa Umbuzo Wamandla kuba nzima kakhulu futhi kube nzima ukuwanakekela nokuwathuthukisa. Ezimweni ezinjalo, amathuluzi e-ETL ayasiza.
Ngosizo lwabo, idatha ikhishwa emithonjeni (I-Extract), iguqulwe (Guqula), okusho ukuhlanzwa nokuqhathanisa, futhi ilayishwe endaweni yokugcina idatha (Layisha). Inqolobane yedatha (DWH - Data Warehouse) ngokuvamile iyisizindalwazi esihlobene esitholakala kuseva. Le database iqukethe idatha elungele ukuhlaziywa. Inqubo ye-ETL yethulwa ngokohlelo, olubuyekeza idatha ye-warehouse ibe yakamuva. Ngendlela, leli khishi lonke linikezwa ngokuphelele yi-Integration Services, eyingxenye ye-MS SQL Server.
Ngaphezu kwalokho, njengangaphambili, ungasebenzisa i-Excel, i-Power BI, noma amanye amathuluzi okuhlaziya afana ne-Tableau noma i-Qlik Sense ukuze wakhe imodeli yebhizinisi yedatha nokubonwa ngamehlo. Kodwa okokuqala, ngithanda ukukudonsela ukunaka kwelinye elinye ithuba ongase ungazi ngalo, naphezu kweqiniso lokuthi kade litholakala kuwena. Sikhuluma ngokwakha amamodeli ebhizinisi sisebenzisa izinsiza zokuhlaziya ze-MS SQL Server, okuyi-Analysis Services.
Amamodeli wedatha kumasevisi wokuhlaziya we-MS
Lesi sigaba sendatshana sizothakazelisa kakhulu kulabo asebevele besebenzisa i-MS SQL Server enkampanini yabo.
Izinsizakalo Zokuhlaziya okwamanje zihlinzeka ngezinhlobo ezimbili zamamodeli wedatha: amamodeli e-multidimensional kanye ne-tabular. Ngaphezu kweqiniso lokuthi idatha kulawa mamodeli ixhunyiwe, amanani ezinkomba zemodeli ahlanganiswe kusengaphambili futhi agcinwe kumaseli ekhiyubhu e-OLAP, afinyelelwa yimibuzo ye-MDX noma ye-DAX. Ngenxa yalesi sakhiwo sokulondoloza idatha, umbuzo ohlanganisa izigidi zamarekhodi ubuyiselwa ngemizuzwana. Le ndlela yokufinyelela idatha iyadingeka ezinkampanini amathebula azo okuthengiselana aqukethe amarekhodi angaphezu kwesigidi (umkhawulo ongaphezulu awukhawulelwe).
I-Excel, Power BI namanye amathuluzi amaningi βahloniphekileβ angaxhuma kumamodeli anjalo futhi abone ngeso lengqondo idatha evela ezakhiweni zawo.
Uma uthathe indlela βethuthukisiweβ: wenze inqubo ye-ETL ngokuzenzakalelayo futhi wakha amamodeli ebhizinisi usebenzisa izinsiza ze-MS SQL Server, kufanele ube nengosi yakho yebhizinisi.
Ingosi yebhizinisi
Ngayo, abalawuli bazoqapha futhi baphathe inqubo yokubika. Ukuba khona kwengosi kuzokwenza kube nokwenzeka ukuhlanganisa izinkomba zenkampani: imininingwane emayelana namakhasimende, imikhiqizo, abaphathi, abahlinzeki bempahla izotholakala ukuze iqhathaniswe, ihlelwe futhi ilandwe endaweni eyodwa kuwo wonke umuntu oyisebenzisayo. Kuphothali, ungasebenzisa imisebenzi ehlukahlukene yokushintsha idatha kumasistimu wokubala, isibonelo, ukuphatha ukuphindaphinda kwedatha. Futhi okubaluleke kakhulu, ngosizo lwe-portal, inkinga yokuhlela ukufinyelela okuhlukene kwemibiko ixazululwa ngempumelelo - abasebenzi bazobona kuphela leyo mibiko elungiselelwe iminyango yabo ngendlela ehloselwe bona.
Kodwa-ke, akukacaci ukuthi ukuboniswa kwemibiko ekhasini lephothali kuzohlelwa kanjani. Ukuze uphendule lo mbuzo, okokuqala udinga ukunquma ngobuchwepheshe lapho kuzokwakhiwa khona i-portal. Ngiphakamisa ukusebenzisa olunye lwezinhlaka njengesisekelo: ASP.NET MVC/Web Forms/Core, noma Microsoft SharePoint. Uma inkampani yakho inonjiniyela okungenani oyedwa we-.NET, ukukhetha ngeke kube nzima. Manje usungakhetha iklayenti le-OLAP elingaphakathi nohlelo elingaxhumeka Kumasevisi Okuhlaziya amamodeli amaningi noma amathebula.
Ukukhetha iklayenti le-OLAP ukuze libonwe ngeso lengqondo
Ake siqhathanise amathuluzi amaningana ngokusekelwe ezingeni lobunkimbinkimbi bokushumeka, ukusebenza kanye nentengo: I-Power BI, i-Telerik UI yezingxenye ze-ASP.NET MVC kanye nezingxenye ze-RadarCube ASP.NET MVC.
I-Power BI
Ukuze uhlele ukufinyelela kwabasebenzi benkampani emibikweni ye-Power BI ekhasini lakho lephothali, udinga ukusebenzisa umsebenzi .
Ake ngikutshele ngokushesha ukuthi uzodinga ilayisense ye-Power BI Premium kanye nomthamo owengeziwe ozinikele. Ukuba nomthamo ozinikele kukuvumela ukuthi ushicilele amadeshibhodi nemibiko kubasebenzisi enhlanganweni yakho ngaphandle kokubathengela amalayisensi.
Okokuqala, umbiko okhiqizwe ku-Power BI Desktop ushicilelwa kuphothali ye-Power BI bese, ngosizo lokucushwa okuthile okulula, ushumekwe ekhasini lesicelo sewebhu.
Umhlaziyi angaphatha kalula inqubo yokwenza umbiko olula futhi awushicilele, kodwa izinkinga ezinkulu zingavela ngokushumeka. Kunzima kakhulu futhi ukuqonda indlela yokusebenza yaleli thuluzi: inombolo enkulu yezilungiselelo zesevisi yamafu, okubhaliselwe okuningi, amalayisense, namandla kukhulisa kakhulu imfuneko yezinga lokuqeqeshwa lochwepheshe. Ngakho-ke kungcono ukuphathisa lo msebenzi kuchwepheshe we-IT.
Telerik futhi RadarCube izingxenye
Ukuhlanganisa izingxenye ze-Telerik ne-RadarCube, kwanele ukuba nezinga eliyisisekelo lobuchwepheshe besofthiwe. Ngakho-ke, amakhono ochwepheshe omhleli oyedwa ovela emnyangweni we-IT azokwanela. Odinga ukukwenza nje ukubeka ingxenye ekhasini lewebhu futhi ulenze ngokwezifiso ukuze lihambisane nezidingo zakho.
Isakhi kusuka ku-Telerik UI ye-ASP.NET MVC suite ishumekwe ekhasini ngendlela ye-Razor enomusa futhi inikeza imisebenzi edingeka kakhulu ye-OLAP. Kodwa-ke, uma udinga izilungiselelo zesixhumi esibonakalayo eziguquguqukayo kanye nokusebenza okuthuthukile, khona-ke kungcono ukusebenzisa izingxenye . Inombolo enkulu yezilungiselelo, ukusebenza okucebile okunekhono lokuyichaza kabusha nokuyinweba, izokuvumela ukuthi udale umbiko we-OLAP wanoma ibuphi ubunkimbinkimbi.
Ngezansi kunethebula eliqhathanisa izici zamathuluzi acatshangelwa esikalini esiphansi-Phakathi-Esiphezulu.
I-Power BI
I-Telerik UI ye-ASP.NET MVC
I-RadarCube ASP.NET MVC
Ukubonakala
Phezulu
Okuphansi
Middle
Isethi yemisebenzi ye-OLAP
Phezulu
Okuphansi
Phezulu
Ukuguquguquka kokwenza ngokwezifiso
Phezulu
Phezulu
Phezulu
Amathuba wokweqa imisebenzi
-
-
+
Ukwenza ngokwezifiso isoftware
-
-
+
Izinga lobunkimbinkimbi bokushumeka nokumisa
Phezulu
Okuphansi
Middle
Izindleko eziphansi
Amandla BI Premium EM3
190 rub./ngenyanga
Ilayisensi yonjiniyela oyedwa
I90 000 ΡΡΠ±.
Ilayisensi yonjiniyela oyedwa
I25 000 ΡΡΠ±.
Manje ungadlulela ekuchazeni imibandela yokukhetha ithuluzi lokuhlaziya.
Imibandela yokukhetha ye-Power BI
- Unentshisekelo kumibiko enothe ngamamethrikhi ahlukahlukene nezinto ezihlobene nedatha.
- Ufuna abasebenzi abasebenza ngemibiko bakwazi ukuthola kalula futhi ngokushesha izimpendulo zezinkinga zabo zebhizinisi ngendlela enembile.
- Inkampani inochwepheshe be-IT abanamakhono okuthuthukisa i-BI.
- Isabelomali senkampani sihlanganisa inani elikhulu lenkokhelo yanyanga zonke yesevisi yokuhlaziya ibhizinisi lamafu.
Imibandela yokukhetha izingxenye ze-Telerik
- Sidinga iklayenti elilula le-OLAP lokuhlaziya i-Ad hock.
- Inkampani inonjiniyela wezinga lokungena we-NET kubasebenzi.
- Isabelomali esincane sokuthenga ilayisensi yesikhathi esisodwa kanye nokuvuselelwa kwaso okwengeziwe ngesaphulelo esingaphansi kuka-20%.
Imibandela yokukhetha izingxenye ze-RadarCube
- Udinga iklayenti le-OLAP elinemisebenzi eminingi elinekhono lokwenza ngokwezifiso isixhumi esibonakalayo, kanye nalelo elisekela ukushumeka imisebenzi yakho.
- Inkampani inonjiniyela wezinga eliphakathi le-NET kubasebenzi. Uma lokhu kungenjalo, khona-ke abathuthukisi bengxenye bazohlinzeka ngomusa izinsizakalo zabo, kodwa ngenkokhelo eyengeziwe engeqi izinga lomholo lomklami wesikhathi esigcwele.
- Isabelomali esincane sokuthenga ilayisensi yesikhathi esisodwa kanye nokuvuselelwa kwaso okwengeziwe ngesaphulelo esingu-60%.
isiphetho
Ukukhetha ithuluzi elifanele lezibalo zebhizinisi kuzokuvumela ukuthi uyeke ngokuphelele ukubika ku-Excel. Inkampani yakho izokwazi ukuthuthela kancane kancane futhi ngokungenabuhlungu ekusetshenzisweni kobuchwepheshe obuphambili emkhakheni we-BI futhi iguqule umsebenzi wabahlaziyi kuyo yonke iminyango.
Source: www.habr.com