Sunil Ray — November 6, 2014
Business Intelligence Data Exploration Intermediate Libraries Programming Qlikview Structured Data

Sachin has inspired an entire generation of cricketers in India and abroad. He is one of the few “Universal God” in India, i.e. people follow him irrespective of their age, gender, caste or profession. He can bring the entire nation to a stop while he is in his “zone”. (For non-cricket followers, Cricket is more than a religion in India and Sachin has been probably the most popular cricketer in India’s history).

Today was the launch of his autobiography – Playing it my way. While I plan to grab a copy and read shortly, I thought of paying my tribute to my inspiration “Sachin Ramesh Tendulkar”. So, I have created a dashboard in Qlikview to summarize Sachin’s test career and his achievements.

 

Before we start – a glimpse of Sachin-mania

Sachin has been the most complete batsman in the world cricket. Tendulkar holds about every batting record of the game – be it most runs or hundreds in Tests and ODIs. His stance and stroke making depicts the perfect balance, precision in movement and a wow factor for thousands of fans in anticipation. I can not forget his classical straight drive, back-foot punch and dancing down the track to hit sixes. He held an entire army of strokes in his kitty and would unleash them at the right moment, in the right form. He currently holds 100 centuries including both formats of the game – Test and ODI.

Tendulkar started his test career in Nov 1989 – when i was 5 years old. I started playing cricket watching Sachin bat (and bowl sometimes too). I have been crazy (like a lot of other fans) to watch him bat all these years. So as a small tribute, I have developed a qlikview dashboard to visualize Sachin’s test performance while discussing different visualization methods of Qlikview.

Let’s look at different tabs of this dashboard and what information is available in them

Sachin_Overview_Qlikview

Above is overview of Sachin’s performance summary over the years and against different teams. Here, we have various information about Sachin’s test career:

  1. On his Test debut, Sachin Tendulkar was the third youngest debutant (16years 205days) in test cricket
  2. He has played 200 test matches, 15,921 test runs and 51 test hundreds. These are highest compared to any other player on the earth.
  3. Sachin was first player to reach 12,000, 13,000, 14000 and 15,000 test runs.
  4. Here, we can easily see that he has scored 1,562 runs in 2010 which is best year of his career and 58 runs in year 1995 (worst year in his career)
  5. He scored (3,630) highest against Australia (the team which dominated the world of cricket for most of this time) and lowest (820) against Bangladesh (due to low number of matches).

 

Now lets move to Batting summary of Sachin’s test career:

12_Sachin_Batting_Qlikview

  1. He made a strong comeback between 2003 and 2004. His batting average increased from a meager 17 to 91.5
  2. He is the fourth highest runs scorer in a single calendar year in Test History. He has scored 1562 runs in 2010 and is behind Mohammad Yousuf (1780 runs in 2006), Viv Richards (1710 runs in 1976) and Graeme Smith (1656 runs in 2008).
  3. He scored highest number of 150+ score in Test Cricket (20)
  4. He has the world record for 8,844 runs in Tests away from home.
  5. When I select Away as selection in the Block chart, I can see that Sachin has scored 29 test hundreds away from home – which is a world record.
  6. He scored 7 centuries in year 2010 alone – more than what a lot of batsman manage to score in their entire career.
  7. In Runs Vs. Country Chart (Block chart), you can see that block size is representing the runs scored against country, where as the color of block represents the average. Sachin has better average against Bangladesh, Zimbabwe and Australia (136, 76.5, 55.5) where as lowest average against Pakistan, South Africa and New Zealand (42.3, 42.5, 46.9). Sachin’s lowest average is better than most of the leading batsman in world – no wonder he was referred to as a run machine.
  8. Sachin played highest number of matches against Australia (39) and England (32).

 

Now let’s look at the Sachin’s dismissals

(I know the ardent fans would be shouting that these stats include a few wrong decisions as well)

