{"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\/cs\/blog\/tehnicheskie-otlichiya-bi-sistem-power-bi-qlik-sense-tableau","title":{"rendered":"Technick\u00e9 rozd\u00edly BI syst\u00e9m\u016f (Power BI, Qlik Sense, Tableau)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Doba pot\u0159ebn\u00e1 k p\u0159e\u010dten\u00ed 11 minut<\/i><\/p>\n

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

\nC\u00edlem tohoto \u010dl\u00e1nku je porovn\u00e1n\u00ed t\u0159\u00ed p\u0159edn\u00edch BI platforem, kter\u00e9 jsou vedouc\u00edmi v Gartnerov\u011b kvadrantu:<\/p>\n

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

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

Jmenuji se \u017ddanov Andrej, jsem vedouc\u00ed odd\u011blen\u00ed analytiky spole\u010dnosti Analytik Group (www.analyticsgroup.ru<\/a><\/noindex>). Vytv\u00e1\u0159\u00edme p\u0159ehledn\u00e9 zpr\u00e1vy o marketingu, prodeji, financ\u00edch, logistice, jin\u00fdmi slovy se zab\u00fdv\u00e1me obchodn\u00ed analytikou a vizualizac\u00ed dat. <\/p>\n

S m\u00fdmi kolegy pracujeme ji\u017e n\u011bkolik let s r\u016fzn\u00fdmi BI platformami. M\u00e1me velmi slu\u0161n\u00e9 zku\u0161enosti s projekty, co\u017e n\u00e1m umo\u017e\u0148uje porovnat platformy z pohledu v\u00fdvoj\u00e1\u0159\u016f, analytik\u016f, obchodn\u00edch u\u017eivatel\u016f a implement\u00e1tor\u016f BI syst\u00e9m\u016f. <\/p>\n

Budeme m\u00edt samostatn\u00fd \u010dl\u00e1nek o porovn\u00e1n\u00ed cen a vizu\u00e1ln\u00edho uspo\u0159\u00e1d\u00e1n\u00ed t\u011bchto BI syst\u00e9m\u016f, proto se zde pokus\u00edme ohodnotit tyto syst\u00e9my pr\u00e1v\u011b z pohledu analytika a v\u00fdvoj\u00e1\u0159e. <\/p>\n

Vy\u010dlen\u00edme n\u011bkolik oblast\u00ed pro anal\u00fdzu a ohodnot\u00edme je na 3bodov\u00e9m syst\u00e9mu:<\/p>\n

\u2014 Prah vstupu a po\u017eadavky na analytika;
\n \u2014 Zdroje dat;
\n \u2014 \u010cist\u011bn\u00ed dat, ETL (Extract, Transform, Load)
\n \u2014 Vizualizace a v\u00fdvoj
\n \u2014 Podnikatelsk\u00e9 prost\u0159ed\u00ed \u2014 server, zpr\u00e1vy
\n \u2014 Podpora mobiln\u00edch za\u0159\u00edzen\u00ed
\n \u2014 Vestav\u011bn\u00e1 analytika v aplikac\u00edch\/webov\u00fdch str\u00e1nk\u00e1ch t\u0159et\u00edch stran<\/p><\/blockquote>\n

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

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

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

Power BI<\/h3>\n

\nVid\u011bl jsem mnoho u\u017eivatel\u016f Power BI, kte\u0159\u00ed nebyli IT specialisty, ale mohli vytvo\u0159it docela slu\u0161nou zpr\u00e1vu. Power BI pou\u017e\u00edv\u00e1 stejn\u00fd jazyk dotaz\u016f jako Excel \u2014 Power Query a jazyk vzorc\u016f DAX. Mnoho analytik\u016f dob\u0159e zn\u00e1 Excel, a proto je pro n\u011b p\u0159echod na tento BI syst\u00e9m pom\u011brn\u011b snadn\u00fd. <\/p>\n

V\u011bt\u0161ina akc\u00ed se prov\u00e1d\u00ed pom\u011brn\u011b snadno v editoru dotaz\u016f. Nav\u00edc exista roz\u0161\u00ed\u0159en\u00fd editor s jazykem M pro profesion\u00e1ly.
\n\"Technick\u00e9
\nObr\u00e1zek 2. N\u00e1vrh\u00e1\u0159 dotaz\u016f Power BI<\/i><\/p>\n

Qlik Sense <\/h3>\n

\nQlik Sense vypad\u00e1 velmi p\u0159\u00e1telsky \u2014 mal\u00e9 mno\u017estv\u00ed nastaven\u00ed, rychl\u00e1 mo\u017enost vytvo\u0159it zpr\u00e1vu, lze pou\u017e\u00edvat n\u00e1vrh\u00e1\u0159 na\u010d\u00edt\u00e1n\u00ed dat. <\/p>\n

Na prvn\u00ed pohled se zd\u00e1 jednodu\u0161\u0161\u00ed ne\u017e Power BI a Tableau. Ale z zku\u0161enosti mohu \u0159\u00edci, \u017ee po n\u011bjak\u00e9 dob\u011b, kdy analytik vytvo\u0159\u00ed n\u011bkolik jednoduch\u00fdch zpr\u00e1v a bude pot\u0159ebovat n\u011bco slo\u017eit\u011bj\u0161\u00edho, se setk\u00e1 s pot\u0159ebou programov\u00e1n\u00ed. <\/p>\n

Qlik m\u00e1 velmi siln\u00fd jazyk pro na\u010d\u00edt\u00e1n\u00ed a zpracov\u00e1n\u00ed dat. Existuje vlastn\u00ed jazyk vzorc\u016f Set Analysis. Proto mus\u00ed analytik um\u011bt ps\u00e1t dotazy a spojen\u00ed, umis\u0165ovat data do virtu\u00e1ln\u00edch tabulek a aktivn\u011b pou\u017e\u00edvat prom\u011bnn\u00e9. Mo\u017enosti jazyka jsou velmi \u0161irok\u00e9, ale vy\u017eaduj\u00ed jeho studium. Snad v\u0161ichni analytici Qlik, kter\u00e9 zn\u00e1m, maj\u00ed n\u011bjak\u00fd v\u00e1\u017en\u00fd IT background. <\/p>\n

Integrator\u016fm Qlik, jako jsme my, se \u010dasto l\u00edb\u00ed vypr\u00e1v\u011bt o asociativn\u00edm modelu, kdy p\u0159i na\u010d\u00edt\u00e1n\u00ed dat jsou v\u0161echna data um\u00edst\u011bna do opera\u010dn\u00ed pam\u011bti a vztah mezi daty je realizov\u00e1n vnit\u0159n\u00edm mechanismem platformy. P\u0159i v\u00fdb\u011bru hodnot nedoch\u00e1z\u00ed k prov\u00e1d\u011bn\u00ed vnit\u0159n\u00edch poddotaz\u016f, jako v klasick\u00fdch datab\u00e1z\u00edch. Data jsou vyd\u00e1v\u00e1na t\u00e9m\u011b\u0159 okam\u017eit\u011b d\u00edky p\u0159edem indexovan\u00fdm hodnot\u00e1m a vazb\u00e1m. <\/p>\n

Pravda je, \u017ee v praxi to vede ke vzniku automatick\u00fdch spojen\u00ed tabulek, kdy\u017e se shoduj\u00ed n\u00e1zvy pol\u00ed. Nap\u0159\u00edklad nelze m\u00edt r\u016fzn\u00e9 tabulky bez vazeb, kter\u00e9 maj\u00ed stejn\u00e9 pole. Na to si mus\u00edte zvyknout. Bu\u010f mus\u00edte p\u0159ejmenov\u00e1vat sloupce a sledovat, aby se n\u00e1zvy neshodovaly, nebo mus\u00edte slou\u010dit v\u0161echny tabulky fakt\u016f do jedn\u00e9 a obklopit je referen\u010dn\u00edmi tabulkami typu \u201ehv\u011bzda\u201c. Snad je to pro nov\u00e1\u010dky pohodln\u00e9, ale zku\u0161en\u00fdm analytik\u016fm u\u017e je to jedno. <\/p>\n

Typick\u00e9 rozhran\u00ed pro na\u010d\u00edt\u00e1n\u00ed a zpracov\u00e1n\u00ed dat pro analytika vypad\u00e1 takto.
\n\"Technick\u00e9
\nObr\u00e1zek 3. Editor na\u010d\u00edt\u00e1n\u00ed dat Qlik Sense, tabulka Calendar<\/i><\/p>\n

Pozn\u00e1mka: V Power BI situace obvykle vypad\u00e1 jinak, nech\u00e1v\u00e1\u0161 r\u016fzn\u00e9 tabulky fakt\u016f a referen\u010dn\u00ed tabulky, m\u016f\u017ee\u0161 tabulky manu\u00e1ln\u011b spojovat klasick\u00fdm zp\u016fsobem, tj. ru\u010dn\u011b p\u0159i\u0159azovat sloupce k sob\u011b.<\/i><\/p>\n

Tableau<\/h3>\n

\nV\u00fdvoj\u00e1\u0159i Tableau se prezentuj\u00ed jako BI s p\u0159\u00edjemn\u00fdm a p\u0159\u00e1telsk\u00fdm rozhran\u00edm, kter\u00e9 umo\u017en\u00ed analytikovi samostatn\u011b zkoumat sv\u00e1 data. Ano, v na\u0161\u00ed firm\u011b byli analytici, kte\u0159\u00ed bez IT zku\u0161enost\u00ed mohli vytv\u00e1\u0159et sv\u00e9 zpr\u00e1vy. Ale hodnocen\u00ed Tableau sn\u00ed\u017e\u00edm z n\u011bkolika d\u016fvod\u016f:
\n \u2014 Slab\u00e1 lokalizace pro ru\u0161tinu
\n \u2014 Servery Tableau Online nejsou v RF
\n \u2014 Pom\u011brn\u011b jednoduch\u00fd editor na\u010d\u00edt\u00e1n\u00ed za\u010d\u00edn\u00e1 zp\u016fsobovat probl\u00e9my, kdy\u017e je pot\u0159eba sestavit pom\u011brn\u011b slo\u017eit\u00fd model dat.
\n\"Technick\u00e9
\nObr\u00e1zek 4. Editor na\u010d\u00edt\u00e1n\u00ed dat Tableau<\/i> <\/p>\n

Jedna z ot\u00e1zek, kter\u00e9 se na pohovoru pro analytiky Tableau pt\u00e1me, je: \u201eJak postavit model faktov\u00fdch tabulek ve spojen\u00ed s referen\u010dn\u00edmi tabulkami, ani\u017e bychom v\u0161echno slou\u010dili do jedn\u00e9 tabulky?!\u201c Data Blending vy\u017eaduje promy\u0161len\u00e9 pou\u017eit\u00ed. Mnohokr\u00e1t jsem opravoval chyby duplicitn\u00edch dat u sv\u00fdch analytik\u016f po takov\u00fdch slou\u010den\u00edch. <\/p>\n

Nav\u00edc m\u00e1 Tableau pom\u011brn\u011b zvl\u00e1\u0161tn\u00ed syst\u00e9m, proto\u017ee ka\u017edou grafiku vytv\u00e1\u0159\u00edte na samostatn\u00e9m listu a pot\u00e9 vytv\u00e1\u0159\u00edte Dashboard, kde za\u010d\u00edn\u00e1te umis\u0165ovat vytvo\u0159en\u00e9 listy. Pot\u00e9 m\u016f\u017eete vytvo\u0159it Story, co\u017e je kombinace r\u016fzn\u00fdch Dashboard\u016f. V\u00fdvoj v Qlik a Power BI je v tomto ohledu jednodu\u0161\u0161\u00ed, prost\u011b na list hod\u00edte \u0161ablony graf\u016f, zad\u00e1te m\u011b\u0159\u00edtka a m\u00edry a Dashboard je hotov\u00fd. Pracovn\u00ed zat\u00ed\u017een\u00ed pro p\u0159\u00edpravu v Tableau se mi zd\u00e1 kv\u016fli tomu vy\u0161\u0161\u00ed.<\/p>\n

2. Zdroje dat a nahr\u00e1v\u00e1n\u00ed <\/h2>\n

\n\"Technick\u00e9
\n
\nV t\u00e9to oblasti nen\u00ed jasn\u00fd l\u00eddr, ale vyzdvihneme Qlik kv\u016fli p\u00e1r p\u0159\u00edjemn\u00fdm vlastnostem. <\/p>\n

Tableau v bezplatn\u00e9 verzi je omezeno ve zdroj\u00edch, ale v na\u0161ich \u010dl\u00e1nc\u00edch se v\u00edce zam\u011b\u0159ujeme na podnik\u00e1n\u00ed, a podniky si mohou dovolit komer\u010dn\u00ed produkty a analytiky. Proto jsme Tableau nesn\u00ed\u017eili hodnocen\u00ed v tomto parametru.
\n\"Technick\u00e9
\nObr\u00e1zek 5. Seznam mo\u017en\u00fdch zdroj\u016f Tableau <\/i> <\/p>\n

Jinak je seznam zdroj\u016f v\u0161ude p\u016fsobiv\u00fd \u2014 v\u0161echny tabulkov\u00e9 soubory, v\u0161echny standardn\u00ed datab\u00e1ze, webov\u00e1 p\u0159ipojen\u00ed, v\u0161echno funguje v\u0161ude. Nesetkal jsem se s nestandardn\u00edmi datov\u00fdmi sklady, tam mohou b\u00fdt sv\u00e9 nuance, ale ve v\u011bt\u0161in\u011b p\u0159\u00edpad\u016f nebudete m\u00edt probl\u00e9my s nahr\u00e1v\u00e1n\u00edm dat. V\u00fdjimkou je snad jen 1C. P\u0159\u00edmo napojen\u00ed na 1C nen\u00ed. <\/p>\n

Partne\u0159i Qlik v Rusku prod\u00e1vaj\u00ed sv\u00e9 vlastn\u00ed konektory za 100 000 \u2013 200 000 rubl\u016f, ale ve v\u011bt\u0161in\u011b p\u0159\u00edpad\u016f je levn\u011bj\u0161\u00ed ud\u011blat exporty z 1C na FTP do Excelu nebo datab\u00e1ze SQL. A m\u016f\u017eete publikovat datab\u00e1zi 1C na webu a p\u0159ipojit se k n\u00ed pomoc\u00ed protokolu Odata. <\/p>\n

PowerBI a Tableau to d\u011blaj\u00ed standardn\u011b, ale Qlik si vy\u017e\u00e1d\u00e1 placen\u00fd konektor, tak\u017ee zde je tak\u00e9 jednodu\u0161\u0161\u00ed vyexportovat do mezilehl\u00e9 datab\u00e1ze. V ka\u017ed\u00e9m p\u0159\u00edpad\u011b m\u016f\u017eeme vy\u0159e\u0161it v\u0161echny ot\u00e1zky t\u00fdkaj\u00edc\u00ed se p\u0159ipojen\u00ed.
\n\"Technick\u00e9
\nObr\u00e1zek 6. Seznam mo\u017en\u00fdch zdroj\u016f Qlik Sense <\/i> <\/p>\n

D\u00e1le stoj\u00ed za zm\u00ednku specifikum Qlik, \u017ee jako samostatn\u00fd produkt dod\u00e1vaj\u00ed jak placen\u00e9, tak bezplatn\u00e9 konektory.
\n \"Technick\u00e9
\nObr\u00e1zek 7. Dal\u0161\u00ed konektory Qlik Sense<\/i> <\/p>\n

Zku\u0161enosti nazna\u010duj\u00ed, \u017ee p\u0159i velk\u00fdch objemech dat nebo mnoha zdroj\u00edch nen\u00ed v\u017edy rozumn\u00e9 hned p\u0159ipojit BI syst\u00e9m. V seri\u00f3zn\u00edch projektech se obvykle pou\u017e\u00edv\u00e1 datov\u00e9 skladi\u0161t\u011b, datab\u00e1ze s ji\u017e p\u0159ipraven\u00fdmi daty pro anal\u00fdzu atd. Nen\u00ed mo\u017en\u00e9 vz\u00edt a exportovat nap\u0159\u00edklad 1 miliardu z\u00e1znam\u016f do BI syst\u00e9mu. Zde u\u017e je pot\u0159eba promyslet architekturu \u0159e\u0161en\u00ed.
\n\"Technick\u00e9
\n\"Technick\u00e9
\nObr\u00e1zek 8. Zdroje dat Power BI<\/i><\/p>\n

Ale pro\u010d byl vybr\u00e1n Qlik? L\u00edb\u00ed se mi na n\u011bm 3 v\u011bci:
\n \u2014 QVD soubory<\/b>
\nVlastn\u00ed form\u00e1t ukl\u00e1d\u00e1n\u00ed dat. N\u011bkdy lze postavit v\u00e1\u017en\u00e9 komer\u010dn\u00ed projekty pouze na QVD souborech. Nap\u0159\u00edklad, prvn\u00ed \u00farove\u0148 \u2014 surov\u00e1 data. Druh\u00e1 \u00farove\u0148 \u2014 zpracovan\u00e9 soubory. T\u0159et\u00ed \u00farove\u0148 \u2014 agregovan\u00e1 data atd. Tyto soubory lze vyu\u017e\u00edt v r\u016fzn\u00fdch aplikac\u00edch, mohou za n\u011b odpov\u00eddat r\u016fzn\u00ed zam\u011bstnanci a slu\u017eby. Rychlost na\u010d\u00edt\u00e1n\u00ed z t\u011bchto soubor\u016f je desetkr\u00e1t rychlej\u0161\u00ed ne\u017e z b\u011b\u017en\u00fdch zdroj\u016f dat. To umo\u017e\u0148uje \u0161et\u0159it na datab\u00e1zi a vym\u011b\u0148ovat informace mezi r\u016fzn\u00fdmi aplikacemi Qlik. <\/p>\n

\u2014 Inkremen\u010dn\u00ed na\u010d\u00edt\u00e1n\u00ed dat<\/b>
\nAno, Power BI a Tableau to tak\u00e9 um\u00ed. Ale Power BI vy\u017eaduje drahou Premium verzi, a v Tableau nen\u00ed takov\u00e1 flexibilita jako v Qlik. V Qlik m\u016f\u017eete na QVD souborech prov\u00e1d\u011bt snapshoty syst\u00e9m\u016f v r\u016fzn\u00fdch \u010dasov\u00fdch okam\u017eic\u00edch a pot\u00e9 tato data zpracov\u00e1vat podle va\u0161ich pot\u0159eb.<\/p>\n

\u2014 P\u0159ipojen\u00ed extern\u00edch skript\u016f<\/b>
\nKrom\u011b QVD soubor\u016f pro uchov\u00e1v\u00e1n\u00ed dat lze v Qlik skript tak\u00e9 um\u00edstit mimo aplikaci a p\u0159ipojit p\u0159\u00edkazem Include. To ji\u017e umo\u017e\u0148uje zorganizovat t\u00fdmovou pr\u00e1ci, pou\u017e\u00edvat syst\u00e9my \u0159\u00edzen\u00ed verz\u00ed a spravovat jednotn\u00fd k\u00f3d pro r\u016fzn\u00e9 aplikace. V Power BI je pokro\u010dil\u00fd editor dotaz\u016f, ale takovou t\u00fdmovou pr\u00e1ci jsme neumo\u017enili nastavit jako v Qlik. Ostatn\u011b v\u0161echny BI maj\u00ed s t\u00edmto pot\u00ed\u017ee, spravovat sou\u010dasn\u011b data, k\u00f3d a vizualizace ve v\u0161ech aplikac\u00edch z jedin\u00e9ho m\u00edsta je jednodu\u0161e nemo\u017en\u00e9. Maxim\u00e1ln\u011b, co jsme dok\u00e1zali ud\u011blat, je vyv\u00e9st QVD soubory a k\u00f3d skript\u016f. Vizu\u00e1ln\u00ed prvky mus\u00edme upravovat uvnit\u0159 samotn\u00fdch report\u016f, co\u017e n\u00e1m neumo\u017e\u0148uje hromadn\u011b m\u011bnit vizualizace u v\u0161ech klient\u016f sou\u010dasn\u011b. <\/p>\n

A jak je to s mechanismem Live p\u0159ipojen\u00ed? Tableau a Power BI podporuj\u00ed LIVE p\u0159ipojen\u00ed k n\u011bkolika zdroj\u016fm, na rozd\u00edl od Qlik. Na tuto funkci se d\u00edv\u00e1me pon\u011bkud lhostejn\u011b, proto\u017ee praxe ukazuje, \u017ee kdy\u017e jde o velk\u00e1 data, pr\u00e1ce s LIVE p\u0159ipojen\u00edm se st\u00e1v\u00e1 t\u00e9m\u011b\u0159 nemo\u017enou. A BI v\u011bt\u0161inou pot\u0159ebujeme pro velk\u00e1 data. <\/p>\n

3. \u010cist\u011bn\u00ed dat, ETL (Extract, Transform, Load)<\/h2>\n

\n\"Technick\u00e9
\n
\nV t\u00e9to sekci m\u00e1m dva l\u00eddry, Qlik Sense a Power BI.
\n\u0158ekn\u011bme, \u017ee Qlik je mocn\u00fd, ale slo\u017eit\u00fd. Kdy\u017e se nau\u010d\u00edte jejich SQL podobn\u00fd jazyk, budete moci t\u00e9m\u011b\u0159 v\u0161echno \u2014 virtu\u00e1ln\u00ed tabulky, spojen\u00ed a sjednocen\u00ed tabulek, proj\u00edt cyklem tabulkou a vygenerovat nov\u00e9 tabulky, spousta p\u0159\u00edkaz\u016f na zpracov\u00e1n\u00ed \u0159et\u011bzc\u016f. Nap\u0159\u00edklad pole v jedn\u00e9 bu\u0148ce, kter\u00e9 obsahuje data ve form\u00e1tu \"Ivanov 851 B\u00edl\u00fd\", lze na m\u00edst\u011b rozlo\u017eit nejen na 3 sloupce (jak to um\u00ed v\u0161ichni), ale p\u0159\u00edmo i na 3 \u0159\u00e1dky. Tot\u00e9\u017e na m\u00edst\u011b ud\u011blat sjednocen\u00ed 3 \u0159\u00e1dk\u016f do 1 je tak\u00e9 snadn\u00e9.
\n\"Technick\u00e9
\nObr\u00e1zek 9. Jak na\u010d\u00edst a transponovat tabulku v Qlik Sense z Google Sheets<\/i><\/p>\n

Power BI v tomto ohledu vypad\u00e1 jednodu\u0161eji, ale v\u011bt\u0161ina \u00fakol\u016f se snadno \u0159e\u0161\u00ed p\u0159es n\u00e1vrh\u00e1\u0159 dotaz\u016f. Nastavil jsem \u0159adu parametr\u016f, transponoval tabulku, pracoval s daty, a to v\u0161e bez jedin\u00e9 \u0159\u00e1dky k\u00f3du.
\n\"Technick\u00e9
\nObr\u00e1zek 10. Jak na\u010d\u00edst a transponovat tabulku v Power BI z AmoCRM<\/i><\/p>\n

U Tableu mi p\u0159ijde, \u017ee maj\u00ed jinou ideologii. V\u00edce dbaj\u00ed na kr\u00e1su a design. P\u0159ipojit spoustu r\u016fzn\u00fdch zdroj\u016f, sjednotit je v\u0161echny a zpracovat uvnit\u0159 Tableu mi p\u0159ipad\u00e1 velmi obt\u00ed\u017en\u00e9. V komer\u010dn\u00edch projektech se v\u011bt\u0161inou pro Tableau data ji\u017e p\u0159ipravuj\u00ed a akumuluj\u00ed ve skladov\u00fdch a datab\u00e1zov\u00fdch syst\u00e9mech.
\n \"Technick\u00e9
\nObr\u00e1zek 11. Jak na\u010d\u00edst a transponovat tabulku v Tableu<\/i><\/p>\n

4. Vizualizace<\/h2>\n

\n\"Technick\u00e9
\n
\nV t\u00e9to sekci jsme nevy\u010dlenili l\u00eddra. Budeme m\u00edt samostatn\u00fd \u010dl\u00e1nek, kde na p\u0159\u00edkladu jednoho p\u0159\u00edpadu uk\u00e1\u017eeme stejnou zpr\u00e1vu ve v\u0161ech 3 syst\u00e9mech. (\u010cl\u00e1nek \u201eAnalytika d\u00edvek s n\u00edzkou soci\u00e1ln\u00ed odpov\u011bdnost\u00ed\u201c)<\/a><\/noindex>Je to v\u00edce o vkusu a dovednostech analytika. Na internetu najdete velmi kr\u00e1sn\u00e9 obr\u00e1zky postaven\u00e9 na kter\u00e9koliv z t\u011bchto syst\u00e9m\u016f. Z\u00e1kladn\u00ed mo\u017enosti vizualizac\u00ed jsou u v\u0161ech zhruba stejn\u00e9. Zbytek se \u0159e\u0161\u00ed pomoc\u00ed roz\u0161\u00ed\u0159en\u00ed. Existuj\u00ed placen\u00e1 i bezplatn\u00e1. Jsou tu roz\u0161\u00ed\u0159en\u00ed od samotn\u00fdch dodavatel\u016f, stejn\u011b jako od freelanc\u00e9r\u016f a integr\u00e1tor\u016f. M\u016f\u017eete si napsat vlastn\u00ed vizualiza\u010dn\u00ed roz\u0161\u00ed\u0159en\u00ed pro jakoukoli platformu. <\/p>\n

M\u00e1m r\u00e1d styl Tableau, pova\u017euji ho za p\u0159\u00edsn\u00fd a korpor\u00e1tn\u00ed. Ale skute\u010dn\u011b kr\u00e1sn\u00fd obr\u00e1zek v Tableau se t\u011b\u017eko z\u00edsk\u00e1v\u00e1. Skv\u011bl\u00fd p\u0159\u00edklad vizualizace Tableau, kde jsou pou\u017eita pouze roz\u0161\u00ed\u0159en\u00ed. Nesm\u00edm to tak opakovat, proto\u017ee nem\u00e1m tato roz\u0161\u00ed\u0159en\u00ed, ale vypad\u00e1 to hezky.
\n\"Technick\u00e9
\nObr\u00e1zek 12. Vzhled zpr\u00e1v Tableau s roz\u0161\u00ed\u0159en\u00edmi<\/i> <\/p>\n

I Power BI m\u016f\u017ee b\u00fdt zaj\u00edmav\u00e9.
\n\"Technick\u00e9
\nObr\u00e1zek 13. Vzhled zpr\u00e1v Power BI s roz\u0161\u00ed\u0159en\u00edmi<\/i><\/p>\n

Jedna v\u011bc, kterou nech\u00e1pu v Power BI, je, pro\u010d maj\u00ed tak zvl\u00e1\u0161tn\u00ed v\u00fdchoz\u00ed barvy. Na jak\u00e9mkoli grafu mus\u00edm zm\u011bnit barvu na svou firemn\u00ed a div\u00edm se standardn\u00edmu barevn\u00e9mu sch\u00e9matu. <\/p>\n

Qlik Sense tak\u00e9 z\u00e1vis\u00ed na roz\u0161\u00ed\u0159en\u00edch. Pou\u017eit\u00ed dopl\u0148k\u016f m\u016f\u017ee zm\u011bnit zpr\u00e1vy k nepozn\u00e1n\u00ed. Tak\u00e9 si m\u016f\u017eete nainstalovat vlastn\u00ed t\u00e9ma a design.
\n\"Technick\u00e9
\nObr\u00e1zek 14. Vzhled zpr\u00e1v Qlik Sense s roz\u0161\u00ed\u0159en\u00edmi<\/i> <\/p>\n

Z pohledu v\u00fdvoj\u00e1\u0159e je pro m\u011b Qlik Sense pohodln\u011bj\u0161\u00ed d\u00edky standardn\u00edm mo\u017enostem, jako jsou alternativn\u00ed dimenze a m\u011b\u0159en\u00ed. V nastaven\u00edch vizualizace m\u016f\u017eete zadat n\u011bkolik dimenz\u00ed a m\u011b\u0159en\u00ed a u\u017eivatel si m\u016f\u017ee snadno nastavit, co chce na kter\u00e9m grafu vid\u011bt. <\/p>\n

V Power BI a Tableau mus\u00edm nastavovat parametry, tla\u010d\u00edtka, programovat chov\u00e1n\u00ed syst\u00e9mu podle t\u011bchto parametr\u016f. Div\u00edm se, pro\u010d je to tak slo\u017eit\u00e9. Tot\u00e9\u017e plat\u00ed pro mo\u017enost zm\u011bnit vzhled vizualizac\u00ed. <\/p>\n

V Qliku m\u016f\u017eete v jednom objektu skr\u00fdt r\u016fzn\u00e9 typy vizualizac\u00ed, zat\u00edmco v Power BI a Tableau je to slo\u017eit\u011bj\u0161\u00ed. Op\u011bt plat\u00ed, \u017ee to v\u00edce z\u00e1vis\u00ed na dovednostech prov\u00e1d\u011bj\u00edc\u00edho. V jak\u00e9mkoli syst\u00e9mu lze vytvo\u0159it mistrovsk\u00e9 d\u00edlo, ale bez zku\u0161enost\u00ed budou v\u0161ude vznikat nev\u00fdrazn\u00e9 grafiky. <\/p>\n

5. Korpor\u00e1tn\u00ed prost\u0159ed\u00ed \u2014 server, zpr\u00e1vy<\/h2>\n

\n\"Technick\u00e9
\n
\nV\u0161echny produkty maj\u00ed firemn\u00ed serverov\u00e9 verze. Pracoval jsem se v\u0161emi edicemi a mohu \u0159\u00edci, \u017ee ka\u017ed\u00e1 m\u00e1 sv\u00e9 siln\u00e9 a slab\u00e9 str\u00e1nky. V\u00fdb\u011br produktu by m\u011bl b\u00fdt p\u0159izp\u016fsoben va\u0161im softwarov\u00fdm po\u017eadavk\u016fm s ohledem na jejich nuance. V\u0161ichni dodavatel\u00e9 umo\u017e\u0148uj\u00ed p\u0159id\u011blovat pr\u00e1va jak na \u00farovni \u00fa\u010dt\u016f a skupin, tak na \u00farovni Data Row Level Security. Je k dispozici automatick\u00e9 aktualizace zpr\u00e1v podle pl\u00e1nu. <\/p>\n

Qlik Sense Enterprise je skv\u011blou p\u0159\u00edle\u017eitost\u00ed, jak vybudovat anal\u00fdzu uvnit\u0159 va\u0161\u00ed organizace pro st\u0159edn\u00ed podniky. To se m\u016f\u017ee zd\u00e1t dra\u017e\u0161\u00ed ne\u017e Power BI Pro, ale nesm\u00edme zapom\u00ednat, \u017ee servery Power BI Pro jsou v cloudu na \u00fazem\u00ed Microsoftu a na v\u00fdkon nem\u00e1te vliv. A kdy\u017e budete pot\u0159ebovat Power BI Premium, kter\u00e9 lze nasadit na va\u0161ich serverech, cena za\u010d\u00edn\u00e1 od 5000 $ m\u011bs\u00ed\u010dn\u011b. <\/p>\n

\"Technick\u00e9
\n
\nQlik Sense Enterprise za\u010d\u00edn\u00e1 od 230 000 K\u010d za 5 licenc\u00ed (platba za rok, pot\u00e9 pouze technick\u00e1 podpora), co\u017e je mnohem dostupn\u011bj\u0161\u00ed ne\u017e Power BI Premium. A Qlik Sense Enterprise umo\u017e\u0148uje vyu\u017e\u00edt v\u0161echny mo\u017enosti Qlik. Snad krom\u011b jedn\u00e9. N\u011bkdej\u0161\u00ed rozhodnut\u00ed Qlik dodat mo\u017enost odes\u00edlat zpr\u00e1vy ve form\u00e1tu PDF e-mailem jako samostatnou slu\u017ebu NPrinting je pon\u011bkud nepochopiteln\u00e9.<\/p>\n

Ale Qlik Sense Enterprise je mocn\u011bj\u0161\u00ed ne\u017e Power BI Pro, a proto zde m\u016f\u017eeme prov\u00e9st n\u00e1sleduj\u00edc\u00ed srovn\u00e1n\u00ed. <\/p>\n

Qlik Sense Enterprise = Power BI Premium. P\u0159i stejn\u00fdch mo\u017enostech je to levn\u011bj\u0161\u00ed p\u0159i pr\u016fm\u011brn\u00fdch nasazen\u00edch. Velk\u00e1 nasazen\u00ed se obvykle posuzuj\u00ed na stran\u011b dodavatele, kde mohou nab\u00edzet individu\u00e1ln\u00ed podm\u00ednky pro va\u0161i firmu. <\/p>\n

V tomto ohledu d\u00e1me p\u0159ednost Qlik Sense Enterprise, tam jsou v\u0161echny mo\u017enosti pro v\u00fdstavbu v\u00e1\u017en\u00e9 analytiky na obrovsk\u00fdch datech. Podle na\u0161eho n\u00e1zoru bude Qlik fungovat rychleji ne\u017e Power BI na velk\u00fdch datech; na konferenc\u00edch Qlik jsme se setk\u00e1vali se z\u00e1kazn\u00edky, kte\u0159\u00ed zpo\u010d\u00e1tku testovali sv\u00e9 data v miliard\u00e1ch z\u00e1znam\u016f a Power BI ukazoval hor\u0161\u00ed v\u00fdsledky.
\n\"Technick\u00e9
\nObr\u00e1zek 15. Vzhled zpr\u00e1v serveru Qlik Sense Enterprise<\/i> <\/p>\n

Qlik Sense Cloud = Power BI Pro. Qlik Sense Cloud je o 1,5 n\u00e1sobek dra\u017e\u0161\u00ed* a existuje v\u00fdznamn\u00e9 omezen\u00ed, kter\u00e9 n\u00e1m neumo\u017e\u0148uje pou\u017e\u00edt tuto platformu. Nen\u00ed mo\u017en\u00e9 pou\u017e\u00edvat roz\u0161\u00ed\u0159en\u00ed, ani vestav\u011bn\u00e1. Bez roz\u0161\u00ed\u0159en\u00ed ztr\u00e1c\u00ed Qlik svou vizu\u00e1ln\u00ed kr\u00e1su.
\n\"Technick\u00e9
\nObr\u00e1zek 16. Vzhled \u0159\u00eddic\u00edho panelu Power BI Pro<\/i> <\/p>\n

*Alternativou je vyu\u017eit\u00ed Qlik Sense Enterprise na z\u00e1klad\u011b p\u0159edplatn\u00e9ho. Aby tento \u010dl\u00e1nek nebyl vn\u00edm\u00e1n jako reklama, nebudeme se zab\u00fdvat na\u0161\u00ed cenotvorbou. <\/p><\/blockquote>\n

Tableau pro n\u00e1s stoj\u00ed trochu stranou. Nab\u00edz\u00ed jak cloudov\u00e9 p\u0159edplatn\u00e9 za 70 $ na v\u00fdvoj\u00e1\u0159e a 15 $ na u\u017eivatele, tak tak\u00e9 drah\u00e1 serverov\u00e1 \u0159e\u0161en\u00ed. Hlavn\u00ed my\u0161lenkou Tableau je v\u0161ak, \u017ee pro velk\u00e1 data je t\u0159eba organizovat zpracov\u00e1n\u00ed a ukl\u00e1d\u00e1n\u00ed dat na stran\u011b. Objektivn\u011b men\u0161\u00ed funkcionalita neumo\u017e\u0148uje prov\u00e1d\u011bt v\u00e1\u017en\u00e9 zpracov\u00e1n\u00ed dat v Tableau. Vizualizovat, analyzovat, ano. Ale pro mal\u00e9 a st\u0159edn\u00ed podniky b\u00fdv\u00e1 obvykle probl\u00e9mem vytvo\u0159it samostatn\u00e9 \u00falo\u017ei\u0161t\u011b. Proto bych sn\u00ed\u017eil hodnocen\u00ed Tableau, kdyby to nebylo jejich unik\u00e1tn\u00ed z\u00e1znam. Server Tableau bez probl\u00e9m\u016f zas\u00edl\u00e1 e-maily podle pl\u00e1nu s p\u0159\u00edlohami ve form\u00e1tu CSV nebo PDF. Lze tak\u00e9 nastavovat opr\u00e1vn\u011bn\u00ed, automatick\u00e9 filtry a dal\u0161\u00ed. Power BI a Qlik to z n\u011bjak\u00e9ho d\u016fvodu neum\u00ed, co\u017e m\u016f\u017ee b\u00fdt pro n\u011bkoho kritick\u00e9. D\u00edky tomu Tableau udr\u017euje svou pozici v na\u0161em sporu. <\/p>\n

\"Technick\u00e9
\nObr\u00e1zek 17. Vzhled \u0159\u00eddic\u00edho panelu Tableau Server.<\/i><\/p>\n

Tak\u00e9 v korpor\u00e1tn\u00edm prost\u0159ed\u00ed je t\u0159eba zv\u00e1\u017eit n\u00e1klady na implementaci a \u00fadr\u017ebu. V Rusku se ust\u00e1lil trend, \u017ee Power BI je v\u00edce roz\u0161\u00ed\u0159en\u00fd v mal\u00e9m podnik\u00e1n\u00ed. To vedlo k vzniku velk\u00e9ho mno\u017estv\u00ed pracovn\u00edch nab\u00eddek a \u017eivotopis\u016f, jako\u017e i k vzniku n\u011bkolika integr\u00e1tor\u016f. To umo\u017en\u00ed naj\u00edt specialisty pro men\u0161\u00ed projekty. Ale pravd\u011bpodobn\u011b v\u011bt\u0161ina z nich nebude m\u00edt zku\u0161enosti s v\u011bt\u0161\u00edmi implementacemi a prac\u00ed s velk\u00fdmi daty. Qlik a Tableau jsou naopak. Partner\u016f Qlik je m\u00e1lo, a Tableau je\u0161t\u011b m\u00e9n\u011b. Tito partne\u0159i se specializuj\u00ed na v\u011bt\u0161\u00ed implementace s vysok\u00fdm pr\u016fm\u011brn\u00fdm \u00fa\u010dtem. Nab\u00eddky a \u017eivotopisy na trhu nejsou po\u010detn\u00e9, p\u0159ek\u00e1\u017eka vstupu do t\u011bchto produkt\u016f je slo\u017eit\u011bj\u0161\u00ed ne\u017e v p\u0159\u00edpad\u011b Power BI. Ale v Rusku existuj\u00ed \u00fasp\u011b\u0161n\u00e9 implementace t\u011bchto produkt\u016f pro tis\u00edce u\u017eivatel\u016f a tyto produkty se dob\u0159e osv\u011bd\u010duj\u00ed na velk\u00fdch datech. Je t\u0159eba prost\u011b pochopit slab\u00e9 a siln\u00e9 str\u00e1nky produkt\u016f v souvislosti pr\u00e1v\u011b s va\u0161\u00edm podnik\u00e1n\u00edm. <\/p>\n

6. Podpora mobiln\u00edch za\u0159\u00edzen\u00ed. <\/h2>\n

\n\"Technick\u00e9
\n
\nV t\u00e9to \u010d\u00e1sti se zam\u011b\u0159\u00edme na Power BI a Tableau. M\u016f\u017eete nainstalovat mobiln\u00ed aplikace, kter\u00e9 se na obrazovk\u00e1ch mobiln\u00edch za\u0159\u00edzen\u00ed zobrazuj\u00ed celkem dob\u0159e. I kdy\u017e se n\u00e1m zd\u00e1, \u017ee analytika na mobiln\u00edch za\u0159\u00edzen\u00edch zaost\u00e1v\u00e1 za analytikou na PC. Nen\u00ed tak pohodln\u00e9 pou\u017e\u00edvat filtry, obr\u00e1zky jsou mal\u00e9, \u010d\u00edsla \u0161patn\u011b viditeln\u00e1 apod. <\/p>\n

\"Technick\u00e9
\nObr\u00e1zek 18. Vzhled zpr\u00e1vy Power BI na iPhonu<\/i><\/p>\n

\"Technick\u00e9
\nObr\u00e1zek 19. Vzhled zpr\u00e1vy Tableau na iPhonu<\/i><\/p>\n

\"Technick\u00e9
\nObr\u00e1zek 20. Vzhled zpr\u00e1vy Qlik Sense na iPhonu<\/i><\/p>\n

Pro\u010d jsme sn\u00ed\u017eili hodnocen\u00ed Qlik? Z n\u00e1m nepochopiteln\u00fdch d\u016fvod\u016f je mobiln\u00ed klient dostupn\u00fd pouze na iPhonu, na Androidu si budete muset vysta\u010dit s b\u011b\u017en\u00fdm prohl\u00ed\u017ee\u010dem. Nav\u00edc je t\u0159eba ihned pochopit, \u017ee \u0159ada roz\u0161\u00ed\u0159en\u00ed nebo vizualizac\u00ed se na mobiln\u00edch za\u0159\u00edzen\u00edch nezmen\u0161uje nebo se neposunuje automaticky, jak by se o\u010dek\u00e1valo. Zpr\u00e1va, kter\u00e1 v PC vypad\u00e1 velmi dob\u0159e, na mal\u00e9m displeji vypad\u00e1 mnohem h\u016f\u0159e. Je nutn\u00e9 vytv\u00e1\u0159et pro mobiln\u00ed za\u0159\u00edzen\u00ed zvl\u00e1\u0161tn\u00ed zpr\u00e1vu, kde se odstra\u0148uj\u00ed filtry, KPI a dal\u0161\u00ed objekty. To se tak\u00e9 t\u00fdk\u00e1 Power BI nebo Tableau, ale v Qlik to je zvl\u00e1\u0161\u0165 v\u00fdrazn\u00e9. Douf\u00e1me, \u017ee Qlik je\u0161t\u011b zapracuje na sv\u00e9m mobiln\u00edm klientu. <\/p>\n

Pokud pl\u00e1nujete tr\u00e1vit hodn\u011b \u010dasu anal\u00fdzou p\u0159\u00edmo z mobiln\u00edch za\u0159\u00edzen\u00ed, m\u00e1 smysl nainstalovat v\u0161echny 3 klienty a na testovac\u00edch zpr\u00e1v\u00e1ch ov\u011b\u0159it jejich zobrazen\u00ed. Ka\u017ed\u00fd dodavatel m\u00e1 na sv\u00fdch str\u00e1nk\u00e1ch galerii testovac\u00edch zpr\u00e1v pro sezn\u00e1men\u00ed. <\/p>\n

7. Vlo\u017een\u00e1 (embedded) analytika do extern\u00edch aplikac\u00ed\/web\u016f<\/h2>\n

\n\"Technick\u00e9
\n
\nVyu\u017e\u00edv\u00e1n\u00ed analytiky jako extern\u00edho servisu nen\u00ed v\u017edy pohodln\u00e9. Mo\u017en\u00e1 vyv\u00edj\u00edte sv\u016fj produkt, ale nejste p\u0159ipraveni na v\u00fdvoj vizualizace a analytick\u00e9ho enginu od nuly. Mo\u017en\u00e1 chcete nasadit analytiku na sv\u00e9m webu, aby se klient s\u00e1m registroval, nahr\u00e1val sv\u00e1 data a prov\u00e1d\u011bl anal\u00fdzu v r\u00e1mci sv\u00e9ho u\u017eivatelsk\u00e9ho \u00fa\u010dtu. K tomu pot\u0159ebujete vlo\u017eenou analytiku (Embedded).
\nV\u0161echny produkty to umo\u017e\u0148uj\u00ed, ale v t\u00e9to kategorii vyzdvihneme Qlik. <\/p>\n

Power Bi a Tableau jasn\u011b \u0159\u00edkaj\u00ed, \u017ee pro takov\u00e9 \u00fa\u010dely je t\u0159eba zakoupit samostatn\u00fd produkt Tableau Embedded Analytics nebo Power BI Embedded. Tato \u0159e\u0161en\u00ed nejsou levn\u00e1 a stoj\u00ed tis\u00edce dolar\u016f za m\u011bs\u00edc, co\u017e okam\u017eit\u011b omezuje jejich vyu\u017eit\u00ed. V\u011bt\u0161ina projekt\u016f se tak okam\u017eit\u011b st\u00e1v\u00e1 nerentabiln\u00ed pro na\u0161e klienty. M\u011bjte na pam\u011bti, \u017ee je pot\u0159eba nejen publikovat zpr\u00e1vu na cel\u00e9m internetu, ale zajistit publikaci zpr\u00e1v podle ur\u010dit\u00fdch p\u0159\u00edstup\u016f, s ochranou dat, autorizac\u00ed u\u017eivatel\u016f apod. <\/p>\n

Qlik v\u00e1m v\u0161ak umo\u017en\u00ed naj\u00edt \u0159e\u0161en\u00ed. Samoz\u0159ejm\u011b maj\u00ed tak\u00e9 Qlik Analytics Platform, kter\u00e1 je licencov\u00e1na na server a umo\u017e\u0148uje neomezen\u00fd po\u010det p\u0159ipojen\u00ed. To bude tak\u00e9 drah\u00e9, jako u konkurent\u016f Tableau a Power Bi. A pokud jde o neomezen\u00e1 p\u0159ipojen\u00ed, opc\u00ed p\u0159\u00edli\u0161 nen\u00ed. <\/p>\n

Ve Qlik existuje pojem Mashup. P\u0159edstavte si, \u017ee m\u00e1te Qlik Sense Enterprise a 10 licenc\u00ed. Standardn\u00ed analytika, vzhled \u2013 to u\u017e v\u00e1s omrzelo. Spust\u00edte vlastn\u00ed web nebo aplikaci a m\u016f\u017eete do n\u00ed integrovat svou analytiku p\u0159\u00edmo. Podstatou je, \u017ee zjednodu\u0161en\u011b \u0159e\u010deno, Mashup je vizualizace v programov\u00e9m k\u00f3du. Pomoc\u00ed API m\u016f\u017eete programov\u011b ur\u010dit vytvo\u0159en\u00ed vizualizace uvnit\u0159 sv\u00e9 aplikace nebo webu. Qlik Sense Enterprise budete st\u00e1le pot\u0159ebovat pro licencov\u00e1n\u00ed (licence na p\u0159ipojen\u00ed k webu = licence na p\u0159ipojen\u00ed k BI), pro na\u010d\u00edt\u00e1n\u00ed dat atd., ale vizualizace se ji\u017e nebudou zobrazovat na stran\u011b tohoto serveru, ale budou integrovan\u00e9 do va\u0161\u00ed aplikace nebo webu. M\u016f\u017eete vyu\u017e\u00edt CSS styly, zad\u00e1vat nov\u00e9 p\u00edsma, barvy. Va\u0161ich 10 u\u017eivatel\u016f nyn\u00ed nebude vstupovat na server analytiky, ale budou pou\u017e\u00edvat v\u00e1\u0161 firemn\u00ed port\u00e1l nebo aplikaci. Analytika se posune na novou \u00farove\u0148. <\/p>\n

\"Technick\u00e9
\nObr\u00e1zek 21. Vzhled zpr\u00e1vy Qlik Sense integrovan\u00e9 na webov\u00fdch str\u00e1nk\u00e1ch<\/i><\/p>\n

U\u017e bude obt\u00ed\u017en\u00e9 poznat, kde kon\u010d\u00ed prvky webu a kde za\u010d\u00edn\u00e1 Qlik Sense.
\nSamoz\u0159ejm\u011b budete pot\u0159ebovat program\u00e1tora, nebo sp\u00ed\u0161e n\u011bkolik. Jeden na webov\u00e9 programov\u00e1n\u00ed, dal\u0161\u00ed pro pr\u00e1ci s API Qlik. Ale v\u00fdsledek stoj\u00ed za to. <\/p>\n

Z\u00e1v\u011bry. Shr\u0148me to. <\/h2>\n

\n\"Technick\u00e9
\n
\nT\u011b\u017eko \u0159\u00edci, kdo je lep\u0161\u00ed a kdo hor\u0161\u00ed. Power BI a Qlik v na\u0161em srovn\u00e1n\u00ed jsou na stejn\u00e9 \u00farovni, Tableau m\u00edrn\u011b zaost\u00e1v\u00e1. Ale pro va\u0161e podnik\u00e1n\u00ed m\u016f\u017ee b\u00fdt v\u00fdsledek jin\u00fd. V BI platform\u00e1ch je velmi d\u016fle\u017eit\u00e1 vizu\u00e1ln\u00ed slo\u017eka. Pokud jste prozkoumali des\u00edtky demoverz\u00ed a obr\u00e1zk\u016f na internetu ohledn\u011b v\u0161ech BI syst\u00e9m\u016f a nel\u00edb\u00ed se v\u00e1m vzhled jedn\u00e9 z platforem, pravd\u011bpodobn\u011b ji nebudete zav\u00e1d\u011bt, i kdy\u017e v\u00e1s uspokoj\u00ed cena nebo technick\u00e9 parametry. <\/p>\n

D\u00e1le bude nezbytn\u00e9 spo\u010d\u00edtat n\u00e1klady na licence, zaveden\u00ed a \u00fadr\u017ebu BI platformy. Je mo\u017en\u00e9, \u017ee v \u0432\u0430\u0448\u0435\u043c p\u0159\u00edpad\u011b vzejde najevo l\u00eddr. Velk\u00fd v\u00fdznam m\u00e1 dodavatel nebo mo\u017enost najmout vhodn\u00e9ho specialistu. Bez profesion\u00e1l\u016f bude v\u00fdsledek v jak\u00e9koli platform\u011b \u017ealostn\u00fd. <\/p>\n

P\u0159ejeme v\u00e1m \u00fasp\u011b\u0161n\u00e9 BI integrace, 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 rozd\u00edly BI syst\u00e9m\u016f (Power BI, Qlik Sense, Tableau) | ProHoster","description":"Doba pot\u0159ebn\u00e1 na p\u0159e\u010dten\u00ed 11 minut My a Gartner\u016fv kvadrant 2019 BI :-) C\u00edlem tohoto \u010dl\u00e1nku je srovn\u00e1n\u00ed t\u0159\u00ed p\u0159edn\u00edch BI platforem, kter\u00e9 jsou l\u00eddry v Gartnerov\u011b kvadrantu.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/tehnicheskie-otlichiya-bi-sistem-power-bi-qlik-sense-tableau","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/30060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=30060"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/30060\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=30060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=30060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=30060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}