Showing a Correlation Over Time - Animated Scatterplot in Tableau
A free video tutorial from R-Tutorials Training
Data Science Education
4.4 instructor rating • 24 courses • 223,421 students
Learn more from the full courseThe Tableau 2018 Comprehensive Guide
Get a comprehensive skillset in Tableau and succeed in business intelligence, data visualization and in your career!
10:38:12 of on-demand video • Updated February 2019
- choose the best visualization type
- be familiar with the Tableau interface and Tableau terminology
- choose a suitable Tableau product
- writing custom codes for best results
- be a Tableau mentor for team colleagues
- perform hands on tasks in Tableau
- create custom visualizations
English [Auto] In this tutorial I'm going to show you how to build this animated scatterplot the visualization shows life expectancy against fertility rate for all the countries in the world that use a 50 years timeframe with five steps. So it begins at nineteen sixty and ends at 2010. The data is available on the World Bank dot o r g Web site so everybody can access it and downloaded the raw data is not appropriate for processing and. So a restructured and cleaned it in Excel if you want to learn more about how this procedure is done. Then I recommend to check out the later section of this course which is about preparing your data for tableau. For now you can just download the clean CCV file and work along. Up is connected to the data source. We can see that he tests them mentions such as country names regions and years and two measures fertility rate and life expectancy. If we open the worksheet and place the two measures on the shelves we get to scatterplot. Let's break it down by countries. As you can see we also get 15 now values which we can filter out. The database includes all countries of the world. But for some of them there is no data available. Hence the now values. We can also add region to the kallah shelf. The plot looks better now but there is still not enough detail since the blue aggregates values of 50 years. This is the perfect opportunity to include the animation in the visualization. You might have already wondered what the pages shelf is good for. Well it lets you break a few into a series of pages. It works like those good old flipbook animations. The field you put on the page or shelf will break down the visualization by its values. So if we put year on it then we get a series of plots by the years of 1960 1965 1970 and so on until 2010. This allows us to compare the data in different portions of time. You can flip the pages one by one manually by using these buttons all you can let the blog go through them automatically by pushing this button. The flipping goes onwards and there was as well. No this is very cool but we can make it even better by displaying the history of the marks. Check in the show history box and opened the dropdown next to it. Let's show the history for all marks and let's also show the trails. It means that as the market moves it lets a trail behind so the user can see the route off the mark. At last we can format the trails so they appear less vibrant than the actual marks. This makes the visualization less messy. All right so now we are finished. We can go through the animation with these three buttons. You can set the speed of flipping pages. I think this visualisation looks really amazing. You can even use a region as Filcher so only those marks are visible which you are interested in. And this makes comparing marks a piece of cake. If you want to get a similar view but without using the pages shelf there is a method for that as well. Let's open a new worksheet and create the same scatterplot this time before we add year. We can change the mark to line as we put years on the path shelf. The visualisation turns into a spaghetti looking structured plot. The lines are representing the changes of mocs over the years to enhance the visual appeal. We can reduce transparency add some markers and also reduce the width of the lines. Basically this gives us the very same plot but it summarizes all steps of changes in one visualization. All right guys I hope you found this tutorial interesting. I definitely like creating plots like these too. If there are some questions remaining unanswered feel free to share them in the Q&A section.