Umahluko kwezobuchwephesha kwiinkqubo zeBI (Power BI, Qlik Sense, Tableau)

Ixesha elifunekayo lokufunda imizuzu eli-11

Thina kunye neGartner Square ka-2019 BI :)

Injongo yeli nqaku kukuthelekisa iiplatifti ezintathu eziphambili zeBI ezikwiinkokeli zeGartner quadrant:

-Power BI (Microsoft)
—Itheyibhile
—Qlik

Umzobo 1. Gartner BI Magic Quadrant 2019

Igama lam ngu-Andrey Zhdanov, ndiyintloko yesebe le-analytics kwi-Analytics Group (www.analyticsgroup.ru). Sakha iingxelo ezibonwayo kwintengiso, ukuthengisa, imali, izinto zokusebenza, ngamanye amazwi, sibandakanyeka kuhlalutyo lweshishini kunye nokubonwa kwedatha.

Mna noogxa bam besisebenza ngamaqonga ahlukeneyo e-BI iminyaka eliqela. Sinamava amahle kakhulu eprojekthi, esivumela ukuba siqhathanise amaqonga ukusuka kwindawo yokujonga abaphuhlisi, abahlalutyi, abasebenzisi beshishini kunye nabaphumezi beenkqubo zeBI.

Siya kuba nenqaku elahlukileyo ngokuthelekisa amaxabiso kunye noyilo olubonakalayo lwezi nkqubo ze-BI, ngoko apha siza kuzama ukuvavanya ezi nkqubo ukusuka kwindawo yokujonga umhlalutyi kunye nomphuhlisi.

Masiqaqambise iindawo ezininzi zohlalutyo kwaye sizivavanye sisebenzisa inkqubo enamanqaku ama-3:

- Umda wokungena kunye neemfuno zomhlalutyi;
- Imithombo yedatha;
-Ukucocwa kwedatha, i-ETL (Isicatshulwa, iTshintsho, uMlayisho)
-Imibono kunye nophuhliso
- Indawo yenkampani - iseva, iingxelo
- Inkxaso yezixhobo eziphathwayo
- I-embedded (eyakhelwe ngaphakathi) i-analytics kwizicelo zomntu wesithathu / iindawo

1. Umda wokungena kunye neemfuno zomhlalutyi

Amandla eBI

Ndibone uninzi lwabasebenzisi be-Power BI ababengengabo abachwephesha be-IT kodwa banokwenza ingxelo entle kakhulu. I-Power BI isebenzisa ulwimi lombuzo olufanayo njenge-Excel - Umbuzo wamandla kunye nolwimi lwefomula ye-DAX. Abahlalutyi abaninzi bayayazi i-Excel kakuhle, ke ukutshintshela kule nkqubo ye-BI kulula kakhulu kubo.

Iintshukumo ezininzi zilula ukwenza kumhleli wombuzo. Kwaye kukho umhleli ophambili onolwimi lwe-M lweengcali.

Umzobo 2. Power BI Umbuzo Umakhi

Ingqondo yeQlik

I-Qlik Sense ibonakala inobungane kakhulu - inani elincinci lezicwangciso, amandla okukhawuleza ukwenza ingxelo, ungasebenzisa umyili womthwalo wedatha.

Ekuqaleni kubonakala kulula kunePower BI kunye neTafile. Kodwa ukusuka kumava ndiya kuthetha ukuba emva kwexesha, xa umhlalutyi edala isibini seengxelo ezilula kwaye ufuna into enzima ngakumbi, uya kujongana nesidingo sokucwangcisa.

I-Qlik inolwimi olunamandla kakhulu lokulayisha kunye nokucubungula idatha. Inolwimi lwayo lwefomula, Seta uhlalutyo. Ngoko ke, umhlalutyi kufuneka akwazi ukubhala imibuzo kunye nokudibanisa, ukubeka idatha kwiitheyibhile ezibonakalayo, kwaye asebenzise ngokusebenzayo iinguqu. Izakhono zolwimi zibanzi kakhulu, kodwa kuya kufuna ukufunda. Mhlawumbi bonke abahlalutyi beQlik endibaziyo banohlobo oluthile lwemvelaphi ye-IT enzulu.

