Luluphi ukhetho lwakho?
Rhoqo, ukusetyenziswa kweenkqubo ze-BI ezibizayo nezintsonkothileyo kunokutshintshwa ngokulula kwaye kungabizi kakhulu, kodwa izixhobo zohlalutyo ezisebenzayo. Emva kokufunda eli nqaku, uya kuba nakho ukuvavanya iimfuno zohlalutyo lweshishini lakho kwaye uqonde ukuba loluphi ukhetho olulungele ishishini lakho.
Ngokuqinisekileyo, zonke iinkqubo ze-BI zinoyilo olunzima kakhulu kwaye ukuphunyezwa kwazo kwinkampani akuyona into elula, efuna imali eninzi yesisombululo kunye nabahlanganisi abaqeqeshwe kakhulu. Kuya kufuneka ubuyele ngokuphindaphindiweyo kwiinkonzo zabo, kuba yonke into ayiyi kuphelisa ngokuphunyezwa kunye nokugunyaziswa - kwixesha elizayo kuya kufuneka ukuba ucokise ukusebenza, ukuphuhlisa iingxelo ezintsha kunye nezalathisi. Kufuneka kuthathelwe ingqalelo ukuba ukuba inkqubo iphumelele, uya kufuna abasebenzi abaninzi ngakumbi ukuba basebenze kuyo, kwaye oku kuthetha ukuthenga iilayisensi ezongezelelweyo zabasebenzisi.
Olunye uphawu oludityanisiweyo lweenkqubo zobukrelekrele beshishini eliphambili yiseti enkulu kakhulu yemisebenzi, uninzi lwayo ongasoze uyisebenzise, ββkodwa iya kuqhubeka ukuyihlawula ngalo lonke ixesha uhlaziya iilayisensi zakho.
Ezi mpawu zingentla zeenkqubo zeBI zikwenza ucinge ngokukhetha enye indlela. Emva koko, ndiphakamisa ukuthelekisa isisombululo kwisethi eqhelekileyo yemisebenzi xa ulungiselela iingxelo usebenzisa i-Power BI kunye ne-Excel.
Amandla BI okanye Excel?
Njengomthetho, ukwakha ingxelo yokuthengisa ngekota, umhlalutyi ukhuphela idatha kwiinkqubo ze-accounting, uthelekisa kunye nezikhombisi zakhe kwaye uqokelele usebenzisa umsebenzi weVLOOKUP kwitafile enye, ngesiseko apho ingxelo yakhiwe khona.
Isonjululwa njani le ngxaki ngokusebenzisa i-Power BI?
Idatha evela kwimithombo ilayishwe kwisistim kwaye ilungiselelwe ukuhlalutya: yahlulahlulwe kwiitafile, zicocwe kwaye zithelekiswe. Emva koko, imodeli yezoshishino iyakhiwa: iitheyibhile zidibaniswe omnye komnye, izikhombisi zichazwe, kwaye ii-hierarchies zesiko zenziwe. Inqanaba elilandelayo kukubonwa. Apha, ngokutsala ngokulula kunye nokulahla izilawuli kunye namawijethi, ideshibhodi esebenzayo iyenziwa. Zonke izinto zixhunyiwe ngemodeli yedatha. Xa uhlalutya, oku kukuvumela ukuba uqwalasele kulwazi oluyimfuneko, uluhluza kuzo zonke iimboniselo ngonqakrazo olunye kuyo nayiphi na into yedeshbhodi.
Ziziphi iingenelo zokusebenzisa i-Power BI xa kuthelekiswa nendlela yendabuko enokubonwa kulo mzekelo ungasentla?
I-1 - Ukuzenzekelayo kwenkqubo yokufumana idatha kunye nokulungiselela uhlalutyo.
I-2 - Ukwakha imodeli yeshishini.
3 -Umbono ongakholelekiyo.
4 β Ukufikelela okwahlukileyo kwiingxelo.
Ngoku makhe sijonge inqaku ngalinye ngokwahlukeneyo.
I-1 - Ukulungiselela idatha yokwakha ingxelo, kufuneka uchaze inkqubo emva kokuba idibanise idatha kunye neenkqubo zayo, kwaye rhoqo xa ufuna ukufumana ingxelo ngexesha elithile, i-Power BI iya kudlula idatha ngokusebenzisa inkqubo eyenziwe. . Oku ngokuzenzekelayo uninzi lomsebenzi obandakanyekayo ekulungiseleleni idatha yokuhlalutya. Kodwa inyaniso kukuba i-Power BI iqhuba inkqubo yokulungiselela idatha isebenzisa isixhobo esifumaneka kwi-classic version ye-Excel, kwaye ibizwa ngokuba. . Ikuvumela ukuba ugqibezele umsebenzi kwi-Excel ngendlela efanayo.
I-2 - imeko iyafana apha. Isixhobo se-Power BI sokwakha imodeli yeshishini sikwakhona kwi-Excel - oku .
3 - Njengoko sele uqikelele, ngokujonga imeko iyafana: Ulwandiso lwe-Excel - ujongene nalo msebenzi ngesithonga.
I-4 - Kuhlala ukufumana ukufikelela kwiingxelo. Izinto azilunganga apha. Inyaniso kukuba i-Power BI yinkonzo yefu efumaneka nge-akhawunti yakho. Umlawuli wenkonzo usasaza abasebenzisi kumaqela kwaye usete amanqanaba ahlukeneyo okufikelela kwiingxelo kula maqela. Oku kuphumeza umahluko wamalungelo okufikelela phakathi kwabasebenzi benkampani. Ngaloo ndlela, abahlalutyi, abaphathi kunye nabalawuli, xa befikelela kwiphepha elifanayo, babone ingxelo kwimbono efikelelekayo kubo. Ukufikelela kwiseti ethile yedatha okanye kuyo yonke ingxelo kunokunyinwa. Nangona kunjalo, ukuba ingxelo ikwifayile ye-Excel, ngoko ngemigudu yomlawuli wenkqubo unokuzama ukusombulula ingxaki ngokufikelela, kodwa oku akuyi kufana. Ndiza kubuyela kulo msebenzi xa ndichaza iimpawu ze-portal yenkampani.
Kuyafaneleka ukuba uqaphele ukuba, njengomthetho, imfuno yenkampani yeedeshibhodi eziyinkimbinkimbi kunye ezintle ayinkulu kwaye kaninzi, ukuhlalutya idatha kwi-Excel, emva kokwakha imodeli yezoshishino, ababheki kwizakhono ze-Power View, kodwa sebenzisa i-pivot. iitafile. Babonelela ngokusebenza kwe-OLAP okwaneleyo ukusombulula uninzi lweengxaki zohlalutyo lweshishini.
Ngaloo ndlela, ukhetho lokuqhuba uhlalutyo lweshishini kwi-Excel lunokwanelisa kakuhle iimfuno zenkampani ephakathi kunye nenani elincinci labasebenzi abafuna iingxelo. Nangona kunjalo, ukuba iimfuno zenkampani yakho zinamabhongo ngakumbi, musa ukungxama ukubhenela kwizixhobo eziza kusombulula yonke into ngaxeshanye.
Ndizisa ingqalelo yakho indlela yobuchwephesha, oya kuthi ufumane eyakho, elawulwa ngokupheleleyo, inkqubo ezenzekelayo yokuvelisa iingxelo zohlalutyo lweshishini kunye nokufikelela okulinganiselweyo kuzo.
I-ETL kunye ne-DWH
Kwiindlela ezixoxwe ngaphambili zokwakha iingxelo zoshishino, ukulayisha kunye nokulungiselela idatha yohlalutyo lwenziwa ngokusebenzisa iteknoloji ye-Power Query. Le ndlela ihlala ithetheleleka ngokupheleleyo kwaye isebenza ukuba akukho mithombo yolwazi mininzi: inkqubo yokubala enye kunye neencwadi zeereferensi ezivela kwiitafile ze-Excel. Nangona kunjalo, ngokunyuka kwenani leenkqubo zokubala, ukusombulula le ngxaki usebenzisa i-Power Query kuba nzima kakhulu kwaye kunzima ukuyigcina nokuphuhlisa. Kwiimeko ezinjalo, izixhobo ze-ETL ziza kuhlangula.
Ngoncedo lwabo, idatha ikhutshwe kwimithombo (i-Extract), iguqulwe (iTshintsho), ethetha ukucocwa kunye nokuthelekisa, kwaye ilayishwe kwindawo yokugcina idatha (Umthwalo). Ugcino lwedatha (DWH - Data Warehouse) , njengomthetho, isiseko sedatha esinxulumeneyo esibekwe kumncedisi. Le datha iqulethe idatha efanelekileyo yokuhlalutya. Inkqubo ye-ETL iqaliswe ngokweshedyuli, ehlaziya idatha yendawo yokugcina impahla ukuya kutsha nje. Ngendlela, le khitshi yonke ikhonza ngokugqibeleleyo kwiiNkonzo zokuHlanganisa, eziyinxalenye ye-MS SQL Server.
Ukuqhubela phambili, njengangaphambili, ungasebenzisa i-Excel, i-Power BI, okanye ezinye izixhobo zokuhlalutya ezifana neTableau okanye i-Qlik Sense ukwakha imodeli yeshishini yedatha kunye nokubonwa. Kodwa kuqala, ndingathanda ukutsalela ingqalelo yakho kwelinye ithuba onokuthi ungazi ngalo, nangona sele likhona ixesha elide. Sithetha malunga nokwakhiwa kweemodeli zoshishino usebenzisa iinkonzo zohlalutyo ze-MS SQL Server, ezizezi IiNkonzo zokuHlalutya.
Iimodeli zedatha kwiiNkonzo zokuHlalutya kweMS
Eli candelo lenqaku liya kuba nomdla ngakumbi kwabo sele besebenzisa i-MS SQL Server kwinkampani yabo.
Iinkonzo zokuhlalutya okwangoku zibonelela ngeentlobo ezimbini zeemodeli zedatha: imodeli ye-multidimensional kunye ne-tabular. Ukongeza kwinto yokuba idatha kwezi modeli idityanisiwe, amaxabiso ezalathi zemodeli adityaniswe kwangaphambili kwaye agcinwe kwiiseli zetyhubhu ze-OLAP, ezifunyenwe yi-MDX okanye imibuzo ye-DAX. Ngenxa yolu lwakhiwo logcino lwedatha, umbuzo ofikelela kwizigidi zeerekhodi ubuyiselwa ngemizuzwana. Le ndlela yokufikelela kwidatha iyimfuneko kwiinkampani ezineetafile zokuthengiselana ziqulethe iirekhodi ezingaphezu kwesigidi (umda ophezulu awukhawulelwanga).
I-Excel, i-Power BI kunye nezinye izixhobo ezininzi "ezihloniphekileyo" zinokudibanisa kwiimodeli ezinjalo kwaye zibonise idatha kwizakhiwo zabo.
Ukuba uthathe indlela "ephambili": uzenzele inkqubo ye-ETL kwaye wakha iimodeli zoshishino usebenzisa iinkonzo ze-MS SQL Server, ngoko ufanelwe ukuba ube ne-portal yakho yenkampani.
Portal yoshishino
Ngayo, abalawuli baya kubeka iliso kwaye balawule inkqubo yokunika ingxelo. Ubukho be-portal buya kwenza ukuba kube lula ukudibanisa ii-directory zenkampani: ulwazi malunga nabathengi, iimveliso, abaphathi, ababoneleli baya kufumaneka xa kuthelekiswa, ukuhlela kunye nokukhuphela kwindawo enye kuye wonke umntu oyisebenzisayo. Kwi-portal, unokuphumeza imisebenzi eyahlukeneyo yokutshintsha idatha kwiinkqubo zokubala, umzekelo, ukulawula ukuphindaphinda kwedatha. Kwaye okona kubaluleke kakhulu, ngoncedo lwe-portal, ingxaki yokulungelelanisa ukufikelela okwahlukileyo kwiingxelo kusonjululwe ngempumelelo - abasebenzi baya kubona kuphela ezo ngxelo ezilungiselelwe ngokwabo kumasebe abo ngendlela ejoliswe kubo.
Nangona kunjalo, akukacaci ukuba ukuboniswa kweengxelo kwiphepha le-portal kuya kuququzelelwa njani. Ukuphendula lo mbuzo, kufuneka uqale wenze isigqibo malunga neteknoloji apho i-portal iya kwakhiwa khona. Ndicebisa ukusebenzisa enye yesikhokelo njengesiseko: ASP.NET MVC/Web Forms/Core, okanye Microsoft SharePoint. Ukuba inkampani yakho inonjiniyela omnye .NET, ke ukhetho aluyi kuba nzima. Ngoku ungakhetha umxhasi we-OLAP ongaphakathi kwisicelo onokuqhagamshela kwiiNkonzo zoHlahlelo lwemifuziselo emininzi okanye yetheyibhile.
Ukukhetha umxhasi we-OLAP wokubonwa
Makhe sithelekise izixhobo eziliqela ngokusekelwe kwinqanaba ukuntsonkotha kufakelo, ukusebenza kunye nexabiso: Power BI, Telerik UI for ASP.NET amacandelo MVC kunye RadarCube ASP.NET amacandelo MVC.
Amandla eBI
Ukulungelelanisa ukufikelela kubasebenzi benkampani kwiingxelo ze-Power BI kwiphepha lakho le-portal, kufuneka usebenzise umsebenzi .
Mandikuxelele kwangoko ukuba uya kufuna ilayisensi yePower BI Premium kunye nomthamo owongezelelweyo ozinikeleyo. Ukuba nomthamo ozinikeleyo kukuvumela ukuba upapashe iidashbhodi kunye neengxelo kubasebenzisi abakumbutho wakho ngaphandle kokuba ubathengele iilayisensi.
Okokuqala, ingxelo eveliswe kwi-Power BI Desktop ipapashwa kwi-portal ye-Power BI kwaye emva koko, ngoncedo lolunye uqwalaselo olulula, lufakwe kwiphepha lesicelo sewebhu.
Umhlalutyi unokusingatha ngokulula inkqubo yokuvelisa ingxelo elula kunye nokupapasha, kodwa iingxaki ezinzulu zinokuvela ngokufakela. Kwakhona kunzima kakhulu ukuqonda indlela yokusebenza kwesi sixhobo: inani elikhulu lemimiselo yenkonzo yefu, ukubhaliswa okuninzi, iilayisenisi, kunye nobuchule kwandisa kakhulu imfuno yenqanaba loqeqesho lweengcali. Ngoko ke kungcono ukunikezela lo msebenzi kwingcali ye-IT.
Telerik kunye RadarCube amacandelo
Ukufakela iTelerik kunye neRadarCube amacandelo, kwanele ukuba ube nenqanaba elisisiseko leteknoloji yesoftware. Ke ngoko, izakhono zobuchwephesha zomdwelisi wenkqubo omnye kwisebe le-IT ziya kwanela. Konke okufuneka ukwenze kukubeka icandelo kwiphepha lewebhu kwaye wenze ngokwezifiso ukuze lihambelane neemfuno zakho.
Icandelo isuka kwi Telerik UI ye ASP.NET MVC suite ilungisiwe kwiphepha ngendlela enobubele ye Razor kwaye ibonelela ngeyona misebenzi iyimfuneko ye OLAP. Nangona kunjalo, ukuba ufuna iisetingi eziguquguqukayo zojongano kunye nokusebenza okuphezulu, ke kungcono ukusebenzisa amacandelo . Inani elikhulu lezicwangciso, ukusebenza okucebileyo kunye nokukwazi ukuphinda uchaze kwaye ukwandise, kuya kukuvumela ukuba wenze ingxelo ye-OLAP nayiphi na into enzima.
Ngezantsi itheyibhile ethelekisa iimpawu zezixhobo eziqwalaselwayo kwi-Low-Medium-High scale.
Amandla eBI
Telerik UI for ASP.NET MVC
RadarCube ASP.NET MVC
Ukubonakala
Ephakamileyo
Ephantsi
Phakathi
Iseti yemisebenzi ye-OLAP
Ephakamileyo
Ephantsi
Ephakamileyo
Ukuguquguquka kokwenza ngokwezifiso
Ephakamileyo
Ephakamileyo
Ephakamileyo
Ukubanakho kwemisebenzi engaphezulu
-
-
+
Ukulungiswa kwesoftware
-
-
+
Inqanaba lobunzima bofakelo kunye noqwalaselo
Ephakamileyo
Ephantsi
Phakathi
Ubuncinci bexabiso
Amandla BI Premium EM3
190 rub./ngenyanga
Ilayisensi yomphuhlisi omnye
90 000
Ilayisensi yomphuhlisi omnye
25 000
Ngoku unokuqhubela phambili ekuchazeni iikhrayitheriya zokukhetha isixhobo sokuhlalutya.
Iikhrayitheriya zokukhetha ze-BI zamandla
- Unomdla kwiingxelo ezityebileyo kwiimetriki ezahlukeneyo kunye nezinto ezinxulumene nedatha.
- Ufuna abasebenzi abasebenza ngeengxelo bakwazi ukufumana lula kwaye ngokukhawuleza iimpendulo kwiingxaki zabo ishishini ngendlela enembile.
- Inkampani inengcali ye-IT enezakhono zophuhliso lwe-BI.
- Uhlahlo lwabiwo-mali lwenkampani lubandakanya isixa esikhulu sentlawulo yenyanga yenkonzo yokuhlalutya ishishini lelifu.
Imiqathango yokukhetha amacandelo Telerik
- Sifuna umxhasi we-OLAP olula wohlalutyo lwe-Ad hock.
- Inkampani ine-entry-level .NET developer on staff.
- Uhlahlo lwabiwo-mali oluncinci lokuthenga iphepha-mvume lexesha elinye kunye nokuhlaziywa kwakhona ngesaphulelo esingaphantsi kwe-20%.
Imiqathango yokukhetha amacandelo eRadarCube
- Udinga umxhasi osebenzayo we-OLAP onobuchule bokwenza ujongano ngokwezifiso, kunye nalowo uxhasa ukubethelela imisebenzi yakho.
- Inkampani inomphuhlisi ophakathi .NET kubasebenzi. Ukuba oku akunjalo, ngoko abaphuhlisi becandelo baya kubonelela ngobubele ngeenkonzo zabo, kodwa ngentlawulo eyongezelelweyo engagqithisi kwinqanaba lomvuzo womprogram osisigxina.
- Uhlahlo lwabiwo-mali oluncinci lokuthenga iphepha-mvume lexesha elinye kunye nokuhlaziywa kwayo ngesaphulelo se-60%.
isiphelo
Ukukhetha isixhobo esifanelekileyo sohlalutyo lweshishini kuya kukuvumela ukuba ulahle ngokupheleleyo ingxelo kwi-Excel. Inkampani yakho iya kukwazi ukuhamba ngokuthe ngcembe kwaye ingenabuhlungu ekusebenziseni itekhnoloji ephezulu kwintsimi ye-BI kwaye izenzele ngokuzenzekelayo umsebenzi wabahlalutyi kuwo onke amasebe.
umthombo: www.habr.com