Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)

Isikhathi esidingekayo sokufunda imizuzu eyi-11

Thina kanye ne-Gartner Square 2019 BI :)

Inhloso yalesi sihloko ukuqhathanisa izinkundla ezintathu ezihamba phambili ze-BI ezikubaholi be-Gartner quadrant:

- Power BI (Microsoft)
—Ithebula
- Qiniso

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 1. I-Gartner BI Magic Quadrant 2019

Igama lami ngingu-Andrey Zhdanov, ngiyinhloko yomnyango we-analytics ku-Analytics Group (www.analyticsgroup.ru). Sakha imibiko ebonakalayo mayelana nokumaketha, ukuthengisa, ezezimali, ukuhleleka, ngamanye amazwi, sizibandakanya ekuhlaziyeni kwebhizinisi nasekuboneni idatha.

Mina nozakwethu sesisebenze nezinkundla ezahlukene ze-BI iminyaka eminingana. Sinolwazi oluhle kakhulu lwephrojekthi, olusivumela ukuthi siqhathanise izinkundla ngokombono wabathuthukisi, abahlaziyi, abasebenzisi bebhizinisi nabaqalisi bezinhlelo ze-BI.

Sizoba nendatshana ehlukile yokuqhathanisa amanani kanye nokwakheka okubonakalayo kwalezi zinhlelo ze-BI, ngakho-ke lapha sizozama ukuhlola lezi zinhlelo ngombono womhlaziyi kanye nonjiniyela.

Ake sigqamise izindawo ezimbalwa zokuhlaziya futhi sizihlole sisebenzisa isistimu enamaphuzu ama-3:

- Umkhawulo wokungena kanye nezidingo zomhlaziyi;
- Imithombo yedatha;
- Ukuhlanza idatha, i-ETL (Khipha, Guqula, Ukulayisha)
- Imibono kanye nentuthuko
- Indawo yebhizinisi - iseva, imibiko
- Ukusekelwa kwamadivayisi eselula
- Izibalo ezishumekiwe (ezakhelwe ngaphakathi) ezinhlelweni/kumasayithi ezinkampani zangaphandle

1. Umkhawulo wokungena nezimfuneko zomhlaziyi

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)

I-Power BI

Ngibone abasebenzisi abaningi be-Power BI ababengebona ochwepheshe be-IT kodwa abangakha umbiko omuhle kakhulu. I-Power BI isebenzisa ulimi lombuzo olufanayo njenge-Excel - Umbuzo Wamandla kanye nolimi lwefomula ye-DAX. Abahlaziyi abaningi bazi kahle i-Excel, ngakho ukushintshela kulolu hlelo lwe-BI kulula kakhulu kubo.

Izenzo eziningi zilula ukuzenza kumhleli wombuzo. Futhi kukhona umhleli othuthukile onolimi lwe-M lwabachwepheshe.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 2. I-Power BI Query Builder

I-Qlik Sense

I-Qlik Sense ibukeka inobungane kakhulu - inombolo encane yezilungiselelo, ikhono elisheshayo lokudala umbiko, ungasebenzisa umklami wokulayisha idatha.

Ekuqaleni kubonakala kulula kune-Power BI ne-Tableau. Kodwa ngokuhlangenwe nakho ngizosho ukuthi ngemva kwesikhashana, lapho umhlaziyi edala imibiko embalwa elula futhi edinga into eyinkimbinkimbi, uzobhekana nesidingo sokuhlela.

I-Qlik inolimi olunamandla kakhulu lokulayisha nokucubungula idatha. Inolimi lwayo lwefomula, i-Set Analysis. Ngakho-ke, umhlaziyi kufanele akwazi ukubhala imibuzo nokuxhumana, abeke idatha kumathebula abonakalayo, futhi asebenzise okuguquguqukayo ngenkuthalo. Amakhono olimi abanzi kakhulu, kodwa azodinga ukufunda. Mhlawumbe bonke abahlaziyi be-Qlik engibaziyo banohlobo oluthile lwesizinda se-IT esibucayi.