Abahlanganisi be-Qlik, njengathi, bahlala bethanda ukuthetha ngemodeli yokudibanisa, xa xa ulayisha idatha, yonke into ifakwe kwi-RAM, kwaye uxhulumaniso phakathi kwedatha lwenziwa ngumatshini wangaphakathi weqonga. Ukuba xa ukhetha amaxabiso, ii-subqueries zangaphakathi ayenziwa, njengakwisiseko sedatha sakudala. Idatha ibonelelwa ngoko nangoko ngenxa yamaxabiso afakwe ngaphambili kunye nobudlelwane.

Kuyinyani, ekusebenzeni oku kukhokelela ekudaleni ukudibanisa kwetafile ezenzekelayo xa amagama entsimi ehambelana. Umzekelo, awukwazi ukuba neetafile ezahlukeneyo ngaphandle kobudlelwane obuya kuba nentsimi efanayo. Kufuneka uqhelane nale nto. Kufuneka nokuba uthiye ngokutsha imiqolo kwaye uqinisekise ukuba amagama awahambelani, okanye udibanise zonke iitheyibhile zenyani kwenye kwaye uzirhangqe ngoluhlu lwenkwenkwezi. Mhlawumbi kulungele abaqalayo, kodwa kubahlalutyi abanamava akunandaba.

Ujongano oluqhelekileyo lokulayisha kunye nokucubungula idatha yomhlalutyi ijongeka ngolu hlobo.

Umzobo 3. Qlik Sense umhleli womthwalo wedatha, Itafile yeKhalenda

Qaphela: Kwi-Power BI imeko idla ngokubukeka ngokwahlukileyo, ushiya iitafile ezahlukeneyo zeenyani kunye neereferensi, ungazibandakanya ngesandla iitafile ngendlela yakudala, okt. Ndithelekisa iikholomu komnye nomnye ngesandla.

itheyibhile

Abaphuhlisi babeka i-Tableau njenge-BI ene-interface efanelekileyo kunye neyobuhlobo eya kuvumela umhlalutyi ukuba afunde ngokuzimeleyo idatha yabo. Ewe, kwinkampani yethu kwakukho abahlalutyi abathi, ngaphandle kwamava e-IT, banokwenza iingxelo zabo. Kodwa ndiza kuthoba ukalisho lwam lweTafile ngenxa yezizathu ezininzi:
-Indawo ebuthathaka ngolwimi lwesiRashiya
- Iiseva ezikwi-Intanethi azikho kwi-Russian Federation
— Umakhi womthwalo olula ngokufanelekileyo uqala ukubangela iingxaki xa ufuna ukwakha imodeli yedatha entsonkothileyo.

Umzobo 4. Itheyibhile yoMlayishi weDatha umakhi

Omnye wemibuzo esiyibuza abahlalutyi beTableau ngexesha lodliwano-ndlebe kukuba "Uyakha njani imodeli yeetheyibhile zeenyani kunye neetafile zereferensi ngaphandle kokubeka yonke into kwitafile enye?!" Ukudityaniswa kweDatha kufuna ukusetyenziswa okucingisisiweyo. Ndizilungisile iimpazamo zokuphindaphinda idatha kumaxesha amaninzi phakathi kwabahlalutyi bam emva kokudityaniswa okunjalo.

Ngaphezu koko, iTheyibhile inenkqubo ekhethekileyo, apho wenza itshathi nganye kwiPhepha elahlukileyo, kwaye emva koko udale iDashboard, apho uqala khona ukubeka amaphepha adaliweyo. Emva koko unokwenza iBali, le yindibaniselwano yeeDashboards ezahlukeneyo. Uphuhliso kwi-Qlik kunye ne-Power BI ilula kulo mba; ngokukhawuleza ubeka iitemplates zegrafu kwiphepha, imilinganiselo yokumisela kunye nemilinganiselo, kwaye iDashboard ilungile. Kum kubonakala ngathi iindleko zabasebenzi zokulungiselela eTable ziyanda ngenxa yoku.

2. Imithombo yedatha kunye nokukhuphela

Akukho ophumeleleyo ucacileyo kweli candelo, kodwa siza kuqaqambisa iQlik ngenxa yezinto ezimbalwa ezintle.

Itheyibhile kwinguqulelo yasimahla ikhawulelwe kwimithombo, kodwa kumanqaku ethu sijolise ngakumbi kwishishini, kwaye amashishini angakwazi ukuthenga iimveliso zorhwebo kunye nabahlalutyi. Ke ngoko, iTheyibhile ayikhange ithobe ukukala kwayo kule parameter.

