{"id":123,"date":"2016-12-19T12:00:12","date_gmt":"2016-12-19T11:00:12","guid":{"rendered":"http:\/\/cij.hu\/hu\/?p=123"},"modified":"2017-01-28T21:26:20","modified_gmt":"2017-01-28T20:26:20","slug":"adatelemzesi-eszkozok-es-programok-az-ujsagirasban","status":"publish","type":"post","link":"https:\/\/cij.hu\/hu\/adatelemzesi-eszkozok-es-programok-az-ujsagirasban\/","title":{"rendered":"Adatelemz\u00e9si eszk\u00f6z\u00f6k \u00e9s programok az \u00fajs\u00e1g\u00edr\u00e1sban"},"content":{"rendered":"<p>Hogyan haszn\u00e1lhatj\u00e1k \u00fajs\u00e1g\u00edr\u00f3k az Excelt \u00e9s az SQL szervereket munk\u00e1jukban? Err\u0151l tartott egynapos, gyakorlatk\u00f6zpont\u00fa m\u0171helyfoglalkoz\u00e1sokat a F\u00fcggetlen M\u00e9diak\u00f6zpont 2016. december 12-\u00e9n \u00e9s 13-\u00e1n <strong>Crina Boros<\/strong>, nemzetk\u00f6zi adat\u00fajs\u00e1g\u00edr\u00f3-szak\u00e9rt\u0151 vezet\u00e9s\u00e9vel.<\/p>\n<p><span id=\"more-3884\"><\/span>A workshop kifejezetten t\u00e9nyfelt\u00e1r\u00f3 \u00e9s gazdas\u00e1gi \u00fajs\u00e1g\u00edr\u00f3k sz\u00e1m\u00e1ra volt hasznos, akik rendszeresen dolgoznak nagy mennyis\u00e9g\u0171 adattal. Az els\u0151 napon az Excellel \u00e9s a Google Fusion Tables szoftverrel ismerkedhettek meg. Megtanult\u00e1k haszn\u00e1lni az Excel alapvet\u0151 funkci\u00f3it, sz\u00e1m\u00edt\u00e1sokat, sz\u0171r\u00e9seket, hogyan k\u00e9sz\u00edtsenek pivot t\u00e1bl\u00e1kat \u00e9s hogyan egyes\u00edtsenek t\u00e1bl\u00e1zatokat ahhoz, hogy mint\u00e1kat \u00e9s t\u00f6rt\u00e9neteket vegyenek \u00e9szre az adatsorokban. A m\u00e1sodik napon az Exceln\u00e9l j\u00f3val nagyobb adatb\u00e1zisokat is kezelni tud\u00f3, programk\u00f3d alap\u00fa SQL szerverrel dolgozhattak a r\u00e9sztvev\u0151k. Ezzel a programmal, illetve programnyelvvel bonyolultabb adatelemz\u00e9sek v\u00e9gezhet\u0151ek, mint Excelben, valamint gyakran hat\u00e9konyabban \u00f6sszekapcsolhat\u00f3ak k\u00e9t k\u00fcl\u00f6nb\u00f6z\u0151 adatb\u00e1zisban szerepl\u0151 inform\u00e1ci\u00f3k.<\/p>\n<div id=\"attachment_124\" style=\"width: 690px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-124\" class=\"wp-image-124 size-large\" src=\"http:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0239-4-1024x681.jpg\" alt=\"Crina seg\u00edt az SQL k\u00f3dokat meg\u00edrni\" width=\"680\" height=\"452\" srcset=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0239-4-1024x681.jpg 1024w, https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0239-4-300x199.jpg 300w, https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0239-4-768x511.jpg 768w, https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0239-4-680x452.jpg 680w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><p id=\"caption-attachment-124\" class=\"wp-caption-text\">Crina seg\u00edt az SQL k\u00f3dokat meg\u00edrni<\/p><\/div>\n<p>A workshopokoat <strong>Crina Boros <\/strong>d\u00edjnyertes, szabad\u00fasz\u00f3 oknyomoz\u00f3 \u00fajs\u00e1g\u00edr\u00f3 \u00e9s adat\u00fajs\u00e1g\u00edr\u00e1s tr\u00e9ner vezette, akinek szakter\u00fclete az adatelemz\u00e9s \u00e9s a k\u00f6z\u00e9rdek\u0171 adatig\u00e9nyl\u00e9s. Munk\u00e1it a BBC, a Thomson Reuters, a Greenpeace, a The Black Sea \u00e9s az OffshoreAlert publik\u00e1lta. Jelenleg Londonban \u00e9l, \u00e9s nemzetk\u00f6zi szinten k\u00e9pz\u00e9seket tart adat\u00fajs\u00e1g\u00edr\u00f3knak. Id\u00e9n j\u00faliusban m\u00e1r a F\u00fcggetlen M\u00e9diak\u00f6zpont \u00e9s a P\u00e9csi Tudom\u00e1nyegyetem ny\u00e1ri adat\u00fajs\u00e1g\u00edr\u00f3i t\u00e1bor\u00e1ban is tartott egy alapoz\u00f3 kurzust.<\/p>\n<p><em>A rendezv\u00e9ny r\u00e9sze a F\u00fcggetlen M\u00e9diak\u00f6zpont Az \u00fajs\u00e1g\u00edr\u00e1s \u00fajraind\u00edt\u00e1sa\u201d c\u00edm\u0171 projektj\u00e9nek, amelyet a Ny\u00edlt T\u00e1rsadalom Int\u00e9zet Alap\u00edtv\u00e1ny t\u00e1mogat.<\/em><\/p>\n<p>Tov\u00e1bbi k\u00e9pek a foglalkoz\u00e1sr\u00f3l (<em>Fot\u00f3k: M\u00f3ricz Ilona \u00e9s Kiss Eszter):<\/em><\/p>\n<style type=\"text\/css\">\n#foogallery-gallery-125 .fg-image { width: 150px; }\n#foogallery-gallery-125 { --fg-gutter: 10px; }<\/style>\n\t\t\t<div class=\"foogallery foogallery-container foogallery-default foogallery-lightbox-foobox-free fg-center fg-default fg-ready fg-light fg-border-thin fg-shadow-small fg-loading-default fg-loaded-fade-in fg-hover-fade fg-hover-zoom\" id=\"foogallery-gallery-125\" data-foogallery=\"{&quot;item&quot;:{&quot;showCaptionTitle&quot;:true,&quot;showCaptionDescription&quot;:false},&quot;lazy&quot;:true}\" style=\"--fg-title-line-clamp: 0; --fg-description-line-clamp: 0;\" >\n\t<div class=\"fg-item fg-type-image fg-idle\"><figure class=\"fg-item-inner\"><a href=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/IMG_0958.jpg\" data-attachment-id=\"126\" data-type=\"image\" class=\"fg-thumb\"><span class=\"fg-image-wrap\"><img decoding=\"async\" width=\"150\" height=\"150\" class=\"skip-lazy fg-image\" data-src-fg=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/cache\/2017\/01\/IMG_0958\/2049936324.jpg\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20width%3D%22150%22%20height%3D%22150%22%20viewBox%3D%220%200%20150%20150%22%3E%3C%2Fsvg%3E\" loading=\"eager\"><\/span><span class=\"fg-image-overlay\"><\/span><\/a><\/figure><div class=\"fg-loader\"><\/div><\/div><div class=\"fg-item fg-type-image fg-idle\"><figure class=\"fg-item-inner\"><a href=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0235-2.jpg\" data-attachment-id=\"127\" data-type=\"image\" class=\"fg-thumb\"><span class=\"fg-image-wrap\"><img decoding=\"async\" width=\"150\" height=\"150\" class=\"skip-lazy fg-image\" data-src-fg=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/cache\/2017\/01\/DSC_0235-2\/3568934032.jpg\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20width%3D%22150%22%20height%3D%22150%22%20viewBox%3D%220%200%20150%20150%22%3E%3C%2Fsvg%3E\" loading=\"eager\"><\/span><span class=\"fg-image-overlay\"><\/span><\/a><\/figure><div class=\"fg-loader\"><\/div><\/div><div class=\"fg-item fg-type-image fg-idle\"><figure class=\"fg-item-inner\"><a href=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0236-3.jpg\" data-attachment-id=\"128\" data-type=\"image\" class=\"fg-thumb\"><span class=\"fg-image-wrap\"><img decoding=\"async\" width=\"150\" height=\"150\" class=\"skip-lazy fg-image\" data-src-fg=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/cache\/2017\/01\/DSC_0236-3\/2758164206.jpg\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20width%3D%22150%22%20height%3D%22150%22%20viewBox%3D%220%200%20150%20150%22%3E%3C%2Fsvg%3E\" loading=\"eager\"><\/span><span class=\"fg-image-overlay\"><\/span><\/a><\/figure><div class=\"fg-loader\"><\/div><\/div><div class=\"fg-item fg-type-image fg-idle\"><figure class=\"fg-item-inner\"><a href=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0239-4-1.jpg\" data-attachment-id=\"129\" data-type=\"image\" class=\"fg-thumb\"><span class=\"fg-image-wrap\"><img decoding=\"async\" width=\"150\" height=\"150\" class=\"skip-lazy fg-image\" data-src-fg=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/cache\/2017\/01\/DSC_0239-4-1\/1628470412.jpg\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20width%3D%22150%22%20height%3D%22150%22%20viewBox%3D%220%200%20150%20150%22%3E%3C%2Fsvg%3E\" loading=\"eager\"><\/span><span class=\"fg-image-overlay\"><\/span><\/a><\/figure><div class=\"fg-loader\"><\/div><\/div><div class=\"fg-item fg-type-image fg-idle\"><figure class=\"fg-item-inner\"><a href=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0242-6.jpg\" data-attachment-id=\"130\" data-type=\"image\" class=\"fg-thumb\"><span class=\"fg-image-wrap\"><img decoding=\"async\" width=\"150\" height=\"150\" class=\"skip-lazy fg-image\" data-src-fg=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/cache\/2017\/01\/DSC_0242-6\/4207955072.jpg\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20width%3D%22150%22%20height%3D%22150%22%20viewBox%3D%220%200%20150%20150%22%3E%3C%2Fsvg%3E\" loading=\"eager\"><\/span><span class=\"fg-image-overlay\"><\/span><\/a><\/figure><div class=\"fg-loader\"><\/div><\/div><div class=\"fg-item fg-type-image fg-idle\"><figure class=\"fg-item-inner\"><a href=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0244-7.jpg\" data-attachment-id=\"131\" data-type=\"image\" class=\"fg-thumb\"><span class=\"fg-image-wrap\"><img decoding=\"async\" width=\"150\" height=\"150\" class=\"skip-lazy fg-image\" data-src-fg=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/cache\/2017\/01\/DSC_0244-7\/3422447861.jpg\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20width%3D%22150%22%20height%3D%22150%22%20viewBox%3D%220%200%20150%20150%22%3E%3C%2Fsvg%3E\" loading=\"eager\"><\/span><span class=\"fg-image-overlay\"><\/span><\/a><\/figure><div class=\"fg-loader\"><\/div><\/div><div class=\"fg-item fg-type-image fg-idle\"><figure class=\"fg-item-inner\"><a href=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/DSC_0246-8.jpg\" data-attachment-id=\"132\" data-type=\"image\" class=\"fg-thumb\"><span class=\"fg-image-wrap\"><img decoding=\"async\" width=\"150\" height=\"150\" class=\"skip-lazy fg-image\" data-src-fg=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/cache\/2017\/01\/DSC_0246-8\/3706999249.jpg\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20width%3D%22150%22%20height%3D%22150%22%20viewBox%3D%220%200%20150%20150%22%3E%3C%2Fsvg%3E\" loading=\"eager\"><\/span><span class=\"fg-image-overlay\"><\/span><\/a><\/figure><div class=\"fg-loader\"><\/div><\/div><div class=\"fg-item fg-type-image fg-idle\"><figure class=\"fg-item-inner\"><a href=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/2017\/01\/IMG_0953.jpg\" data-attachment-id=\"133\" data-type=\"image\" class=\"fg-thumb\"><span class=\"fg-image-wrap\"><img decoding=\"async\" width=\"150\" height=\"150\" class=\"skip-lazy fg-image\" data-src-fg=\"https:\/\/cij.hu\/hu\/wp-content\/uploads\/cache\/2017\/01\/IMG_0953\/4091093163.jpg\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20width%3D%22150%22%20height%3D%22150%22%20viewBox%3D%220%200%20150%20150%22%3E%3C%2Fsvg%3E\" loading=\"eager\"><\/span><span class=\"fg-image-overlay\"><\/span><\/a><\/figure><div class=\"fg-loader\"><\/div><\/div><\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Hogyan haszn\u00e1lhatj\u00e1k \u00fajs\u00e1g\u00edr\u00f3k az Excelt \u00e9s az SQL szervereket munk\u00e1jukban? Err\u0151l tartott egynapos, gyakorlatk\u00f6zpont\u00fa m\u0171helyfoglalkoz\u00e1sokat a F\u00fcggetlen M\u00e9diak\u00f6zpont 2016. december 12-\u00e9n \u00e9s 13-\u00e1n Crina Boros, nemzetk\u00f6zi adat\u00fajs\u00e1g\u00edr\u00f3-szak\u00e9rt\u0151 vezet\u00e9s\u00e9vel. A workshop kifejezetten t\u00e9nyfelt\u00e1r\u00f3 \u00e9s gazdas\u00e1gi \u00fajs\u00e1g\u00edr\u00f3k sz\u00e1m\u00e1ra volt hasznos, akik rendszeresen dolgoznak nagy mennyis\u00e9g\u0171 adattal. Az els\u0151 napon az Excellel \u00e9s a Google Fusion Tables szoftverrel [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":124,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-megtortent-esemenyek"],"_links":{"self":[{"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/posts\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":3,"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"predecessor-version":[{"id":252,"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/posts\/123\/revisions\/252"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/media\/124"}],"wp:attachment":[{"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cij.hu\/hu\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}