Abadidiyeli be-Qlik, njengathi, bavame ukuthanda ukukhuluma ngemodeli ehlangene, lapho lapho kulayishwa idatha, yonke ifakwa ku-RAM, futhi ukuxhumana phakathi kwedatha kwenziwa indlela yangaphakathi yesikhulumi. Ukuthi lapho kukhethwa amanani, imibuzo engaphansi yangaphakathi ayenziwa, njengakusizindalwazi sakudala. Idatha inikezwa cishe ngaso leso sikhathi ngenxa yamanani afakwe kunkomba kanye nobudlelwano.

Yiqiniso, ngokusebenza lokhu kuholela ekwakhiweni kokujoyina kwethebula okuzenzakalelayo lapho amagama enkundla ehambisana. Isibonelo, awukwazi ukuba namatafula ahlukene ngaphandle kobudlelwane obuzoba nenkundla efanayo. Kumele ukujwayele lokhu. Kufanele uqambe kabusha amakholomu futhi uqiniseke ukuthi amagama awahambelani, noma uhlanganise wonke amathebula amaqiniso abe ngelilodwa futhi uwahaqe ngezinkhomba zohlobo lwenkanyezi. Cishe ilungele abaqalayo, kodwa kubahlaziyi abanolwazi akunandaba.

Isixhumi esibonakalayo esijwayelekile sokulayisha nokucubungula idatha yomhlaziyi sibukeka kanje.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 3. Umhleli wedatha ye-Qlik Sense, ithebula lekhalenda

Qaphela: Ku-Power BI isimo ngokuvamile sibukeka sihlukile, ushiya amathebula eqiniso namareferensi ahlukene, ungakwazi ukujoyina amatafula ngendlela yakudala, i.e. Ngiqhathanisa amakholomu komunye nomunye ngesandla.

ithebula

Onjiniyela babeka i-Tableau njenge-BI ene-interface elula nenobungane ezovumela umhlaziyi ukuthi afunde ngokuzimela idatha yakhe. Yebo, enkampanini yethu kwakukhona abahlaziyi abathi, ngaphandle kwesipiliyoni se-IT, bangenza imibiko yabo. Kodwa ngizokwehlisa isilinganiso sami se-Tableau ngezizathu ezimbalwa:
- Ukwakhiwa kwasendaweni okubuthakathaka ngolimi lwesiRashiya
- Amaseva we-Tableau Online awekho e-Russian Federation
- Umakhi womthwalo olula uqala ukudala izinkinga lapho udinga ukwakha imodeli yedatha eyinkimbinkimbi.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 4. Umakhi Womthwalo Wedatha Yethebula

Omunye wemibuzo esiyibuza abahlaziyi be-Tableau ngesikhathi sezingxoxo uthi “Ungayakha kanjani imodeli yamathebula eqiniso ngamatafula okubhekisela ngaphandle kokubeka yonke into etafuleni elilodwa?!” Ukuhlanganisa Idatha kudinga ukusetshenziswa okucabangelayo. Ngilungise amaphutha okuphinda idatha izikhathi eziningi phakathi kwabahlaziyi bami ngemva kokuhlanganiswa okunjalo.

Futhi, i-Tableau inesistimu ehlukile, lapho wenza khona ishadi ngalinye Eshidini elihlukile, bese udala Ideshibhodi, lapho uqala khona ukubeka amashidi adaliwe. Bese ungakwazi ukudala Indaba, lokhu kuyinhlanganisela yamadeshibhodi ahlukene. Ukuthuthukiswa kwe-Qlik kanye ne-Power BI kulula kulokhu; ngokushesha uphonsa izifanekiso zegrafu eshidini, usethe izilinganiso nezilinganiso, futhi Ideshibhodi isilungile. Kimina kubonakala sengathi izindleko zabasebenzi zokulungiselela eTableau ziyenyuka ngenxa yalokhu.

2. Imithombo yedatha nokulanda

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)

Akekho owinile ocacile kulesi sigaba, kodwa sizogqamisa i-Qlik ngenxa yezici ezimbalwa ezinhle.

I-Tableau enguqulweni yamahhala inomkhawulo emithonjeni, kodwa ezihlokweni zethu sigxila kakhulu ebhizinisini, futhi amabhizinisi angakwazi ukukhokhela imikhiqizo yokuthengisa nabahlaziyi. Ngakho-ke, i-Tableau ayizange yehlise isilinganiso sayo sale pharamitha.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 5. Uhlu lwemithombo ye-Tableau engaba khona

