{"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":"biznesa-izlukosana-maziem-un-videjiem-uznemumiem-kad-tam-ir-jega","status":"publish","type":"post","link":"https:\/\/www.leaplytics.de\/lv\/biznesa-izlukosana-maziem-un-videjiem-uznemumiem-kad-tam-ir-jega\/","title":{"rendered":"Biznesa izl\u016bko\u0161ana mazajiem uz\u0146\u0113mumiem - kad tas ir lietder\u012bgi?"},"content":{"rendered":"<p>Tie, kas zina n\u0101kotni, ir priek\u0161\u0101! M\u016bsu tr\u012bsda\u013c\u012bgaj\u0101 rakst\u0101 lasiet, k\u0101p\u0113c biznesa inteli\u0123ence ir \u012bpa\u0161i svar\u012bga maziem un vid\u0113jiem uz\u0146\u0113mumiem (MVU), cik sare\u017e\u0123\u012bts paties\u012bb\u0101 ir pirmais solis, bet k\u0101das ir ar\u012b b\u016btisk\u0101s priek\u0161roc\u012bbas un k\u0101 j\u016bs varat efekt\u012bvi risin\u0101t visu \u0161o jaut\u0101jumu. MVU kontroles un vad\u012bbas eksperts Andreas Maliks (Andreas Malik), k\u0101 ar\u012b biznesa inteli\u0123ences speci\u0101listi un viena no vado\u0161ajiem datu vizualiz\u0101ciju un pane\u013cu Power BI un Qlik Sense pakalpojumu sniedz\u0113jiem Stefans Preuslers (Stefan Preusler) un Dominiks Galsheimers (Dominik Galsheimer) ar savu pieredzi un ekspertu zin\u0101\u0161an\u0101m j\u016bs iepaz\u012bstin\u0101s ar \u0161\u012bm 3 aizraujo\u0161aj\u0101m rakstu s\u0113rijas da\u013c\u0101m. Pirmaj\u0101 da\u013c\u0101 m\u0113s apl\u016bkosim, k\u0101p\u0113c Business Intelligence un MVU labi sader kop\u0101. Otraj\u0101 da\u013c\u0101 apl\u016bkota skaidra priek\u0161roc\u012bbu noteik\u0161ana un l\u012bdz ar to pareiz\u0101 br\u012b\u017ea atra\u0161ana, kad to uzs\u0101kt. P\u0113c tam tre\u0161aj\u0101 da\u013c\u0101 tiek par\u0101d\u012bti svar\u012bgi pirmie \u012bsteno\u0161anas un ievie\u0161anas so\u013ci.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p><strong>1. da\u013ca: K\u0101p\u0113c BI un MVU labi sader kop\u0101<\/strong><\/p>\n\n\n\n<p>Kr\u012b\u017eu, karu un arvien strauj\u0101ku p\u0101rmai\u0146u laik\u0101 uz\u0146\u0113m\u0113jdarb\u012bbas vid\u0113 uz\u0146\u0113mumiem ir svar\u012bgi rea\u0123\u0113t savlaic\u012bgi.<\/p>\n\n\n\n<p>Lai tiktu gal\u0101 ar \u0161iem izaicin\u0101jumiem, ir j\u0101analiz\u0113 dati par visiem uz\u0146\u0113m\u0113jdarb\u012bbas procesiem, lai tos apkopotu j\u0113gpiln\u0101 veid\u0101 un p\u0113c iesp\u0113jas samazin\u0101tu laiku, kas nepiecie\u0161ams l\u0113mumiem svar\u012bgas inform\u0101cijas sagatavo\u0161anai. \u0160o uzdevumu veic ar t\u0101 saukto Business Intelligence (BI). BI ir kop\u012bgs apz\u012bm\u0113jums metod\u0113m un procesiem sistem\u0101tiskai datu anal\u012bzei.<\/p>\n\n\n\n<p>V\u0113l pirms da\u017eiem gadiem BI bija rezerv\u0113ta lieliem uz\u0146\u0113mumiem. Jo \u012bpa\u0161i \u0146emot v\u0113r\u0101 BI risin\u0101jumu augst\u0101s izmaksas, Business Intelligence nebija interesants vid\u0113jiem uz\u0146\u0113mumiem. Ta\u010du pa \u0161o laiku BI ir non\u0101cis ar\u012b mazos un vid\u0113jos uz\u0146\u0113mumos (MVU). Bet k\u0101 \u0161ie MVU tiek defin\u0113ti? <\/p>\n\n\n\n<p>Liel\u0101kajai da\u013cai <strong>\u013coti mazs<\/strong> <strong>uz\u0146\u0113mumi<\/strong> (ES defin\u012bcija &lt;10 darbinieku apgroz\u012bjums &lt; 2 miljoni EUR gad\u0101) datu modelis ir viegli p\u0101rvald\u0101ms un tiek kart\u0113ts ar MS-Excel. \u0160eit bie\u017ei vien pietiek ar izv\u0113l\u0113t\u0101m pamatv\u0113rt\u012bb\u0101m un galvenajiem skait\u013ciem, lai veiktu ikm\u0113ne\u0161a novir\u017eu anal\u012bzi. Prezent\u0101cija tiek veikta uz vienas DIN-A4 lapas ar pe\u013c\u0146as\/zaud\u0113jumu p\u0101rskatu, bilanci un likvidit\u0101tes datiem. Turkl\u0101t tiek sniegta inform\u0101cija par pas\u016bt\u012bjumu situ\u0101ciju, produktivit\u0101ti (vai jaudas izmanto\u0161anu) un visp\u0101r\u0113jiem tirgus notikumiem.<\/p>\n\n\n\n<p>In <strong>mazie uz\u0146\u0113mumi<\/strong> (10 - 50 darbinieku, apgroz\u012bjums 2 - 10 miljoni EUR gad\u0101), kontroles sist\u0113ma ir nedaudz pla\u0161\u0101ka. Papildus vair\u0101kiem galvenajiem skait\u013ciem un novir\u017eu anal\u012bzei parasti ir ar\u012b priek\u0161skat\u012bjums\/prognoze.<\/p>\n\n\n\n<p>Gad\u012bjum\u0101, ja <strong>vid\u0113ja lieluma uz\u0146\u0113mumi<\/strong> (50 - 250 darbinieku, apgroz\u012bjums 10 - 50 miljoni EUR gad\u0101), papildus detaliz\u0113t\u0101m v\u0113rt\u012bb\u0101m, galvenajiem skait\u013ciem un anal\u012bz\u0113m tiek \u0146emta v\u0113r\u0101 ar\u012b inform\u0101cija, kas attiecas uz n\u0101kotni. T\u0101d\u0113j\u0101di galven\u0101 uzman\u012bba tiek piev\u0113rsta l\u012bdzsvarotam un skaidram inform\u0101cijas bl\u012bvumam.<\/p>\n\n\n\n<p>BI risin\u0101jumi nav gatavas sist\u0113mas; tos izveido individu\u0101li uz\u0146\u0113mumam (piel\u0101go\u0161ana). T\u0101s tiek izstr\u0101d\u0101tas, \u0146emot v\u0113r\u0101 attiec\u012bg\u0101s uz\u0146\u0113muma pras\u012bbas. R\u016bp\u012bga izstr\u0101de ir iz\u0161\u0137iro\u0161a BI sist\u0113mas priek\u0161roc\u012bb\u0101m un praktiskumam.<\/p>\n\n\n\n<p><strong>BI koncepcija jeb \"K\u0101du anal\u012bzi klients var redz\u0113t sav\u0101 pilotu kab\u012bn\u0113?\"<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\" type=\"1\"><li>Pirmaj\u0101 posm\u0101 ir j\u0101defin\u0113 uz\u0146\u0113mumam specifiskais n\u0101kotnes BI m\u0113r\u0137is. \u0160im nol\u016bkam uz\u0146\u0113m\u0113jam\/kontrolierim j\u0101formul\u0113, k\u0101dus galvenos r\u0101d\u012bt\u0101jus un nov\u0113rt\u0113jumus vi\u0146\u0161 v\u0113las ieg\u016bt galu gal\u0101.<\/li><li>N\u0101kamaj\u0101 posm\u0101 \u0161\u012bs pras\u012bbas tiek preciz\u0113tas un konkretiz\u0113tas. 3.<\/li><li>Lai ieg\u016btu galvenos skait\u013cus\/inform\u0101ciju, ir j\u0101p\u0101rbauda, kuri dati jau ir pieejami un kuri v\u0113l ir nepiecie\u0161ami. J\u0101preciz\u0113 datu avoti.<\/li><li>Zi\u0146o\u0161anas sist\u0113ma ir izstr\u0101d\u0101ta, pamatojoties uz iepriek\u0161 noteiktajiem galvenajiem r\u0101d\u012bt\u0101jiem un anal\u012bz\u0113m.<\/li><li>Savienot attiec\u012bgos datus no da\u017e\u0101diem avotiem (izveidot datu noliktavu).<\/li><li>Datu b\u0101zes sasaiste ar v\u0113lamo zi\u0146o\u0161anas sist\u0113mu.<\/li><li>Rezult\u0101ts: uz\u0146\u0113mumam piel\u0101gota kab\u012bne<\/li><\/ul>\n\n\n\n<p><strong>BI sist\u0113ma sal\u012bdzin\u0101jum\u0101 ar Excel jeb \"Kad p\u0101riet no Excel uz BI sist\u0113mu?\"<\/strong><\/p>\n\n\n\n<p>Izmantojot MS-Excel, m\u016bsdien\u0101s varat veikt daudzas anal\u012bzes un izveidot nelielas automatiz\u0101cijas (VBA makrouzdevumus). Priek\u0161roc\u012bbas ir t\u0101das, ka t\u0101 ir pieejama katr\u0101 uz\u0146\u0113mum\u0101, to var \u0101tri ieviest un t\u0101 ir ar\u012b l\u0113ta.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>K\u0101 <strong>\u013coti mazs<\/strong> <strong>uz\u0146\u0113mumi<\/strong>, parasti ar to pietiek. \u0160eit var b\u016bt lietder\u012bgi ar kontrolinga eksperta pal\u012bdz\u012bbu noteikt, vai \u0161ie nov\u0113rt\u0113jumi ir pietiekami, lai veiksm\u012bgi vad\u012btu uz\u0146\u0113mumu.<\/li><li>K\u0101 <strong>mazs uz\u0146\u0113mums<\/strong>, uz Excel balst\u012bti nov\u0113rt\u0113jumi uz\u0146\u0113mumu vad\u012bbai \u0101tri sasniedz savas robe\u017eas. Liel\u0101s manu\u0101l\u0101s izmaksas ir k\u013c\u016bdainas, laikietilp\u012bgas un viendimension\u0101las. \u0160aj\u0101 br\u012bd\u012b ir lietder\u012bgi izp\u0113t\u012bt BI priek\u0161roc\u012bbas. Visvienk\u0101r\u0161\u0101kais veids ir organiz\u0113t nesaisto\u0161u konsult\u0101ciju.<\/li><li>K\u0101 <strong>vid\u0113ja lieluma uz\u0146\u0113mums<\/strong>, lai veiksm\u012bgi darbotos k\u0101 uz\u0146\u0113mums, ir svar\u012bgi izveidot BI sist\u0113mu. Izmantojot tikai uz MS-Excel balst\u012btu sist\u0113mu, j\u016bs zaud\u0113jat daudz laika un naudas.<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>Rakstu s\u0113rijas otr\u0101 da\u013ca tiks public\u0113ta n\u0101kamned\u0113\u013c. Taj\u0101 lasiet, k\u0101p\u0113c noteikt \u012bsto laiku BI ievie\u0161anai ir izaicin\u0101jums un k\u0101 j\u016bs varat tikt gal\u0101 ar \u0161o uzdevumu. <\/p>\n\n\n\n<p>Ja ir v\u0113l k\u0101di jaut\u0101jumi, m\u0113s esam j\u016bsu r\u012bc\u012bb\u0101:<\/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>Tie, kas zina n\u0101kotni, ir priek\u0161\u0101! M\u016bsu tr\u012bsda\u013c\u012bgaj\u0101 rakst\u0101 lasiet, k\u0101p\u0113c biznesa inteli\u0123ence ir \u012bpa\u0161i svar\u012bga maziem un vid\u0113jiem uz\u0146\u0113mumiem (MVU), cik sare\u017e\u0123\u012bts paties\u012bb\u0101 ir pirmais solis, bet k\u0101das ir ar\u012b b\u016btisk\u0101s priek\u0161roc\u012bbas un k\u0101 j\u016bs varat efekt\u012bvi risin\u0101t visu \u0161o jaut\u0101jumu. MVU eksperts kontroles un ... <\/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\/lv\/wp-json\/wp\/v2\/posts\/8482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/comments?post=8482"}],"version-history":[{"count":0,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/posts\/8482\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/media\/8480"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/media?parent=8482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/categories?post=8482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/tags?post=8482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}