Umzobo 5. Uluhlu lwemithombo enokubakho kwiThebhile

Kungenjalo, uluhlu lwemithombo lunomtsalane kuyo yonke indawo - zonke iifayile zetafile, zonke iziseko zolwazi ezisemgangathweni, uqhagamshelo lwewebhu, yonke into isebenza kuyo yonke indawo. Andizange ndidibane nokugcinwa kwedatha engekho-standard, banokuba ne-nuances yabo, kodwa kwiimeko ezininzi awuyi kuba neengxaki zokulayisha idatha. Kuphela ngaphandle kwe-1C. Akukho ziqhagamshelo ngqo kwi-1C.

Amaqabane e-Qlik eRashiya athengisa iziqhagamshelo zabo kwi-100 - 000 ye-ruble, kodwa kwiimeko ezininzi kubiza kakhulu ukwenza ukulayisha kwi-200C ukuya kwi-FTP ukuya kwi-Excel okanye i-database ye-SQL. Okanye unokushicilela i-database ye-000C kwiwebhu kwaye uqhagamshele kuyo usebenzisa i-Odata protocol.

I-PowerBI kunye neTableau inokwenza oku njengomgangatho, kodwa i-Qlik iya kucela umdibaniso ohlawulelwayo, ngoko ke kulula ukuyilayisha kwi-database ephakathi. Kwimeko nayiphi na into, yonke imiba yoxhulumaniso ingasonjululwa.

Umzobo 6. Uluhlu lwemithombo ye-Qlik Sense enokwenzeka

Ukongezelela, kuyafaneleka ukuba uqaphele inqaku le-Qlik ukuba babonelela ngokuhlawulelwa kunye neziqhagamshelo zamahhala njengemveliso eyahlukileyo.

Umzobo 7. Izixhumi ezongezelelweyo ze-Qlik Sense

Ngokusuka kumava, ndiya kongeza ukuba ngemithamo emikhulu yedatha okanye imithombo emininzi, akusoloko kucetyiswa ukuba udibanise ngokukhawuleza inkqubo ye-BI. Iiprojekthi ezinzulu zihlala zisebenzisa indawo yokugcina idatha, isiseko sedatha esele ilungiselelwe ukuhlalutya, njl. Awunakuthatha kwaye ulayishe, yithi, iirekhodi ezibhiliyoni ezi-1 kwinkqubo ye-BI. Apha sele kufuneka ucinge ngoyilo lwesisombululo.


Umzobo 8. Imithombo yedatha ye-BI yamandla

Kodwa kwakutheni ukuze uQlik akhethwe? Ndizithanda kakhulu izinto ezi-3:
- Iifayile ze-QVD
Ifomathi yokugcinwa kwedatha eyakhe. Ngamanye amaxesha kunokwenzeka ukwakha iiprojekthi ezinzulu zorhwebo kuphela kwiifayile ze-QVD. Umzekelo, inqanaba lokuqala yidatha ekrwada. Inqanaba lesibini licutshungulwa iifayile. Inqanaba lesithathu yidatha ehlanganisiweyo, njl. Ezi fayile zinokusetyenziswa kwizicelo ezahlukeneyo, kwaye abasebenzi kunye neenkonzo ezahlukeneyo banokuba noxanduva kuzo. Isantya sokukhuphela kwiifayile ezinjalo siphindwe kashumi ngokukhawuleza kunemithombo yedatha eqhelekileyo. Oku kukuvumela ukuba ugcine iindleko zedatha kwaye wabelane ngolwazi phakathi kwezicelo ezahlukeneyo ze-Qlik.

-Ukufakwa kwedatha okongeziweyo
Ewe, iPower BI kunye neTableau zinokwenza oku nazo. Kodwa i-Power BI ifuna i-Premium version ebiza kakhulu, kwaye i-Tableau ayinayo uguquko lwe-Qlik. KwiQlik, usebenzisa iifayile zeQVD, unokwenza izifinyezo zeenkqubo ngamaxesha ahlukeneyo kwaye emva koko usebenze le datha njengoko uthanda.