Kungenjalo, uhlu lwemithombo luhlaba umxhwele yonke indawo - wonke amafayela ethebula, yonke imininingwane yolwazi, ukuxhumana kwewebhu, yonke into isebenza yonke indawo. Angizange ngihlangabezane nokugcinwa kwedatha okungajwayelekile, kungase kube nama-nuances azo, kodwa ezimweni eziningi ngeke ube nezinkinga zokulayisha idatha. Okuhlukile kuphela yi-1C. Azikho izixhumi eziqondile ku-1C.

Ozakwethu be-Qlik e-Russia bathengisa izixhumi zabo ngama-ruble ayi-100 - 000, kodwa ezimweni eziningi ishibhile ukwenza ukulayisha kusuka ku-200C kuya ku-FTP kuya ku-Excel noma isizindalwazi se-SQL. Noma ungashicilela isizindalwazi se-000C kuwebhu futhi uxhume kuso usebenzisa iphrothokholi ye-Odata.

I-PowerBI ne-Tableau zingenza lokhu njengendinganiso, kodwa i-Qlik izocela isixhumi esikhokhelwayo, ngakho-ke kulula futhi ukusilayisha kusizindalwazi esimaphakathi. Kunoma yikuphi, zonke izinkinga zokuxhuma zingaxazululwa.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 6. Uhlu lwemithombo ye-Qlik Sense engaba khona

Ukwengeza, kufanelekile ukuqaphela isici se-Qlik esihlinzeka ngazo zombili izixhumi ezikhokhelwayo nezimahhala njengomkhiqizo ohlukile.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 7. Izixhumi ezengeziwe ze-Qlik Sense

Kusukela kokuhlangenwe nakho, ngizofaka ukuthi ngenani elikhulu ledatha noma imithombo eminingi, akukuhle ngaso sonke isikhathi ukuxhuma ngokushesha uhlelo lwe-BI. Amaphrojekthi abalulekile ngokuvamile asebenzisa inqolobane yedatha, isizindalwazi esinedatha esivele isilungiselelwe ukuhlaziywa, njll. Awukwazi ukuthatha futhi ulayishe, ake sithi, amarekhodi ayizigidi eziyizinkulungwane ezingu-1 ohlelweni lwe-BI. Lapha usuvele udinga ukucabanga ngokusebenzisa i-architecture yesisombululo.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 8. Imithombo yedatha ye-Power BI

Kodwa kungani uQlik aqokwa? Ngithanda kakhulu izinto ezi-3:
- Amafayela e-QVD
Ifomethi yesitoreji sedatha siqu. Kwesinye isikhathi kuyenzeka ukuthi kwakhiwe amaphrojekthi amakhulu okuhweba kuphela kumafayela e-QVD. Isibonelo, izinga lokuqala idatha eluhlaza. Izinga lesibili amafayela acutshunguliwe. Izinga lesithathu idatha ehlanganisiwe, njll. Lawa mafayela angasetshenziswa ezinhlelweni ezihlukene, futhi abasebenzi namasevisi ahlukene angase abe nesibopho ngawo. Isivinini sokulanda kumafayela anjalo sishesha ngokuphindwe kashumi kunemithombo evamile yedatha. Lokhu kukuvumela ukuthi wonge ezindlekweni zesizindalwazi futhi wabelane ngolwazi phakathi kwezinhlelo zokusebenza ezihlukene ze-Qlik.

- Ukulayishwa kwedatha okukhuphukayo
Yebo, i-Power BI ne-Tableau nazo zingakwenza lokhu. Kodwa i-Power BI idinga inguqulo ye-Premium ebizayo, futhi i-Tableau ayinakho ukuguquguquka kwe-Qlik. Ku-Qlik, usebenzisa amafayela e-QVD, ungenza izifinyezo zezinhlelo ngezikhathi ezihlukene bese ucubungula le datha ngendlela othanda ngayo.

