Select the column we want to filter data based on (SL.No. Click on add and a new pop up will appear listing all the columns in the dataset. Click on the add button and a pop-up window will appear. On the top right corner of the Data Source page, you will see a Filters section and an Add button. How do we remove those rows temporarily? We can filter them out using the Tableau’s filters. We don’t need these rows for now so we will remove them from the data temporarily. For example, when Tableau aggregates the sum of a specific crime for the entire country, it will sum up all the rows including the ones shown above. If we ignore these rows, it will mess up the numbers that we are going to visualise. If you observe closely, in the SL.No column we will find invalid values such as Total (States), Total (UT) and Total(All India). On the Data Source page, we will be able to see the active connections and the data which we imported.īefore we proceed to visualisation, we need to solve a small discrepancy in the data. Once you click open, the data will be imported into the Tableau worksheet. Select the downloaded file and click open. So we will click on the ‘Text file’ option. The panel will have a hand full of options to connect to a variety of data sources such as excel, text, pdf and also live database servers. Let’s fire it up and do some visualisations! Connecting To The datasetĪfter you fire up the Tableau Public application, you will be greeted with a homepage that has a Connect panel on its left side. Install the application in your system with the downloaded installer. In this tutorial, we will stick to the free version of Tableau available called Tableau Public. To begin with Tableau, you must install the Tableau Desktop application in your local machine. In the example that follows, I have renamed the dataset as crimes_india.csv Install Tableau Public We will be using the state-wise crime in India Dataset. In this tutorial, we will use the free version of Tableau to visualise data with an example. As a platform that allows Data Analysts and Data Scientists to portray data effortlessly, Tableau saves a lot of time by not having to code for every pixel of the information displayed. Tableau is one of the most popular tools for data visualization.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |