{"id":11146,"date":"2020-06-17T15:32:50","date_gmt":"2020-06-17T13:32:50","guid":{"rendered":"https:\/\/help.marketingminer.com\/article\/az-exportalt-adatok-adatelemzese\/"},"modified":"2023-03-17T16:04:49","modified_gmt":"2023-03-17T15:04:49","slug":"az-exportalt-adatok-adatelemzese","status":"publish","type":"kb","link":"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/","title":{"rendered":"Az export\u00e1lt adatok adatelemz\u00e9se"},"content":{"rendered":"\n<h2>Excel<\/h2>\n\n<p>Az <strong>Excel-t\u00e1bl\u00e1zat a Marketing Miner alapvet\u0151 kimenete<\/strong>, amely a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra a report elk\u00e9sz\u00fclte ut\u00e1n el\u00e9rhet\u0151. Mindig tartalmaz egy kezdeti list\u00e1t (Report), amely \u00f6sszefoglalja az \u00f6sszegy\u0171jt\u00f6tt adatokra vonatkoz\u00f3 inform\u00e1ci\u00f3kat, majd egy \u00e1ltal\u00e1nos list\u00e1t Data, amely az egyes sorok kimenet\u00e9n\u00e9l el\u00e9rhet\u0151 adatokat tartalmazza, majd m\u00e1s list\u00e1kat a b\u00e1ny\u00e1szok szerint, amelyek nem p\u00e1ros\u00edthat\u00f3k egyenesen egy sorba.<\/p>\n\n<p><strong>Tervez\u00e9si kiigaz\u00edt\u00e1s<\/strong><\/p>\n\n<p>A f\u00e1jl let\u00f6lt\u00e9se \u00e9s megnyit\u00e1sa ut\u00e1n a felhaszn\u00e1l\u00f3 a kezdeti list\u00e1hoz (Jelent\u00e9s) jut. Egyes Excel-verzi\u00f3k <strong>enged\u00e9lyt<\/strong> k\u00e9rnek a manipul\u00e1l\u00e1s el\u0151tt, mivel az internetr\u0151l let\u00f6lt\u00f6tt f\u00e1jlr\u00f3l van sz\u00f3, hasonl\u00f3an az al\u00e1bbi k\u00e9phez:<\/p>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"39\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/excel-permission-1024x39.png\" alt=\"Excel enged&#xE9;ly\" class=\"wp-image-3017\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/excel-permission-1024x39.png 1024w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/excel-permission-300x12.png 300w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/excel-permission-768x30.png 768w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/excel-permission.png 1275w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<p>Ahhoz, hogy a felhaszn\u00e1l\u00f3 manipul\u00e1lni tudja a f\u00e1jlt, el\u0151sz\u00f6r enged\u00e9lyt kell adnia r\u00e1. Az Excel gyakran a kimeneti f\u00e1jlt a <strong>sz\u00f6veg beburkol\u00e1sa<\/strong> n\u00e9lk\u00fcl jelen\u00edti meg, ami a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra kaotikusnak t\u0171nhet. Annak \u00e9rdek\u00e9ben, hogy a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra egy\u00e9rtelm\u0171bb legyen, a wrap text funkci\u00f3t el kell t\u00e1vol\u00edtani:<\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"193\" height=\"101\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/wrapping-in-Excel.png\" alt=\"Csomagol&#xE1;s Excelben\" class=\"wp-image-3020\"\/><\/figure><\/div>\n\n<p><strong>Sz\u0171r\u0151 l\u00e9trehoz\u00e1sa<\/strong><\/p>\n\n<p>A sz\u0171r\u0151 funkci\u00f3 az adatok megjelen\u00edt\u00e9s\u00e9nek be\u00e1ll\u00edt\u00e1s\u00e1ra szolg\u00e1l. Ez a funkci\u00f3 l\u00e9trehoz egy sz\u0171r\u0151tartom\u00e1nyt a fels\u0151 oszlopokb\u00f3l, amely lehet\u0151v\u00e9 teszi a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra, hogy sorokat keressen az oszlopokban, vagy m\u00e1s m\u00f3don sz\u0171rje az adatk\u00e9szlet tartalm\u00e1t:<\/p>\n\n<iframe loading=\"lazy\" width=\"718\" height=\"429\" src=\"https:\/\/www.youtube.com\/embed\/YNB4a2pzq4E\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n<p><strong>P\u00e9ld\u00e1k a tartalomsz\u0171r\u00e9sre<\/strong><\/p>\n\n<p>Az alapvet\u0151 sz\u0171r\u00e9s sz\u00f6vegsz\u0171r\u00e9s. A felhaszn\u00e1l\u00f3 be\u00edrja a sz\u00f6veg egy r\u00e9sz\u00e9t, amely megfelel a kiv\u00e1lasztott oszlop cell\u00e1inak, \u00e9s az OK gombra kattint\u00e1s ut\u00e1n a felhaszn\u00e1l\u00f3 csak a hozz\u00e1rendel\u00e9snek megfelel\u0151 adatk\u00e9szlethez jut.<\/p>\n\n<p>Az Excel k\u00e9t alapvet\u0151 \u00e9s leggyakrabban haszn\u00e1lt sz\u0171r\u0151t\u00edpussal rendelkezik:<\/p>\n\n<p><strong>Sz\u00f6vegsz\u0171r\u0151k<\/strong><\/p>\n\n<p>Ha az oszlop cell\u00e1iban sz\u00f6veges tartalom van, az Excel sz\u00f6vegsz\u0171r\u0151ket haszn\u00e1l a sz\u0171r\u00e9shez. Ezek a sz\u0171r\u0151k a keres\u00e9shez hasonl\u00f3an m\u0171k\u00f6dnek, \u00e9s a funkci\u00f3juk a nev\u00fckh\u00f6z hasonl\u00f3an intuit\u00edv.:<\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"539\" height=\"359\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-filters.png\" alt=\"Sz&#xF6;vegsz&#x171;r&#x151;k\" class=\"wp-image-3023\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-filters.png 539w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-filters-300x200.png 300w\" sizes=\"(max-width: 539px) 100vw, 539px\" \/><\/figure><\/div>\n\n<p><strong>Sz\u00e1msz\u0171r\u0151k<\/strong><\/p>\n\n<p>Ha az oszlop cell\u00e1iban sz\u00e1mtartalom van, az Excel sz\u00e1msz\u0171r\u0151ket haszn\u00e1l a sz\u0171r\u00e9shez. Ezek lehet\u0151v\u00e9 teszik a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra, hogy kiv\u00e1lassza az adatk\u00e9szlet egy olyan r\u00e9sz\u00e9t, amely megfelel a tartom\u00e1ny \u00f6sszetettebb felt\u00e9teleinek vagy az oszlopcell\u00e1k minim\u00e1lis vagy maxim\u00e1lis \u00e9rt\u00e9k\u00e9nek.<\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"451\" height=\"276\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/number-filters.png\" alt=\"Sz&#xE1;msz&#x171;r&#x151;k\" class=\"wp-image-3026\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/number-filters.png 451w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/number-filters-300x184.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/figure><\/div>\n\n<p><strong>Felt\u00e9teles form\u00e1z\u00e1s<\/strong><\/p>\n\n<p>A felt\u00e9teles form\u00e1z\u00e1s a cella sz\u00edn\u00e9nek megv\u00e1ltoztat\u00e1s\u00e1ra szolg\u00e1l, a cella \u00e9rt\u00e9k\u00e9nek az eg\u00e9sz oszlophoz viszony\u00edtott \u00e9rt\u00e9ke alapj\u00e1n. Az alkalmaz\u00e1s \u00e9s a kimenet p\u00e9ld\u00e1ja az al\u00e1bbi vide\u00f3n l\u00e1that\u00f3:<\/p>\n\n<p><strong>Diagramok k\u00e9sz\u00edt\u00e9se<\/strong><\/p>\n\n<p>A kimeneti adatok felhaszn\u00e1l\u00e1s\u00e1val a felhaszn\u00e1l\u00f3 ezut\u00e1n diagramokat k\u00e9sz\u00edthet:<\/p>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"371\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/charts-in-Excel-1024x371.png\" alt=\"Diagramok Excelben\" class=\"wp-image-3029\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/charts-in-Excel-1024x371.png 1024w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/charts-in-Excel-300x109.png 300w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/charts-in-Excel-768x278.png 768w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/charts-in-Excel.png 1270w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<p><strong>Egy\u00e9b oktat\u00f3anyagok a Microsoft Excelhez:<\/strong><\/p>\n\n<p>A grafikonok Excelben t\u00f6rt\u00e9n\u0151 elk\u00e9sz\u00edt\u00e9s\u00e9re vonatkoz\u00f3 utas\u00edt\u00e1sok a k\u00f6vetkez\u0151 c\u00edmen tal\u00e1lhat\u00f3k:<br\/><a href=\"http:\/\/blog.hubspot.com\/marketing\/how-to-build-excel-graph#sm.0001r0d1h49fkev4ss01cfocetczs\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/blog.hubspot.com\/marketing\/how-to-build-excel-graph#sm.0001r0d1h49fkev4ss01cfocetczs<\/a><\/p>\n\n<h2>OpenRefine<\/h2>\n\n<p>Az al\u00e1bbi m\u0171veletekhez az OpenRefine valamelyik verzi\u00f3j\u00e1nak telep\u00edt\u00e9se sz\u00fcks\u00e9ges. Megtal\u00e1lhat\u00f3 a k\u00f6vetkez\u0151 c\u00edmen:<br\/><a href=\"http:\/\/openrefine.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/openrefine.org\/<\/a><\/p>\n\n<p><strong>Projekt l\u00e9trehoz\u00e1sa import\u00e1lt adatokb\u00f3l<\/strong><\/p>\n\n<p>Egy projekt OpenRefine-be t\u00f6rt\u00e9n\u0151 import\u00e1l\u00e1s\u00e1hoz a Marketing Minerb\u0151l let\u00f6lt\u00f6tt XLSX f\u00e1jlt kell import\u00e1lni az eszk\u00f6z bemenet\u00e9n. A m\u00e1sodik l\u00e9p\u00e9sben ki kell v\u00e1lasztani a feldolgozand\u00f3 lapok list\u00e1j\u00e1t. Az OpenRefine-nek automatikusan fel kell ismernie a f\u00e1jl k\u00f3dol\u00e1s\u00e1t, \u00e9s a kimeneti p\u00e9ld\u00e1ban meg kell jelen\u00edtenie a projekt el\u0151n\u00e9zet\u00e9t.<\/p>\n\n<p>A projekt elnevez\u00e9se \u00e9s a <strong>Projekt l\u00e9trehoz\u00e1sa<\/strong> gombra kattint\u00e1s ut\u00e1n egy \u00faj projekt j\u00f6n l\u00e9tre az OpenRefine-ban, \u00e9s az al\u00e1bbi utas\u00edt\u00e1sok seg\u00edts\u00e9g\u00e9vel tov\u00e1bb dolgozhat vele.<\/p>\n\n<iframe loading=\"lazy\" width=\"718\" height=\"429\" src=\"https:\/\/www.youtube.com\/embed\/YnkL1A_4Kqw\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n<p><strong>Facet alkalmaz\u00e1s \u00e9s kimeneti sz\u0171r\u00e9s<\/strong><\/p>\n\n<p>Az OpenRefine egyik er\u0151ss\u00e9ge a <strong>Facetekkel<\/strong> \u00e9s <strong>sz\u0171r\u0151kkel<\/strong> val\u00f3 munka. Lehet\u0151v\u00e9 teszik a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra a gyors munk\u00e1t a potenci\u00e1lis probl\u00e9m\u00e1k \u00e9s lehet\u0151s\u00e9gek azonos\u00edt\u00e1s\u00e1val. A fakult\u00e1sok egyidej\u0171leg kombin\u00e1lhat\u00f3k egym\u00e1ssal. A tartalomsz\u0171r\u00e9s \u00e9s szegment\u00e1l\u00e1s alapvet\u0151 eszk\u00f6zei a k\u00f6vetkez\u0151k:<\/p>\n\n<p><strong>Sz\u00f6vegsz\u0171r\u0151<\/strong><\/p>\n\n<p>Egyszer\u0171 keres\u00e9s a sz\u00f6veg egy r\u00e9sz\u00e9nek \u00e9s a cella tartalm\u00e1nak egyez\u00e9s\u00e9vel. A sz\u00f6vegsz\u0171r\u0151ben a felhaszn\u00e1l\u00f3 dolgozhat szab\u00e1lyos kifejez\u00e9sekkel, vagy megadhatja, hogy a hozz\u00e1rendel\u00e9s nagy- \u00e9s kisbet\u0171 \u00e9rz\u00e9keny legyen (a bet\u0171k nagy- \u00e9s kisbet\u0171j\u00e9t\u0151l f\u00fcgg).<\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"299\" height=\"93\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/open-refine-text-filter.png\" alt=\"Sz&#xF6;vegsz&#x171;r&#x151; finom&#xED;t&#xE1;sa\" class=\"wp-image-3032\"\/><\/figure><\/div>\n\n<p><strong>Sz\u00f6veg Facet<\/strong><\/p>\n\n<p>A Text Facet a cell\u00e1kat az egyez\u00e9s\u00fck alapj\u00e1n csoportos\u00edtja. A projekt teljes oszlop\u00e1t vizsg\u00e1lja, amelyre a felhaszn\u00e1l\u00f3 r\u00e1kattintott, \u00e9s egyes\u00edti az azonos tartalm\u00fa cell\u00e1kat, \u00edgy a felhaszn\u00e1l\u00f3 sz\u0171rheti az oszlop azonos cell\u00e1inak tartalm\u00e1t.<\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"298\" height=\"296\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-facet-1.png\" alt=\"Sz&#xF6;veg finom&#xED;t&#xE1;sa aspektus megnyit&#xE1;sa\" class=\"wp-image-3035\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-facet-1.png 298w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-facet-1-150x150.png 150w\" sizes=\"(max-width: 298px) 100vw, 298px\" \/><\/figure><\/div>\n\n<p>Ez a Facet hasonl\u00f3an m\u0171k\u00f6dik, mint a cell\u00e1k tartalma szerinti klaszterez\u00e9s, amikor az Excelben sz\u0171r\u00fcnk.<\/p>\n\n<p><strong>Numerikus Facet<\/strong><\/p>\n\n<p>A Numeric Facet figyelembe veszi a haszn\u00e1lt oszlopok cell\u00e1it, amelyekben sz\u00e1mok vannak, majd ezeket egy X tengelyre viszi ki, ahol a felhaszn\u00e1l\u00f3 a tengely tartom\u00e1ny\u00e1nak eltol\u00e1s\u00e1val meghat\u00e1rozhatja azokat az adatokat, amelyekkel dolgozni szeretne (vagy azokat az adatokat, amelyeket l\u00e1tni szeretne).<\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"299\" height=\"126\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/numeric-facet-open-refine.png\" alt=\"Numberic Facet nyitott finom&#xED;t&#xE1;s\" class=\"wp-image-3038\"\/><\/figure><\/div>\n\n<p>A Numeric Facet t\u00f6bb oszlop felett t\u00f6rt\u00e9n\u0151 v\u00e9grehajt\u00e1sa ut\u00e1n a korl\u00e1toz\u00e1sok kombin\u00e1l\u00f3dnak.<\/p>\n\n<p><strong>Scatterplot Facet<\/strong><\/p>\n\n<p>A Scatterplot Facet hasonl\u00f3an m\u0171k\u00f6dik, mint a Numeric Facet, azzal a k\u00fcl\u00f6nbs\u00e9ggel, hogy az adatokat egyszerre k\u00e9t tengelyre viszi ki. A felhaszn\u00e1l\u00f3 ekkor kap egy m\u00e9r\u0151sz\u00e1mot az X tengelyen \u00e9s egy m\u00e1sikat az Y tengelyen. A Scatterplot Facet szegmens kiv\u00e1laszt\u00e1sa ut\u00e1n a felhaszn\u00e1l\u00f3 eljut a sz\u0171rt tartalomhoz, amely a kiv\u00e1laszt\u00e1s\u00e1ba esik.<\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"296\" height=\"198\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/Scatterplot-Facet-2.png\" alt=\"Scatterplot Facet\" class=\"wp-image-3041\"\/><\/figure><\/div>\n\n<p>A Scatterplot Facet p\u00e9ld\u00e1ul t\u00f6k\u00e9letes a Boston m\u00e1trixhoz.<\/p>\n\n<p><strong>Sz\u00f3 Facet<\/strong><\/p>\n\n<p>A Word Facet a Customized Facets (Testreszabott Facetek) szakaszban tal\u00e1lhat\u00f3, \u00e9s egyszer\u0171en a kiv\u00e1lasztott oszlop cell\u00e1it szavakra osztja. Ezut\u00e1n kisz\u00e1m\u00edtja az el\u0151fordul\u00e1suk gyakoris\u00e1g\u00e1t, \u00e9s a kimeneten megjelen\u00edti azt.<\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"297\" height=\"295\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/word-facet-open-refine.png\" alt=\"Word Facet - Open Refine\" class=\"wp-image-3044\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/word-facet-open-refine.png 297w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/word-facet-open-refine-150x150.png 150w\" sizes=\"(max-width: 297px) 100vw, 297px\" \/><\/figure><\/div>\n\n<p>A Word Facet seg\u00edts\u00e9g\u00e9vel k\u00f6nnyen kider\u00edthet\u0151 az egyes kifejez\u00e9sek el\u0151fordul\u00e1si gyakoris\u00e1ga, illetve a tartalom ellen\u0151rz\u00e9se vagy a konkurenci\u00e1t\u00f3l val\u00f3 m\u00e1sol\u00e1s sor\u00e1n meghat\u00e1rozhat\u00f3 a lek\u00e9rdez\u00e9sek el\u0151fordul\u00e1si gyakoris\u00e1ga.<\/p>\n\n<p><strong>Sz\u00f6veghossz\u00fas\u00e1g Facet<\/strong><\/p>\n\n<p>Facet, amely beolvassa a kiv\u00e1lasztott oszlop cell\u00e1it, \u00e9s a hosszukat a sz\u0171rt X tengelyre vezeti.<\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"297\" height=\"295\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-length-facet-open-refine-1.png\" alt=\"Sz&#xF6;veghossz&#xFA;s&#xE1;g Open Refine facet\" class=\"wp-image-3047\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-length-facet-open-refine-1.png 297w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-length-facet-open-refine-1-150x150.png 150w\" sizes=\"(max-width: 297px) 100vw, 297px\" \/><\/figure><\/div>\n\n<p>Nagyon hasznos lehet a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra, amikor a c\u00edm hossz\u00e1t ellen\u0151rzi vagy a versenyt\u00e1rs hirdet\u00e9seket elemzi.<\/p>\n\n<p><strong>Facet by blank<\/strong><\/p>\n\n<p>Egyszer\u0171 facet, amely csak a cell\u00e1kat vizsg\u00e1lja, \u00e9s azokat, amelyek \u00fcresek, igaznak, a t\u00f6bbit pedig hamisnak nevezi.<\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"297\" height=\"152\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/facet-by-blank-open-refine.png\" alt=\"Facet by blank Open Refine\" class=\"wp-image-3050\"\/><\/figure><\/div>\n\n<h2>Tableau<\/h2>\n\n<p>A Tableau egy nagyszer\u0171 eszk\u00f6z az \u00fczleti intelligencia ter\u00fclet\u00e9n. A Marketing Miner felhaszn\u00e1l\u00f3i sz\u00e1m\u00e1ra gyors \u00e9s hat\u00e9kony lehet\u0151s\u00e9get biztos\u00edt az adatok vizualiz\u00e1l\u00e1s\u00e1ra.<br\/>Tov\u00e1bbi inform\u00e1ci\u00f3 az eszk\u00f6zr\u0151l \u00e9s annak let\u00f6lt\u00e9s\u00e9r\u0151l a k\u00f6vetkez\u0151 c\u00edmen:<br\/><a href=\"http:\/\/www.tableau.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/www.tableau.com\/<\/a><\/p>\n\n<p><strong>A kimenet import\u00e1l\u00e1sa a Tableau-ba<\/strong><\/p>\n\n<p>A Tableau elind\u00edt\u00e1sa ut\u00e1n a felhaszn\u00e1l\u00f3 l\u00e9trehoz egy \u00faj projektet, amelybe import\u00e1lja a Marketing Miner Excel-kimenetet. Onnan a felhaszn\u00e1l\u00f3 azt\u00e1n a Tableau seg\u00edts\u00e9g\u00e9vel h\u00fazza be az Excel list\u00e1t, amelyet a Tableau seg\u00edts\u00e9g\u00e9vel feldolgozni szeretne.:<\/p>\n\n<iframe loading=\"lazy\" width=\"718\" height=\"429\" src=\"https:\/\/www.youtube.com\/embed\/oLAh9RWwfmQ\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n<p><strong>Adatvizualiz\u00e1ci\u00f3<\/strong><\/p>\n\n<p>Miut\u00e1n eljutott a munkalapra, egyszer\u0171en, a dimenzi\u00f3k \u00e9s m\u00e9r\u0151sz\u00e1mok \u00e1th\u00faz\u00e1s\u00e1val l\u00e9trehozhatja az adatvizualiz\u00e1ci\u00f3t.:<\/p>\n\n<iframe loading=\"lazy\" width=\"718\" height=\"429\" src=\"https:\/\/www.youtube.com\/embed\/YGhAr4xjtMk\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n<p>Tov\u00e1bbi inform\u00e1ci\u00f3 a Tableau adatmegjelen\u00edt\u00e9si lehet\u0151s\u00e9geir\u0151l a k\u00f6vetkez\u0151 c\u00edmen tal\u00e1lhat\u00f3:<br\/><a href=\"http:\/\/www.tableau.com\/learn\/training\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/www.tableau.com\/learn\/training<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel Az Excel-t&aacute;bl&aacute;zat a Marketing Miner alapvet&#337; kimenete, amely a felhaszn&aacute;l&oacute; sz&aacute;m&aacute;ra a report elk&eacute;sz&uuml;lte ut&aacute;n el&eacute;rhet&#337;. Mindig tartalmaz egy kezdeti list&aacute;t (Report), amely &ouml;sszefoglalja az &ouml;sszegy&#369;jt&ouml;tt adatokra vonatkoz&oacute; inform&aacute;ci&oacute;kat, majd egy &aacute;ltal&aacute;nos list&aacute;t Data, amely az egyes sorok kimenet&eacute;n&eacute;l el&eacute;rhet&#337; adatokat tartalmazza, majd m&aacute;s list&aacute;kat a b&aacute;ny&aacute;szok szerint, amelyek nem p&aacute;ros&iacute;that&oacute;k egyenesen egy sorba. &#8230; <a title=\"Az export\u00e1lt adatok adatelemz\u00e9se\" class=\"read-more\" href=\"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/\" aria-label=\"Tov\u00e1bbiak Az export\u00e1lt adatok adatelemz\u00e9se\">Olvass tov\u00e1bb<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"kbtopic":[179],"kbtag":[166,167,164,163,168],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Az export\u00e1lt adatok adatelemz\u00e9se - Marketing Miner Knowledge Base - HU<\/title>\n<meta name=\"description\" content=\"Excel Az Excel-t\u00e1bl\u00e1zat a Marketing Miner alapvet\u0151 kimenete, amely a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra a report elk\u00e9sz\u00fclte ut\u00e1n el\u00e9rhet\u0151. Mindig tartalmaz egy kezdeti\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Az export\u00e1lt adatok adatelemz\u00e9se - Marketing Miner Knowledge Base - HU\" \/>\n<meta property=\"og:description\" content=\"Excel Az Excel-t\u00e1bl\u00e1zat a Marketing Miner alapvet\u0151 kimenete, amely a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra a report elk\u00e9sz\u00fclte ut\u00e1n el\u00e9rhet\u0151. Mindig tartalmaz egy kezdeti\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/\" \/>\n<meta property=\"og:site_name\" content=\"Marketing Miner Knowledge Base - HU\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/marketingminer\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-17T15:04:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/10\/data-analysis-of-exported-data.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/10\/data-analysis-of-exported-data.png\" \/>\n<meta name=\"twitter:site\" content=\"@marketingminer\" \/>\n<meta name=\"twitter:label1\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/\",\"url\":\"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/\",\"name\":\"Az export\u00e1lt adatok adatelemz\u00e9se - Marketing Miner Knowledge Base - HU\",\"isPartOf\":{\"@id\":\"https:\/\/help.marketingminer.com\/hu\/#website\"},\"datePublished\":\"2020-06-17T13:32:50+00:00\",\"dateModified\":\"2023-03-17T15:04:49+00:00\",\"description\":\"Excel Az Excel-t\u00e1bl\u00e1zat a Marketing Miner alapvet\u0151 kimenete, amely a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra a report elk\u00e9sz\u00fclte ut\u00e1n el\u00e9rhet\u0151. Mindig tartalmaz egy kezdeti\",\"breadcrumb\":{\"@id\":\"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/help.marketingminer.com\/hu\/homepage-hu\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Az export\u00e1lt adatok adatelemz\u00e9se\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/help.marketingminer.com\/hu\/#website\",\"url\":\"https:\/\/help.marketingminer.com\/hu\/\",\"name\":\"Marketing Miner Knowledge Base - HU\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/help.marketingminer.com\/hu\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/help.marketingminer.com\/hu\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/help.marketingminer.com\/hu\/#organization\",\"name\":\"Marketing Miner\",\"url\":\"https:\/\/help.marketingminer.com\/hu\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/help.marketingminer.com\/hu\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/cropped-Logo-01@3x.png\",\"contentUrl\":\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/cropped-Logo-01@3x.png\",\"width\":4098,\"height\":819,\"caption\":\"Marketing Miner\"},\"image\":{\"@id\":\"https:\/\/help.marketingminer.com\/hu\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/marketingminer\/\",\"https:\/\/twitter.com\/marketingminer\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Az export\u00e1lt adatok adatelemz\u00e9se - Marketing Miner Knowledge Base - HU","description":"Excel Az Excel-t\u00e1bl\u00e1zat a Marketing Miner alapvet\u0151 kimenete, amely a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra a report elk\u00e9sz\u00fclte ut\u00e1n el\u00e9rhet\u0151. Mindig tartalmaz egy kezdeti","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:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/","og_locale":"hu_HU","og_type":"article","og_title":"Az export\u00e1lt adatok adatelemz\u00e9se - Marketing Miner Knowledge Base - HU","og_description":"Excel Az Excel-t\u00e1bl\u00e1zat a Marketing Miner alapvet\u0151 kimenete, amely a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra a report elk\u00e9sz\u00fclte ut\u00e1n el\u00e9rhet\u0151. Mindig tartalmaz egy kezdeti","og_url":"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/","og_site_name":"Marketing Miner Knowledge Base - HU","article_publisher":"https:\/\/www.facebook.com\/marketingminer\/","article_modified_time":"2023-03-17T15:04:49+00:00","og_image":[{"url":"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/10\/data-analysis-of-exported-data.png"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/10\/data-analysis-of-exported-data.png","twitter_site":"@marketingminer","twitter_misc":{"Becs\u00fclt olvas\u00e1si id\u0151":"7 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/","url":"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/","name":"Az export\u00e1lt adatok adatelemz\u00e9se - Marketing Miner Knowledge Base - HU","isPartOf":{"@id":"https:\/\/help.marketingminer.com\/hu\/#website"},"datePublished":"2020-06-17T13:32:50+00:00","dateModified":"2023-03-17T15:04:49+00:00","description":"Excel Az Excel-t\u00e1bl\u00e1zat a Marketing Miner alapvet\u0151 kimenete, amely a felhaszn\u00e1l\u00f3 sz\u00e1m\u00e1ra a report elk\u00e9sz\u00fclte ut\u00e1n el\u00e9rhet\u0151. Mindig tartalmaz egy kezdeti","breadcrumb":{"@id":"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/help.marketingminer.com\/hu\/article\/az-exportalt-adatok-adatelemzese\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/help.marketingminer.com\/hu\/homepage-hu\/"},{"@type":"ListItem","position":2,"name":"Az export\u00e1lt adatok adatelemz\u00e9se"}]},{"@type":"WebSite","@id":"https:\/\/help.marketingminer.com\/hu\/#website","url":"https:\/\/help.marketingminer.com\/hu\/","name":"Marketing Miner Knowledge Base - HU","description":"","publisher":{"@id":"https:\/\/help.marketingminer.com\/hu\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/help.marketingminer.com\/hu\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/help.marketingminer.com\/hu\/#organization","name":"Marketing Miner","url":"https:\/\/help.marketingminer.com\/hu\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/help.marketingminer.com\/hu\/#\/schema\/logo\/image\/","url":"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/cropped-Logo-01@3x.png","contentUrl":"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/cropped-Logo-01@3x.png","width":4098,"height":819,"caption":"Marketing Miner"},"image":{"@id":"https:\/\/help.marketingminer.com\/hu\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/marketingminer\/","https:\/\/twitter.com\/marketingminer"]}]}},"_links":{"self":[{"href":"https:\/\/help.marketingminer.com\/hu\/wp-json\/wp\/v2\/kb\/11146"}],"collection":[{"href":"https:\/\/help.marketingminer.com\/hu\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/help.marketingminer.com\/hu\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.marketingminer.com\/hu\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/help.marketingminer.com\/hu\/wp-json\/wp\/v2\/comments?post=11146"}],"version-history":[{"count":1,"href":"https:\/\/help.marketingminer.com\/hu\/wp-json\/wp\/v2\/kb\/11146\/revisions"}],"predecessor-version":[{"id":11147,"href":"https:\/\/help.marketingminer.com\/hu\/wp-json\/wp\/v2\/kb\/11146\/revisions\/11147"}],"wp:attachment":[{"href":"https:\/\/help.marketingminer.com\/hu\/wp-json\/wp\/v2\/media?parent=11146"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/help.marketingminer.com\/hu\/wp-json\/wp\/v2\/kbtopic?post=11146"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/help.marketingminer.com\/hu\/wp-json\/wp\/v2\/kbtag?post=11146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}