Sachin_Dismissal_Qlikview

  1. As Sachin has scored highest score against  Australia, he also got highest dismissals by them
  2. He was an awesome runner within 22 yards and has only been dismissed 9 times as run out
  3. He was dismissed highest number of times by McGrath, Gillespie and Murali (6 times) – Oh! How much I loved these battles
  4. England comes out to be a strong opponent, as Sachin got dismissed second highest number of times (49) by England and he has low average against them. Well done England!

 

Let’s look at the methods we used to visualize this information

  1. Represent images, headings and summary in text boxes
  2. Highlight maximum and minimum value of line chart, Bar chart and pivot tables
  3. Use color of block chart to represent batting average
  4. Sorting in bar chart based on expression
  5. Use of scroll bar in column chart
  6. Various formatting options for different objects like list box, column, Pie and block chart.

 

End Note:-

In this article, we looked at  various visualization methods to represent information in Qlikview dashboard while discussing about test match performance of the legend Sachin Ramesh Tendulkar. In next article, we will discuss details about these methods, specifically:

  • How to highlight maximum and minimum values of column and line charts?
  • How to show another expression by color of the section of block?
  • Sorting of dimension based on expression
  • How to use scroll bar in column chart and many other layout or visualization options.

Have you found this article interesting or you have better visualization methods to represent similar information. If so, I’d love to hear your thoughts through comments below as it also benefit someone while designing dashboard.

If you like what you just read & want to continue your analytics learning, subscribe to our emailsfollow us on twitter or like our facebook page.

About the Author

Sunil Ray

I am a Business Analytics and Intelligence professional with deep experience in the Indian Insurance industry. I have worked for various multi-national Insurance companies in last 7 years.

Our Top Authors

Download Analytics Vidhya App for the Latest blog/Article

12 thoughts on "A tribute to Sachin! Qlikview dashboard for his glorious test career"

Venu
Venu says: November 07, 2014 at 1:22 am
Irrelevant post on this blog... Reply
Naveen
Naveen says: November 07, 2014 at 7:31 am
Please share the data source. I would like to try this in Qlikview. Reply
Sunny
Sunny says: November 07, 2014 at 10:36 am
I cannot find the link to the dashboard.. Looks Interesting. Reply
anil
anil says: November 08, 2014 at 10:50 am
nice post the design part Reply
Kunal Jain
Kunal Jain says: November 10, 2014 at 9:34 pm
Venu, Sorry to disappoint you on this post. I personally think that the topic was interesting and would have presented a nice way to get people excited on building some dashboard on a subject they love - which it did to some extent. Thanks for your feedback - highly appreciated. Regards, Kunal Reply
Manish
Manish says: November 11, 2014 at 7:55 am
Hi Kunal, Nice try... I have made something similar.... Can you share data source? Reply
Vijay
Vijay says: November 12, 2014 at 9:59 am
Hi Kunal, Excellent tribute to the Master and yes the way you have depicted in charts is impressive. Thanks Vijay Reply
shankar
shankar says: November 16, 2014 at 2:45 pm
Sir, Please share data source , want to develop same Reply
Sudheer
Sudheer says: November 30, 2014 at 8:18 am
for whose who have been requesting for data, here you go : https://s3-ap-southeast-1.amazonaws.com/sudheerrao07/sachin-test.xls Reply
Venkat
Venkat says: December 13, 2014 at 2:03 am
Thank you Sudheer Ji.. Reply
sumit jadhav
sumit jadhav says: October 07, 2015 at 6:33 am
pls send the data ,i want to develop a dashboard on the same Reply
Devaraj
Devaraj says: December 21, 2015 at 8:45 pm
HI Kunal , I am a avid follower of Your Blogs. I must say it helped me a lot . I am currently Learning qlikview and tried to replicate the dashboard. I have few Challenges : 1) In overview Tab ,Runs scored vs Country ,its not coming exactly same as your screen shot. I went on and checked that i did not linked the Metrics table (Sachin Details) and Dimension table (Stadium info) is not linked . Could you please help . Either i would like to see the datamodel or how did you overcome it or qvw file. Thank you for your Awesome posts!! Reply

Leave a Reply Your email address will not be published. Required fields are marked *