— Ukuqhagamshela imibhalo yangaphandle
Ukongeza kwiifayile ze-QVD zokugcina idatha, kwi-Qlik ikhowudi yeskripthi nayo ingathathwa ngaphandle kwesicelo kwaye ifakwe kunye nomyalelo Faka. Oku sele kukuvumela ukuba uququzelele umsebenzi weqela, usebenzise iinkqubo zolawulo lwenguqulelo, kwaye ulawule ikhowudi enye yezicelo ezahlukeneyo. I-Power BI inomhleli wombuzo ophezulu, kodwa asikwazanga ukuseta umsebenzi weqela njengakwiQlik. Ngokubanzi, zonke i-BI zineengxaki ngale nto; akunakwenzeka ukulawula idatha ngaxeshanye, ikhowudi, kunye nokubonwayo kuzo zonke izicelo ezisuka kwindawo enye. Eyona nto sakwazi ukuyenza kukukhupha iifayile zeQVD kunye nekhowudi yeskripthi. Izinto ezibonwayo kufuneka zihlelwe ngaphakathi kweengxelo ngokwazo, ezingasivumeli ukuba sitshintshe kakhulu imbonakalo yabo bonke abathengi ngaxeshanye.

Kodwa kuthekani ngesixhobo esinje ngoQhagamshelwano lweLive? Itheyibhile kunye ne-Power BI ixhasa unxibelelwano LIVE kuluhlu lwemithombo, ngokungafaniyo neQlik. Asinamdla kweli nqaku, kuba... ukuziqhelanisa kubonisa ukuba xa kufikwa kwidatha enkulu, ukusebenza ngonxibelelwano LIVE kuba yinto engenakwenzeka. Kwaye i-BI kwiimeko ezininzi iyadingeka kwidatha enkulu.

3. Ukucoca idatha, i-ETL (I-Extract, Transform, Load)

Kweli candelo ndineenkokeli ze-2, i-Qlik Sense kunye ne-Power Bi.
Masithi iQlik inamandla kodwa intsonkothile. Nje ukuba uqonde ulwimi lwabo olufana ne-SQL, unokwenza phantse yonke into - iitafile ezinenyani, ukudibanisa kunye nokudityaniswa kweetafile, ujikeleze itafile kwaye uvelise iitafile ezintsha, iqela lemiyalelo yokucwangcisa imiqolo. Ngokomzekelo, intsimi kwi-1 iseli ezaliswe yidatha efana ne-"Ivanov 851 Bely" kwi-fly ingachithwa kuphela kwiikholomu ezi-3 (njengoko wonke umntu enokukwenza), kodwa nakwimigqa ye-3 kanye, umzekelo. Kwakhona kulula ukwenza into efanayo kwi-fly: ukudibanisa imigca emi-3 ku-1.

Umzobo 9. Indlela yokulayisha kunye nokuguqula itafile kwi-Qlik Sense ukusuka kwi-Google Sheets

I-Power BI ibonakala ilula kulo mba, kodwa uninzi lweengxaki zinokusonjululwa ngokulula ngomyili wemibuzo. Ndibeka inani leeparitha, ndigqithise itafile, ndasebenza kwidatha, kwaye konke oku ngaphandle komgca omnye wekhowudi.

Umzobo 10. Uyilayisha njani kwaye uguqule itafile kwi-Power BI esuka kwi-AmoCRM

Itheyibhile ibonakala kum inembono eyahlukileyo. Zininzi malunga nobuhle kunye noyilo. Kubonakala kunzima kakhulu ukudibanisa iqela lemithombo eyahlukeneyo, ukudibanisa yonke kunye nokuyiqhuba ngaphakathi kwiThebhile. Kwiiprojekthi zorhwebo, kwiimeko ezininzi, idatha sele ilungisiwe kwaye iqokelelwe kwi-Tableau kwiindawo zokugcina kunye neenkcukacha.

Umfanekiso 11. Uyilayisha njani kwaye uyitshintshe njani itafile kwiThebhile

4. Izinto ezibonakalayo

Kweli candelo asikhange sibalule inkokeli. Siza kuba nenqaku elahlukileyo apho, sisebenzisa umzekelo wemeko enye, siya kubonisa ingxelo efanayo kuzo zonke iinkqubo ze-3 (Inqaku elithi "Uhlalutyo lwamantombazana anoxanduva oluphantsi loluntu"). Yinto ngakumbi umcimbi incasa kunye nobuchule umhlalutyi. Kwi-Intanethi unokufumana imifanekiso emihle kakhulu eyakhiwe ngesiseko sayo nayiphi na yezi nkqubo. Amandla okubona okusisiseko aphantse afane kuye wonke umntu. Eminye isonjululwe kusetyenziswa i-Extensons. Kukho ezihlawulelwayo nezisimahla. Kukho izandiso ezivela kubathengisi ngokwabo, kunye nakwi-freelancers kunye nabadibanisi. Ungabhala eyakho isandiso sokubonwayo kulo naliphi na iqonga.