- Ukuxhumanisa imibhalo yangaphandle
Ngokungeziwe kumafayela e-QVD okugcina idatha, ku-Qlik ikhodi yombhalo ingaphinde ithathwe ngaphandle kohlelo lokusebenza futhi ifakwe nomyalo othi Faka. Lokhu kakade kukuvumela ukuthi uhlele umsebenzi weqembu, usebenzise amasistimu okulawula inguqulo, futhi uphathe ikhodi eyodwa yezinhlelo zokusebenza ezahlukene. I-Power BI inomhleli wemibuzo othuthukisiwe, kodwa asikwazanga ukumisa umsebenzi weqembu njengaku-Qlik. Sekukonke, yonke i-BI inezinkinga ngalokhu; akunakwenzeka ukuphatha idatha ngesikhathi esisodwa, ikhodi, nokubonwayo kuzo zonke izinhlelo zokusebenza endaweni eyodwa. Okuningi esikwazile ukukwenza ukukhipha amafayela e-QVD nekhodi yombhalo. Izinto ezibonakalayo kufanele zihlelwe ngaphakathi kwemibiko ngokwayo, okungasivumeli ukuthi siguqule kakhulu ukubonwa kwawo wonke amaklayenti ngesikhathi esisodwa.

Kodwa kuthiwani ngomshini onjengoxhumano olubukhoma? I-Tableau kanye ne-Power BI zisekela uxhumo LIVE kumithombo ehlukahlukene, ngokungafani ne-Qlik. Asinandaba nalesi sici, ngoba... umkhuba ubonisa ukuthi uma kuziwa kudatha enkulu, ukusebenza ngoxhumo LIVE kuba yinto engenakwenzeka. Futhi i-BI ezimweni eziningi iyadingeka kudatha enkulu.

3. Ukuhlanza idatha, i-ETL (I-Extract, Transform, Layisha)

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)

Kulesi sigaba nginabaholi abangu-2, i-Qlik Sense kanye ne-Power Bi.
Ake sithi i-Qlik inamandla kodwa iyinkimbinkimbi. Uma usuqonda ulimi lwabo olufana ne-SQL, ungenza cishe yonke into - amathebula abonakalayo, ukuhlanganisa nokuhlanganisa amathebula, ukuzungeza kuthebula futhi ukhiqize amathebula amasha, inqwaba yemiyalelo yokucubungula imigqa. Isibonelo, inkambu kuseli elingu-1 eligcwaliswe ngedatha efana ne-“Ivanov 851 Bely” endizeni ingahle iboliswe hhayi nje ibe amakholomu angu-3 (njengoba wonke umuntu engenza), kodwa futhi ibe yimigqa emi-3 ngesikhathi esisodwa, isibonelo. Kulula futhi ukwenza into efanayo endizeni ngokuhlanganisa imigqa emi-3 ibe ngu-1.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 9. Ungalayisha kanjani futhi uguqule itafula ku-Qlik Sense kusuka ku-Google AmaSpredishithi

I-Power BI ibonakala ilula kulokhu, kodwa izinkinga eziningi zingaxazululwa kalula ngomklami wemibuzo. Ngisethe imingcele eminingi, ngashintsha itafula, ngasebenza kudatha, futhi konke lokhu ngaphandle komugqa owodwa wekhodi.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 10. Ungalayisha kanjani futhi uguqule ithebula libe yi-Power BI esuka ku-AmoCRM

I-Tableau ibonakala kimi inombono ohlukile. Zimayelana nobuhle nokuklama. Kubonakala kunzima kakhulu ukuxhuma inqwaba yemithombo ehlukene, uyihlanganise yonke futhi uyicubungule ngaphakathi kwe-Tableau. Kumaphrojekthi wezohwebo, ezimweni eziningi, idatha isivele ilungisiwe futhi iqoqwe ku-Tableau ezinqolobaneni nasezinqolobaneni zolwazi.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 11. Ungalayisha kanjani futhi uguqule itafula ku-Tableau

4. Okubonwayo

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)

Kulesi sigaba asigqamisanga umholi. Sizoba nendatshana ehlukile lapho, sisebenzisa isibonelo sesimo esisodwa, sizobonisa umbiko ofanayo kuzo zonke izinhlelo ezi-3 (Isihloko esithi “Izibalo zamantombazane anomthwalo wemfanelo ophansi emphakathini”). Kungaphezulu indaba yokunambitha nekhono lomhlaziyi. Ku-inthanethi ungathola izithombe ezinhle kakhulu ezakhiwe ngesisekelo sanoma iyiphi yalezi zinhlelo. Amakhono ayisisekelo okubuka acishe afane kuwo wonke umuntu. Okunye kuxazululwa kusetshenziswa ama-Extensons. Akhona akhokhelwayo namahhala. Kukhona izandiso ezivela kubathengisi ngokwabo, kanye nezivela kuma-freelancers kanye nabadidiyeli. Ungabhala esakho isandiso sokubuka sanoma iyiphi ingxenyekazi.

