A tribute to Sachin! Qlikview dashboard for his glorious test career

Sunil Ray 28 May, 2017 • 4 min read

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.

Sunil Ray 28 May 2017

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.

Frequently Asked Questions

Lorem ipsum dolor sit amet, consectetur adipiscing elit,

Responses From Readers

Clear

Venu
Venu 07 Nov, 2014

Irrelevant post on this blog...

Naveen
Naveen 07 Nov, 2014

Please share the data source. I would like to try this in Qlikview.

Sunny
Sunny 07 Nov, 2014

I cannot find the link to the dashboard.. Looks Interesting.

anil
anil 08 Nov, 2014

nice post the design part

Manish
Manish 11 Nov, 2014

Hi Kunal, Nice try... I have made something similar.... Can you share data source?

Vijay
Vijay 12 Nov, 2014

Hi Kunal, Excellent tribute to the Master and yes the way you have depicted in charts is impressive. Thanks Vijay

shankar
shankar 16 Nov, 2014

Sir, Please share data source , want to develop same

Sudheer
Sudheer 30 Nov, 2014

for whose who have been requesting for data, here you go : https://s3-ap-southeast-1.amazonaws.com/sudheerrao07/sachin-test.xls

Venkat
Venkat 13 Dec, 2014

Thank you Sudheer Ji..

sumit jadhav
sumit jadhav 07 Oct, 2015

pls send the data ,i want to develop a dashboard on the same

Devaraj
Devaraj 21 Dec, 2015

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!!

Apps
Apps 17 Dec, 2017

Looks really interesting.. Please share link to the dashboard

Roshan
Roshan 08 Mar, 2018

Interesting one. Could you please share the source data?