{"id":3034,"date":"2024-02-09T14:36:54","date_gmt":"2024-02-09T13:36:54","guid":{"rendered":"https:\/\/newdatalabs.com\/en\/?p=3034"},"modified":"2024-01-28T14:44:46","modified_gmt":"2024-01-28T13:44:46","slug":"charts-in-tableau-part-4-relationships-scatterplot","status":"publish","type":"post","link":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/","title":{"rendered":"Charts in Tableau Part 4: Relationships- Scatterplot"},"content":{"rendered":"\n

In the previous posts of the \u201c60 charts in Tableau<\/a>\u201d series, I described the techniques for visualizing the category and time data as well as the elements of the whole. Let\u2019s recall \u2013 bar charts were recommended for the category data, and line charts for the time data. There were more options available for the elements of the whole, depending on the type of data. In terms of relationships, we are going to discuss one preferred option \u2013 a scatterplot.<\/p>\n\n\n\n

Visualizing deficiencies between variables with a Scatterplot<\/h2>\n\n\n\n

Scatterplot \u2013 a point chart \u2013 is a perfect way to show the deficiencies between two variables according to the level of detail chosen. This chart presents selected variables on two axes and the data point represents the level of detail. For example, the below chart shows the dependencies between Sales and Profit values. Data points represent product categories: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

The above chart clearly shows the dependence \u2013 the higher the sales, the higher the profit. Scatterplot is intended for this purpose \u2013 it allows you to quickly evaluate visually if the correlation exists or not. Another advantage is the possibility to identify the outliers. In this case, it is the Tables category, which is the only one with a negative profit. It is the extreme outlier; in addition, there are also positive and negative outliers. To better visualize this, we can add a trend line to our chart: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

The trend line confirms our observation about the linear dependence of the sales and profit. In addition to the clearly outstanding Tables value, we also have such categories as Chairs, Storage and Phones, which are below the trend line, meaning they are less profitable. On the other side, we have such categories like Art, Accessories and Appliances, which are more profitable than shown by the trend line.<\/p>\n\n\n\n

Adding further analysis dimensions to a Scatterplot<\/h2>\n\n\n\n

A Scatterplot can be extended by additional data dimensions to increase the amount of information provided by the chart. Let\u2019s start with color \u2013 we will add color to the aggregate product category in accordance with the legend: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

This helps to identify where the subcategories of a given category are on the chart: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

The last element that can be used to show another dimension of data is the size of data points. We will add the quantity field which shows the category size: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

That\u2019s not all when it comes to the analytical capacity of the scatterplot. By using reference lines, you can also add to the chart the lines that show the average values of the sales and profit: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

What possibilities does it give us? We have been able to divide the datapoints (categories in our case) into four areas. This way we can easily identify strong categories and the categories to be improved: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

More categories and variables<\/h2>\n\n\n\n

A scatterplot shows continuous variables on its axes; whereas you can use the datapoints to demonstrate the dependencies between category variables. As a result, your effect will be similar to a highlight table or heat map, but you will have an additional dimension \u2013 the size. Such a visualization is called a correlation matrix: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Looking at the above chart, it is easy to identify the main markets (France, Germany, UK) and categories (Phones, Copiers and Bookcases). The color in this case shows the profit, which helps to highlight the unprofitable dependencies between the market and category. For example, Holland or Sween have most of their categories unprofitable. This way you can identify the areas for optimization. A correlation matrix is less functional compared to the scatterplot \u2013 you can visualize two continuous dimensions (size and color), instead of four dimensions in the scatterplot (X-axis, Y-axis, size and color); however, you get a second category dimension, which also has certain advantages.<\/p>\n\n\n\n

Another option is to use parallel coordinates, which is a chart that shows the changes in the continuous variables for various dimensions. This chart is helpful when you want to present the dependencies of more than two variables the same way as on the scatterplot. The only limit is the common axis, which means that the dimensions should have a similar order of magnitude. Otherwise, the chart will become illegible. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

What other options are available?<\/h2>\n\n\n\n

There is a range of other visualization options, however, none of them are as easy to present the information as a scatterplot. For example, a radar chart consists of one continuous variable and several categories: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

A chord diagram is another example \u2013 it shows interactions between the categories: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

These charts are not easy to prepare and understand, and as such, they are not widely used. Another aspect are the organizational charts that show the hierarchy within the organization. Similar to them are network diagrams. Dendrograms (charts showing decision trees or hierarchies) are currently becoming increasingly popular. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Relationships = a Scatterplot<\/h2>\n\n\n\n

When setting out to visualize relationships between data, it is always good to start with a scatterplot. This chart is easy to prepare, moreover, it\u2019s a very flexible and useful tool. It is also quite easy to understand by end users. The additional features such as adding size, color, trend line and reference lines, make it a very powerful data visualization tool. Only in specific cases (such as visualization of hierarchy), it is recommended to use more advanced solutions to visualize the relationships.<\/p>\n\n\n\n

Mateusz Karmalski, Tableau Author<\/p>\n","protected":false},"excerpt":{"rendered":"

In the previous posts of the \u201c60 charts in Tableau\u201d series, I described the techniques for visualizing the category and time data as well as the elements of the whole. Let\u2019s recall \u2013 bar charts were recommended for the category data, and line charts for the time data. There were more options available for the […]<\/p>\n","protected":false},"author":1,"featured_media":3035,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"content-sidebar","footnotes":""},"categories":[9,5],"tags":[],"class_list":{"0":"post-3034","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-blog","8":"category-tableau","9":"entry"},"yoast_head":"\nCharts in Tableau Part 4: Relationships- Scatterplot - NewDataLabs<\/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:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Charts in Tableau Part 4: Relationships- Scatterplot - NewDataLabs\" \/>\n<meta property=\"og:description\" content=\"In the previous posts of the \u201c60 charts in Tableau\u201d series, I described the techniques for visualizing the category and time data as well as the elements of the whole. Let\u2019s recall \u2013 bar charts were recommended for the category data, and line charts for the time data. There were more options available for the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/\" \/>\n<meta property=\"og:site_name\" content=\"NewDataLabs\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-09T13:36:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/blog_miniatura.png\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"216\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Barbara\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Barbara\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/\"},\"author\":{\"name\":\"Barbara\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/#\\\/schema\\\/person\\\/dfa2df2f2fb6fcecdd8f69f00cffba29\"},\"headline\":\"Charts in Tableau Part 4: Relationships- Scatterplot\",\"datePublished\":\"2024-02-09T13:36:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/\"},\"wordCount\":887,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/blog_miniatura.png\",\"articleSection\":[\"Blog\",\"Tableau\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/\",\"url\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/\",\"name\":\"Charts in Tableau Part 4: Relationships- Scatterplot - NewDataLabs\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/blog_miniatura.png\",\"datePublished\":\"2024-02-09T13:36:54+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/#\\\/schema\\\/person\\\/dfa2df2f2fb6fcecdd8f69f00cffba29\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/#primaryimage\",\"url\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/blog_miniatura.png\",\"contentUrl\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/blog_miniatura.png\",\"width\":360,\"height\":216},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/charts-in-tableau-part-4-relationships-scatterplot\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Charts in Tableau Part 4: Relationships- Scatterplot\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/\",\"name\":\"NewDataLabs\",\"description\":\"Tableau - Business Intelligence Tools\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/#\\\/schema\\\/person\\\/dfa2df2f2fb6fcecdd8f69f00cffba29\",\"name\":\"Barbara\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g\",\"caption\":\"Barbara\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Charts in Tableau Part 4: Relationships- Scatterplot - NewDataLabs","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:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/","og_locale":"en_US","og_type":"article","og_title":"Charts in Tableau Part 4: Relationships- Scatterplot - NewDataLabs","og_description":"In the previous posts of the \u201c60 charts in Tableau\u201d series, I described the techniques for visualizing the category and time data as well as the elements of the whole. Let\u2019s recall \u2013 bar charts were recommended for the category data, and line charts for the time data. There were more options available for the […]","og_url":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/","og_site_name":"NewDataLabs","article_published_time":"2024-02-09T13:36:54+00:00","og_image":[{"width":360,"height":216,"url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/blog_miniatura.png","type":"image\/png"}],"author":"Barbara","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Barbara","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/#article","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/"},"author":{"name":"Barbara","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29"},"headline":"Charts in Tableau Part 4: Relationships- Scatterplot","datePublished":"2024-02-09T13:36:54+00:00","mainEntityOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/"},"wordCount":887,"commentCount":0,"image":{"@id":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/blog_miniatura.png","articleSection":["Blog","Tableau"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/","url":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/","name":"Charts in Tableau Part 4: Relationships- Scatterplot - NewDataLabs","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/#primaryimage"},"image":{"@id":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/blog_miniatura.png","datePublished":"2024-02-09T13:36:54+00:00","author":{"@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29"},"breadcrumb":{"@id":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/#primaryimage","url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/blog_miniatura.png","contentUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/blog_miniatura.png","width":360,"height":216},{"@type":"BreadcrumbList","@id":"https:\/\/newdatalabs.com\/en\/charts-in-tableau-part-4-relationships-scatterplot\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/newdatalabs.com\/en\/"},{"@type":"ListItem","position":2,"name":"Charts in Tableau Part 4: Relationships- Scatterplot"}]},{"@type":"WebSite","@id":"https:\/\/newdatalabs.com\/en\/#website","url":"https:\/\/newdatalabs.com\/en\/","name":"NewDataLabs","description":"Tableau - Business Intelligence Tools","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/newdatalabs.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29","name":"Barbara","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g","caption":"Barbara"}}]}},"_links":{"self":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/comments?post=3034"}],"version-history":[{"count":4,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3034\/revisions"}],"predecessor-version":[{"id":3056,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3034\/revisions\/3056"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media\/3035"}],"wp:attachment":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media?parent=3034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/categories?post=3034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/tags?post=3034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}