Ngiyasithanda isitayela sikaTableau, ngicabanga ukuthi siqinile futhi sihlangene. Kodwa ukuthola isithombe esihle ngempela eTableau kunzima. Isibonelo esihle kakhulu sokubonwa kwe-Tableau kusetshenziswa izandiso kuphela. Ngeke ngikwazi ukuphinda lokhu, ngoba... Anginazo lezi zandiso, kodwa kubukeka kukuhle.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 12. Ukuvela kwemibiko yeTableau enezandiso

I-Power BI nayo ingenziwa ibe mnandi.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 13. Ukuvela Kwemibiko Yezandiso Zamandla Bic

Okuwukuphela kwento engingayiqondi mayelana ne-Power BI ukuthi kungani benemibala ezenzakalelayo engavamile. Kunoma yiliphi ishadi, ngiphoqelekile ukuthi ngiguqule umbala kube owami obhalwe uphawu, owebhizinisi futhi ngiyamangala ngombala ojwayelekile.

I-Qlik Sense nayo incike Ezandisweni. Ukusebenzisa izengezo kungashintsha imibiko ngale kokuqashelwa. Ungakwazi futhi ukwengeza itimu yakho kanye nomklamo.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 14. Ukuvela kwemibiko ye-Qlik Sense enezandiso

Ngokombono wonjiniyela, ngincamela i-Qlik Sense ngenxa yezinketho ezijwayelekile ezifana nobukhulu obuhlukile nezilinganiso. Ungasetha ubukhulu nezilinganiso ezimbalwa kuzilungiselelo zokubuka, futhi umsebenzisi angasetha kalula lokho okufanele akubheke eshadini elithile.

Ku-Power Bi naku-Tableau, kufanele ngilungise imingcele, izinkinobho, ngihlele ukuziphatha kwesistimu kuye ngale mingcele. Kazi kungani kunzima kangaka. Into efanayo nekhono lokushintsha uhlobo lwe-villization.

Ku-Qlik ungafihla izinhlobo ezahlukene zokubuka entweni eyodwa, kodwa ku-Power BI naku-Tableau lokhu kunzima kakhulu. Nalapha futhi, lokhu kuncike kakhulu ekhonweni lomdlali. Ungenza umsebenzi wobuciko kunoma iyiphi isistimu, kodwa ngaphandle kwesipiliyoni uzogcina unezithombe ezingabizi yonke indawo.

5. Imvelo Corporate - iseva, imibiko

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)

Yonke imikhiqizo inezinguqulo zeseva yenkampani. Ngisebenze nazo zonke izinhlelo futhi ngingasho ukuthi zonke zinamandla nobuthakathaka. Ukukhethwa komkhiqizo kufanele kusekelwe ezidingweni zesofthiwe yakho, kucatshangelwa ama-nuances awo. Bonke abathengisi banganikeza amalungelo kokubili ku-akhawunti neleveli yeqembu, kanye nakuVikeleko Lwezinga Lomugqa Wedatha. Ukubuyekezwa okuzenzakalelayo kwemibiko kushejuli kuyatholakala.

I-Qlik Sense Enterprise iyithuba elihle lokwakha izibalo ngaphakathi kwenhlangano yakho zamabhizinisi aphakathi nendawo. Lokhu kungase kubonakale kubiza kakhulu kune-Power BI Pro, kodwa ungakhohlwa ukuthi amaseva e-Power BI Pro atholakala efwini endaweni ye-Microsoft futhi awukwazi ukuthonya ukusebenza, futhi uma udinga i-Power BI Premium, engasatshalaliswa kumaseva akho, bese intengo iqala kusuka ku-$5000 ngenyanga.

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)