Ndiyasithanda isitayile sikaTableau, ndicinga ukuba singqongqo kwaye sihlangene. Kodwa ukufumana umfanekiso omhle ngokwenene eTableau kunzima. Umzekelo ogqwesileyo wokubonwa kweTafile usebenzisa izandiso kuphela. Andizukwazi ukuphinda oku, kuba... Andinazo ezi zandiso, kodwa zikhangeleka zintle.

Umfanekiso 12. Imbonakalo yoludwe lweengxelo kunye noLwandiso

Amandla BI anokwenziwa umdla.

Umfanekiso 13. Inkangeleko yengxelo yoLwandiso lwePower Bic

Ekuphela kwento endingayiqondiyo malunga ne-Power BI kukuba kutheni benemibala engaqhelekanga engagqibekanga. Kuyo nayiphi na itshathi, ndinyanzelekile ukuba nditshintshe umbala kwi-brand yam, yenkampani kwaye ndothuswa ngumbala oqhelekileyo.

I-Qlik Sense ikwaxhomekeke kwiZandiso. Ukusebenzisa izongezo kunokutshintsha iingxelo ngaphaya kokuqatshelwa. Unokongeza owakho umxholo kunye noyilo.

Umzobo 14. Ukubonakala kweengxelo ze-Qlik Sense kunye neZandiso

Ukusuka kwimbono yomphuhlisi, ndikhetha iQlik Sense ngenxa yeenketho eziqhelekileyo ezifana nemilinganiselo kunye nemilinganiselo. Unokuseta imilinganiselo emininzi kunye nemilinganiselo kwimimiselo yokujonga, kwaye umsebenzisi unokuseta ngokulula oko kufuneka ajonge kwitshathi ethile.

Kwi-Power Bi kunye neTableau, kufuneka ndiqwalasele iiparameters, amaqhosha, inkqubo yokuziphatha kwenkqubo ngokuxhomekeke kwezi parameters. I wonder kutheni kunzima kangaka. Into efanayo kunye nokukwazi ukutshintsha uhlobo lwe-villization.

Kwi-Qlik unokufihla iintlobo ezahlukeneyo zokubonwayo kwinto enye, kodwa kwi-Power BI kunye neTableau oku kunzima ngakumbi. Kwakhona, oku kuxhomekeke ngakumbi kubuchule bomdlali. Unokwenza umzobo wobugcisa kuyo nayiphi na inkqubo, kodwa ngaphandle kwamava uya kuphelela kwigraphics ezingabonakaliyo kuyo yonke indawo.

5. Ubume benkampani - iseva, iingxelo

Zonke iimveliso zineenguqulelo zeseva yenkampani. Ndisebenze ngazo zonke iintlelo kwaye ndingatsho ukuba zonke zinamandla kunye nobuthathaka. Ukukhethwa kwemveliso kufuneka kusekwe kwiimfuno zakho zesoftware, kuthathelwa ingqalelo ama-nuances abo. Bonke abathengisi banokunika amalungelo omabini kwinqanaba le-akhawunti kunye neqela, nakwiNqanaba loKhuseleko lweNqanaba leDatha. Uhlaziyo oluzenzekelayo lweengxelo kwishedyuli luyafumaneka.

I-Qlik Sense Enterprise lithuba elihle lokwakha uhlalutyo ngaphakathi kwintlangano yakho kumashishini aphakathi. Oku kunokubonakala kubiza kakhulu kunePower BI Pro, kodwa ungalibali ukuba iiseva zePower BI Pro zibekwe efini kumhlaba weMicrosoft kwaye awunakuphembelela ukusebenza, kwaye xa ufuna iPower BI Premium, enokubekwa kwiiseva zakho, ke ixabiso liqala ukusuka $5000 ngenyanga.

