{"id":4305,"date":"2022-02-09T11:33:00","date_gmt":"2022-02-09T10:33:00","guid":{"rendered":"https:\/\/info21.cz\/?p=4305"},"modified":"2025-08-07T15:53:48","modified_gmt":"2025-08-07T13:53:48","slug":"pouziti-datoveho-skladu-se-systemem-lighthouse21","status":"publish","type":"post","link":"https:\/\/www.info21.cz\/en\/pouziti-datoveho-skladu-se-systemem-lighthouse21\/","title":{"rendered":"Pou\u017eit\u00ed datov\u00e9ho skladu se syst\u00e9mem Lighthouse21"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"4305\" class=\"elementor elementor-4305\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e531549 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e531549\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-81df7f6\" data-id=\"81df7f6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8820e76 elementor-widget elementor-widget-text-editor\" data-id=\"8820e76\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: justify;\">Mana\u017eersk\u00fd syst\u00e9m Lighthouse21 umo\u017e\u0148uje online anal\u00fdzu dat z\u00a0n\u011bkolika datov\u00fdch zdroj\u016f &#8211; v\u010detn\u011b konsolidace dat z\u00a0v\u00edce spole\u010dnost\u00ed. To m\u00e1 v\u0161ak jist\u00e1 omezen\u00ed &#8211; zejm\u00e9na pokud firma pou\u017e\u00edv\u00e1 r\u016fzn\u00e9 podnikov\u00e9 syst\u00e9my a pot\u0159ebuje dos\u00e1hnout spole\u010dn\u00e9ho vyhodnocen\u00ed dat. V\u00a0takov\u00e9m p\u0159\u00edpad\u011b podnikov\u00e1 data neumo\u017e\u0148uj\u00ed optim\u00e1ln\u00ed anal\u00fdzu dat.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8122fb2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8122fb2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ebcf9be\" data-id=\"ebcf9be\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6658bc1 elementor-widget elementor-widget-heading\" data-id=\"6658bc1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Ide\u00e1ln\u00ed \u00falo\u017ei\u0161t\u011b podnikov\u00fdch dat<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-578d7db elementor-widget elementor-widget-text-editor\" data-id=\"578d7db\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>V\u00a0sou\u010dasn\u00e9 dob\u011b je \u010dast\u00fd model, kdy mate\u0159sk\u00e1 firma\u00a0<em>konsoliduje data<\/em>\u00a0z\u00a0dce\u0159in\u00fdch spole\u010dnost\u00ed. N\u011bkdy tyto spole\u010dnosti u\u017e\u00edvaj\u00ed\u00a0<em>r\u016fzn\u00e9 podnikov\u00e9 syst\u00e9my.<\/em>\u00a0P\u0159i konsolidaci dat je vhodn\u00e9 stanovit pravidla pro vz\u00e1jemn\u00e9\u00a0<em>obchodn\u00ed aktivity<\/em>\u00a0\u2013 aby se prodej koncov\u00e9mu z\u00e1kazn\u00edkovi na\u010d\u00edtal jen jednou a ne n\u011bkolikr\u00e1t\u00a0 &#8211; jak se zbo\u017e\u00ed nebo v\u00fdrobky \u201ep\u0159eprod\u00e1vaj\u00ed\u201c mezi spole\u010dnostmi.<\/p><p>\u010casto se tak\u00e9 st\u00e1v\u00e1, \u017ee firmy pou\u017e\u00edvaj\u00ed podnikov\u00e9 syst\u00e9my, kter\u00e9 se vyv\u00edjely n\u011bkolik let a nov\u00e9 tabulky byly do syst\u00e9mu jen \u201ep\u0159ilepov\u00e1ny\u201c a nebyla provedena\u00a0<em>datov\u00e1 optimalizace.<\/em>\u00a0D\u016fsledkem t\u00e9to situace b\u00fdv\u00e1 nevhodn\u011b navr\u017een\u00e1\u00a0<em>struktura\u00a0podnikov\u00e9 datab\u00e1ze,<\/em>\u00a0kter\u00e1 neumo\u017e\u0148uje spr\u00e1vnou\u00a0<em>anal\u00fdzu dat,<\/em>\u00a0nebo jejich anal\u00fdza trv\u00e1 velmi dlouho. V\u00a0takov\u00e9m p\u0159\u00edpad\u011b je pot\u0159eba data p\u0159ed vlastn\u00ed anal\u00fdzou upravit\u2026<\/p><p>V\u00a0t\u011bchto p\u0159\u00edpadech se vol\u00ed jako\u00a0<em>zdroj dat pro mana\u017eersk\u00fd syst\u00e9m<\/em>\u00a0Lighthouse21 varianta datov\u00e9ho skladu.\u00a0<em>Datov\u00fd sklad &#8211; Data Warehouse (DWH)<\/em>\u00a0je ide\u00e1ln\u00edm \u00falo\u017ei\u0161t\u011bm podnikov\u00fdch dat \u00a0&#8211; data se ukl\u00e1daj\u00ed v\u00a0optim\u00e1ln\u00ed podob\u011b pro perfektn\u00ed\u00a0<em>analytick\u00e9 zpracov\u00e1n\u00ed.<\/em>\u00a0D\u00edky tomu se mohou pln\u011b vyu\u017e\u00edt\u00a0<em>n\u00e1stroje Business Intelligence<\/em>\u00a0pro anal\u00fdzu dat.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-58de882 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"58de882\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e2017b8\" data-id=\"e2017b8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-df0d98c elementor-widget elementor-widget-heading\" data-id=\"df0d98c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Optim\u00e1ln\u00ed struktura dat<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2238203 elementor-widget elementor-widget-text-editor\" data-id=\"2238203\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A pro\u010d je d\u016fle\u017eit\u00e9 m\u00edt\u00a0<em>optim\u00e1ln\u00ed strukturu dat?<\/em>\u00a0D\u00edky tomu se do datov\u00e9ho skladu nep\u0159en\u00e1\u0161\u00ed zbyte\u010dn\u00e9 \u00fadaje, kter\u00e9 by zpomalovaly nebo zm\u00e1tly\u00a0<em>v\u00fdsledky podnikov\u00e9 anal\u00fdzy.<\/em>\u00a0D\u00e1le zajist\u00ed vytvo\u0159en\u00ed vazeb mezi datov\u00fdmi tabulkami, kter\u00e9 spolu souvis\u00ed. Optimalizace sou\u010dasn\u011b sjednot\u00ed\u00a0<em>datovou strukturu<\/em>\u00a0s\u00a0daty z\u00a0n\u011bkolika syst\u00e9m\u016f. D\u00e1le tak\u00e9 konsoliduje data pro spole\u010dnosti v\u00a0holdingov\u00e9 struktu\u0159e\u2026\u00a0<\/p><p>N\u011bkdy je mo\u017en\u00e9 i ukl\u00e1dat redundantn\u00ed \u00fadaje, aby se usnadnila anal\u00fdza dat. V\u00a0neposledn\u00ed \u0159ad\u011b je mo\u017en\u00e9 p\u0159i pln\u011bn\u00ed datov\u00e9ho skladu spo\u010d\u00edtat celou \u0159adu\u00a0<em>podnikov\u00fdch ukazatel\u016f,<\/em>\u00a0kter\u00e9 se pak mohou prezentovat v\u00a0<em>dashboardech.\u00a0<\/em>Ty mohou b\u00fdt zp\u011btn\u011b ukl\u00e1d\u00e1ny i v\u00a0d\u0159\u00edv\u011bj\u0161\u00edch hodnot\u00e1ch, abychom mohli<em>\u00a0porovnat stavy ukazatele\u00a0<\/em>v\u00a0minulosti.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Mana\u017eersk\u00fd syst\u00e9m Lighthouse21 umo\u017e\u0148uje online anal\u00fdzu dat z\u00a0n\u011bkolika datov\u00fdch zdroj\u016f &#8211; v\u010detn\u011b konsolidace dat z\u00a0v\u00edce spole\u010dnost\u00ed. To m\u00e1 v\u0161ak jist\u00e1 omezen\u00ed &#8211; zejm\u00e9na pokud firma pou\u017e\u00edv\u00e1 r\u016fzn\u00e9 podnikov\u00e9 syst\u00e9my a pot\u0159ebuje dos\u00e1hnout spole\u010dn\u00e9ho vyhodnocen\u00ed dat. V\u00a0takov\u00e9m p\u0159\u00edpad\u011b podnikov\u00e1 data neumo\u017e\u0148uj\u00ed optim\u00e1ln\u00ed anal\u00fdzu dat. Ide\u00e1ln\u00ed \u00falo\u017ei\u0161t\u011b podnikov\u00fdch dat V\u00a0sou\u010dasn\u00e9 dob\u011b je \u010dast\u00fd model, kdy mate\u0159sk\u00e1 firma\u00a0konsoliduje&hellip;&nbsp;<a href=\"https:\/\/www.info21.cz\/en\/pouziti-datoveho-skladu-se-systemem-lighthouse21\/\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Pou\u017eit\u00ed datov\u00e9ho skladu se syst\u00e9mem Lighthouse21<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":4306,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-4305","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lighthouse21"],"views":1623,"_links":{"self":[{"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/posts\/4305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/comments?post=4305"}],"version-history":[{"count":4,"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/posts\/4305\/revisions"}],"predecessor-version":[{"id":4310,"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/posts\/4305\/revisions\/4310"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/media\/4306"}],"wp:attachment":[{"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/media?parent=4305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/categories?post=4305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.info21.cz\/en\/wp-json\/wp\/v2\/tags?post=4305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}