I-Qlik Sense Enterprise iqala ku-RUB 230. ngamalayisense angu-000 (imali ekhokhwa ngonyaka, bese kuba ukwesekwa kobuchwepheshe kuphela), okuthengekayo kakhulu kune-Power BI Premium. Futhi i-Qlik Sense Enterprise izokuvumela ukuthi usebenzise wonke amakhono e-Qlik. Mhlawumbe ngaphandle kweyodwa. Ngesizathu esithile, u-Qlik unqume ukuthi isici esifana nekhono lokuthumela imibiko ye-PDF nge-imeyili kufanele sinikezwe njengesevisi ehlukile ye-NPrinting.

Kepha i-Qlik Sense Enterprise inamandla kakhulu kunePower BI Pro ngakho-ke ukuqhathanisa okulandelayo kungenziwa.

I-Qlik Sense Enterprise = I-Power BI Premium, enamakhono alinganayo avele ashibhile ekusetshenzisweni okumaphakathi. Ukuqaliswa okukhulu kuvame ukubalwa ngasohlangothini lomthengisi, lapho kunganikeza izimo zomuntu ngamunye zenkampani yakho.

Mayelana nalokhu, sizokhetha i-Qlik Sense Enterprise, inawo wonke amathuba okwakha ukuhlaziya okujulile kudatha enkulu. Ngokubona kwethu, i-Qlik izosebenza ngokushesha kune-Power BI ngezinhlaka ezinkulu; ezingqungqutheleni ze-Qlik sahlangana namaklayenti aqale ahlola idatha yawo ngezigidigidi zamarekhodi futhi i-Power BI yabonisa imiphumela emibi kakhulu.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 15. Ukuvela kwemibiko yeseva ye-Qlik Sense Enterprise

Qlik Sense Cloud = Power BI Pro. I-Qlik Sense Cloud ibiza ngokuphindwe ka-1.5* futhi kukhona umkhawulo obaluleke kakhulu le nkundla engasivumeli. Awukwazi ukusebenzisa Izandiso, ngisho nezakhelwe ngaphakathi. Futhi ngaphandle kwezandiso, i-Qlik ilahlekelwa ubuhle bayo obubonakalayo.
Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 16. Ukubukeka kwephaneli yokulawula ye-Power BI Pro

*Okunye ukusebenzisa ukubhalisa kwe-Qlik Sense Enterprise. Kodwa ukuze lesi sihloko singabonakali njengesokukhangisa, ngeke siwafake amanani ethu

Futhi iTableau ime eceleni kancane ngathi. Banakho kokubili okubhaliselwe kwamafu nge-$70 ngonjiniyela ngamunye kanye ne-$15 ngokubuka ngakunye, kanye nezixazululo zeseva ezibizayo. Kodwa umqondo oyinhloko weTableau ukuthi ngedatha enkulu udinga ukuhlela ukucubungula nokugcinwa kwedatha eceleni. Ngokwenhloso, ukusebenza okuncane akuvumeli ukucutshungulwa kwedatha okubucayi ku-Tableau. Bona ngeso lengqondo, hlaziya, yebo. Kodwa kumabhizinisi amancane naphakathi nendawo, ukudala isitoreji esihlukene kuvame ukuba yinkinga. Ngabe ngehlise amaphuzu ku-Tableau, uma kungenjalo ngenxa yesici sabo esi-1. Iseva ye-Tableau ithumela kalula ama-imeyili ahleliwe ane-CSV noma okunamathiselwe kwi-PDF. Ngaphezu kwalokho, ungasabalalisa amalungelo, izihlungi ezizenzakalelayo, njll. Ngesizathu esithile i-Power BI ne-Qlik azikwazi ukwenza lokhu, kodwa kwabanye kungase kube bucayi. Ngenxa yalokhu, i-Tableau inesikhundla engxabanweni yethu.

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 17. Ukubukeka kwephaneli yokulawula iseva ye-Tableau