I-Qlik Sense Enterprise iqala kwi-RUB 230. kuba 000 iilayisensi (umrhumo ngonyaka, ke kuphela inkxaso yobugcisa), efikelelekayo kakhulu ngaphezu Power BI Premium. Kwaye iQlik Sense Enterprise iya kukuvumela ukuba usebenzise bonke ubunakho beQlik. Mhlawumbi ngaphandle komnye. Ngesizathu esithile, u-Qlik wagqiba kwelokuba into efana namandla okuthumela iingxelo ze-PDF nge-imeyile kufuneka inikezelwe njengenkonzo eyahlukileyo yoShicilelo.

Kodwa iQlik Sense Enterprise inamandla ngakumbi kunePower BI Pro kwaye ke uthelekiso olulandelayo lunokwenziwa.

I-Qlik Sense Enterprise = I-Power BI Premium, enobuchule obulinganayo ijika ibe nexabiso eliphantsi ekuphunyezweni okuphakathi. Ukuphunyezwa okukhulu ngokuqhelekileyo kubalwa kwicala lomthengisi, apho banokubonelela ngeemeko zomntu ngamnye kwinkampani yakho.

Kulo mba, siya kunika ukhetho kwiQlik Sense Enterprise, inawo onke amathuba okwakha i-analytics enzulu kwidatha enkulu. Ngokombono wethu, i-Qlik iya kusebenza ngokukhawuleza kune-Power BI kwii-arrays ezinkulu; kwiinkomfa ze-Qlik sadibana nabathengi abaqale bavavanya idatha yabo kwiibhiliyoni zeerekhodi kunye ne-Power BI ibonise iziphumo ezimbi.

Umzobo 15. Imbonakalo yeengxelo zeseva yeQlik Sense Enterprise

Qlik Sense Cloud = Power BI Pro. I-Qlik Sense Cloud ijika ibe ngamaxesha e-1.5 ebiza kakhulu * kwaye kukho umda obaluleke kakhulu ukuba eli qonga alisivumeli. Awukwazi ukusebenzisa Izandiso, kwanezo zakhelwe ngaphakathi. Kwaye ngaphandle kwezandiso, i-Qlik ilahlekelwa bubuhle bayo obubonakalayo.

Umzobo 16. Ukubonakala kwephaneli yokulawula ye-Power BI Pro

*Enye indlela kukusebenzisa umrhumo weQlik Sense Enterprise. Kodwa ukuze eli nqaku lingabonakali njengentengiso, asiyi kugubungela amaxabiso ethu

Kwaye iTableau ime kancinane ecaleni kwethu. Bobabini banemirhumo yefu ye-$ 70 ngomphuhlisi kunye ne-$ 15 ngombono ngamnye, kunye nezisombululo zeseva ezibizayo. Kodwa imbono ephambili yeTableau kukuba kwidatha enkulu kufuneka uququzelele ukusetyenzwa kwedatha kunye nokugcinwa ecaleni. Ngenjongo, ukusebenza okuncinci akuvumeli ukusetyenzwa kwedatha enzulu kwiThebhile. Yiba nombono, hlalutya, ewe. Kodwa kumashishini amancinci naphakathi, ukudala indawo yokugcina eyahlukileyo kuhlala kuyingxaki. Ngendilehlile inqaku leTheyibhile ke ngoko, ukuba ibingeyonto yabo i-1. Iseva ye-Tableau ithumela ngaphandle komthungo ii-imeyile ezicwangcisiweyo kunye ne-CSV okanye i-PDF encamatheleyo. Ngaphezu koko, unokusasaza amalungelo, izihluzi ezizenzekelayo, njl. Ngesizathu esithile i-Power BI kunye ne-Qlik ayinakuyenza le nto, kodwa kwabanye ingabaluleka. Ngenxa yoku, iTableau ibambe isikhundla kwingxabano yethu.

Umzobo 17. Imbonakalo yepaneli yolawulo lweSiva yeTheyibhile

