We all know the data is important. Today millions of data are created every second and if we can analyze it, use it for a good cause, there is nothing can stop us. The only problem is we are humans. Unlike, computers, we can’t analyze it only by seeing it. We need a visualization platform for this. And I believe Tableau is here to help you.
Recently, Salesforce bought Tableau for $15.3 bn, one of the biggest acquisitions has ever made. This is a sign of how the world is moving towards data-driven decision making and If you want to be a part of it, this article would definitely help you out to get started.
Here we will try to visualize the data of India Election results for Parliament from the beginning, 1951. I got the data from a simple google search. You can search it or download it from here:http://mospi.nic.in/sites/default/files/statistical_year_book_india_2015/Table%2043.1_5.xls
There are three types of Tableau products are available for data visualization: 1. Tableau Server, 2. Tableau Desktop and 3. Tableau Public. Among them, server and desktop are the paid ones but you can use the tableau public for free. The only thing is that all the visualization you created using the public will have to be published in the Tableau public dashboard. You can’t keep them private for your internal use only. I will suggest you start with the Tableau public and when you are confident, you can use the paid ones for your commercial or personal use. You can download it from here: https://public.tableau.com/en-us/s/ (give your email > create a public profile > download the software)
Now you have downloaded it, let’s start working on it. When you first open the software you will see the below screen.
On the left-hand side all the data connectors excel, pdf, google sheet etc. are available, on the right-hand side useful resources for you to explore and in the middle the recent projects you are working on. To connect with a data source just click on the file type you want to connect. For this demonstration, we are going to use the excel file I have shared earlier with you. Just open the file using Tableau and you will see this below screen.
On the left-hand side, you will see sheets are available. Just drag the sheet you want to visualize in the upper-middle position and you will see the above screen. Just see on the screen that there are a lot of null values are available which you can minimize manually but it would take a lot of time. There is a really beautiful option is available for you to try it out which is Data Interpreter in the upper left-hand side just under the Sheets menu. Whenever you click on this option, you will see a dramatical change in your data set.
See the change Tableau is done for you. It removes all the null values and gives the data-set a beautiful shape to play around with. Now you have uploaded the data, let’s work on it. To do that click on sheet 1 as shown in the above figure.
This is the sheet dashboard. On the left-hand side, there are dimensions and Measures and middle is the working area. Select any Dimension or Measure and right click on it for more options you can play around with. Suppose in the above figure, I have selected the measure and I am changing the name as per your convenience. Now I have changed the dimension and measure names, it looks like this.
After changing the names, let’s create a visualization from this data.
Just see the beautiful visualization I have created within a minute. Using the control key, I have selected the election year in Dimension and the parties in Measures. Then I clicked on the Horizontal bars visualization and Voilla. This beautiful visualization has been created for me. Then I have added a filter year wise by just drag the election year in dimension and drop it in the filter area. clicked on the drop down and select show Filter. From the right-hand top, you can select the specific year and the Tableau will show you the result as per your needs. Isn’t it great!
This is how easily you can create data visualizations using Tableau. If you are more interested in in-depth learning, I will highly recommend checking out this tutorial series from Edureka! YouTube Channel (https://www.youtube.com/watch?v=jj6-0cvcNEA&list=PL9ooVrP1hQOH7ni13w776zP_X9ny3Eksv). Those are just awesome. and if you want to download the above visualization, you can get it from here: https://public.tableau.com/profile/soumyabrata.roy#!/vizhome/IndiaLokshavaElectionResult/ElectionResultbyYear?publish=yes
Hope you have liked it, let me know your thoughts down in the comment below. See you later.
Originally published at https://www.linkedin.com on June 16, 2019.