{"id":30060,"date":"2019-10-31T21:33:27","date_gmt":"2019-10-31T18:33:27","guid":{"rendered":"https:\/\/prohoster.info\/blog\/tehnicheskie-otlichiya-bi-sistem-power-bi-qlik-sense-tableau\/"},"modified":"2019-10-31T21:33:27","modified_gmt":"2019-10-31T18:33:27","slug":"tehnicheskie-otlichiya-bi-sistem-power-bi-qlik-sense-tableau","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/tehnicheskie-otlichiya-bi-sistem-power-bi-qlik-sense-tableau","title":{"rendered":"Technick\u00e9 rozdiely BI syst\u00e9mov (Power BI, Qlik Sense, Tableau)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\u010cas potrebn\u00fd na pre\u010d\u00edtanie 11 min\u00fat<\/i><\/p>\n

My a Gartnerov kvadrant 2019 BI \ud83d\ude42<\/h2>\n

\nCie\u013eom tohto \u010dl\u00e1nku je porovnanie troch ved\u00facich BI platforiem, ktor\u00e9 s\u00fa l\u00eddrami v kvadrante Gartner:<\/p>\n

\u2014 Power BI (Microsoft)
\n \u2014 Tableau
\n \u2014 Qlik<\/p><\/blockquote>\n

\n\"Technick\u00e9
\nObr\u00e1zok 1. Gartner BI Magic Quadrant 2019<\/i><\/p>\n

Vol\u00e1m sa \u017ddanov Andrej, som ved\u00faci oddelenia analytiky spolo\u010dnosti Analytics Group (www.analyticsgroup.ru<\/a><\/noindex>). Vytv\u00e1rame preh\u013eadn\u00e9 spr\u00e1vy o marketingu, predaji, financi\u00e1ch, logistike, in\u00fdmi slovami, zaober\u00e1me sa obchodnou analytikou a vizualiz\u00e1ciou d\u00e1t. <\/p>\n

Ja a moji kolegovia u\u017e nieko\u013eko rokov pracujeme s r\u00f4znymi BI platformami. M\u00e1me ve\u013emi slu\u0161n\u00e9 sk\u00fasenosti s projektmi, \u010do n\u00e1m umo\u017e\u0148uje porovn\u00e1va\u0165 platformy z poh\u013eadu v\u00fdvoj\u00e1rov, analytikov, obchodn\u00fdch pou\u017e\u00edvate\u013eov a implement\u00e1torov BI syst\u00e9mov. <\/p>\n

Budeme ma\u0165 osobitn\u00fd \u010dl\u00e1nok o porovnan\u00ed cien a vizu\u00e1lneho dizajnu t\u00fdchto BI syst\u00e9mov, preto sa tu pok\u00fasime ohodnoti\u0165 tieto syst\u00e9my pr\u00e1ve z poh\u013eadu analytika a v\u00fdvoj\u00e1ra. <\/p>\n

Vy\u010dlen\u00edme nieko\u013eko smerov na anal\u00fdzu a ohodnot\u00edme ich na 3-bodovej stupnici:<\/p>\n

\u2014 Prah vstupu a po\u017eiadavky na analytika;
\n \u2014 Zdroje d\u00e1t;
\n \u2014 \u010cistenie d\u00e1t, ETL (Extract, Transform, Load)
\n \u2014 Vizualiz\u00e1cie a v\u00fdvoj
\n \u2014 Firemn\u00e9 prostredie \u2014 server, spr\u00e1vy
\n \u2014 Podpora mobiln\u00fdch zariaden\u00ed
\n \u2014 Vlo\u017een\u00e1 (embedded) analytika v extern\u00fdch aplik\u00e1ci\u00e1ch\/webov\u00fdch str\u00e1nkach<\/p><\/blockquote>\n

\n<\/a><\/noindex><\/p>\n

1. Prah vstupu a po\u017eiadavky na analytika<\/h2>\n

\n\"Technick\u00e9
\n<\/p>\n

Power BI<\/h3>\n

\nVid\u011bl som ve\u013ea pou\u017e\u00edvate\u013eov Power BI, ktor\u00ed neboli IT odborn\u00edkmi, ale mohli vytvori\u0165 slu\u0161n\u00fa spr\u00e1vu. Power BI pou\u017e\u00edva ten ist\u00fd jazyk dotazov ako Excel \u2014 Power Query a jazyk formul\u00ed DAX. Mnoh\u00ed analytici dobre poznaj\u00fa Excel, a preto prejs\u0165 na tento BI syst\u00e9m pre nich nie je probl\u00e9m. <\/p>\n

V\u00e4\u010d\u0161ina akci\u00ed sa vykon\u00e1va relat\u00edvne jednoducho v editore dotazov. Navy\u0161e existuje roz\u0161\u00edren\u00fd editor s jazykom M pre profesion\u00e1lov.
\n\"Technick\u00e9
\nObr\u00e1zok 2. N\u00e1vrh\u00e1r dotazov Power BI<\/i><\/p>\n

Qlik Sense <\/h3>\n

\nQlik Sense vyzer\u00e1 ve\u013emi priate\u013esky \u2014 mal\u00e9 mno\u017estvo nastaven\u00ed, r\u00fdchla mo\u017enos\u0165 vytvori\u0165 spr\u00e1vu, mo\u017eno pou\u017ei\u0165 n\u00e1stroj na na\u010d\u00edtanie d\u00e1t. <\/p>\n

Na za\u010diatku sa zd\u00e1 by\u0165 jednoduch\u0161\u00ed ako Power BI a Tableau. Ale z vlastnej sk\u00fasenosti poviem, \u017ee po ur\u010ditom \u010dase, ke\u010f analytik vytvor\u00ed p\u00e1r jednoduch\u00fdch spr\u00e1v a potrebuje nie\u010do zlo\u017eitej\u0161ie, naraz\u00ed na potrebu programova\u0165. <\/p>\n

Qlik m\u00e1 ve\u013emi v\u00fdkonn\u00fd jazyk na na\u010d\u00edtanie a spracovanie d\u00e1t. Existuje vlastn\u00fd jazyk formul\u00ed Set Analysis. Preto mus\u00ed analytik vedie\u0165 p\u00edsa\u0165 dotazy a spojenia, umiest\u0148ova\u0165 d\u00e1ta do virtu\u00e1lnych tabuliek a akt\u00edvne pou\u017e\u00edva\u0165 premenn\u00e9. Mo\u017enosti jazyka s\u00fa ve\u013emi \u0161irok\u00e9, ale vy\u017eaduj\u00fa si jeho \u0161t\u00fadium. Sn\u00e1\u010f v\u0161etci analytici Qlik, ktor\u00fdch pozn\u00e1m, maj\u00fa nejak\u00e9 v\u00e1\u017ene IT z\u00e1zemie. <\/p>\n

Integr\u00e1tori Qlik, ako sme my, \u010dasto radi rozpr\u00e1vaj\u00fa o asociat\u00edvnom modeli, kedy s\u00fa v\u0161etky d\u00e1ta pri na\u010d\u00edtan\u00ed umiestnen\u00e9 do opera\u010dnej pam\u00e4te a spojenie medzi \u00fadajmi zabezpe\u010duje intern\u00fd mechanizmus platformy. Pri v\u00fdbere hodn\u00f4t nedoch\u00e1dza k intern\u00fdm poddotazom, ako v klasick\u00fdch datab\u00e1zach. D\u00e1ta s\u00fa poskytovan\u00e9 takmer okam\u017eite v\u010faka vopred indexovan\u00fdm hodnot\u00e1m a vz\u0165ahom. <\/p>\n

Pravda\u017ee, v praxi to vedie k vytv\u00e1raniu automatick\u00fdch spojen\u00ed tabuliek pri zhode n\u00e1zvov pol\u00ed. Napr\u00edklad nie je mo\u017en\u00e9 ma\u0165 r\u00f4zne tabu\u013eky bez spojen\u00ed, ktor\u00e9 bud\u00fa ma\u0165 rovnak\u00e9 pole. Na to si treba zvykn\u00fa\u0165. Mus\u00ed\u0161 bu\u010f premenova\u0165 st\u013apce a sledova\u0165, aby sa men\u00e1 nezhodovali, alebo zl\u00fa\u010di\u0165 v\u0161etky tabu\u013eky faktov do jednej a obklopi\u0165 ich referen\u010dn\u00fdmi tabu\u013ekami typu 'hviezda'. Sn\u00e1\u010f je to pre nov\u00e1\u010dikov pohodln\u00e9, ale sk\u00fasenej\u0161\u00ed analytici to u\u017e nepova\u017euj\u00fa za probl\u00e9m. <\/p>\n

Typick\u00e9 rozhranie na na\u010d\u00edtanie a spracovanie d\u00e1t pre analytika vyzer\u00e1 takto.
\n\"Technick\u00e9
\nObr\u00e1zok 3. Editor na\u010d\u00edtania d\u00e1t Qlik Sense, tabu\u013eka Calendar<\/i><\/p>\n

Pozn\u00e1mka: V Power BI situ\u00e1cia zvy\u010dajne vyzer\u00e1 inak, nech\u00e1va\u0161 r\u00f4zne tabu\u013eky faktov a referen\u010dn\u00e9 tabu\u013eky, m\u00f4\u017ee\u0161 manu\u00e1lne sp\u00e1ja\u0165 tabu\u013eky klasick\u00fdm sp\u00f4sobom, t.j. porovn\u00e1van\u00edm st\u013apcov navz\u00e1jom.<\/i><\/p>\n

Tableau<\/h3>\n

\nV\u00fdvoj\u00e1ri Tableau ho prezentuj\u00fa ako BI s pohodln\u00fdm a priate\u013esk\u00fdm rozhran\u00edm, ktor\u00e9 umo\u017e\u0148uje analytikovi samostatne presk\u00famava\u0165 svoje d\u00e1ta. \u00c1no, v na\u0161ej spolo\u010dnosti boli analytici, ktor\u00ed bez IT sk\u00fasenost\u00ed mohli vytv\u00e1ra\u0165 svoje spr\u00e1vy. Ale hodnotenie Tableau zn\u00ed\u017eim z nieko\u013ek\u00fdch d\u00f4vodov:
\n \u2014 Slab\u00e1 lokaliz\u00e1cia pre ru\u0161tinu
\n \u2014 Servery Tableau Online sa nenach\u00e1dzaj\u00fa v RF
\n \u2014 Pomerne jednoduch\u00fd kon\u0161trukt\u00e9r na\u010d\u00edtania za\u010d\u00edna sp\u00f4sobova\u0165 probl\u00e9my, ke\u010f treba postavi\u0165 dos\u0165 zlo\u017eit\u00fd model d\u00e1t.
\n\"Technick\u00e9
\nObr\u00e1zok 4. Kon\u0161trukt\u00e9r na\u010d\u00edtania d\u00e1t Tableau<\/i> <\/p>\n

Jedna z ot\u00e1zok, ktor\u00e9 kladieme na pohovoroch analytikom pre Tableau je: \u201eAko postavi\u0165 model tabu\u013eky faktov s referen\u010dn\u00fdmi tabu\u013ekami, bez toho, aby sme v\u0161etko spojili do jednej tabu\u013eky?!\" Data Blending si vy\u017eaduje premyslen\u00e9 pou\u017e\u00edvanie. Mnohokr\u00e1t som opravil u svojich analytikov chyby duplicitn\u00fdch \u00fadajov po tak\u00fdchto zl\u00fa\u010deniach. <\/p>\n

Navy\u0161e m\u00e1 Tableau dos\u0165 osobit\u00fd syst\u00e9m, ke\u010f\u017ee ka\u017ed\u00fd graf vytv\u00e1rate na samostatnom liste a potom vytv\u00e1rate Dashboard, kde za\u010dnete umiest\u0148ova\u0165 vytvoren\u00e9 listy. N\u00e1sledne m\u00f4\u017eete vytvori\u0165 Story, \u010do je kombin\u00e1cia r\u00f4znych Dashboardov. V\u00fdvoj v Qlik a Power BI je v tomto oh\u013eade jednoduch\u0161\u00ed, okam\u017eite nakresl\u00edte na liste \u0161abl\u00f3ny grafov, nastav\u00edte opatrenia a merania a Dashboard je hotov\u00fd. Pracovn\u00e9 n\u00e1klady na pr\u00edpravu v Tableau sa mi zdaj\u00fa z tohto d\u00f4vodu vy\u0161\u0161ie.<\/p>\n

2. Zdroj d\u00e1t a na\u010d\u00edtanie <\/h2>\n

\n\"Technick\u00e9
\n
\nV tejto sekcii nie je jasn\u00fd l\u00eddri, ale vyberieme Qlik pre p\u00e1r pr\u00edjemn\u00fdch vlastnost\u00ed. <\/p>\n

Tableau je v bezplatnej verzii limitovan\u00e9 vo zdrojoch, ale v na\u0161ich \u010dl\u00e1nkoch sa viac orientujeme na podniky, a tie si m\u00f4\u017eu dovoli\u0165 komer\u010dn\u00e9 produkty a analytikov. Preto sme neutr\u00e1lny na hodnotenie Tableau v tomto parametri.
\n\"Technick\u00e9
\nObr\u00e1zok 5. Zoznam mo\u017en\u00fdch zdrojov Tableau <\/i> <\/p>\n

Inak, zoznam zdrojov je v\u0161ade p\u00f4sobiv\u00fd \u2014 v\u0161etky tabu\u013ekov\u00e9 s\u00fabory, v\u0161etky \u0161tandardn\u00e9 datab\u00e1zy, webov\u00e9 pripojenia, v\u0161etko funguje. Nestretol som sa s netradi\u010dn\u00fdmi \u00falo\u017eiskami d\u00e1t, tam m\u00f4\u017eu existova\u0165 svoje nuansy, ale vo v\u00e4\u010d\u0161ine pr\u00edpadov nebudete ma\u0165 probl\u00e9my s na\u010d\u00edtan\u00edm d\u00e1t. V\u00fdnimkou je pravdepodobne len 1C. Priame konektory k 1C neexistuj\u00fa. <\/p>\n

Partneri Qlik v Rusku pred\u00e1vaj\u00fa svoje vlastn\u00e9 konektory za 100 000 \u2014 200 000 rub\u013eov, ale vo v\u00e4\u010d\u0161ine pr\u00edpadov je lacnej\u0161ie urobi\u0165 exporty z 1C na FTP do Excelu alebo datab\u00e1zy SQL. M\u00f4\u017eete tie\u017e publikova\u0165 datab\u00e1zu 1C na webe a pripoji\u0165 sa k nej cez protokol Odata. <\/p>\n

PowerBI a Tableau to maj\u00fa \u0161tandardne, ale Qlik po\u017eaduje platen\u00fd konektor, tak\u017ee je tie\u017e jednoduch\u0161ie exportova\u0165 do medzi\u010dasej datab\u00e1zy. V ka\u017edom pr\u00edpade sa daj\u00fa vyrie\u0161i\u0165 v\u0161etky ot\u00e1zky t\u00fdkaj\u00face sa pripojen\u00ed.
\n\"Technick\u00e9
\nObr\u00e1zok 6. Zoznam mo\u017en\u00fdch zdrojov Qlik Sense <\/i> <\/p>\n

Je navy\u0161e potrebn\u00e9 poznamena\u0165 zvl\u00e1\u0161tnos\u0165 Qlik, \u017ee ako samostatn\u00fd produkt dod\u00e1vaj\u00fa platen\u00e9 aj bezplatn\u00e9 konektory.
\n \"Technick\u00e9
\nObr\u00e1zok 7. Dodato\u010dn\u00e9 konektory Qlik Sense<\/i> <\/p>\n

Z osobn\u00fdch sk\u00fasenost\u00ed prid\u00e1vam, \u017ee pri ve\u013ek\u00fdch objemoch d\u00e1t alebo mnoh\u00fdch zdrojoch nie je v\u017edy rozumn\u00e9 hne\u010f pripoji\u0165 BI syst\u00e9m. V\u00fdchodiskom pre v\u00e1\u017ene projekty je obvykle d\u00e1tov\u00fd sklad, datab\u00e1za s u\u017e pripraven\u00fdmi d\u00e1tami na anal\u00fdzu at\u010f. Nemo\u017eno len tak vzia\u0165 a exportova\u0165 povedzme 1 miliardu z\u00e1znamov do BI syst\u00e9mu. Tu u\u017e je potrebn\u00e9 prem\u00fd\u0161\u013ea\u0165 nad architekt\u00farou rie\u0161enia.
\n\"Technick\u00e9
\n\"Technick\u00e9
\nObr\u00e1zok 8. Zdroje d\u00e1t Power BI<\/i><\/p>\n

Ale pre\u010do sme zd\u00f4raznili Qlik? P\u00e1\u010dia sa mi tri veci:
\n \u2014 QVD s\u00fabory<\/b>
\nS\u00fakromn\u00fd form\u00e1t ukladania d\u00e1t. Niekedy je mo\u017en\u00e9 postavi\u0165 v\u00e1\u017ene komer\u010dn\u00e9 projekty iba na QVD s\u00faboroch. Napr\u00edklad prv\u00e1 \u00farove\u0148 \u2014 surov\u00e9 d\u00e1ta. Druh\u00e1 \u00farove\u0148 \u2014 spracovan\u00e9 s\u00fabory. Tretia \u00farove\u0148 \u2014 agregovan\u00e9 d\u00e1ta at\u010f. Tieto s\u00fabory sa daj\u00fa pou\u017e\u00edva\u0165 v r\u00f4znych aplik\u00e1ci\u00e1ch, m\u00f4\u017eu za ne zodpoveda\u0165 r\u00f4zni zamestnanci a slu\u017eby. R\u00fdchlos\u0165 na\u010d\u00edtania z tak\u00fdchto s\u00faborov je desa\u0165kr\u00e1t r\u00fdchlej\u0161ia ako z be\u017en\u00fdch zdrojov d\u00e1t. To umo\u017e\u0148uje \u0161etri\u0165 na datab\u00e1ze a zdie\u013ea\u0165 inform\u00e1cie medzi r\u00f4znymi aplik\u00e1ciami Qlik. <\/p>\n

\u2014 Inkrement\u00e1lne na\u010d\u00edtanie d\u00e1t<\/b>
\n\u00c1no, Power BI a Tableau to tie\u017e dok\u00e1\u017eu. Ale Power BI si vy\u017eaduje drah\u00fa Premium verziu, a v Tableau nie je t\u00e1 flexibilita, ak\u00fa m\u00e1 Qlik. V Qlik na QVD s\u00faboroch m\u00f4\u017eete robi\u0165 snapshoty syst\u00e9mov na r\u00f4znu dobu a potom tieto d\u00e1ta spracov\u00e1va\u0165 pod\u013ea svojich predst\u00e1v.<\/p>\n

\u2014 Pripojenie extern\u00fdch skriptov<\/b>
\nOkrem QVD s\u00faborov na ukladanie d\u00e1t, v Qlik je mo\u017en\u00e9 k\u00f3d skriptu tie\u017e vynies\u0165 mimo aplik\u00e1cie a pripoji\u0165 ho pr\u00edkazom Include. To u\u017e umo\u017e\u0148uje organizova\u0165 t\u00edmov\u00fa pr\u00e1cu, pou\u017e\u00edva\u0165 syst\u00e9my spr\u00e1vy verzi\u00ed, spravova\u0165 jednotn\u00fd k\u00f3d pre r\u00f4zne aplik\u00e1cie. V Power BI je roz\u0161\u00edren\u00fd editor dotazov, ale tak\u00fa t\u00edmov\u00fa pr\u00e1cu sa n\u00e1m nepodarilo nastavi\u0165 ako v Qlik. Vo v\u0161eobecnosti maj\u00fa v\u0161etky BI syst\u00e9my s t\u00fdmto probl\u00e9m, spravova\u0165 s\u00fa\u010dasne a d\u00e1ta, aj k\u00f3d, aj vizualiz\u00e1cie vo v\u0161etk\u00fdch aplik\u00e1ci\u00e1ch z jedn\u00e9ho miesta je jednoducho nemo\u017en\u00e9. Maxim\u00e1lne, \u010do sa n\u00e1m podarilo spravi\u0165, je vynies\u0165 QVD s\u00fabory a k\u00f3d skriptov. Vizualiza\u010dn\u00e9 prvky mus\u00edme upravova\u0165 priamo vo v\u00fdkazoch, \u010do n\u00e1m neumo\u017e\u0148uje hromadne meni\u0165 vizualiz\u00e1cie u v\u0161etk\u00fdch klientov s\u00fa\u010dasne. <\/p>\n

A \u010do tak\u00fd mechanizmus ako Live pripojenie? Tableau a Power BI podporuj\u00fa LIVE pripojenie k nieko\u013ek\u00fdm zdrojom, na rozdiel od Qlik. K tejto funkcii sa staviame dos\u0165 indiferentne, preto\u017ee prax ukazuje, \u017ee ke\u010f ide o ve\u013ek\u00e9 d\u00e1ta, pr\u00e1ca s LIVE pripojen\u00edm sa st\u00e1va prakticky nemo\u017enou. A BI je v\u00e4\u010d\u0161inou potrebn\u00fd pre ve\u013ek\u00e9 d\u00e1ta. <\/p>\n

3. \u010cistenie d\u00e1t, ETL (Extract, Transform, Load)<\/h2>\n

\n\"Technick\u00e9
\n
\nV tejto sekcii m\u00e1m dvoch l\u00eddrov, Qlik Sense a Power BI.
\nPovedzme to takto, Qlik je mocn\u00fd, ale zlo\u017eit\u00fd. Ak sa dostanete do ich jazyka podobn\u00e9ho SQL, m\u00f4\u017eete prakticky v\u0161etko \u2014 virtu\u00e1lne tabu\u013eky, spojenia a zl\u00fa\u010denie tabuliek, prejs\u0165 cyklom cez tabu\u013eku a generova\u0165 nov\u00e9 tabu\u013eky, mno\u017estvo pr\u00edkazov na spracovanie riadkov. Napr\u00edklad pole v 1 bunke, ktor\u00e9 obsahuje d\u00e1ta vo forme \"Ivanov 851 Biele\" m\u00f4\u017eete naletie rozlo\u017ei\u0165 nielen na 3 st\u013apce (ako v\u0161etci zvl\u00e1daj\u00fa), ale aj okam\u017eite na 3 riadky. Rovnako tak naletie zl\u00fa\u010di\u0165 3 riadky do 1 tie\u017e \u013eahko.
\n\"Technick\u00e9
\nObr\u00e1zok 9. Ako nahra\u0165 a transponova\u0165 tabu\u013eku v Qlik Sense z Google Sheets<\/i><\/p>\n

Power BI sa v tomto smere zd\u00e1 by\u0165 jednoduch\u0161\u00ed, ale v\u00e4\u010d\u0161ina \u00faloh sa \u013eahko rie\u0161i prostredn\u00edctvom kon\u0161truktora dotazov. Nastav\u00edte nieko\u013eko parametrov, transponujete tabu\u013eku, pracujete s d\u00e1tami, a to v\u0161etko bez jedinej riadky k\u00f3du.
\n\"Technick\u00e9
\nObr\u00e1zok 10. Ako nahra\u0165 a transponova\u0165 tabu\u013eku v Power BI z AmoCRM<\/i><\/p>\n

Tabu\u013ea mi pripad\u00e1 s inou ideol\u00f3giou. Viac sa zameriavaj\u00fa na kr\u00e1su a dizajn. Pripoji\u0165 mno\u017estvo r\u00f4znych zdrojov, spoji\u0165 ich v\u0161etky a spracova\u0165 ich v Tablea mi pripad\u00e1 ve\u013emi \u0165a\u017ek\u00e9. V komer\u010dn\u00fdch projektoch sa vo v\u00e4\u010d\u0161ine pr\u00edpadov pre Tableau u\u017e pripravuj\u00fa a akumuluj\u00fa d\u00e1ta v \u00falo\u017eisk\u00e1ch a datab\u00e1zach.
\n \"Technick\u00e9
\nObr\u00e1zok 11. Ako nahra\u0165 a transponova\u0165 tabu\u013eku v Tableau<\/i><\/p>\n

4. Vizualiz\u00e1cie<\/h2>\n

\n\"Technick\u00e9
\n
\nV tejto sekcii sme nevy\u010dlenili l\u00eddra. Budeme ma\u0165 samostatn\u00fd \u010dl\u00e1nok, kde na pr\u00edklade jedn\u00e9ho pr\u00edpadu uk\u00e1\u017eeme rovnak\u00fd report vo v\u0161etk\u00fdch 3 syst\u00e9moch. (\u010cl\u00e1nok \u201eAnalytika diev\u010dat s n\u00edzkou soci\u00e1lnou zodpovednos\u0165ou \u201e)<\/a><\/noindex>Tu ide v\u00e4\u010d\u0161inou o vkus a zru\u010dnos\u0165 analytika. Na internete mo\u017eno n\u00e1js\u0165 ve\u013emi pekn\u00e9 obr\u00e1zky, postaven\u00e9 na akomko\u013evek z t\u00fdchto syst\u00e9mov. Z\u00e1kladn\u00e9 mo\u017enosti vizualiz\u00e1ci\u00ed s\u00fa u v\u0161etk\u00fdch pribli\u017ene rovnak\u00e9. Ostatn\u00e9 sa rie\u0161i pou\u017eit\u00edm roz\u0161\u00edren\u00ed. Existuj\u00fa platen\u00e9 aj bezplatn\u00e9 verz\u00e1cie. S\u00fa roz\u0161\u00edrenia od samotn\u00fdch dod\u00e1vate\u013eov tak aj od freelancerov a integr\u00e1torov. M\u00f4\u017eete si nap\u00edsa\u0165 vlastn\u00e9 roz\u0161\u00edrenie vizualiz\u00e1cie pre ak\u00fako\u013evek platformu. <\/p>\n

P\u00e1\u010di sa mi \u0161t\u00fdl Tableau, pova\u017eujem ho za pr\u00edsny a korpor\u00e1tny. Ale z\u00edska\u0165 skuto\u010dne pekn\u00fd obr\u00e1zok v Tableau je \u0165a\u017ek\u00e9. Skvel\u00fd pr\u00edklad vizualiz\u00e1cie Tableau, kde s\u00fa pou\u017eit\u00e9 len roz\u0161\u00edrenia. Nebudem to m\u00f4c\u0165 tak zopakova\u0165, preto\u017ee nem\u00e1m tieto roz\u0161\u00edrenia, ale vyzer\u00e1 to pekne.
\n\"Technick\u00e9
\nObr\u00e1zok 12. Vzh\u013ead spr\u00e1v Tableau s roz\u0161\u00edreniami<\/i> <\/p>\n

Power BI m\u00f4\u017ee by\u0165 tie\u017e zauj\u00edmav\u00e9.
\n\"Technick\u00e9
\nObr\u00e1zok 13. Vzh\u013ead spr\u00e1v Power BI s roz\u0161\u00edreniami<\/i><\/p>\n

Jedna vec, ktor\u00fa nech\u00e1pem v Power BI, je d\u00f4vod, pre\u010do maj\u00fa tak\u00e9 zvl\u00e1\u0161tne predvolen\u00e9 farby. Na akomko\u013evek grafe som n\u00faten\u00fd meni\u0165 farbu na svoju firemn\u00fa, korpor\u00e1tnu a div\u00edm sa, pre\u010do je \u0161tandardn\u00e1 farebnos\u0165 tak\u00e1to. <\/p>\n

Qlik Sense tie\u017e z\u00e1vis\u00ed od roz\u0161\u00edren\u00ed. Pou\u017eitie doplnkov m\u00f4\u017ee men\u00ed\u0165 spr\u00e1vy do nepoznania. M\u00f4\u017eete si tie\u017e nastavi\u0165 vlastn\u00e9 t\u00e9my a dizajn.
\n\"Technick\u00e9
\nObr\u00e1zok 14. Vzh\u013ead spr\u00e1v Qlik Sense s roz\u0161\u00edreniami<\/i> <\/p>\n

Z poh\u013eadu v\u00fdvoj\u00e1ra je pre m\u0148a Qlik Sense pohodlnej\u0161ie v\u010faka \u0161tandardn\u00fdm mo\u017enostiam ako alternat\u00edvne dimenzie a metriky. V nastaveniach vizualiz\u00e1cie m\u00f4\u017eete zada\u0165 nieko\u013eko dimenzi\u00ed a metr\u00edk, a pou\u017e\u00edvate\u013e si m\u00f4\u017ee \u013eahko s\u00e1m nastavi\u0165, \u010do chce vidie\u0165 na tom alebo onom grafe. <\/p>\n

V Power BI a Tableau mus\u00edm nastavova\u0165 parametre, tla\u010didl\u00e1, programova\u0165 spr\u00e1vanie syst\u00e9mu v z\u00e1vislosti od t\u00fdchto parametrov. Udivuje ma, pre\u010do je to tak\u00e9 zlo\u017eit\u00e9. Rovnako je to aj s mo\u017enos\u0165ou zmeni\u0165 vzh\u013ead vizualiz\u00e1ci\u00ed. <\/p>\n

V Qlik m\u00f4\u017eete skry\u0165 r\u00f4zne druhy vizualiz\u00e1ci\u00ed v jednom objekte, zatia\u013e \u010do v Power BI a Tableau je to zlo\u017eitej\u0161ie. Op\u00e4\u0165, tu viac z\u00e1vis\u00ed od zru\u010dnosti vykon\u00e1vate\u013ea. M\u00f4\u017eete v akomko\u013evek syst\u00e9me vytvori\u0165 majstrovsk\u00e9 dielo, ale bez sk\u00fasenost\u00ed bud\u00fa v\u0161ade v\u00fdsledn\u00e9 grafy nev\u00fdrazn\u00e9. <\/p>\n

5. Korpor\u00e1tne prostredie \u2013 server, spr\u00e1vy<\/h2>\n

\n\"Technick\u00e9
\n
\nV\u0161etky produkty maj\u00fa podnikov\u00e9 serverov\u00e9 verzie. Pracoval som so v\u0161etk\u00fdmi ed\u00edciami a m\u00f4\u017eem poveda\u0165, \u017ee ka\u017ed\u00e1 m\u00e1 svoje siln\u00e9 a slab\u00e9 str\u00e1nky. Vo\u013eba produktu by mala by\u0165 zalo\u017een\u00e1 na va\u0161ich po\u017eiadavk\u00e1ch na softv\u00e9r s oh\u013eadom na ich nuansy. U v\u0161etk\u00fdch dod\u00e1vate\u013eov je mo\u017en\u00e9 prerozdeli\u0165 opr\u00e1vnenia na \u00farovni \u00fa\u010dtov a skup\u00edn, ako aj na \u00farovni Data Row Level Security. K dispoz\u00edcii je automatick\u00e1 aktualiz\u00e1cia spr\u00e1v pod\u013ea pl\u00e1nu. <\/p>\n

Qlik Sense Enterprise je skvel\u00e1 pr\u00edle\u017eitos\u0165 na vybudovanie analytiky vo va\u0161ej organiz\u00e1cii pre stredn\u00e9 podniky. M\u00f4\u017ee sa zda\u0165 drah\u0161\u00ed ako Power BI Pro, ale netreba zab\u00fada\u0165, \u017ee servery Power BI Pro s\u00fa v cloude na \u00fazem\u00ed Microsoftu a na v\u00fdkon nem\u00e1te vplyv. A ke\u010f budete potrebova\u0165 Power BI Premium, ktor\u00fd m\u00f4\u017eete nasadi\u0165 na va\u0161ich serveroch, cena za\u010d\u00edna od 5000$ za mesiac. <\/p>\n

\"Technick\u00e9
\n
\nQlik Sense Enterprise za\u010d\u00edna na cene 230 000 rub\u013eov za 5 licenci\u00ed (ro\u010dne, \u010fal\u0161ie n\u00e1klady s\u00fa len na technick\u00fa podporu), \u010do je ove\u013ea dostupnej\u0161ie ako Power BI Premium. A Qlik Sense Enterprise v\u00e1m umo\u017en\u00ed vyu\u017ei\u0165 v\u0161etky mo\u017enosti Qlik. Sn\u00e1\u010f okrem jednej. Z nejak\u00e9ho d\u00f4vodu sa Qlik rozhodol, \u017ee funkcia zasielania spr\u00e1v vo form\u00e1te PDF e-mailom by mala by\u0165 poskytnut\u00e1 ako samostatn\u00e1 slu\u017eba NPrinting.<\/p>\n

Ale Qlik Sense Enterprise je v\u00fdkonnej\u0161\u00ed ako Power BI Pro, a preto m\u00f4\u017eeme urobi\u0165 nasleduj\u00face porovnanie. <\/p>\n

Qlik Sense Enterprise = Power BI Premium, s rovnak\u00fdmi mo\u017enos\u0165ami sa to uk\u00e1\u017ee ako lacnej\u0161ie pri stredn\u00fdch implement\u00e1ci\u00e1ch. Ve\u013ek\u00e9 implement\u00e1cie sa zvy\u010dajne kalkuluj\u00fa u\u017e na strane dod\u00e1vate\u013ea, kde m\u00f4\u017eu pon\u00faka\u0165 individu\u00e1lne podmienky pre va\u0161u spolo\u010dnos\u0165. <\/p>\n

V tomto oh\u013eade d\u00e1me prednos\u0165 Qlik Sense Enterprise, tam s\u00fa v\u0161etky mo\u017enosti na vybudovanie v\u00e1\u017enej analytiky na obrovsk\u00fdch \u00fadajoch. Pod\u013ea n\u00e1\u0161ho n\u00e1zoru bude Qlik fungova\u0165 r\u00fdchlej\u0161ie ako Power BI na ve\u013ek\u00fdch mno\u017ein\u00e1ch d\u00e1t; na konferenci\u00e1ch Qlik sme sa stretli s klientmi, ktor\u00ed spo\u010diatku testovali svoje \u00fadaje v miliard\u00e1ch z\u00e1znamov a Power BI dosahoval hor\u0161ie v\u00fdsledky.
\n\"Technick\u00e9
\nObr\u00e1zok 15. Vzh\u013ead spr\u00e1v servera Qlik Sense Enterprise<\/i> <\/p>\n

Qlik Sense Cloud = Power BI Pro. Qlik Sense Cloud je o 1,5-kr\u00e1t drah\u0161\u00ed* a existuje tu ve\u013emi v\u00fdznamn\u00e9 obmedzenie, ktor\u00e9 n\u00e1m neumo\u017e\u0148uje pou\u017e\u00edva\u0165 t\u00fato platformu. Nie je mo\u017en\u00e9 pou\u017e\u00edva\u0165 roz\u0161\u00edrenia, dokonca ani vstavan\u00e9. A bez roz\u0161\u00edren\u00ed Qlik str\u00e1ca trochu na svojej vizu\u00e1lnej kr\u00e1se.
\n\"Technick\u00e9
\nObr\u00e1zok 16. Vzh\u013ead ovl\u00e1dacieho panela Power BI Pro<\/i> <\/p>\n

*Alternat\u00edvou je pou\u017e\u00edvanie Qlik Sense Enterprise na z\u00e1klade predplatn\u00e9ho. Aby sa v\u0161ak tento \u010dl\u00e1nok nevn\u00edmal ako reklama, nebudeme sa zaobera\u0165 na\u0161ou cenovou politikou. <\/p><\/blockquote>\n

Tableau je pre n\u00e1s trochu mimo. Maj\u00fa ako cloudov\u00e9 predplatn\u00e9 za 70 $ na v\u00fdvoj\u00e1ra a 15 $ na prezeranie, tak aj drah\u00e9 serverov\u00e9 rie\u0161enia. Hlavn\u00e1 my\u0161lienka Tableau je, \u017ee pre ve\u013ek\u00e9 d\u00e1ta je potrebn\u00e9 organizova\u0165 spracovanie a ukladanie d\u00e1t na strane. Objekt\u00edvne men\u0161ia funkcionalita neumo\u017e\u0148uje d\u00f4kladn\u00e9 spracovanie d\u00e1t v Tableau. Vizu\u00e1lne zobrazi\u0165, analyzova\u0165 \u00e1no. Ale pre mal\u00e9 a stredn\u00e9 podniky je obvykle probl\u00e9m vytvori\u0165 samostatn\u00e9 \u00falo\u017eisko. Keby nebolo ich jednej v\u00fdhody, hodnotenie Tableau by som zn\u00ed\u017eil. Server Tableau bez probl\u00e9mov posiela e-maily pod\u013ea pl\u00e1nu s pr\u00edlohami vo form\u00e1te CSV alebo PDF. M\u00f4\u017eete nastavova\u0165 pr\u00e1va, automatick\u00e9 filtre a podobne. Power BI a Qlik to z nejak\u00e9ho d\u00f4vodu nedok\u00e1\u017eu, a niekomu to m\u00f4\u017ee by\u0165 k\u013e\u00fa\u010dov\u00e9. Preto Tableau udr\u017euje svoju poz\u00edciu v na\u0161ej diskusii. <\/p>\n

\"Technick\u00e9
\nObr\u00e1zok 17. Vzh\u013ead panela Tableau Server.<\/i><\/p>\n

Rovnako v podnikate\u013eskom prostred\u00ed je potrebn\u00e9 zv\u00e1\u017ei\u0165 n\u00e1klady na implement\u00e1ciu a \u00fadr\u017ebu. V Rusku je be\u017en\u00e9, \u017ee Power BI je roz\u0161\u00edrenej\u0161\u00ed v malom biznise. To viedlo k vzniku ve\u013ek\u00e9ho mno\u017estva pon\u00fak a CV, ako aj vzniku mal\u00fdch integr\u00e1torov. To umo\u017en\u00ed n\u00e1js\u0165 odborn\u00edkov na mal\u00e9 projekty. Ale pravdepodobne v\u0161etci z nich nebud\u00fa ma\u0165 sk\u00fasenosti s ve\u013ek\u00fdmi implement\u00e1ciami a pr\u00e1cou s ve\u013ek\u00fdmi d\u00e1tami. Naopak, Qlik a Tableau. Partnerov Qlik je m\u00e1lo, a e\u0161te menej je partnerov Tableau. Tito partneri sa \u0161pecializuj\u00fa na ve\u013ek\u00e9 implement\u00e1cie s vysokou priemernou hodnotou zml\u00fav. Na trhu nie je ve\u013ea pon\u00fak a CV, vstupn\u00e1 bari\u00e9ra do t\u00fdchto produktov je zlo\u017eitej\u0161ia ako u Power BI. Ale v Rusku existuj\u00fa \u00faspe\u0161n\u00e9 implement\u00e1cie t\u00fdchto produktov pre tis\u00edce pou\u017e\u00edvate\u013eov a tieto produkty sa na ve\u013ek\u00fdch d\u00e1tach ve\u013emi dobre osved\u010duj\u00fa. Je len potrebn\u00e9 pochopi\u0165 slab\u00e9 a siln\u00e9 str\u00e1nky produktov vo vz\u0165ahu k v\u00e1\u0161mu podnikaniu. <\/p>\n

6. Podpora mobiln\u00fdch zariaden\u00ed. <\/h2>\n

\n\"Technick\u00e9
\n
\nV tejto \u010dasti sa zameriame na Power BI a Tableau. M\u00f4\u017eete si nain\u0161talova\u0165 mobiln\u00e9 aplik\u00e1cie a relat\u00edvne dobre sa bud\u00fa zobrazi\u0165 na obrazovk\u00e1ch mobiln\u00fdch zariaden\u00ed. Hoci sa n\u00e1m zd\u00e1, \u017ee anal\u00fdza na mobiln\u00fdch zariadeniach zaost\u00e1va za anal\u00fdzou na PC. Napokon nie je tak pohodln\u00e9 pou\u017e\u00edva\u0165 filtre, obr\u00e1zky s\u00fa mal\u00e9, \u010d\u00edsla sa zle \u010d\u00edtaj\u00fa at\u010f. <\/p>\n

\"Technick\u00e9
\nObr\u00e1zok 18. Vzh\u013ead reportu Power BI na iPhone<\/i><\/p>\n

\"Technick\u00e9
\nObr\u00e1zok 19. Vzh\u013ead reportu Tableau na iPhone<\/i><\/p>\n

\"Technick\u00e9
\nObr\u00e1zok 20. Vzh\u013ead reportu Qlik Sense na iPhone<\/i><\/p>\n

Pre\u010do boli body pre Qlik zn\u00ed\u017een\u00e9? Z nejasn\u00fdch n\u00e1m pr\u00ed\u010din je mobiln\u00fd klient dostupn\u00fd iba na iPhone, na Androide sa mus\u00ed pou\u017e\u00edva\u0165 be\u017en\u00fd prehliada\u010d. Navy\u0161e pri pou\u017eit\u00ed Qliku je nutn\u00e9 si uvedomi\u0165, \u017ee niektor\u00e9 roz\u0161\u00edrenia alebo vizualiz\u00e1cie sa na mobiln\u00fdch zariadeniach nezmen\u0161uj\u00fa alebo sa automaticky neumiest\u0148uj\u00fa tak, ako sa o\u010dak\u00e1va. Report, ktor\u00fd vyzer\u00e1 ve\u013emi pekne na PC, na malom obrazovke vyzer\u00e1 ove\u013ea hor\u0161ie. Pre mobiln\u00e9 zariadenia je potrebn\u00e9 vytvori\u0165 samostatn\u00fd report, kde sa odstr\u00e1nia filtre, KPI a \u010fal\u0161ie objekty. To sa t\u00fdka aj Power BI a Tableau, ale v Qliku sa to prejavuje obzvl\u00e1\u0161\u0165 silno. D\u00fafame, \u017ee Qlik e\u0161te popracuje na svojom mobilnom kliete. <\/p>\n

Ak pl\u00e1nujete tr\u00e1vi\u0165 ve\u013ea \u010dasu anal\u00fdzou pr\u00e1ve na mobiln\u00fdch zariadeniach, m\u00e1 zmysel nain\u0161talova\u0165 v\u0161etk\u00fdch 3 klientov a na testovac\u00edch reportoch skontrolova\u0165 ich zobrazenie. Ak\u00fdko\u013evek dod\u00e1vate\u013e m\u00e1 na svojej str\u00e1nke gal\u00e9riu testovac\u00edch reportov na obozn\u00e1menie. <\/p>\n

7. Vstavan\u00e1 analytika v extern\u00fdch aplik\u00e1ci\u00e1ch\/sestra\u0148ach<\/h2>\n

\n\"Technick\u00e9
\n
\nPou\u017e\u00edvanie analytiky ako externeho servisu nie je v\u017edy pohodln\u00e9. Mo\u017eno vyv\u00edjate svoj produkt, ale nie ste pripraven\u00ed sa zaobera\u0165 v\u00fdvojom vizualiz\u00e1cie a analytick\u00e9ho enginu od nuly. Mo\u017eno chcete zavies\u0165 analytiku na svojej str\u00e1nke, aby sa klient mohol s\u00e1m registrova\u0165, nahr\u00e1va\u0165 svoje \u00fadaje a vykon\u00e1va\u0165 anal\u00fdzu v r\u00e1mci svojho osobn\u00e9ho \u00fa\u010dtu. Na to potrebujete vstavan\u00fa analytiku (Embedded).
\nV\u0161etky produkty to umo\u017e\u0148uj\u00fa, ale v tejto kateg\u00f3rii vyzdvihneme Qlik. <\/p>\n

Power BI a Tableau jednozna\u010dne tvrdia, \u017ee na tieto \u00fa\u010dely je potrebn\u00e9 zak\u00fapi\u0165 samostatn\u00fd produkt Tableau Embedded Analytics alebo Power BI Embedded. Tieto rie\u0161enia nie s\u00fa lacn\u00e9, st\u00e1\u0165 tis\u00edce dol\u00e1rov mesa\u010dne, \u010do okam\u017eite obmedzuje ich pou\u017eitie. V\u00e4\u010d\u0161ina projektov sa okam\u017eite st\u00e1va nerentabiln\u00fdmi pre na\u0161ich klientov. Je potrebn\u00e9 ma\u0165 na pam\u00e4ti, \u017ee nie je treba len zverejni\u0165 spr\u00e1vu na celom internete, ale zabezpe\u010di\u0165 publikovanie spr\u00e1v pod\u013ea ur\u010dit\u00fdch pr\u00edstupov, s ochranou \u00fadajov, autoriz\u00e1ciou pou\u017e\u00edvate\u013eov at\u010f. <\/p>\n

A Qlik v\u00e1m umo\u017en\u00ed n\u00e1js\u0165 rie\u0161enie. Samozrejme, maj\u00fa aj Qlik Analytics Platform, ktor\u00e1 je licencovan\u00e1 na server a organizuje neobmedzen\u00e9 mno\u017estvo pripojen\u00ed. Bude to tie\u017e drah\u00e9 ako konkurenti Tableau a Power BI. A v pr\u00edpade neobmedzen\u00fdch pripojen\u00ed nie je ve\u013ea mo\u017enost\u00ed. <\/p>\n

Ale v Qlik existuje pojem Mashup. Povedzme, \u017ee m\u00e1te Qlik Sense Enterprise a 10 licenci\u00ed. \u0160tandardn\u00e1 analytika, vzh\u013ead, u\u017e v\u00e1s nebav\u00ed. Vy vytvor\u00edte vlastn\u00fa webov\u00fa str\u00e1nku alebo aplik\u00e1ciu a m\u00f4\u017eete integrova\u0165 cel\u00fa svoju analytiku priamo tam. Pointa je v tom, \u017ee zjednodu\u0161ene povedan\u00e9, Mashup je vizualiz\u00e1cia v programovom k\u00f3de. Prostredn\u00edctvom API m\u00f4\u017eete programovo zad\u00e1va\u0165 vytvorenie vizualiz\u00e1cie vo va\u0161ej aplik\u00e1cii alebo na str\u00e1nke. Qlik Sense Enterprise budete st\u00e1le potrebova\u0165 na licencovanie (licencie na pripojenia k str\u00e1nke = licencie na pripojenia k BI), na na\u010d\u00edtanie \u00fadajov at\u010f., ale vizualiz\u00e1cie sa u\u017e nebud\u00fa zobrazi\u0165 na strane tohto servera, ale bud\u00fa sa integrova\u0165 do va\u0161ej aplik\u00e1cie alebo str\u00e1nky. M\u00f4\u017eete pou\u017e\u00edva\u0165 CSS \u0161t\u00fdly, nastavova\u0165 nov\u00e9 p\u00edsma, farby. Va\u0161ich 10 pou\u017e\u00edvate\u013eov teraz nebude chodi\u0165 na server analytiky, ale bud\u00fa pou\u017e\u00edva\u0165 v\u00e1\u0161 firemn\u00fd port\u00e1l alebo aplik\u00e1ciu. Analytika sa dostane na nov\u00fa \u00farove\u0148. <\/p>\n

\"Technick\u00e9
\nObr\u00e1zok 21. Vzh\u013ead spr\u00e1vy Qlik Sense integrovan\u00e9ho na webovej str\u00e1nke<\/i><\/p>\n

U\u017e bude \u0165a\u017ek\u00e9 pochopi\u0165, kde s\u00fa prvky str\u00e1nky a kde za\u010d\u00edna Qlik Sense.
\nSamozrejme, budete potrebova\u0165 program\u00e1tora, a sk\u00f4r nieko\u013eko. Jeden na webov\u00e9 programovanie, druh\u00fd na pr\u00e1cu s API Qlik. Ale v\u00fdsledok stoj\u00ed za to. <\/p>\n

Z\u00e1ver. Zhrnieme to. <\/h2>\n

\n\"Technick\u00e9
\n
\nJe \u0165a\u017ek\u00e9 jednozna\u010dne poveda\u0165, kto je lep\u0161\u00ed a kto hor\u0161\u00ed. Power BI a Qlik s\u00fa v na\u0161om s\u00fa\u0165a\u017een\u00ed na rovnakej \u00farovni, Tableau o nie\u010do zaost\u00e1va. Ale mo\u017eno pre va\u0161e podnikanie bude v\u00fdsledok in\u00fd. V BI platform\u00e1ch je vizu\u00e1lna zlo\u017eka ve\u013emi d\u00f4le\u017eit\u00e1. Ak ste si prezerali desiatky demoverzi\u00ed a obr\u00e1zkov na internete pre v\u0161etky BI syst\u00e9my a nep\u00e1\u010di sa v\u00e1m, ako jedna z platforiem vyzer\u00e1, pravdepodobne ju nebudete implementova\u0165, aj ke\u010f v\u00e1m vyhovuje cena alebo technick\u00e9 vlastnosti. <\/p>\n

\u010ealej bude nevyhnutn\u00e9 vypo\u010d\u00edta\u0165 n\u00e1klady na licencie, implement\u00e1ciu a \u00fadr\u017ebu BI platformy. Mo\u017eno vo va\u0161om pr\u00edpade vyjde na povrch l\u00edder. Ve\u013ek\u00fd v\u00fdznam m\u00e1 dod\u00e1vate\u013e alebo mo\u017enos\u0165 naja\u0165 vhodn\u00e9ho odborn\u00edka. Bez profesion\u00e1lov bude v\u00fdsledok na akejko\u013evek platforme \u017ealostn\u00fd. <\/p>\n

Prajem v\u00e1m \u00faspe\u0161n\u00e9 BI integr\u00e1cie, Andrej \u017ddanov a Vladim\u00edr Lazarev, Analytics Group<\/p>\n

Zdroj: habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0412\u0440\u0435\u043c\u044f \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0435 \u043d\u0430 \u043f\u0440\u043e\u0447\u0442\u0435\u043d\u0438\u0435 11 \u043c\u0438\u043d\u0443\u0442 \u041c\u044b \u0438 \u041a\u0432\u0430\u0434\u0440\u0430\u0442 \u0413\u0430\u0440\u0442\u043d\u0435\u0440\u0430 2019 BI \ud83d\ude42 \u0426\u0435\u043b\u044c\u044e \u0434\u0430\u043d\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0438 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u0435 \u0442\u0440\u0451\u0445 \u0432\u0435\u0434\u0443\u0449\u0438\u0445 BI \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0430\u0445\u043e\u0434\u044f\u0442\u0441\u044f \u0432 \u043b\u0438\u0434\u0435\u0440\u0430\u0445 \u043a\u0432\u0430\u0434\u0440\u0430\u043d\u0442\u0430 Gartner: \u2014 Power BI (Microsoft) \u2014 Tableau \u2014 Qlik \u0420\u0438\u0441\u0443\u043d\u043e\u043a 1. Gartner BI Magic Quadrant 2019 \u041c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0416\u0434\u0430\u043d\u043e\u0432 \u0410\u043d\u0434\u0440\u0435\u0439, \u044f \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c \u043e\u0442\u0434\u0435\u043b\u0430 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0438 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0438 \u0410\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0441 \u0413\u0440\u0443\u043f\u043f (www.analyticsgroup.ru). […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-30060","post","type-post","status-publish","format-standard","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Technick\u00e9 rozdiely BI syst\u00e9mov (Power BI, Qlik Sense, Tableau) | ProHoster","description":"\u010cas potrebn\u00fd na pre\u010d\u00edtanie 11 min\u00fat. My a Gartnerov kvadrant 2019 BI :-) Cie\u013eom tohto \u010dl\u00e1nku je porovna\u0165 tri ved\u00face BI platformy, ktor\u00e9 sa nach\u00e1dzaj\u00fa v l\u00eddrovskom kvadrante Gartner.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/tehnicheskie-otlichiya-bi-sistem-power-bi-qlik-sense-tableau","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0422\u0435\u0445\u043d\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u043e\u0442\u043b\u0438\u0447\u0438\u044f BI \u0441\u0438\u0441\u0442\u0435\u043c (Power BI, Qlik Sense, Tableau) | ProHoster","og:description":"\u0412\u0440\u0435\u043c\u044f \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0435 \u043d\u0430 \u043f\u0440\u043e\u0447\u0442\u0435\u043d\u0438\u0435 11 \u043c\u0438\u043d\u0443\u0442 \u041c\u044b \u0438 \u041a\u0432\u0430\u0434\u0440\u0430\u0442 \u0413\u0430\u0440\u0442\u043d\u0435\u0440\u0430 2019 BI :-) \u0426\u0435\u043b\u044c\u044e \u0434\u0430\u043d\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0438 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u0435 \u0442\u0440\u0451\u0445 \u0432\u0435\u0434\u0443\u0449\u0438\u0445 BI \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0430\u0445\u043e\u0434\u044f\u0442\u0441\u044f \u0432 \u043b\u0438\u0434\u0435\u0440\u0430\u0445 \u043a\u0432\u0430\u0434\u0440\u0430\u043d\u0442\u0430 Gartner:.","og:url":"https:\/\/prohoster.info\/sk\/blog\/tehnicheskie-otlichiya-bi-sistem-power-bi-qlik-sense-tableau","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T18:33:27+00:00","article:modified_time":"2019-10-31T18:33:27+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"30060","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-20 23:36:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 03:43:14","updated":"2026-01-20 23:36:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/30060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=30060"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/30060\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=30060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=30060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=30060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}