Kwakhona kwindawo yenkampani, kufuneka ucinge ngeendleko zokuphunyezwa kunye nokugcinwa. ERashiya, umkhuba uphuhlise ukuba i-Power BI ixhaphake kakhulu kumashishini amancinci. Oku kwakhokelela ekuveleni kwenani elikhulu lezithuba kunye nokuqala kwakhona, kunye nokuvela kwabadibanisi abancinci. Oku kuya kukuvumela ukuba ufumane iingcali zeprojekthi encinci. Kodwa kunokwenzeka ukuba, bonke abayi kuba namava ekuphunyezweni okukhulu kunye nokusebenza ngedatha enkulu. I-Qlik kunye neTableau zichasene. Bambalwa amaqabane e-Qlik, kwaye bambalwa namaqabane e-Tableau. La maqabane asebenza ngokukhethekileyo ekuphunyezweni okukhulu kunye netshekhi ephakathi enkulu. Akukho zithuba zininzi kwaye ziqala kwakhona kwimarike; umqobo wokungena kwezi mveliso unzima ngakumbi kunePower BI. Kodwa eRashiya kukho ukuphunyezwa ngempumelelo kwezi mveliso kumawaka abasebenzisi, kwaye ezi mveliso ziqhuba kakuhle kwiidatha ezinkulu. Kufuneka nje uqonde amandla kunye nobuthathaka beemveliso njengoko zisebenza ngokuthe ngqo kwishishini lakho.

6. Inkxaso yezixhobo eziphathwayo.

Kweli candelo siza kugxininisa i-Power BI kunye neTableau. Ungafaka usetyenziso oluphathwayo kwaye ziya kujongeka zanele kwizikrini zezixhobo eziphathwayo. Nangona kubonakala ngathi i-analytics kwizixhobo eziphathwayo zingaphantsi kuhlalutyo kwiiPC. Sekunjalo, akulula kangako ukusebenzisa izihluzi, imifanekiso incinci, amanani anzima ukubonwa, njl.

Umzobo 18. Ukubonakala kwengxelo ye-Power BI kwi-iPhone

Umzobo 19. Imbonakalo yengxelo yeTheyibhile kwi-iPhone

Umzobo 20. Ukubonakala kwengxelo yeQlik Sense kwi-iPhone

Kwakutheni ukuze kuthotywe amanqaku eQlik? Ngezizathu esingazaziyo, umxhasi weselula ufumaneka kuphela kwi-iPhone; kwi-Android kuya kufuneka usebenzise isikhangeli esiqhelekileyo. Ngaphezu koko, xa usebenzisa i-Qlik, ngoko nangoko kufuneka uqonde ukuba inani leZandiso okanye iimboniso azincitshiswanga okanye iimoto zibekwe kwizixhobo eziphathwayo njengoko kulindelwe. Ingxelo ekhangeleka intle kakhulu kwiPC ibonakala imbi kakhulu kwiscreen esincinci. Kuya kufuneka wenze ingxelo eyahlukileyo yezixhobo eziphathwayo, apho unokususa izihlungi, ii-KPI kunye nenani lezinye izinto. Oku kusebenza nakwi-Power BI okanye kwiTableau, kodwa ichazwa ngakumbi kwiQlik. Siyathemba ukuba iQlik iya kuqhubeka nokusebenza kumxhasi wayo weselula.

Ukuba uceba ukuchitha ixesha elininzi uqhuba i-analytics kwizixhobo eziphathwayo, ngoko kunengqiqo ukufaka bonke abathengi be-3 kwaye ukhangele umboniso wabo kwiingxelo zovavanyo. Nawuphi na umthengisi unegalari yeengxelo zovavanyo kwiwebhusayithi yakhe ukuze ihlaziywe.

7. I-Embedded (eyakhelwe ngaphakathi) i-analytics kwizicelo zomntu wesithathu / iisayithi

Ukusebenzisa uhlalutyo njengenkonzo yomntu wesithathu akusoloko kulula. Mhlawumbi uphuhlisa imveliso yakho, kodwa awukakulungeli ukuphuhlisa i-injini yokubona kunye nohlalutyo ukusuka ekuqaleni. Mhlawumbi ufuna ukuhambisa i-analytics kwiwebhusayithi yakho ukuze umxhasi azibhalise ngokwakhe, alayishe idatha yakhe kwaye enze uhlalutyo ngaphakathi kweakhawunti yakhe. Ukwenza oku, udinga i-analytics eyakhelwe-ngaphakathi (Embedded).
Zonke iimveliso zikuvumela ukuba wenze oku, kodwa kolu didi siza kuqaqambisa iQlik.