Futhi endaweni yebhizinisi, udinga ukucabanga ngezindleko zokuqaliswa nokugcinwa. E-Russia, umkhuba uthuthukile ukuthi i-Power BI ivame kakhulu emabhizinisini amancane. Lokhu kuholele ekuveleni kwenani elikhulu lezikhala zezikhala kanye nokuqala kabusha, kanye nokuvela kwabadidiyeli abancane. Lokhu kuzokuvumela ukuthi uthole ochwepheshe bephrojekthi encane. Kodwa cishe, bonke ngeke babe nolwazi ekusetshenzisweni okukhulu nokusebenza ngedatha enkulu. U-Qlik no-Tableau baphambene. Kukhona ozakwethu abambalwa be-Qlik, kanye nozakwethu abambalwa be-Tableau. Laba ozakwethu basebenza ngokukhethekile ekusetshenzisweni okukhulu ngokuhlola okumaphakathi okukhulu. Azikho izikhala eziningi futhi ziqala kabusha emakethe; isithiyo sokungena kule mikhiqizo sinzima kakhulu kune-Power BI. Kodwa e-Russia kukhona ukuqaliswa ngempumelelo kwale mikhiqizo ezinkulungwaneni zabasebenzisi, futhi le mikhiqizo yenza kahle kudatha enkulu. Udinga nje ukuqonda amandla kanye nobuthakathaka bemikhiqizo njengoba isebenza ngqo ebhizinisini lakho.

6. Ukusekelwa kwamadivayisi eselula.

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)

Kulesi sigaba sizogqamisa i-Power BI ne-Tableau. Ungafaka izinhlelo zokusebenza zeselula futhi zizobukeka zanele ezikrinini zamadivayisi eselula. Nakuba kubonakala kithi ukuthi izibalo kumadivayisi eselula zingaphansi kokuhlaziya kuma-PC. Noma kunjalo, akulula kangako ukusebenzisa izihlungi, izithombe zincane, izinombolo zinzima ukuzibona, njll.

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 18. Ukuvela kombiko we-Power BI ku-iPhone

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 19. Ukuvela kombiko wethebula ku-iPhone

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 20. Ukuvela kombiko we-Qlik Sense ku-iPhone

Kungani amaphuzu e-Qlik ehlisiwe? Ngezizathu esizaziyo, iklayenti leselula litholakala kuphela ku-iPhone; ku-Android kuzodingeka usebenzise isiphequluli esivamile. Futhi, uma usebenzisa i-Qlik, kufanele uqonde ngokushesha ukuthi Izandiso eziningi noma ukubonwa akuncishiswa noma izimoto zibekwe kumadivayisi eselula njengoba kulindelekile. Umbiko obukeka umuhle kakhulu ku-PC ubukeka kabi kakhulu esikrinini esincane. Kufanele wenze umbiko ohlukile wamadivayisi eselula, lapho ungasusa khona izihlungi, ama-KPI kanye nenani lezinye izinto. Lokhu kusebenza futhi ku-Power BI noma ku-Tableau, kodwa kubizwa ikakhulukazi ku-Qlik. Sithemba ukuthi i-Qlik izoqhubeka nokusebenza kuklayenti layo leselula.

Uma uhlela ukuchitha isikhathi esiningi wenza izibalo ezivela kumadivayisi eselula, khona-ke kunengqondo ukufaka wonke amaklayenti angu-3 futhi uhlole isibonisi sawo emibikweni yokuhlola. Noma yimuphi umthengisi unegalari yemibiko yokuhlola kuwebhusayithi yakhe ukuze ibuyekezwe.

7. Izibalo ezishumekiwe (ezakhelwe ngaphakathi) ezinhlelweni/kumasayithi ezinkampani zangaphandle

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)

Ukusebenzisa izibalo njengesevisi yenkampani yangaphandle akulula ngaso sonke isikhathi. Mhlawumbe uzakhela owakho umkhiqizo, kodwa awukakalungeli ukuthuthukisa injini yokubona ngeso lengqondo kusukela ekuqaleni. Mhlawumbe ufuna ukufaka ama-analytics kuwebhusayithi yakho ukuze iklayenti lizibhalise, lilayishe idatha yalo futhi lenze ukuhlaziya ngaphakathi kwe-akhawunti yalo yomuntu siqu. Ukuze wenze lokhu, udinga ukuhlaziya okwakhelwe ngaphakathi (Kushunyekiwe).
Yonke imikhiqizo ikuvumela ukuthi wenze lokhu, kodwa kulesi sigaba sizogqamisa i-Qlik.

