{"id":513501,"date":"2022-08-26T14:54:00","date_gmt":"2022-08-26T12:54:00","guid":{"rendered":"https:\/\/www.devoteam.com\/expert-view\/alteryx-exploratory-data-analysis-eda\/"},"modified":"2022-08-26T14:54:00","modified_gmt":"2022-08-26T12:54:00","slug":"alteryx-exploratory-data-analysis-eda","status":"publish","type":"expert-view","link":"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/","title":{"rendered":"Alteryx exploratory data analysis &#8211; EDA"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/dk.devoteam.com\/wp-content\/uploads\/sites\/22\/2022\/11\/1661434657-jb-pptx.jpg\" alt=\"\" class=\"wp-image-18383\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You just got access to your dataset and you are ready to start spraying out cool analytics. Especially if you have a good idea about how your data is looking, it is tempting to skip exploring the data before diving head first into it.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Alteryx is full of tools that make an EDA(Exploratory Data Analysis) too easy to skip. By just spending 5 minutes looking into your data you might find errors or relations in your dataset that you would otherwise have missed. This is meant as a basic guide to a quick and general EDA and hopefully helps you avoid getting lost.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/dk.devoteam.com\/wp-content\/uploads\/sites\/22\/2022\/11\/1661436075-weekend-lost.gif\" alt=\"\" class=\"wp-image-18377\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>An EDA will help you:&nbsp;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Find missing data, wrong data types and data sizes<\/li>\n\n\n\n<li>Find outliers that might or might not be explainable&nbsp;<\/li>\n\n\n\n<li>Find new relations between parameters&nbsp;<\/li>\n\n\n\n<li>Find general trends in the data<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Keep it simple &#8211; use the result window&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The&nbsp;<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/results-window\" target=\"_blank\" rel=\"noreferrer noopener\"><u>result window<\/u><\/a>&nbsp;is always in your view and is a great way to quickly check your data. In the results window, the data quality bar can be viewed above each column. Colours indicate what percentage of the column contains OK values(green), empty values(Grey), Null values(yellow), and not OK values(red). The specific meaning of each colour can be seen&nbsp;<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/results-window\" target=\"_blank\" rel=\"noreferrer noopener\"><u>here<\/u><\/a>. The&nbsp;<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/data-cleansing-tool\" target=\"_blank\" rel=\"noreferrer noopener\"><u>Data Cleansing<\/u><\/a>&nbsp;tool is great at cleaning your data. Insert this tool to remove leading or trailing white spaces, remove null rows and columns, and for other quick cleaning methods.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Clicking the \u2018Metadata\u2019 button in the result window will show you the datatype, size, source, and description of each column. A too small column size or wrong datatype will mess with your analysis sooner or later; make it a habit to check this as the first thing. To quickly change these values use the&nbsp;<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/select-tool\"><u>Select tool<\/u><\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/dk.devoteam.com\/wp-content\/uploads\/sites\/22\/2022\/11\/1661436153-cleaning-gif.gif\" alt=\"\" class=\"wp-image-18380\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Browse Tool &#8211; Data Profile&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Probably the most used tool in Alteryx for a reason. Apart from looking at the actual data points themselves, the browse tool is great at giving an overview of your data. In the&nbsp;<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/browse-tool\"><u>Browse tool<\/u><\/a>&nbsp;configuration window, a profile of the data is available. The data quality bar is also available here together with the distribution of values in each column. By clicking on the name of a column in the configuration window, a more detailed profile of the specific column will appear.&nbsp; Depending on the datatype different statistical values such as mean, standard deviation, max, min, average, shortest value, longest value, ect will be displayed. Here it is easy to check whether the min, max and other values make sense and to further investigate if they don\u2019t. The view will also give you a histogram of your data. Maybe you can find a nice bell curve somewhere in your data. For a fancy histogram, a violin plot can be generated using the \u2018<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/violin-plot-tool\"><u>Violin Plot<\/u><\/a>\u2019 tool.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/dk.devoteam.com\/wp-content\/uploads\/sites\/22\/2022\/10\/1661436179-histogram-gif.gif\" alt=\"\" class=\"wp-image-17639\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Other tools in the Data Investigation category that will help you gain similar insight are&nbsp;<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/basic-data-profile-tool\"><u>Basic Data Profiling<\/u><\/a>,&nbsp;<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/field-summary-tool\"><u>Field Summary<\/u><\/a>, and&nbsp;<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/frequency-table-tool\"><u>Frequency Table<\/u><\/a>.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Look at the numbers<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.datocms-assets.com\/42808\/1661436200-math-numbers.gif\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Looking at insight for individual columns is important, however, seeing how different columns relate to each other can be just as insightful. With the&nbsp;<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/association-analysis-tool\"><u>Association Analysis<\/u><\/a>&nbsp;tool, a correlation matrix can easily be generated for numerical columns. Here a correlation coefficient close to 1 indicates a high positive correlation, 0 indicates no correlation and a correlation coefficient close to -1 indicates a high negative correlation. If you are using your data for data modelling you might have to remove columns that are correlated to improve the model and reduce the overall complexity. To figure out how to reduce the dimensionality of your data multiple methods can be used, some of them can be found&nbsp;<a href=\"https:\/\/en.wikipedia.org\/wiki\/Dimensionality_reduction\"><u>here<\/u><\/a>.<br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.datocms-assets.com\/42808\/1661436276-scatter-gif.gif\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For correlated columns, the&nbsp;<a href=\"https:\/\/help.alteryx.com\/20221\/designer\/scatterplot-tool\"><u>Scatter Plot<\/u><\/a>&nbsp;tool can be used to gain a quick visual insight into how the values are correlated and general trends in the data. You might find that parameters that you thought would be linearly correlated are actually exponentially correlated. In the scatter plot it is possible to visually detect outliers. Many definitions of&nbsp;<a href=\"https:\/\/en.wikipedia.org\/wiki\/Outlier#Definitions_and_detection\"><u>outliers<\/u><\/a>&nbsp;exist, with one of them being a point that is more than 3 standard deviations away from the mean. The standard deviation and mean for a column can be found with the browse tool. Whether data points should be removed depends on the specific case, however, it should always be justified in the analysis.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.datocms-assets.com\/42808\/1661436276-scatter-gif.gif\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">By just spending five minutes adding a few tools to your workflow you will easily be able to find insights that you might otherwise have missed and avoid frustration further into your analysis. The methods discussed are all a part of a simple EDA, with more advanced EDA methods existing. However, for most cases the tools discussed should be more than enough to clean your data and find new insights, enabling you to make an efficient and thorough analysis.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br>When you run into problems make sure to visit the&nbsp;<a href=\"https:\/\/community.alteryx.com\/\"><u>Alteryx Community<\/u><\/a>&nbsp;where it is almost certain that someone else has had the same problem as you. If you have any questions or comments please reach out to me.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You just got access to your dataset and you are ready to start spraying out cool analytics. Especially if you have a good idea about how your data is looking, it is tempting to skip exploring the data before diving head first into it.&nbsp; Alteryx is full of tools that make an EDA(Exploratory Data Analysis) [&hellip;]<\/p>\n","protected":false},"featured_media":0,"template":"","categories":[],"tags":[],"industry":[],"class_list":["post-513501","expert-view","type-expert-view","status-publish","hentry"],"acf":[],"cards":"\n\t<div class=\"single-post-card\">\n\n\t\t\n\n\t\t\n\t\t<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-43282307 wp-block-group-is-layout-flex\">\n\t<p style=\"font-style:normal;font-weight:700\" class=\"has-link-color wp-elements-1 wp-block-lp-post-type has-text-color has-primary-color has-small-font-size\">Expert View<\/p>\n\n\t\t\n\t\t<h3 style=\"font-style:normal;font-weight:400\" class=\"wp-block-post-title has-base-font-size\"><a href=\"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/\" target=\"_self\" >Alteryx exploratory data analysis &#8211; EDA<\/a><\/h3><\/div>\n\t\t\n\t<\/div>\n\n","yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Alteryx exploratory data analysis - EDA | Devoteam<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Alteryx exploratory data analysis - EDA\" \/>\n<meta property=\"og:description\" content=\"You just got access to your dataset and you are ready to start spraying out cool analytics. Especially if you have a good idea about how your data is looking, it is tempting to skip exploring the data before diving head first into it.&nbsp; Alteryx is full of tools that make an EDA(Exploratory Data Analysis) [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/\" \/>\n<meta property=\"og:site_name\" content=\"Devoteam\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/09\/MAHA-GOUIAA.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"668\" \/>\n\t<meta property=\"og:image:height\" content=\"684\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/expert-view\\\/alteryx-exploratory-data-analysis-eda\\\/\",\"url\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/expert-view\\\/alteryx-exploratory-data-analysis-eda\\\/\",\"name\":\"Alteryx exploratory data analysis - EDA | Devoteam\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/expert-view\\\/alteryx-exploratory-data-analysis-eda\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/expert-view\\\/alteryx-exploratory-data-analysis-eda\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dk.devoteam.com\\\/wp-content\\\/uploads\\\/sites\\\/22\\\/2022\\\/11\\\/1661434657-jb-pptx.jpg\",\"datePublished\":\"2022-08-26T12:54:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/expert-view\\\/alteryx-exploratory-data-analysis-eda\\\/#breadcrumb\"},\"inLanguage\":\"en-SE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/devoteam.info\\\/en-se\\\/expert-view\\\/alteryx-exploratory-data-analysis-eda\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-SE\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/expert-view\\\/alteryx-exploratory-data-analysis-eda\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dk.devoteam.com\\\/wp-content\\\/uploads\\\/sites\\\/22\\\/2022\\\/11\\\/1661434657-jb-pptx.jpg\",\"contentUrl\":\"https:\\\/\\\/dk.devoteam.com\\\/wp-content\\\/uploads\\\/sites\\\/22\\\/2022\\\/11\\\/1661434657-jb-pptx.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/expert-view\\\/alteryx-exploratory-data-analysis-eda\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expert View\",\"item\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/expert-view\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Alteryx exploratory data analysis &#8211; EDA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/#website\",\"url\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/\",\"name\":\"Devoteam\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/devoteam.info\\\/en-se\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-SE\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Alteryx exploratory data analysis - EDA | Devoteam","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:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/","og_locale":"en_US","og_type":"article","og_title":"Alteryx exploratory data analysis - EDA","og_description":"You just got access to your dataset and you are ready to start spraying out cool analytics. Especially if you have a good idea about how your data is looking, it is tempting to skip exploring the data before diving head first into it.&nbsp; Alteryx is full of tools that make an EDA(Exploratory Data Analysis) [&hellip;]","og_url":"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/","og_site_name":"Devoteam","og_image":[{"width":668,"height":684,"url":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/09\/MAHA-GOUIAA.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/","url":"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/","name":"Alteryx exploratory data analysis - EDA | Devoteam","isPartOf":{"@id":"https:\/\/devoteam.info\/en-se\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/#primaryimage"},"image":{"@id":"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/#primaryimage"},"thumbnailUrl":"https:\/\/dk.devoteam.com\/wp-content\/uploads\/sites\/22\/2022\/11\/1661434657-jb-pptx.jpg","datePublished":"2022-08-26T12:54:00+00:00","breadcrumb":{"@id":"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/#breadcrumb"},"inLanguage":"en-SE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/"]}]},{"@type":"ImageObject","inLanguage":"en-SE","@id":"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/#primaryimage","url":"https:\/\/dk.devoteam.com\/wp-content\/uploads\/sites\/22\/2022\/11\/1661434657-jb-pptx.jpg","contentUrl":"https:\/\/dk.devoteam.com\/wp-content\/uploads\/sites\/22\/2022\/11\/1661434657-jb-pptx.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/devoteam.info\/en-se\/expert-view\/alteryx-exploratory-data-analysis-eda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devoteam.info\/en-se\/"},{"@type":"ListItem","position":2,"name":"Expert View","item":"https:\/\/devoteam.info\/en-se\/expert-view\/"},{"@type":"ListItem","position":3,"name":"Alteryx exploratory data analysis &#8211; EDA"}]},{"@type":"WebSite","@id":"https:\/\/devoteam.info\/en-se\/#website","url":"https:\/\/devoteam.info\/en-se\/","name":"Devoteam","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devoteam.info\/en-se\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-SE"}]}},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Julien Pawlowski","author_link":"https:\/\/devoteam.info\/en-se\/author\/"},"uagb_comment_info":0,"uagb_excerpt":"You just got access to your dataset and you are ready to start spraying out cool analytics. Especially if you have a good idea about how your data is looking, it is tempting to skip exploring the data before diving head first into it.&nbsp; Alteryx is full of tools that make an EDA(Exploratory Data Analysis)&hellip;","_links":{"self":[{"href":"https:\/\/devoteam.info\/en-se\/wp-json\/wp\/v2\/expert-view\/513501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devoteam.info\/en-se\/wp-json\/wp\/v2\/expert-view"}],"about":[{"href":"https:\/\/devoteam.info\/en-se\/wp-json\/wp\/v2\/types\/expert-view"}],"version-history":[{"count":0,"href":"https:\/\/devoteam.info\/en-se\/wp-json\/wp\/v2\/expert-view\/513501\/revisions"}],"wp:attachment":[{"href":"https:\/\/devoteam.info\/en-se\/wp-json\/wp\/v2\/media?parent=513501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devoteam.info\/en-se\/wp-json\/wp\/v2\/categories?post=513501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devoteam.info\/en-se\/wp-json\/wp\/v2\/tags?post=513501"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/devoteam.info\/en-se\/wp-json\/wp\/v2\/industry?post=513501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}