I-Power Bi kunye neTable zitsho ngokucacileyo ukuba ngeenjongo ezinjalo kufuneka uthenge i-Tableau Embedded Analytics eyahlukileyo okanye i-Power BI Embedded product. Ezi ayizozisombululo ezincinci ezixabisa amawaka eedola ngenyanga, nto leyo enciphisa ngokukhawuleza ukusetyenziswa kwazo. Uninzi lweeprojekthi zikhawuleza zingabi nangeniso kubathengi bethu. Oku kuthetha ukuba awudingi nje ukupapasha ingxelo kwi-Intanethi yonke, kodwa ukuqinisekisa ukuba iingxelo zipapashwa ngokufikelela okuthile, ngokukhuselwa kwedatha, ukugunyazwa komsebenzisi, njl.

Kwaye uQlik uya kukuvumela ukuba uphume. Ngokuqinisekileyo, banayo iQlik Analytics Platform, enelayisensi kwiseva nganye kwaye iququzelele inani elingenamkhawulo lokudibanisa. Iya kuxabisa kakhulu njengabo bakhuphisana nabo kwiTableau kunye nePower Bi. Kwaye kwimeko yoqhagamshelwano olungenamkhawulo, akukho zikhetho ezininzi.

Kodwa kwaQlik kukho into ekuthiwa yiMashup. Masithi uneQlik Sense Enterprise kunye neelayisensi ezili-10. Uhlalutyo olusemgangathweni, imbonakalo, yonke into sele ikruqukile. Wakha iwebhusayithi yakho okanye isicelo, kwaye unokuphumeza zonke ii-analytics zakho apho. Iqhinga kukuba, ukuyibeka ngokulula, iMashup yimbonakalo yekhowudi yenkqubo. Ukusebenzisa i-API, unokwenza ngokwenkqubo umboniso ngaphakathi kwesicelo sakho okanye iwebhusayithi. Uzakufuna iQlik Sense Enterprise yokunika ilayisenisi (iilayisensi zoqhagamshelo lwesiza = iilayisenisi zokudityaniswa kweBI), ukulayisha idatha, njl., kodwa ukubonwa akusayi kuphinda kuboniswe kwicala lalo mncedisi, kodwa kuya kwakhiwa kwindawo yakho. isicelo okanye iwebhusayithi. Unokusebenzisa izimbo zeCSS, seta iifonti ezintsha kunye nemibala. Abasebenzisi bakho be-10 abasayi kuphinda bangene kwiseva yohlalutyo, kodwa baya kusebenzisa i-portal yakho yenkampani okanye isicelo. Uhlalutyo luya kufikelela kwinqanaba elitsha.

Umzobo 21. Imbonakalo yengxelo yeQlik Sense efakwe kwiwebhusayithi

Kuya kuba nzima ukuqonda ukuba ziphi iindawo zesayithi kunye nalapho i-Qlik Sense iqala khona.
Ewe kunjalo, uya kufuna umdwelisi wenkqubo, okanye nokuba zininzi ngakumbi. Enye yenkqubo yewebhu, enye yokusebenza neQlik API. Kodwa umphumo ufanelekile.

Izigqibo. Makhe sishwankathele.

Kunzima ukuthetha ngokungathandabuzekiyo ukuba ngubani ongcono kwaye ngubani ombi. IPower BI kunye neQlik ziyalingana kukhuphiswano lwethu, iTableau ingaphantsi kancinci. Kodwa mhlawumbi umphumo uya kwahluka kwishishini lakho. Kwiiplatifti ze-BI, icandelo elibonakalayo libaluleke kakhulu. Ukuba ujonge uninzi lweengxelo zeedemo kunye nemifanekiso kwi-Intanethi kuzo zonke iinkqubo ze-BI kwaye awuyithandi indlela enye yamaqonga ajongeka ngayo, ngokuqinisekileyo awuyi kuyiphumeza, nokuba wanelisekile lixabiso okanye ubugcisa. inkxaso. iimpawu.

Okulandelayo, ngokuqinisekileyo kuya kufuneka ukubala iindleko zeelayisensi, ukuphunyezwa kunye nokugcinwa kweqonga le-BI. Mhlawumbi kwimeko yakho kuya kuchongwa inkokeli. Ikontraki okanye ukukwazi ukuqesha ingcali efanelekileyo kubaluleke kakhulu. Ngaphandle kweengcali kulo naliphi na iqonga, umphumo uya kuba yintlekele.

Ukudityaniswa okuphumeleleyo kwe-BI kuwe, uAndrey Zhdanov kunye noVladimir Lazarev, iQela loHlaziyo

umthombo: www.habr.com