I-Power Bi ne-Tableau zisho ngokucacile ukuthi ngezinjongo ezinjalo udinga ukuthenga i-Tableau Embedded Analytics ehlukile noma umkhiqizo Oshumekiwe we-Power BI. Lezi akuzona izixazululo ezishibhile ezibiza izinkulungwane zamaRandi ngenyanga, ezinciphisa ngokushesha ukusetshenziswa kwazo. Amaphrojekthi amaningi ngokushesha angabi nanzuzo kumakhasimende ethu. Lokhu kusho ukuthi awudingi nje ukushicilela umbiko kuyo yonke i-inthanethi, kodwa ukuqinisekisa ukuthi imibiko ishicilelwa ngokuvumelana nokufinyelela okuthile, ngokuvikelwa kwedatha, ukugunyazwa komsebenzisi, njll.

Futhi i-Qlik izokuvumela ukuthi uphume. Yebo, futhi bane-Qlik Analytics Platform, enelayisensi ngeseva ngayinye futhi ihlela inombolo engenamkhawulo yokuxhumana. Kuzobiza futhi njengezimbangi i-Tableau ne-Power Bi. Futhi esimweni sokuxhumeka okungenamkhawulo, azikho izinketho eziningi.

Kodwa kwaQlik kunento ebizwa ngeMashup. Ake sithi unamalayisensi e-Qlik Sense Enterprise namalayisense ayi-10. Izibalo ezijwayelekile, ukubukeka, yonke into isivele iyisicefe. Wakha iwebhusayithi yakho noma uhlelo lokusebenza, futhi ungasebenzisa zonke izibalo zakho khona lapho. Iqhinga liwukuthi, ukuyibeka kalula, i-Mashup iwukubona ngeso lengqondo ikhodi yohlelo. Usebenzisa i-API, ungakha ngokohlelo ukubonwa ngaphakathi kwesicelo sakho noma iwebhusayithi. Usazodinga i-Qlik Sense Enterprise ukuze uthole amalayisense (amalayisensi okuxhumana kwesayithi = amalayisense okuxhumeka ku-BI), ukuze ulayishe idatha, njll., kodwa okubukwayo ngeke kusaboniswa ohlangothini lwalesi siphakeli, kodwa kuzokwakhelwa kuwe. isicelo noma iwebhusayithi. Ungasebenzisa izitayela ze-CSS, usethe amafonti amasha nemibala. Abasebenzisi bakho abayi-10 ngeke besangena kuseva yezibalo, kodwa bazosebenzisa iphothali yakho yebhizinisi noma uhlelo lokusebenza. Izibalo zizofinyelela izinga elisha.

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)
Umfanekiso 21. Ukuvela kombiko we-Qlik Sense oshunyekwe kusizindalwazi

Kuzoba nzima ukuqonda ukuthi izinto zesayithi ziphi nokuthi i-Qlik Sense iqala kuphi.
Vele, uzodinga umklami, noma okungenzeka ukuthi ambalwa. Eyodwa eyokuhlela iwebhu, eyokusebenza ne-Qlik API. Kodwa umphumela kuwufanele.

Iziphetho. Ake sifingqe.

Umehluko wobuchwepheshe wezinhlelo ze-BI (Power BI, Qlik Sense, Tableau)

Kunzima ukusho ngokungananazi ukuthi ubani ongcono nokuthi ubani omubi kakhulu. I-Power BI ne-Qlik ziyalingana emqhudelwaneni wethu, i-Tableau ingaphansi kancane. Kodwa mhlawumbe umphumela uzohluka ebhizinisini lakho. Kumapulatifomu e-BI, ingxenye ebonakalayo ibaluleke kakhulu. Uma ubheke inqwaba yemibiko yedemo nezithombe eziku-inthanethi zawo wonke amasistimu e-BI futhi ungathandi ukuthi enye yezinkundla ibukeka kanjani, cishe ngeke uyisebenzise, ​​noma ngabe wanelisekile ngenani noma ngobuchwepheshe. ukusekela. izici.

Okulandelayo, nakanjani uzodinga ukubala izindleko zamalayisense, ukuqaliswa kanye nokugcinwa kwesiteji se-BI. Mhlawumbe ecaleni lakho kuzobonakala umholi. Usonkontileka noma ikhono lokuqasha uchwepheshe ofanelekayo kubaluleke kakhulu. Ngaphandle kochwepheshe kunoma iyiphi inkundla, umphumela uzoba yinhlekelele.

Ukuhlanganiswa okuphumelelayo kwe-BI kuwe, u-Andrey Zhdanov no-Vladimir Lazarev, Iqembu le-Analytics

Source: www.habr.com

Engeza amazwana