{"id":7124,"date":"2020-04-27T15:10:07","date_gmt":"2020-04-27T13:10:07","guid":{"rendered":"https:\/\/kovacsgyulacoach.hu\/?p=7124"},"modified":"2022-04-27T17:32:38","modified_gmt":"2022-04-27T15:32:38","slug":"picasso-szkeccs-kihelyezett-trening","status":"publish","type":"post","link":"https:\/\/kovacsgyulacoach.hu\/picasso-szkeccs-kihelyezett-trening\/","title":{"rendered":"Picasso szkeccs"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"7124\" class=\"elementor elementor-7124\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-34c0e5d0 ot-traditional elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"34c0e5d0\" data-element_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-3b78b119 ot-flex-column-vertical\" data-id=\"3b78b119\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4b21df4b elementor-widget elementor-widget-text-editor\" data-id=\"4b21df4b\" data-element_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<h5><span style=\"color: #000000;\">\/\/ K\u00c9PZ\u00c9S C\u00c9LJA<\/span><\/h5>\n<span style=\"color: #000000;\"><strong><em>Picasso \u2013 &#8222;Nem keresek. Tal\u00e1lok&#8221;!<\/em><\/strong><\/span>\n\n<span style=\"color: #000000;\">Napjainkban az adatelemz\u00e9si piac egyik legdinamikusabban fejl\u0151d\u0151 ter\u00fclete az adatvizualiz\u00e1ci\u00f3. Rengeteg kiv\u00e1l\u00f3 BI eszk\u00f6z \u00e1ll rendelkez\u00e9s\u00fcnkre, hogy az adatok alapj\u00e1n l\u00e1tv\u00e1nyos grafikonokat, dashboardokat k\u00e9sz\u00edts\u00fcnk. Azonban sok esetben sajnos h\u00e1tt\u00e9rbe szorul az adatvizualiz\u00e1ci\u00f3 els\u0151dleges c\u00e9lja, az<\/span><span style=\"color: #000000;\"><em>\u00a0elemz\u00e9si eredm\u00e9nyek \u00c9RTHET\u0150 megjelen\u00edt\u00e9se a d\u00f6nt\u00e9shoz\u00f3k sz\u00e1m\u00e1ra. <\/em><\/span><span style=\"color: #000000;\">A <span style=\"text-decoration: underline;\">k\u00e9pz\u00e9s c\u00e9lja<\/span> olyan Excel tr\u00fckk\u00f6k\/technik\u00e1k bemutat\u00e1sa, melyek seg\u00edts\u00e9g\u00e9vel rendk\u00edv\u00fcl l\u00e1tv\u00e1nyos diagramokat tudunk k\u00e9sz\u00edteni az Excelben.<\/span>\n<h5><span style=\"color: #000000;\">\/\/ K\u00c9PZ\u00c9S TEMATIK\u00c1JA<\/span><\/h5>\n<span style=\"color: #000000;\">Elm\u00e9let:<\/span>\n<ul>\n \t<li>Milyen probl\u00e9m\u00e1k vannak az Excel be\u00e9p\u00edtett sablonjaival? (zajok)<\/li>\n \t<li>Hogyan t\u00fcntess\u00fck el a zajokat az y-tengelyr\u0151l<\/li>\n \t<li>Hogyan \u00e1br\u00e1zoljuk a d\u00e1tumokat az x-tengelyen<\/li>\n \t<li>Milyen diagramt\u00edpust v\u00e1lasszunk?<\/li>\n \t<li>Hogyan alkalmazzunk preattent\u00edv attrib\u00fatumokat? (kiemel\u00e9sek kezel\u00e9se Excel-ben)<\/li>\n \t<li>Milyen sz\u00ednsk\u00e1l\u00e1kat alkalmazzunk? Hogyan ne k\u00e9sz\u00edts\u00fcnk spagetti diagramot?<\/li>\n \t<li>Hogyan k\u00e9sz\u00edts\u00fcnk waterfall (v\u00edzes\u00e9s) diagramot?<\/li>\n \t<li>Hogyan k\u00e9sz\u00edts\u00fcnk tartom\u00e1ny diagramot?<\/li>\n<\/ul>\nGyakorlati blokk (konkr\u00e9t diagramok k\u00e9sz\u00edt\u00e9se k\u00f6z\u00f6sen):\n(Egy t\u00e1bl\u00e1zat alapj\u00e1n hogyan tudunk teljesen elt\u00e9r\u0151 diagramot k\u00e9sz\u00edteni)\n<ul>\n \t<li>\u00c9rt\u00e9kes\u00edt\u00e9si adatok megjelen\u00edt\u00e9se region\u00e1lis szinten vonal \u00e9s ter\u00fclet diagrammal<\/li>\n \t<li>V\u00e1llalati cash-flow \u00e1br\u00e1zol\u00e1sa v\u00edzes\u00e9s diagrammal<\/li>\n \t<li>\u00c1tfut\u00e1si id\u0151k \u00e1br\u00e1zol\u00e1sa oszlop \u00e9s vonal diagrammal<\/li>\n<\/ul>\n<h5><span style=\"color: #000000;\">\/\/ KIKNEK AJ\u00c1NLOM?<\/span><\/h5>\n<span style=\"color: #000000;\">Adatelemz\u0151knek, adatm\u00e9rn\u00f6k\u00f6knek, BI szak\u00e9rt\u0151knek \u00e9s term\u00e9szetesen tan\u00e1csad\u00f3knak, de v\u00e9g\u00fcl is mindenkinek, aki nemcsak mag\u00e1nak k\u00e9sz\u00edt diagramokat, hanem m\u00e1soknak!<\/span>\n<h5><span style=\"color: #000000;\">\/\/ MIKOR \u00c9S HOL?<\/span><\/h5>\n<span style=\"color: #000000;\">Napjainkban nagyon n\u00e9pszer\u0171ek az online workshopok. Azonban jelenleg kis csoportos foglalkoz\u00e1sok keret\u00e9ben tartom a k\u00e9pz\u00e9seket (maxim\u00e1lisan 6 f\u0151). A szem\u00e9lyes oktat\u00e1s sz\u00e1momra egy k\u00fcldet\u00e9s \u2013 hiszek abban, hogy val\u00f3di tud\u00e1s\u00e1tad\u00e1s csak szem\u00e9lyes keretek k\u00f6zt t\u00f6rt\u00e9nhet. A k\u00e9pz\u00e9s sor\u00e1n sz\u00e1mos gyakorlati p\u00e9ld\u00e1t oldunk meg. A tapasztalatom az, hogy a k\u00f6z\u00f6s feladat megold\u00e1sok inspir\u00e1lj\u00e1k a hallgat\u00f3s\u00e1got.<\/span>\n<h6><span style=\"color: #ff6600;\"><em>C\u00e9gek k\u00e9rhetnek kihelyezett tr\u00e9ninget minimum 3 f\u0151s l\u00e9tsz\u00e1mt\u00f3l. Ebben az esetben az id\u0151pont \u00e9s helysz\u00edn k\u00f6z\u00f6s egyeztet\u00e9s alapj\u00e1n ker\u00fcl v\u00e9gleges\u00edt\u00e9sre.<\/em><\/span><\/h6>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77f21f8 elementor-widget elementor-widget-text-editor\" data-id=\"77f21f8\" data-element_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<p style=\"text-align: center;\">\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f4477-o1\" lang=\"hu-HU\" dir=\"ltr\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/wp-json\/wp\/v2\/posts\/7124#wpcf7-f4477-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Kapcsolatfelv\u00e9teli \u0171rlap\" novalidate=\"novalidate\" data-status=\"init\">\n<div style=\"display: none;\">\n<input type=\"hidden\" name=\"_wpcf7\" value=\"4477\" \/>\n<input type=\"hidden\" name=\"_wpcf7_version\" value=\"5.7.7\" \/>\n<input type=\"hidden\" name=\"_wpcf7_locale\" value=\"hu_HU\" \/>\n<input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f4477-o1\" \/>\n<input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/>\n<input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/>\n<input type=\"hidden\" name=\"_wpcf7_recaptcha_response\" value=\"\" \/>\n<\/div>\n<div class=\"main-form\">\n\t<h3 style=\"color:white;\">Regisztr\u00e1ci\u00f3\/\u00e9rdekl\u0151d\u00e9s\n\t<\/h3>\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"your-name\"><input size=\"40\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"N\u00e9v *\" value=\"\" type=\"text\" name=\"your-name\" \/><\/span>\n\t<\/p>\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"your-email\"><input size=\"40\" class=\"wpcf7-form-control wpcf7-text wpcf7-email wpcf7-validates-as-required wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Email *\" value=\"\" type=\"email\" name=\"your-email\" \/><\/span>\n\t<\/p>\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"tel-928\"><input size=\"40\" class=\"wpcf7-form-control wpcf7-text wpcf7-tel wpcf7-validates-as-required wpcf7-validates-as-tel\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Telefon *\" value=\"\" type=\"tel\" name=\"tel-928\" \/><\/span>\n\t<\/p>\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"radio-175\"><span class=\"wpcf7-form-control wpcf7-radio\"><span class=\"wpcf7-list-item first\"><label><input type=\"radio\" name=\"radio-175\" value=\"Regisztr\u00e1ci\u00f3\" checked=\"checked\" \/><span class=\"wpcf7-list-item-label\">Regisztr\u00e1ci\u00f3<\/span><\/label><\/span><span class=\"wpcf7-list-item last\"><label><input type=\"radio\" name=\"radio-175\" value=\"\u00c9rdekl\u0151d\u00e9s\" \/><span class=\"wpcf7-list-item-label\">\u00c9rdekl\u0151d\u00e9s<\/span><\/label><\/span><\/span><\/span>\n\t<\/p>\n\t<h5 style=\"color:white;\">Online tr\u00e9ningek:\n\t<\/h5>\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"checkbox-564\"><span class=\"wpcf7-form-control wpcf7-checkbox\"><span class=\"wpcf7-list-item first\"><label><span class=\"wpcf7-list-item-label\">SHERLOCK<\/span><input type=\"checkbox\" name=\"checkbox-564[]\" value=\"SHERLOCK\" \/><\/label><\/span><span class=\"wpcf7-list-item\"><label><span class=\"wpcf7-list-item-label\">PICASSO<\/span><input type=\"checkbox\" name=\"checkbox-564[]\" value=\"PICASSO\" \/><\/label><\/span><span class=\"wpcf7-list-item last\"><label><span class=\"wpcf7-list-item-label\">NOSTRADAMUS<\/span><input type=\"checkbox\" name=\"checkbox-564[]\" value=\"NOSTRADAMUS\" \/><\/label><\/span><\/span><\/span>\n\t<\/p>\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"checkbox-565\"><span class=\"wpcf7-form-control wpcf7-checkbox\"><span class=\"wpcf7-list-item first last\"><label><span class=\"wpcf7-list-item-label\">TuesData mini online tr\u00e9ningsorozat<\/span><input type=\"checkbox\" name=\"checkbox-565[]\" value=\"TuesData mini online tr\u00e9ningsorozat\" \/><\/label><\/span><\/span><\/span>\n\t<\/p>\n\t<h5 style=\"color:white;\">Kihelyezett tr\u00e9ningek:\n\t<\/h5>\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"checkbox-566\"><span class=\"wpcf7-form-control wpcf7-checkbox\"><span class=\"wpcf7-list-item first\"><label><span class=\"wpcf7-list-item-label\">SHERLOCK<\/span><input type=\"checkbox\" name=\"checkbox-566[]\" value=\"SHERLOCK\" \/><\/label><\/span><span class=\"wpcf7-list-item\"><label><span class=\"wpcf7-list-item-label\">PICASSO<\/span><input type=\"checkbox\" name=\"checkbox-566[]\" value=\"PICASSO\" \/><\/label><\/span><span class=\"wpcf7-list-item\"><label><span class=\"wpcf7-list-item-label\">PICASSO szkeccs<\/span><input type=\"checkbox\" name=\"checkbox-566[]\" value=\"PICASSO szkeccs\" \/><\/label><\/span><span class=\"wpcf7-list-item\"><label><span class=\"wpcf7-list-item-label\">NOSTRADAMUS<\/span><input type=\"checkbox\" name=\"checkbox-566[]\" value=\"NOSTRADAMUS\" \/><\/label><\/span><span class=\"wpcf7-list-item last\"><label><span class=\"wpcf7-list-item-label\">Csapat\u00e9p\u00edt\u00e9s<\/span><input type=\"checkbox\" name=\"checkbox-566[]\" value=\"Csapat\u00e9p\u00edt\u00e9s\" \/><\/label><\/span><\/span><\/span>\n\t<\/p>\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"checkbox-567\"><span class=\"wpcf7-form-control wpcf7-checkbox\"><span class=\"wpcf7-list-item first\"><label><span class=\"wpcf7-list-item-label\">On-the-job tr\u00e9ning<\/span><input type=\"checkbox\" name=\"checkbox-567[]\" value=\"On-the-job tr\u00e9ning\" \/><\/label><\/span><span class=\"wpcf7-list-item last\"><label><span class=\"wpcf7-list-item-label\">Szem\u00e9lyi edz\u00e9s<\/span><input type=\"checkbox\" name=\"checkbox-567[]\" value=\"Szem\u00e9lyi edz\u00e9s\" \/><\/label><\/span><\/span><\/span>\n\t<\/p>\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"your-message\"><textarea cols=\"40\" rows=\"10\" class=\"wpcf7-form-control wpcf7-textarea\" aria-invalid=\"false\" placeholder=\"Megjegyz\u00e9s...\" name=\"your-message\"><\/textarea><\/span>\n\t<\/p>\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"acceptance-928\"><span class=\"wpcf7-form-control wpcf7-acceptance\"><span class=\"wpcf7-list-item\"><label><input type=\"checkbox\" name=\"acceptance-928\" value=\"1\" aria-invalid=\"false\" \/><span class=\"wpcf7-list-item-label\">Elfogadom az adatkezel\u00e9s\u00e9re vonatkoz\u00f3 <a href=\"\/adatvedelmi-iranyelvek\" target=\"_blank\">ir\u00e1nyelveket.<\/a><\/span><\/label><\/span><\/span><\/span><br \/>\n<button type=\"submit\" class=\"octf-btn octf-btn-light\">K\u00fcld\u00e9s<\/button>\n\t<\/p>\n<\/div><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n<\/p>\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\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Picasso \u2013 &#8222;Nem keresek. Tal\u00e1lok!&#8221;<br \/>\nNapjainkban az adatelemz\u00e9si piac egyik legdinamikusabban fejl\u0151d\u0151 ter\u00fclete az adatvizualiz\u00e1ci\u00f3.<\/p>\n","protected":false},"author":4,"featured_media":6043,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"none"},"categories":[97],"tags":[100,103,87],"_links":{"self":[{"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/posts\/7124"}],"collection":[{"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/comments?post=7124"}],"version-history":[{"count":11,"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/posts\/7124\/revisions"}],"predecessor-version":[{"id":7313,"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/posts\/7124\/revisions\/7313"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/media\/6043"}],"wp:attachment":[{"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/media?parent=7124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/categories?post=7124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kovacsgyulacoach.hu\/wp-json\/wp\/v2\/tags?post=7124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}