{"id":96442,"date":"2020-10-11T19:42:46","date_gmt":"2020-10-11T17:42:46","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/kak-vybrat-instrument-dlya-biznes-analiza"},"modified":"2020-10-11T19:42:46","modified_gmt":"2020-10-11T17:42:46","slug":"kak-vybrat-instrument-dlya-biznes-analiza","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/kak-vybrat-instrument-dlya-biznes-analiza","title":{"rendered":"Ako si vybra\u0165 n\u00e1stroj na biznis anal\u00fdzu","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<h2>Ak\u00fd je v\u00e1\u0161 v\u00fdber?<\/h2>\n<p>\n\u010casto m\u00f4\u017ee by\u0165 pou\u017eitie drah\u00fdch a zlo\u017eit\u00fdch BI syst\u00e9mov nahraden\u00e9 jednoduch\u00fdmi a relat\u00edvne lacn\u00fdmi, ale dostato\u010dne efekt\u00edvnymi analytick\u00fdmi n\u00e1strojmi. Pre\u010d\u00edtan\u00edm tohto \u010dl\u00e1nku budete schopn\u00ed pos\u00fadi\u0165 va\u0161e potreby v oblasti biznis analytiky a pochopi\u0165, ktor\u00fd variant najlep\u0161ie vyhovuje va\u0161emu podniku.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nSamozrejme, v\u0161etky BI syst\u00e9my maj\u00fa mimoriadne zlo\u017eit\u00fa architekt\u00faru a ich implement\u00e1cia v spolo\u010dnosti nie je jednoduchou \u00falohou, ktor\u00e1 si vy\u017eaduje zna\u010dn\u00e9 prostriedky na rie\u0161enie a vysoko kvalifikovan\u00fdch integr\u00e1torov. Budete sa musie\u0165 viackr\u00e1t uch\u00fdli\u0165 k ich slu\u017eb\u00e1m, preto\u017ee implement\u00e1cia a uvedenie do prev\u00e1dzky nie s\u00fa v\u0161etko \u2013 v bud\u00facnosti bude potrebn\u00e9 doplni\u0165 funkcionalitu, vyvin\u00fa\u0165 nov\u00e9 spr\u00e1vy a ukazovatele. Je potrebn\u00e9 zoh\u013eadni\u0165, \u017ee v pr\u00edpade \u00faspe\u0161nej \u010dinnosti syst\u00e9mu, budete chcie\u0165, aby v \u0148om pracovalo st\u00e1le viac zamestnancov, \u010do znamen\u00e1, \u017ee je potrebn\u00e9 zak\u00fapi\u0165 \u010fal\u0161ie licencie pre pou\u017e\u00edvate\u013eov.<\/p>\n<p>\u010eal\u0161ou neodmyslite\u013enou vlastnos\u0165ou pokro\u010dil\u00fdch biznis analytick\u00fdch syst\u00e9mov je mimoriadne \u0161irok\u00e1 \u0161k\u00e1la funkci\u00ed, z ktor\u00fdch mnoh\u00e9 nikdy nevyu\u017eijete, ale budete za ne neust\u00e1le plati\u0165 v\u017edy, ke\u010f predl\u017eujete licencie.<\/p>\n<p>Vy\u0161\u0161ie uveden\u00e9 vlastnosti BI syst\u00e9mov n\u00fatia zamyslie\u0165 sa nad v\u00fdberom alternat\u00edvy. \u010ealej navrhujem porovna\u0165 rie\u0161enie \u0161tandardn\u00e9ho s\u00faboru \u00faloh pri pr\u00edprave reportingu pomocou Power BI a Excelu.<\/p>\n<h2>Power BI alebo Excel?<\/h2>\n<p>\nAko zvy\u010dajne analytik pri zostavovan\u00ed kvart\u00e1lnej spr\u00e1vy o predaji exportuje d\u00e1ta z \u00fa\u010dtovn\u00fdch syst\u00e9mov, porovn\u00e1va ich so svojimi katal\u00f3gmi a zhroma\u017e\u010fuje pomocou funkcie VLOOKUP do jednej tabu\u013eky, na z\u00e1klade ktorej sa zostavuje spr\u00e1va.<\/p>\n<p>A ako sa t\u00e1to \u00faloha rie\u0161i pomocou Power BI? <\/p>\n<p>\u00dadaje zo zdrojov sa na\u010d\u00edtavaj\u00fa do syst\u00e9mu a pripravuj\u00fa na anal\u00fdzu: rozde\u013euj\u00fa sa na tabu\u013eky, \u010distia a porovn\u00e1vaj\u00fa. N\u00e1sledne sa kon\u0161truuje obchodn\u00fd model: tabu\u013eky sa navz\u00e1jom sp\u00e1jaj\u00fa, ur\u010duje sa metriky, vytv\u00e1raj\u00fa sa pou\u017e\u00edvate\u013esk\u00e9 hierarchie. \u010eal\u0161\u00ed krok \u2013 vizualiz\u00e1cia. Tu, jednoduch\u00fdm \u0165ahan\u00edm ovl\u00e1dac\u00edch prvkov a widgetov, vznik\u00e1 interakt\u00edvny dashboard. V\u0161etky prvky s\u00fa prepojen\u00e9 prostredn\u00edctvom modelu \u00fadajov. Pri anal\u00fdze to umo\u017e\u0148uje zamera\u0165 sa na potrebn\u00e9 inform\u00e1cie a filtrova\u0165 ich vo v\u0161etk\u00fdch zobrazeniach jedn\u00fdm stla\u010den\u00edm ak\u00e9hoko\u013evek prvku dashboardu.<\/p>\n<p>Ak\u00e9 v\u00fdhody poskytuje pou\u017eitie Power BI v porovnan\u00ed s tradi\u010dn\u00fdm pr\u00edstupom, m\u00f4\u017eeme vidie\u0165 na uvedenom pr\u00edklade?<\/p>\n<p>1 \u2013 Automatiz\u00e1cia postupu z\u00edskavania \u00fadajov a ich pr\u00edprava na anal\u00fdzu. <br \/>\n2 \u2013 Vytvorenie obchodn\u00e9ho modelu.<br \/>\n3 \u2013 Neuverite\u013en\u00e1 vizualiz\u00e1cia.<br \/>\n4 \u2013 Obmedzen\u00fd pr\u00edstup k reportom.<\/p>\n<p>Teraz si rozoberieme ka\u017ed\u00fd bod podrobnej\u0161ie.<\/p>\n<p>1 \u2013 Na pr\u00edpravu \u00fadajov na vytvorenie reportu je potrebn\u00e9 jednorazovo definova\u0165 proced\u00faru, ktor\u00e1 vykon\u00e1va pripojenie k \u00fadajom a ich spracovanie, a v\u017edy, ke\u010f bude potrebn\u00e9 z\u00edska\u0165 report za in\u00e9 obdobie, Power BI prejde \u00fadaje cez vytvoren\u00fa proced\u00faru. T\u00fdm sa automatizuje v\u00e4\u010d\u0161ina pr\u00e1ce na pr\u00edprave \u00fadajov na anal\u00fdzu. Ale je tu aj to, \u017ee Power BI vykon\u00e1va proced\u00faru pr\u00edpravy \u00fadajov pomocou n\u00e1stroja, ktor\u00fd je dostupn\u00fd v klasickej verzii Excelu, a vol\u00e1 sa <noindex><a rel=\"nofollow\" href=\"https:\/\/support.microsoft.com\/ru-ru\/office\/power-query-%E2%80%94-%D0%BE%D0%B1%D0%B7%D0%BE%D1%80-%D0%B8-%D0%BE%D0%B1%D1%83%D1%87%D0%B5%D0%BD%D0%B8%D0%B5-ed614c81-4b00-4291-bd3a-55d80767f81d\">Power Query<\/a><\/noindex>. Umo\u017e\u0148uje vykona\u0165 \u00falohu v Exceli presne rovnak\u00fdm sp\u00f4sobom.<\/p>\n<p>2 \u2013 Tu je situ\u00e1cia rovnak\u00e1. N\u00e1stroj Power BI na vytvorenie obchodn\u00e9ho modelu je tie\u017e v Exceli \u2013 je to <noindex><a rel=\"nofollow\" href=\"https:\/\/support.microsoft.com\/ru-ru\/office\/%D0%B7%D0%B0%D0%BF%D1%83%D1%81%D1%82%D0%B8%D1%82%D0%B5-%D0%BD%D0%B0%D0%B4%D1%81%D1%82%D1%80%D0%BE%D0%B9%D0%BA%D1%83-power-pivot-%D0%B4%D0%BB%D1%8F-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8\">Power Pivot<\/a><\/noindex>.<\/p>\n<p>3 \u2013 Ako ste si mo\u017eno u\u017e domysleli, s vizualiz\u00e1ciou to vyzer\u00e1 podobne: roz\u0161\u00edrenie Excelu \u2013 <noindex><a rel=\"nofollow\" href=\"https:\/\/support.microsoft.com\/ru-ru\/office\/power-view-%D0%B8%D1%81%D1%81%D0%BB%D0%B5%D0%B4%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5-%D0%B2%D0%B8%D0%B7%D1%83%D0%B0%D0%BB%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F-%D0%B8-%D0%BF%D1%80%D0%B5%D0%B4%D1%81%D1%82%D0%B0%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5-%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85-98268d31-97e2-42aa-a52b-a68cf460472e\">Power View<\/a><\/noindex> sa s touto \u00falohou popasuje v\u00fdborne.<\/p>\n<p>4 \u2013 Je potrebn\u00e9 sa vysporiada\u0165 s pr\u00edstupom k spr\u00e1vam. Situ\u00e1cia nie je tak optimistick\u00e1. Power BI je cloudov\u00e1 slu\u017eba, pr\u00edstup k nej je zabezpe\u010den\u00fd prostredn\u00edctvom osobn\u00e9ho \u00fa\u010dtu. Spr\u00e1vca slu\u017eby prira\u010fuje pou\u017e\u00edvate\u013eov do skup\u00edn a ur\u010duje r\u00f4znu \u00farove\u0148 pr\u00edstupu k spr\u00e1vam pre tieto skupiny. T\u00fdm sa zabezpe\u010duje rozdelenie pr\u00edstupov\u00fdch pr\u00e1v medzi zamestnancami spolo\u010dnosti. Takto analytici, mana\u017e\u00e9ri a riaditelia, ktor\u00ed sa prihl\u00e1sia na t\u00fa ist\u00fa str\u00e1nku, vidia spr\u00e1vu vo pre nich pr\u00edstupnej forme. M\u00f4\u017ee by\u0165 obmedzen\u00fd pr\u00edstup k ur\u010dit\u00fdm s\u00faborom d\u00e1t alebo dokonca k celej spr\u00e1ve. Ak je v\u0161ak spr\u00e1va v s\u00fabore form\u00e1tu Excel, syst\u00e9mov\u00fd administr\u00e1tor m\u00f4\u017ee nielen\u017ee sa pok\u00fasi\u0165 vyrie\u0161i\u0165 probl\u00e9m s pr\u00edstupom, ale to u\u017e nebude to ist\u00e9. K tejto \u00falohe sa e\u0161te vr\u00e1tim, ke\u010f budem popisova\u0165 \u0161pecifik\u00e1 firemn\u00e9ho port\u00e1lu.<\/p>\n<p>Je potrebn\u00e9 poznamena\u0165, \u017ee zvy\u010dajne nie je ve\u013ek\u00e1 potreba spolo\u010dnosti po zlo\u017eit\u00fdch a kr\u00e1snych dashboardoch a \u010dasto, pri anal\u00fdze d\u00e1t v Exceli po vytvoren\u00ed obchodn\u00e9ho modelu, vynechaj\u00fa mo\u017enosti Power View a vyu\u017e\u00edvaj\u00fa kontingen\u010dn\u00e9 tabu\u013eky. Tieto poskytuj\u00fa OLAP funkcie, ktor\u00e9 s\u00fa \u00faplne dostato\u010dn\u00e9 na rie\u0161enie v\u00e4\u010d\u0161iny obchodno-analytick\u00fdch \u00faloh.<\/p>\n<p>Tak\u017ee pou\u017e\u00edvanie Excelu na obchodn\u00fa anal\u00fdzu m\u00f4\u017ee uspokoji\u0165 potreby priemernej spolo\u010dnosti s mal\u00fdm po\u010dtom zamestnancov, ktor\u00ed potrebuj\u00fa spr\u00e1vy. Napriek tomu, ak s\u00fa po\u017eiadavky va\u0161ej spolo\u010dnosti ambici\u00f3znej\u0161ie, nepon\u00e1h\u013eajte sa s n\u00e1strojmi, ktor\u00e9 by vyrie\u0161ili v\u0161etko naraz.<\/p>\n<p>Navrhujem v\u00e1m profesion\u00e1lnej\u0161\u00ed pr\u00edstup, v\u010faka ktor\u00e9mu z\u00edskate vlastn\u00fd, plne spravovan\u00fd, automatizovan\u00fd syst\u00e9m na vytv\u00e1ranie obchodno-analytick\u00fdch spr\u00e1v s rozdelen\u00fdmi pr\u00edstupov\u00fdmi pr\u00e1vami.<\/p>\n<h2>ETL a DWH<\/h2>\n<p>\nV predt\u00fdm presk\u00faman\u00fdch pr\u00edstupoch k vytv\u00e1raniu obchodn\u00fdch spr\u00e1v sa na\u010d\u00edtanie a pr\u00edprava \u00fadajov na anal\u00fdzu uskuto\u010d\u0148ovala pomocou technol\u00f3gie Power Query. Tento sp\u00f4sob zost\u00e1va plne opr\u00e1vnen\u00fd a efekt\u00edvny dovtedy, k\u00fdm je po\u010det zdrojov d\u00e1t n\u00edzky: jeden \u00fa\u010detn\u00fd syst\u00e9m a referen\u010dn\u00e9 \u00fadaje z Excel tabuliek. Av\u0161ak s rast\u00facim po\u010dtom \u00fa\u010detn\u00fdch syst\u00e9mov sa rie\u0161enie tejto \u00falohy prostredn\u00edctvom Power Query st\u00e1va ve\u013emi objemn\u00fdm, obtia\u017enym na \u00fadr\u017ebu a rozvoj. V tak\u00fdchto pr\u00edpadoch prich\u00e1dzaj\u00fa na pomoc n\u00e1stroje pre ETL. <\/p>\n<p>S ich pomocou sa vykon\u00e1va export d\u00e1t zo zdrojov (Extract), ich transform\u00e1cia (Transform), \u010do zah\u0155\u0148a \u010distenie a zladenie, a na\u010d\u00edtanie do d\u00e1tov\u00e9ho \u00falo\u017eiska (Load). D\u00e1tov\u00e9 \u00falo\u017eisko (DWH \u2013 Data Warehouse) je zvy\u010dajne rela\u010dn\u00e1 datab\u00e1za, nach\u00e1dzaj\u00faca sa na serveri. T\u00e1to datab\u00e1za obsahuje d\u00e1ta vhodn\u00e9 na anal\u00fdzu. Na z\u00e1klade pl\u00e1nu sa sp\u00fa\u0161\u0165a ETL proces, ktor\u00fd aktualizuje d\u00e1ta \u00falo\u017eiska na aktu\u00e1lne. Mimochodom, cel\u00fa t\u00fato zlo\u017eit\u00fa pr\u00e1cu n\u00e1dherne obsluhuje Integration Services, s\u00fa\u010das\u0165 MS SQL Server.<\/p>\n<p>\u010ealej, ako aj predt\u00fdm na vytv\u00e1ranie obchodn\u00e9ho modelu \u00fadajov a vizualiz\u00e1ciu m\u00f4\u017eete vyu\u017ei\u0165 Excel, Power BI, alebo in\u00e9 analytick\u00e9 n\u00e1stroje, ako s\u00fa Tableau alebo Qlik Sense. Predt\u00fdm by som v\u0161ak chcel upriami\u0165 va\u0161u pozornos\u0165 e\u0161te na jednu mo\u017enos\u0165, o ktorej ste mo\u017eno nevedeli, aj ke\u010f je v\u00e1m u\u017e d\u00e1vno dostupn\u00e1. Hovor\u00edm o vytv\u00e1ran\u00ed obchodn\u00fdch modelov pomocou analytick\u00fdch slu\u017eieb MS SQL Server, konkr\u00e9tne Analysis Services.<\/p>\n<h2>Modely \u00fadajov v MS Analysis Services<\/h2>\n<p>\nT\u00e1to \u010das\u0165 \u010dl\u00e1nku bude zauj\u00edmavej\u0161ia pre t\u00fdch, ktor\u00ed u\u017e pou\u017e\u00edvaj\u00fa MS SQL Server vo svojej spolo\u010dnosti.<\/p>\n<p>V s\u00fa\u010dasnosti slu\u017eby Analysis Services poskytuj\u00fa dva typy modelov \u00fadajov \u2013 multi-dimenzion\u00e1lny a tabu\u013ekov\u00fd model. Okrem toho, \u017ee s\u00fa d\u00e1ta v t\u00fdchto modeloch prepojen\u00e9, hodnoty ukazovate\u013eov modelu sa predbe\u017ene agreguj\u00fa a ukladaj\u00fa do buniek OLAP kubov, pri\u010dom pr\u00edstup k nim sa uskuto\u010d\u0148uje pomocou MDX alebo DAX dotazov. V\u010faka takej architekt\u00fare ukladania d\u00e1t sa dotaz, ktor\u00fd pokr\u00fdva mili\u00f3ny z\u00e1znamov, vr\u00e1ti za sekundy. Tak\u00fdto sp\u00f4sob pr\u00edstupu k d\u00e1tam je nevyhnutn\u00fd pre spolo\u010dnosti, ktor\u00fdch transak\u010dn\u00e9 tabu\u013eky obsahuj\u00fa od mili\u00f3na z\u00e1znamov (horn\u00fd limit nie je obmedzen\u00fd).<\/p>\n<p>Excel, Power BI a mnoho dal\u0161\u00edch \u201esolidn\u00edch\u201c n\u00e1stroj\u016f um\u00ed p\u0159ipojit se k takov\u00fdm model\u016fm a vizualizovat data jejich struktury.<\/p>\n<p>Pokud jste zvolili \u201epokro\u010dilou\u201c cestu: automatizovali jste proces ETL a vytvo\u0159ili obchodn\u00ed modely pomoc\u00ed slu\u017eeb MS SQL Server, zaslou\u017e\u00edte si m\u00edt sv\u016fj vlastn\u00ed firemn\u00ed port\u00e1l.<\/p>\n<h2>Firemn\u00ed port\u00e1l<\/h2>\n<p>\nCez n\u011bj budou administr\u00e1to\u0159i prov\u00e1d\u011bt monitoring a \u0159\u00edzen\u00ed procesu sestavov\u00e1n\u00ed zpr\u00e1v. P\u0159\u00edtomnost port\u00e1lu umo\u017en\u00ed sjednotit adres\u00e1\u0159e spole\u010dnosti: informace o klientech, produktech, mana\u017eerech a dodavatel\u00edch budou dostupn\u00e9 pro porovn\u00e1v\u00e1n\u00ed, editaci a stahov\u00e1n\u00ed na jednom m\u00edst\u011b pro v\u0161echny, kdo je pou\u017e\u00edvaj\u00ed. Na port\u00e1lu je mo\u017en\u00e9 realizovat prov\u00e1d\u011bn\u00ed r\u016fzn\u00fdch funkc\u00ed pro zm\u011bnu dat \u00fa\u010detn\u00edch syst\u00e9m\u016f, nap\u0159\u00edklad \u0159\u00eddit replikaci dat. A co je nejd\u016fle\u017eit\u011bj\u0161\u00ed, pomoc\u00ed port\u00e1lu se \u00fasp\u011b\u0161n\u011b \u0159e\u0161\u00ed probl\u00e9m organizace omezen\u00e9ho p\u0159\u00edstupu k report\u016fm \u2013 zam\u011bstnanci budou vid\u011bt pouze ty zpr\u00e1vy, kter\u00e9 byly p\u0159ipraveny osobn\u011b pro jejich odd\u011blen\u00ed v ur\u010den\u00e9m pro n\u011b form\u00e1tu.<\/p>\n<p>Nicm\u00e9n\u011b, zat\u00edm nen\u00ed jasn\u00e9, jak bude organizov\u00e1no zobrazen\u00ed report\u016f na str\u00e1nce port\u00e1lu. Aby bylo mo\u017en\u00e9 na tuto ot\u00e1zku odpov\u011bd\u011bt, nejprve je nutn\u00e9 ur\u010dit technologii, na jej\u00edm\u017e z\u00e1klad\u011b bude port\u00e1l postaven. Navrhuji vz\u00edt za z\u00e1klad jeden z framework\u016f: ASP.NET MVC\/Web Forms\/Core nebo Microsoft SharePoint. Pokud ve va\u0161\u00ed spole\u010dnosti existuje alespo\u0148 jeden .NET v\u00fdvoj\u00e1\u0159, nebude to obt\u00ed\u017en\u00e9. Nyn\u00ed je mo\u017en\u00e9 vyb\u00edrat vkl\u00e1dan\u00fd do aplikace OLAP klient, schopn\u00fd se p\u0159ipojit k v\u00edcerozm\u011brn\u00fdm nebo tabulkov\u00fdm model\u016fm slu\u017eeb Analysis Services.<\/p>\n<h2>V\u00fdb\u011br OLAP klienta pro vizualizaci<\/h2>\n<p>\nPorovnejme n\u011bkolik n\u00e1stroj\u016f podle \u00farovn\u011b slo\u017eitosti zapracov\u00e1n\u00ed, funkcionality a ceny: Power BI, komponenty Telerik UI for ASP.NET MVC a komponenty RadarCube ASP.NET MVC.<\/p>\n<h3>Power BI<\/h3>\n<p>\nAby bylo mo\u017en\u00e9 uspo\u0159\u00e1dat p\u0159\u00edstup zam\u011bstnanc\u016f spole\u010dnosti k report\u016fm Power BI na str\u00e1nce sv\u00e9ho port\u00e1lu, je pot\u0159eba vyu\u017e\u00edt funkci <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/ru-ru\/power-bi\/developer\/embedded\/\">Power BI Embedded<\/a><\/noindex>.<\/p>\n<p>Hned \u0159eknu, \u017ee bude pot\u0159eba licence Power BI Premium a dodate\u010dn\u00e1 vyhrazen\u00e1 kapacita. P\u0159\u00edtomnost vyhrazen\u00e9 kapacity umo\u017e\u0148uje publikovat dashboardy a reporty pro u\u017eivatele v organizaci bez nutnosti po\u0159izovat pro n\u011b licence.<\/p>\n<p>Najprv sa spr\u00e1va vytvoren\u00e1 v Power BI Desktop publikuje na port\u00e1li Power BI a potom sa, pomocou zlo\u017eit\u00fdch nastaven\u00ed, vklad\u00e1 na str\u00e1nku webovej aplik\u00e1cie. <\/p>\n<p>S proced\u00farou vytv\u00e1rania jednoduch\u00e9ho reportu a jeho publik\u00e1ciou si m\u00f4\u017ee poradi\u0165 analytik, no so zabudovan\u00edm m\u00f4\u017eu nasta\u0165 v\u00e1\u017ene probl\u00e9my. Je tie\u017e ve\u013emi zlo\u017eit\u00e9 pochopi\u0165, ako tento n\u00e1stroj funguje: ve\u013ek\u00e9 mno\u017estvo nastaven\u00ed cloudovej slu\u017eby, mno\u017estvo predplatn\u00fdch, licenci\u00ed a priestoru v\u00fdrazne zvy\u0161uj\u00fa po\u017eiadavky na \u00farove\u0148 odbornosti \u0161pecialistu. Tak\u017ee t\u00fato \u00falohu je lep\u0161ie zveri\u0165 IT odborn\u00edkovi.<\/p>\n<h3>Komponenty Telerik a RadarCube<\/h3>\n<p>\nNa zabudovanie komponentov Telerik a RadarCube sta\u010d\u00ed ovl\u00e1da\u0165 programovacie technol\u00f3gie na z\u00e1kladnej \u00farovni. Preto bud\u00fa profesion\u00e1lne zru\u010dnosti jedn\u00e9ho program\u00e1tora z IT oddelenia \u00faplne posta\u010duj\u00face. V\u0161etko, \u010do je potrebn\u00e9, je umiestni\u0165 komponent na web-str\u00e1nku a nastavi\u0165 ho pod\u013ea svojich potrieb.<\/p>\n<p>Komponent <noindex><a rel=\"nofollow\" href=\"https:\/\/demos.telerik.com\/aspnet-mvc\/pivotgrid\">PivotGrid<\/a><\/noindex> z bal\u00edka Telerik UI for ASP.NET MVC sa vkladaj\u00fa na str\u00e1nku elegantn\u00fdm sp\u00f4sobom pomocou Razor a poskytuj\u00fa najz\u00e1kladnej\u0161ie OLAP funkcie. Av\u0161ak, ak s\u00fa potrebn\u00e9 flexibilnej\u0161ie nastavenia rozhrania a vyvinut\u00e9 funkcie, je lep\u0161ie pou\u017ei\u0165 komponenty <noindex><a rel=\"nofollow\" href=\"https:\/\/www.radar-soft.ru\/radarcube-aspnet-mvc-features\">RadarCube ASP.NET MVC<\/a><\/noindex>. Ve\u013ek\u00e9 mno\u017estvo nastaven\u00ed, bohat\u00e9 funkcie s mo\u017enos\u0165ami ich predefinovania a roz\u0161\u00edrenia umo\u017enia vytvori\u0165 OLAP report akejko\u013evek zlo\u017eitosti.<\/p>\n<p>Ni\u017e\u0161ie uv\u00e1dzam tabu\u013eku porovnania charakterist\u00edk uva\u017eovan\u00fdch n\u00e1strojov na stupnici N\u00edzky-Stredn\u00fd-Vysok\u00fd.<\/p>\n<p>&nbsp;<br \/>\nPower BI<br \/>\nTelerik UI for ASP.NET MVC<br \/>\nRadarCube ASP.NET MVC<\/p>\n<p>Vizualiz\u00e1cia<br \/>\nVysok\u00fd<br \/>\nN\u00edzky<br \/>\nStredn\u00fd<\/p>\n<p>Sada OLAP funkci\u00ed<br \/>\nVysok\u00fd<br \/>\nN\u00edzky<br \/>\nVysok\u00fd<\/p>\n<p>Flexibilita nastavenia<br \/>\nVysok\u00fd<br \/>\nVysok\u00fd<br \/>\nVysok\u00fd<\/p>\n<p>Mo\u017enos\u0165 predefinovania funkci\u00ed<br \/>\n\u2014<br \/>\n\u2014<br \/>\n+<\/p>\n<p>Programov\u00e1 prisp\u00f4sobite\u013enos\u0165<br \/>\n\u2014<br \/>\n \u2014<br \/>\n+<\/p>\n<p>\u00darove\u0148 zlo\u017eitosti zabudovania a nastavenia<br \/>\nVysok\u00fd<br \/>\nN\u00edzky<br \/>\nStredn\u00fd<\/p>\n<p>Minim\u00e1lna cena<br \/>\nPower BI Premium EM3<\/p>\n<p> 190 000 rub.\/mesiac<br \/>\nLicencia pre jedn\u00e9ho v\u00fdvoj\u00e1ra<\/p>\n<p>90 000 rub.<\/p>\n<p>Licencia pre jedn\u00e9ho v\u00fdvoj\u00e1ra<\/p>\n<p>25 000 rub.<\/p>\n<p>\nTeraz sa m\u00f4\u017eeme presun\u00fa\u0165 k definovaniu krit\u00e9ri\u00ed na v\u00fdber analytick\u00e9ho n\u00e1stroja.<\/p>\n<h3>Podmienky v\u00fdberu Power BI<\/h3>\n<p><\/p>\n<ul>\n<li>Zauj\u00edmaj\u00fa v\u00e1s reporty bohat\u00e9 na r\u00f4zne ukazovatele a prvky s\u00favisiace s d\u00e1tami.<\/li>\n<li>Chcete, aby zamestnanci pracuj\u00faci s reportmi mohli \u013eahko a r\u00fdchlo dost\u00e1va\u0165 odpovede na vynesen\u00e9 obchodn\u00e9 \u00falohy v intuit\u00edvne zrozumite\u013enej forme.<\/li>\n<li>V zamestnan\u00ed spolo\u010dnosti je IT odborn\u00edk s zru\u010dnos\u0165ami v BI v\u00fdvoji.<\/li>\n<li>V rozpo\u010dte spolo\u010dnosti je vy\u010dlenen\u00e1 ve\u013ek\u00e1 suma na mesa\u010dn\u00fa platbu za cloudov\u00fa slu\u017ebu biznis analytiky.<\/li>\n<\/ul>\n<p><\/p>\n<h3>Podmienky v\u00fdberu komponentov Telerik<\/h3>\n<p><\/p>\n<ul>\n<li>Potrebujete jednoduch\u00e9ho OLAP klienta na ad hoc anal\u00fdzu.<\/li>\n<li>V spolo\u010dnosti sa nach\u00e1dza junior .NET v\u00fdvoj\u00e1r.<\/li>\n<li>Mal\u00fd rozpo\u010det na jednorazov\u00fd n\u00e1kup licencie a jej n\u00e1sledn\u00e9 pred\u013a\u017eenie so z\u013eavou menej ako 20 %.<\/li>\n<\/ul>\n<p><\/p>\n<h3>Podmienky v\u00fdberu komponentov RadarCube<\/h3>\n<p><\/p>\n<ul>\n<li>Potrebujete multifunk\u010dn\u00e9ho OLAP klienta s mo\u017enos\u0165ou prisp\u00f4sobenia rozhrania a podporou vkladania vlastn\u00fdch funkci\u00ed.<\/li>\n<li>V spolo\u010dnosti sa nach\u00e1dza stredne pokro\u010dil\u00fd .NET v\u00fdvoj\u00e1r. Ak tak\u00fd nie je, v\u00fdvoj\u00e1ri komponentu ochotne poskytn\u00fa svoje slu\u017eby, av\u0161ak za \u010fal\u0161\u00ed poplatok, ktor\u00fd nepresiahne \u00farove\u0148 mzdy intern\u00e9ho program\u00e1tora.<\/li>\n<li>Mal\u00fd rozpo\u010det na jednorazov\u00fd n\u00e1kup licencie a jej n\u00e1sledn\u00e9 pred\u013a\u017eenie so z\u013eavou 60 %.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Z\u00e1ver<\/h2>\n<p>\nSpr\u00e1vny v\u00fdber n\u00e1stroja na biznis anal\u00fdzu umo\u017en\u00ed \u00fapln\u00fa elimin\u00e1ciu tvorby reportov v Exceli. Va\u0161a spolo\u010dnos\u0165 bude m\u00f4c\u0165 postupne a bezprobl\u00e9movo prejs\u0165 na vyu\u017e\u00edvanie modern\u00fdch technol\u00f3gi\u00ed v oblasti BI a automatizova\u0165 pr\u00e1cu analytikov v\u0161etk\u00fdch oddelen\u00ed.<br \/>\n<br \/>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/522632\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u0430\u043a\u043e\u0439 \u0443 \u0412\u0430\u0441 \u0432\u044b\u0431\u043e\u0440? \u0427\u0430\u0441\u0442\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0434\u043e\u0440\u043e\u0433\u0438\u0445 \u0438 \u0441\u043b\u043e\u0436\u043d\u044b\u0445 BI-\u0441\u0438\u0441\u0442\u0435\u043c \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0437\u0430\u043c\u0435\u043d\u0435\u043d\u043e \u043f\u0440\u043e\u0441\u0442\u044b\u043c\u0438 \u0438 \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043d\u0435\u0434\u043e\u0440\u043e\u0433\u0438\u043c\u0438, \u043d\u043e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u043c\u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u043c\u0438 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u043c\u0438. \u041f\u0440\u043e\u0447\u0438\u0442\u0430\u0432 \u044d\u0442\u0443 \u0441\u0442\u0430\u0442\u044c\u044e, \u0412\u044b \u0441\u043c\u043e\u0436\u0435\u0442\u0435 \u043e\u0446\u0435\u043d\u0438\u0442\u044c \u0412\u0430\u0448\u0438 \u043f\u043e\u0442\u0440\u0435\u0431\u043d\u043e\u0441\u0442\u0438 \u0432 \u043e\u0431\u043b\u0430\u0441\u0442\u0438 \u0431\u0438\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0438 \u0438 \u043f\u043e\u043d\u044f\u0442\u044c \u043a\u0430\u043a\u043e\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442 \u043b\u0443\u0447\u0448\u0435 \u043f\u043e\u0434\u043e\u0439\u0434\u0435\u0442 \u0434\u043b\u044f \u0412\u0430\u0448\u0435\u0433\u043e \u0431\u0438\u0437\u043d\u0435\u0441\u0430. \u0420\u0430\u0437\u0443\u043c\u0435\u0435\u0442\u0441\u044f, \u0432\u0441\u0435 BI-\u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0438\u043c\u0435\u044e\u0442 \u0447\u0440\u0435\u0437\u0432\u044b\u0447\u0430\u0439\u043d\u043e \u0441\u043b\u043e\u0436\u043d\u0443\u044e \u0430\u0440\u0445\u0438\u0442\u0435\u043a\u0442\u0443\u0440\u0443 \u0438 \u0438\u0445 \u0432\u043d\u0435\u0434\u0440\u0435\u043d\u0438\u0435 \u0432 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0438, \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f [&hellip;]<\/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":[688],"tags":[],"class_list":["post-96442","post","type-post","status-publish","format-standard","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u0430\u043a\u043e\u0439 \u0443 \u0412\u0430\u0441 \u0432\u044b\u0431\u043e\u0440? \u0427\u0430\u0441\u0442\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0434\u043e\u0440\u043e\u0433\u0438\u0445 \u0438 \u0441\u043b\u043e\u0436\u043d\u044b\u0445 BI-\u0441\u0438\u0441\u0442\u0435\u043c \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0437\u0430\u043c\u0435\u043d\u0435\u043d\u043e \u043f\u0440\u043e\u0441\u0442\u044b\u043c\u0438 \u0438 \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043d\u0435\u0434\u043e\u0440\u043e\u0433\u0438\u043c\u0438, \u043d\u043e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u043c\u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u043c\u0438 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u043c\u0438.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/kak-vybrat-instrument-dlya-biznes-analiza\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"sk_SK\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041a\u0430\u043a \u0432\u044b\u0431\u0440\u0430\u0442\u044c \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442 \u0434\u043b\u044f \u0431\u0438\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0438\u0437\u0430 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u0430\u043a\u043e\u0439 \u0443 \u0412\u0430\u0441 \u0432\u044b\u0431\u043e\u0440? \u0427\u0430\u0441\u0442\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0434\u043e\u0440\u043e\u0433\u0438\u0445 \u0438 \u0441\u043b\u043e\u0436\u043d\u044b\u0445 BI-\u0441\u0438\u0441\u0442\u0435\u043c \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0437\u0430\u043c\u0435\u043d\u0435\u043d\u043e \u043f\u0440\u043e\u0441\u0442\u044b\u043c\u0438 \u0438 \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043d\u0435\u0434\u043e\u0440\u043e\u0433\u0438\u043c\u0438, \u043d\u043e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u043c\u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u043c\u0438 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u043c\u0438.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/kak-vybrat-instrument-dlya-biznes-analiza\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-10-11T17:42:46+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-10-11T17:42:46+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Ako vybra\u0165 n\u00e1stroj na biznis anal\u00fdzu | ProHoster","description":"Ak\u00fd je v\u00e1\u0161 v\u00fdber? \u010casto m\u00f4\u017ee by\u0165 pou\u017e\u00edvanie drah\u00fdch a zlo\u017eit\u00fdch BI syst\u00e9mov nahraden\u00e9 jednoduch\u00fdmi a relat\u00edvne lacn\u00fdmi, ale dos\u0165 efekt\u00edvnymi analytick\u00fdmi n\u00e1strojmi.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/kak-vybrat-instrument-dlya-biznes-analiza","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\u041a\u0430\u043a \u0432\u044b\u0431\u0440\u0430\u0442\u044c \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442 \u0434\u043b\u044f \u0431\u0438\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0438\u0437\u0430 | ProHoster","og:description":"\u041a\u0430\u043a\u043e\u0439 \u0443 \u0412\u0430\u0441 \u0432\u044b\u0431\u043e\u0440? \u0427\u0430\u0441\u0442\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0434\u043e\u0440\u043e\u0433\u0438\u0445 \u0438 \u0441\u043b\u043e\u0436\u043d\u044b\u0445 BI-\u0441\u0438\u0441\u0442\u0435\u043c \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0437\u0430\u043c\u0435\u043d\u0435\u043d\u043e \u043f\u0440\u043e\u0441\u0442\u044b\u043c\u0438 \u0438 \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043d\u0435\u0434\u043e\u0440\u043e\u0433\u0438\u043c\u0438, \u043d\u043e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u043c\u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u043c\u0438 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u043c\u0438.","og:url":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/kak-vybrat-instrument-dlya-biznes-analiza","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":"2020-10-11T17:42:46+00:00","article:modified_time":"2020-10-11T17:42:46+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"96442","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":"","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 10:42:31","updated":"2022-09-27 18:59:20","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\/96442","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=96442"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/96442\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=96442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=96442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=96442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}