{"id":8482,"date":"2022-06-07T21:26:47","date_gmt":"2022-06-07T19:26:47","guid":{"rendered":"https:\/\/www.leaplytics.de\/?p=8482"},"modified":"2022-06-07T21:37:03","modified_gmt":"2022-06-07T19:37:03","slug":"business-intelligence-pre-male-a-stredne-podniky-kedy-ma-zmysel","status":"publish","type":"post","link":"https:\/\/www.leaplytics.de\/sk\/business-intelligence-pre-male-a-stredne-podniky-kedy-ma-zmysel\/","title":{"rendered":"Business Intelligence pre mal\u00e9 podniky - kedy m\u00e1 zmysel?"},"content":{"rendered":"<p>T\u00ed, ktor\u00ed poznaj\u00fa bud\u00facnos\u0165, s\u00fa vpredu! V na\u0161om trojdielnom \u010dl\u00e1nku si pre\u010d\u00edtajte, pre\u010do je Business Intelligence mimoriadne d\u00f4le\u017eit\u00e1 pre mal\u00e9 a stredn\u00e9 podniky (MSP), ak\u00fd n\u00e1ro\u010dn\u00fd je vlastne prv\u00fd krok, ale ak\u00e9 s\u00fa aj z\u00e1sadn\u00e9 v\u00fdhody a ako m\u00f4\u017eete k celej t\u00e9me pristupova\u0165 efekt\u00edvne. Odborn\u00edk na controlling a riadenie mal\u00fdch a stredn\u00fdch podnikov Andreas Malik, ako aj \u0161pecialisti na Business Intelligence a zakladatelia jedn\u00e9ho z popredn\u00fdch poskytovate\u013eov vizualiz\u00e1ci\u00ed \u00fadajov a dashboardov v oblasti Power BI a Qlik Sense Stefan Preusler a Dominik Galsheimer v\u00e1s svojimi sk\u00fasenos\u0165ami a odborn\u00fdmi znalos\u0165ami preved\u00fa t\u00fdmito 3 zauj\u00edmav\u00fdmi \u010das\u0165ami s\u00e9rie \u010dl\u00e1nkov. V prvej \u010dasti sa pozrieme na to, pre\u010do sa Business Intelligence a mal\u00e9 a stredn\u00e9 podniky dobre dop\u013a\u0148aj\u00fa. Druh\u00e1 \u010das\u0165 sa zaober\u00e1 jasn\u00fdm ur\u010den\u00edm v\u00fdhod, a teda n\u00e1jden\u00edm spr\u00e1vneho okamihu na jej spustenie. Tretia \u010das\u0165 v\u00e1m potom uk\u00e1\u017ee d\u00f4le\u017eit\u00e9 prv\u00e9 kroky pri implement\u00e1cii a zav\u00e1dzan\u00ed<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p><strong>\u010cas\u0165 1: Pre\u010do sa BI a mal\u00e9 a stredn\u00e9 podniky hodia k sebe<\/strong><\/p>\n\n\n\n<p>V \u010dase kr\u00edz, vojen a \u010doraz r\u00fdchlej\u0161\u00edch zmien v podnikate\u013eskom prostred\u00ed je pre spolo\u010dnosti d\u00f4le\u017eit\u00e9 reagova\u0165 v\u010das.<\/p>\n\n\n\n<p>Na zvl\u00e1dnutie t\u00fdchto v\u00fdziev je potrebn\u00e9 analyzova\u0165 \u00fadaje o v\u0161etk\u00fdch podnikov\u00fdch procesoch, aby ich bolo mo\u017en\u00e9 zmysluplne zhrn\u00fa\u0165 a \u010do najviac skr\u00e1ti\u0165 \u010das potrebn\u00fd na pr\u00edpravu inform\u00e1ci\u00ed d\u00f4le\u017eit\u00fdch pre rozhodovanie. T\u00fato \u00falohu pln\u00ed takzvan\u00e1 Business Intelligence (BI). BI je s\u00fahrnn\u00fd pojem pre met\u00f3dy a procesy systematickej anal\u00fdzy \u00fadajov.<\/p>\n\n\n\n<p>E\u0161te pred nieko\u013ek\u00fdmi rokmi bol BI vyhraden\u00fd pre ve\u013ek\u00e9 spolo\u010dnosti. Najm\u00e4 z h\u013eadiska vysok\u00fdch n\u00e1kladov na rie\u0161enia BI nebola Business Intelligence pre stredne ve\u013ek\u00e9 podniky zauj\u00edmav\u00e1. Medzi\u010dasom v\u0161ak BI dorazila aj do mal\u00fdch a stredn\u00fdch podnikov (MSP). Ako s\u00fa v\u0161ak tieto mal\u00e9 a stredn\u00e9 podniky definovan\u00e9? <\/p>\n\n\n\n<p>Pre v\u00e4\u010d\u0161inu <strong>ve\u013emi mal\u00e9<\/strong> <strong>podniky<\/strong> (defin\u00edcia E\u00da &lt; 10 zamestnancov obrat &lt; 2 mili\u00f3ny EUR ro\u010dne) d\u00e1tov\u00fd model je zvl\u00e1dnute\u013en\u00fd a je mapovan\u00fd pomocou MS-Excel. Tu vybran\u00e9 z\u00e1kladn\u00e9 hodnoty a k\u013e\u00fa\u010dov\u00e9 \u00fadaje \u010dasto posta\u010duj\u00fa na mesa\u010dn\u00fa anal\u00fdzu odch\u00fdlok. Prezent\u00e1cia sa vykon\u00e1va na jednej strane DIN-A4 s v\u00fdkazom ziskov a str\u00e1t, s\u00favahou a \u00fadajmi o likvidite. Okrem toho sa uv\u00e1dzaj\u00fa inform\u00e1cie o stave z\u00e1kaziek, produktivite (alebo vyu\u017eit\u00ed kapac\u00edt) a v\u0161eobecn\u00fdch udalostiach na trhu.<\/p>\n\n\n\n<p>Na str\u00e1nke <strong>mal\u00e9 spolo\u010dnosti<\/strong> (10 - 50 zamestnancov, tr\u017eby 2 - 10 mili\u00f3nov EUR ro\u010dne) je syst\u00e9m kontroly o nie\u010do rozsiahlej\u0161\u00ed. Okrem v\u00e4\u010d\u0161ieho po\u010dtu k\u013e\u00fa\u010dov\u00fdch \u00fadajov a anal\u00fdz odch\u00fdlok je zvy\u010dajne k dispoz\u00edcii aj n\u00e1h\u013ead\/progn\u00f3za.<\/p>\n\n\n\n<p>V pr\u00edpade <strong>stredne ve\u013ek\u00e9 spolo\u010dnosti<\/strong> (50 - 250 zamestnancov, tr\u017eby 10 - 50 mil. EUR ro\u010dne) sa okrem podrobn\u00fdch hodn\u00f4t, k\u013e\u00fa\u010dov\u00fdch \u00fadajov a anal\u00fdz zoh\u013ead\u0148uj\u00fa aj inform\u00e1cie relevantn\u00e9 pre bud\u00facnos\u0165. Pri \u010dom sa kladie d\u00f4raz na vyv\u00e1\u017een\u00fa a jasn\u00fa hustotu inform\u00e1ci\u00ed.<\/p>\n\n\n\n<p>Rie\u0161enia BI nie s\u00fa hotov\u00e9 syst\u00e9my; nastavuj\u00fa sa individu\u00e1lne pre spolo\u010dnos\u0165 (prisp\u00f4sobenie). Navrhuje sa s oh\u013eadom na pr\u00edslu\u0161n\u00e9 po\u017eiadavky spolo\u010dnosti. Starostliv\u00fd n\u00e1vrh je rozhoduj\u00faci pre pr\u00ednosy a praktickos\u0165 syst\u00e9mu BI.<\/p>\n\n\n\n<p><strong>Koncepcia BI alebo \"Ktor\u00fa anal\u00fdzu m\u00f4\u017ee z\u00e1kazn\u00edk vidie\u0165 vo svojom kokpite?\"<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\" type=\"1\"><li>V prvom kroku by sa mal definova\u0165 \u0161pecifick\u00fd cie\u013e bud\u00faceho BI v spolo\u010dnosti. Na tento \u00fa\u010del mus\u00ed podnikate\u013e\/kontrol\u00f3r sformulova\u0165, ak\u00e9 k\u013e\u00fa\u010dov\u00e9 \u00fadaje a hodnotenia chce na konci ma\u0165.<\/li><li>V \u010fal\u0161om kroku sa tieto po\u017eiadavky spres\u0148uj\u00fa a konkretizuj\u00fa. 3.<\/li><li>Na z\u00edskanie k\u013e\u00fa\u010dov\u00fdch \u00fadajov\/inform\u00e1ci\u00ed je potrebn\u00e9 presk\u00fama\u0165, ktor\u00e9 \u00fadaje s\u00fa u\u017e k dispoz\u00edcii a ktor\u00e9 s\u00fa e\u0161te potrebn\u00e9. Je potrebn\u00e9 objasni\u0165 zdroje \u00fadajov.<\/li><li>Syst\u00e9m vykazovania je navrhnut\u00fd na z\u00e1klade vopred definovan\u00fdch k\u013e\u00fa\u010dov\u00fdch \u00fadajov a anal\u00fdz.<\/li><li>prepojenie relevantn\u00fdch \u00fadajov z r\u00f4znych zdrojov (vytvorenie d\u00e1tov\u00e9ho skladu).<\/li><li>Prepojenie \u00fadajovej z\u00e1kladne s po\u017eadovan\u00fdm syst\u00e9mom vykazovania.<\/li><li>V\u00fdsledok: kokpit \u0161pecifick\u00fd pre dan\u00fa spolo\u010dnos\u0165<\/li><\/ul>\n\n\n\n<p><strong>Syst\u00e9m BI verzus Excel alebo \"Kedy prejs\u0165 z Excelu na syst\u00e9m BI?\"<\/strong><\/p>\n\n\n\n<p>Pomocou programu MS-Excel m\u00f4\u017eete v s\u00fa\u010dasnosti vykon\u00e1va\u0165 mnoh\u00e9 anal\u00fdzy a vytv\u00e1ra\u0165 mal\u00e9 automatiz\u00e1cie (makr\u00e1 VBA). V\u00fdhodou je, \u017ee je k dispoz\u00edcii v ka\u017edej firme, d\u00e1 sa r\u00fdchlo implementova\u0165 a je aj lacn\u00fd.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Ako <strong>ve\u013emi mal\u00e9<\/strong> <strong>podniky<\/strong>, \u010do zvy\u010dajne sta\u010d\u00ed. Tu m\u00f4\u017ee ma\u0165 zmysel ur\u010di\u0165 s pomocou odborn\u00edka na controlling, \u010di s\u00fa tieto hodnotenia dostato\u010dn\u00e9 na \u00faspe\u0161n\u00e9 riadenie spolo\u010dnosti.<\/li><li>Ako <strong>mal\u00e1 spolo\u010dnos\u0165<\/strong>, hodnotenia zalo\u017een\u00e9 na programe Excel pre podnikov\u00fd mana\u017ement r\u00fdchlo dosiahnu svoje limity. Vysok\u00e9 manu\u00e1lne n\u00e1klady s\u00fa n\u00e1chyln\u00e9 na chyby, \u010dasovo n\u00e1ro\u010dn\u00e9 a jednorozmern\u00e9. V tomto momente m\u00e1 zmysel zaobera\u0165 sa v\u00fdhodami BI. Najjednoduch\u0161\u00edm sp\u00f4sobom je dohodn\u00fa\u0165 si nez\u00e1v\u00e4zn\u00fa konzult\u00e1ciu.<\/li><li>Ako <strong>stredne ve\u013ek\u00e1 spolo\u010dnos\u0165<\/strong>, je nevyhnutn\u00e9 ma\u0165 syst\u00e9m BI, aby ste mohli \u00faspe\u0161ne fungova\u0165 ako firma. So syst\u00e9mom zalo\u017een\u00fdm v\u00fdlu\u010dne na MS-Excel str\u00e1cate ve\u013ea \u010dasu a pe\u0148az\u00ed.<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>Druh\u00e1 \u010das\u0165 s\u00e9rie \u010dl\u00e1nkov bude uverejnen\u00e1 bud\u00faci t\u00fd\u017ede\u0148. V nej sa do\u010d\u00edtate, pre\u010do je ur\u010denie spr\u00e1vneho \u010dasu na zavedenie BI n\u00e1ro\u010dn\u00e9 a ako m\u00f4\u017eete t\u00fato \u00falohu zvl\u00e1dnu\u0165. <\/p>\n\n\n\n<p>V pr\u00edpade \u010fal\u0161\u00edch ot\u00e1zok sme v\u00e1m k dispoz\u00edcii:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/Screenshot-2022-06-07-203456.png\" alt=\"\" class=\"wp-image-8481\" width=\"834\" height=\"447\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/Screenshot-2022-06-07-203456.png 600w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/Screenshot-2022-06-07-203456-300x161.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/Screenshot-2022-06-07-203456-112x60.png 112w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>","protected":false},"excerpt":{"rendered":"<p>T\u00ed, ktor\u00ed poznaj\u00fa bud\u00facnos\u0165, s\u00fa vpredu! V na\u0161om trojdielnom \u010dl\u00e1nku si pre\u010d\u00edtajte, pre\u010do je Business Intelligence mimoriadne d\u00f4le\u017eit\u00e1 pre mal\u00e9 a stredn\u00e9 podniky (MSP), ak\u00fd n\u00e1ro\u010dn\u00fd je vlastne prv\u00fd krok, ale ak\u00e9 s\u00fa aj z\u00e1sadn\u00e9 v\u00fdhody a ako m\u00f4\u017eete k celej t\u00e9me pristupova\u0165 efekt\u00edvne. Odborn\u00edk MSP na controlling a ... <\/p>","protected":false},"author":1,"featured_media":8480,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-8482","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news","latest_post"],"_links":{"self":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/posts\/8482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/comments?post=8482"}],"version-history":[{"count":0,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/posts\/8482\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/media\/8480"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/media?parent=8482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/categories?post=8482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/tags?post=8482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}