{"id":450,"date":"2021-08-01T12:55:32","date_gmt":"2021-08-01T10:55:32","guid":{"rendered":"http:\/\/vita.sk.vps202.nameserver.sk\/?post_type=product&p=450"},"modified":"2026-10-16T19:27:10","modified_gmt":"2026-10-16T17:27:10","slug":"online-kurz-datamining-a-business-intelligence-i-zaciatocnik","status":"publish","type":"product","link":"https:\/\/www.vita.sk\/cs\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/","title":{"rendered":"Online kurz Datamining a Business Intelligence I. Za\u010diato\u010dn\u00edk"},"content":{"rendered":"

Online kurz Datamining a Business Intelligence I. Za\u010diato\u010dn\u00edk je pre v\u00e1s ide\u00e1lny, ak chcete za\u010da\u0165 systematicky spracov\u00e1va\u0165 \u00fadaje a pripravova\u0165 zrozumite\u013en\u00e9 podklady pre rozhodovanie. Ide o certifikovan\u00fd online kurz na Datamining a Business Intelligence. Spolo\u010dne si vysvetl\u00edme, ako sa z \u00fadajov st\u00e1vaj\u00fa inform\u00e1cie vyu\u017eite\u013en\u00e9 pri sledovan\u00ed predaja, hodnoten\u00ed v\u00fdsledkov alebo organizovan\u00ed firemn\u00fdch procesov. Rozl\u00ed\u0161ime z\u00e1kladn\u00e9 typy anal\u00fdz a obozn\u00e1mime sa s metodikou CRISP-DM, ktor\u00e1 pom\u00e1ha usporiada\u0165 postup d\u00e1tov\u00e9ho projektu. Pozrieme sa na r\u00f4zne podoby \u00fadajov, otvoren\u00e9 d\u00e1ta a v\u00fdznam vhodnej pr\u00edpravy podkladov. Datamining a Business Intelligence si pribl\u00ed\u017eime najm\u00e4 prostredn\u00edctvom praktickej pr\u00e1ce s tabu\u013ekami, v\u00fdpo\u010dtami a analytick\u00fdmi n\u00e1strojmi. Na za\u010diatok nepotrebujete sk\u00fasenosti s programovan\u00edm, u\u017eito\u010dn\u00e1 je v\u0161ak samostatn\u00e1 pr\u00e1ca s po\u010d\u00edta\u010dom a z\u00e1kladn\u00e1 orient\u00e1cia v Exceli.<\/p>\n

 <\/p>\n

V praktickej \u010dasti sa zameriame na Microsoft Excel, kontingen\u010dn\u00e9 tabu\u013eky a Power Pivot. Nau\u010d\u00edme sa orientova\u0165 v tabu\u013ek\u00e1ch, pracova\u0165 s filtrami, form\u00e1tmi a r\u00f4znymi typmi \u00fadajov. Precvi\u010d\u00edme si \u00fapravy textu, prevody hodn\u00f4t, pr\u00e1cu s d\u00e1tumami, odkazovanie na bunky a pou\u017e\u00edvanie pomenovan\u00fdch oblast\u00ed. N\u00e1sledne prejdeme na agreg\u00e1ciu \u00fadajov, logick\u00e9 v\u00fdrazy a vzorce, pomocou ktor\u00fdch priprav\u00edme s\u00fahrnn\u00e9 v\u00fdsledky. Uk\u00e1\u017eeme si vytv\u00e1ranie kontingen\u010dn\u00fdch tabuliek a grafov, z\u00edskavanie jedine\u010dn\u00fdch hodn\u00f4t, zora\u010fovanie aj overovanie zad\u00e1van\u00fdch \u00fadajov. Pri Power Pivote sa obozn\u00e1mime s importom d\u00e1t, d\u00e1tov\u00fdmi po\u013eami a v\u00fdpo\u010dtami. Dopln\u00edme orient\u00e1ciu v SQL Serveri, PostgreSQL, exeku\u010dn\u00fdch pl\u00e1noch a vyu\u017eit\u00ed jazyka R pri analytickej pr\u00e1ci. Bonusov\u00e1 \u010das\u0165 predstav\u00ed makr\u00e1, VBA a mo\u017enosti pr\u00e1ce s rozsiahlej\u0161\u00edmi s\u00fabormi v Exceli.<\/p>\n

 <\/p>\n

Online kurz Datamining a Business Intelligence \u0161tudujete v sloven\u010dine a vlastn\u00fdm tempom. Z\u00edskate ro\u010dn\u00fd pr\u00edstup, materi\u00e1ly na stiahnutie, pr\u00edru\u010dku, prezent\u00e1ciu a \u0165ah\u00e1ky. Pri precvi\u010dovan\u00ed odpor\u00fa\u010dame postupova\u0165 od pr\u00edpravy vstupnej tabu\u013eky cez v\u00fdpo\u010dty a\u017e po preh\u013eadn\u00e9 zobrazenie v\u00fdsledkov. Budeme si tak vytv\u00e1ra\u0165 n\u00e1vyk kontrolova\u0165 form\u00e1ty, \u00faplnos\u0165 \u00fadajov a spr\u00e1vnos\u0165 pou\u017eit\u00fdch vzorcov. Z\u00edskan\u00e9 postupy vyu\u017eijete napr\u00edklad pri porovn\u00e1van\u00ed mesa\u010dn\u00fdch v\u00fdsledkov, spracovan\u00ed z\u00e1kazn\u00edckych zoznamov alebo pr\u00edprave podkladov na pracovn\u00fa poradu. Vedomosti si over\u00edme v z\u00e1vere\u010dnom teste a po \u00faspe\u0161nom absolvovan\u00ed z\u00edskate certifik\u00e1t VITA. Ak sa chcete skuto\u010dne nau\u010di\u0165 z\u00e1klady dataminingu a Business Intelligence a vyu\u017e\u00edva\u0165 \u00fadaje pri rozhodovan\u00ed, tak toto je ide\u00e1lny vstupn\u00fd online kurz pre v\u00e1s.<\/p>\n","protected":false},"excerpt":{"rendered":"

Online kurz Datamining a Business Intelligence I. Za\u010diato\u010dn\u00edk v\u00e1s nau\u010d\u00ed analyzova\u0165 a spracov\u00e1va\u0165 d\u00e1ta, pou\u017e\u00edva\u0165 Business Intelligence, SQL, kontingen\u010dn\u00e9 tabu\u013eky, PowerPivot a automatizova\u0165 analytick\u00e9 \u00falohy pomocou makier a VBA.","protected":false},"author":27,"featured_media":24154,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[1042,50,49,73],"product_tag":[188,347,1082,1083,1179,1208,1220,1222,1882,1883,1884],"class_list":{"0":"post-450","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-online-kurzy-business-analyza-babok","7":"product_cat-online-kurzy-datamining-a-business-intelligence","8":"product_cat-online-kurzy-databazy-statistika-analytika","9":"product_cat-bez-kategorie","10":"product_tag-databazy-a-analytika","11":"product_tag-sql","12":"product_tag-microsoft-excel","13":"product_tag-analyza-dat","14":"product_tag-kontingencne-tabulky","15":"product_tag-business-intelligence","16":"product_tag-reporting","17":"product_tag-vizualizacia-dat","18":"product_tag-datamining","19":"product_tag-power-pivot","20":"product_tag-crisp-dm","22":"first","23":"instock","24":"sale","25":"virtual","26":"sold-individually","27":"taxable","28":"purchasable","29":"product-type-simple"},"yoast_head":"\nOnline kurz Datamining a BI pre za\u010diato\u010dn\u00edkov 2026 | VITA<\/title>\n<meta name=\"description\" content=\"Online kurz Datamining a Business Intelligence v\u00e1s nau\u010d\u00ed pracova\u0165 s d\u00e1tami v organiz\u00e1ci\u00e1ch a pou\u017e\u00edvanie BI n\u00e1strojov v podnikovej praxi. \u2705\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online kurz Datamining a Business Intelligence I. Za\u010diato\u010dn\u00edk\" \/>\n<meta property=\"og:description\" content=\"Online kurz Datamining a Business Intelligence v\u00e1s nau\u010d\u00ed pracova\u0165 s d\u00e1tami v organiz\u00e1ci\u00e1ch a pou\u017e\u00edvanie BI n\u00e1strojov v podnikovej praxi. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/\" \/>\n<meta property=\"og:site_name\" content=\"VITA\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/VitaAcademySK\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-16T17:27:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vita.sk\/wp-content\/uploads\/2025\/02\/online-kurz-datamining-a-business-intelligence.png\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t \"@context\": \"https:\/\/schema.org\",\n\t \"@graph\": [\n\t {\n\t \"@type\": \"WebPage\",\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/\",\n\t \"url\": \"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/\",\n\t \"name\": \"Online kurz Datamining a BI pre za\u010diato\u010dn\u00edkov {Y} | VITA\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t },\n\t \"primaryImageOfPage\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/#primaryimage\"\n\t },\n\t \"image\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/#primaryimage\"\n\t },\n\t \"thumbnailUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2025\/02\/online-kurz-datamining-a-business-intelligence.png\",\n\t \"datePublished\": \"2021-08-01T10:55:32+00:00\",\n\t \"dateModified\": \"2026-10-16T17:27:10+00:00\",\n\t \"description\": \"Online kurz Datamining a Business Intelligence v\u00e1s nau\u010d\u00ed pracova\u0165 s d\u00e1tami v organiz\u00e1ci\u00e1ch a pou\u017e\u00edvanie BI n\u00e1strojov v podnikovej praxi. \u2705\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/#breadcrumb\"\n\t },\n\t \"inLanguage\": \"cs\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"ReadAction\",\n\t \"target\": [\n\t \"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/\"\n\t ]\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"ImageObject\",\n\t \"inLanguage\": \"cs\",\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/#primaryimage\",\n\t \"url\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2025\/02\/online-kurz-datamining-a-business-intelligence.png\",\n\t \"contentUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2025\/02\/online-kurz-datamining-a-business-intelligence.png\",\n\t \"width\": 360,\n\t \"height\": 360,\n\t \"caption\": \"online kurz datamining a business intelligence\"\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/#breadcrumb\",\n\t \"itemListElement\": [\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 1,\n\t \"name\": \"VITA Academy\",\n\t \"item\": \"https:\/\/www.vita.sk\/cs\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 2,\n\t \"name\": \"Shop\",\n\t \"item\": \"https:\/\/www.vita.sk\/shop\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 3,\n\t \"name\": \"Spr\u00e1va Datab\u00e1z, \u0160tatistika a D\u00e1tov\u00e1 Anal\u00fdza\",\n\t \"item\": \"https:\/\/www.vita.sk\/online-kurzy-databazy-statistika-analytika\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 4,\n\t \"name\": \"Datamining a business intelligence\",\n\t \"item\": \"https:\/\/www.vita.sk\/online-kurzy-datamining-a-business-intelligence\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 5,\n\t \"name\": \"Online kurz Datamining a Business Intelligence I. Za\u010diato\u010dn\u00edk\"\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"WebSite\",\n\t \"@id\": \"https:\/\/www.vita.sk\/#website\",\n\t \"url\": \"https:\/\/www.vita.sk\/\",\n\t \"name\": \"VITA Academy - Online Kurzy a \u0160kolenia\",\n\t \"description\": \"\",\n\t \"publisher\": {\n\t \"@id\": \"https:\/\/www.vita.sk\/#organization\"\n\t },\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"SearchAction\",\n\t \"target\": {\n\t \"@type\": \"EntryPoint\",\n\t \"urlTemplate\": \"https:\/\/www.vita.sk\/?s={search_term_string}\"\n\t },\n\t \"query-input\": {\n\t \"@type\": \"PropertyValueSpecification\",\n\t \"valueRequired\": true,\n\t \"valueName\": \"search_term_string\"\n\t }\n\t }\n\t ],\n\t \"inLanguage\": \"cs\"\n\t },\n\t {\n\t \"email\": \"admin@vita.sk\",\n\t \"logo\": \"https:\/\/www.vita.sk\/img\/vita_logo.png \",\n\t \"address\": {\n\t \"type\": \"PostalAddress\",\n\t \"streetAddress\": \"Tom\u00e1\u0161ikova 50\/A\",\n\t \"addressLocality\": \"Bratislava\",\n\t \"postalCode\": \"83104\",\n\t \"addressCountry\": {\n\t \"name\": \"SK\",\n\t \"type\": \"Country\"\n\t }\n\t },\n\t \"contactPoint\": {\n\t \"type\": \"ContactPoint\",\n\t \"telephone\": \"+421 907 375\u00a0543\",\n\t \"Email\": \"admin@vita.sk\",\n\t \"contactType\": \"customer service\"\n\t },\n\t \"sameAs\": [\n\t \"https:\/\/www.facebook.com\/VitaAcademySK\/\",\n\t \"https:\/\/www.linkedin.com\/company\/vita-academy\/\"\n\t ]\n\t }\n\t ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Online kurz Datamining a BI pre za\u010diato\u010dn\u00edkov 2026 | VITA","description":"Online kurz Datamining a Business Intelligence v\u00e1s nau\u010d\u00ed pracova\u0165 s d\u00e1tami v organiz\u00e1ci\u00e1ch a pou\u017e\u00edvanie BI n\u00e1strojov v podnikovej praxi. \u2705","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/","og_locale":"cs_CZ","og_type":"article","og_title":"Online kurz Datamining a Business Intelligence I. Za\u010diato\u010dn\u00edk","og_description":"Online kurz Datamining a Business Intelligence v\u00e1s nau\u010d\u00ed pracova\u0165 s d\u00e1tami v organiz\u00e1ci\u00e1ch a pou\u017e\u00edvanie BI n\u00e1strojov v podnikovej praxi. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/","og_site_name":"VITA","article_publisher":"https:\/\/www.facebook.com\/VitaAcademySK","article_modified_time":"2026-10-16T17:27:10+00:00","og_image":[{"width":360,"height":360,"url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2025\/02\/online-kurz-datamining-a-business-intelligence.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"3 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/","url":"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/","name":"Online kurz Datamining a BI pre za\u010diato\u010dn\u00edkov {Y} | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/#primaryimage"},"image":{"@id":"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2025\/02\/online-kurz-datamining-a-business-intelligence.png","datePublished":"2021-08-01T10:55:32+00:00","dateModified":"2026-10-16T17:27:10+00:00","description":"Online kurz Datamining a Business Intelligence v\u00e1s nau\u010d\u00ed pracova\u0165 s d\u00e1tami v organiz\u00e1ci\u00e1ch a pou\u017e\u00edvanie BI n\u00e1strojov v podnikovej praxi. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/#primaryimage","url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2025\/02\/online-kurz-datamining-a-business-intelligence.png","contentUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2025\/02\/online-kurz-datamining-a-business-intelligence.png","width":360,"height":360,"caption":"online kurz datamining a business intelligence"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurz-datamining-a-business-intelligence-i-zaciatocnik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"VITA Academy","item":"https:\/\/www.vita.sk\/cs\/"},{"@type":"ListItem","position":2,"name":"Shop","item":"https:\/\/www.vita.sk\/shop\/"},{"@type":"ListItem","position":3,"name":"Spr\u00e1va Datab\u00e1z, \u0160tatistika a D\u00e1tov\u00e1 Anal\u00fdza","item":"https:\/\/www.vita.sk\/online-kurzy-databazy-statistika-analytika\/"},{"@type":"ListItem","position":4,"name":"Datamining a business intelligence","item":"https:\/\/www.vita.sk\/online-kurzy-datamining-a-business-intelligence\/"},{"@type":"ListItem","position":5,"name":"Online kurz Datamining a Business Intelligence I. Za\u010diato\u010dn\u00edk"}]},{"@type":"WebSite","@id":"https:\/\/www.vita.sk\/#website","url":"https:\/\/www.vita.sk\/","name":"VITA Academy - Online Kurzy a \u0160kolenia","description":"","publisher":{"@id":"https:\/\/www.vita.sk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vita.sk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"email":"admin@vita.sk","logo":"https:\/\/www.vita.sk\/img\/vita_logo.png ","address":{"type":"PostalAddress","streetAddress":"Tom\u00e1\u0161ikova 50\/A","addressLocality":"Bratislava","postalCode":"83104","addressCountry":{"name":"SK","type":"Country"}},"contactPoint":{"type":"ContactPoint","telephone":"+421 907 375\u00a0543","Email":"admin@vita.sk","contactType":"customer service"},"sameAs":["https:\/\/www.facebook.com\/VitaAcademySK\/","https:\/\/www.linkedin.com\/company\/vita-academy\/"]}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product\/450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/types\/product"}],"author":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/comments?post=450"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/media\/24154"}],"wp:attachment":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/media?parent=450"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_brand?post=450"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_cat?post=450"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_tag?post=450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}