Data Visualization | Tableau

Route Map using Tableau (Hub & Spoke Model)

I had an Tableau session last week and I came across possibility of creating hub and spoke in Tableau. I am aware of its been discussed earlier as well in multiple blogs and Tableau public but here I am sharing my experience with Hub and Spoke.

For the matter of this visualization, I extracted all the arrival data to Mumbai airport for 19th Feb from Mumbai Airport arrival website and created excel file in below format:

Each origin and destination had to duplicated into multiple records. For Example:

Flight|Origin|PathID|ArrivalTime|…

6E 189|Delhi  |Delhi – Mumbai|00:40|…

6E 189|Mumbai |Delhi – Mumbai|00:40|…

Next step was to import the data into Tableau and do the necessary data manipulation for cleaner data.

  1. Add origin to detail tab under marks section, this will enable latitude and longitude in the sheet
  2. Drag path id column into color pallette.
  3. select the number of records and put into size tab

This will create following route map (hub & Spoke model) as per below image:

Then I created couple of other sheets on the basis of on-time performance and delay types for different airlines flight arriving at Mumbai Airport and created the final dashboard showing all the details.


Let me know your feedback on the dashboard

Data Visualization | Tableau

My Resume on Tableau

After creating several dashboard and data visualization for clients, I thought let me try to create tableau dashboard to represent my professional experience with skills.

Here I imported Excel file containing my education, work experience and skills into Tableau. As an interviewer, I generally ask people to share one page resume and Tableau gives that flexibility of creating an interactive resume which can be attractive and also speaks about the experience a person has.

Please let me know your feedback on my resume:

Data Visualization | Stats | Tableau

From here I Start: Stats about Virat Kohli on Tableau

I have been thinking about starting a blog from long time however I didn’t get time to start one. Here I am now starting one. Today we are going to see the data visualization on Tableau with Statistics of Virat Kohli. Cricket has been one sport that I have been following since early childhood. So I thought why not pick cricket as topic for my first blog.

Here is the steps I took to download:

1 – Download the data from espncricinfo.com and pasted data into excel spreadsheet

2 – Import the excel into Tableau

3 – Visualize the data into Tableau

4 – Publish the data into Tableau Public and below is the output produced: