Thank you Sachin [a small tribute]

Posted on November 15th, 2013 in Charts and Graphs , Cool Infographics & Data Visualizations - 17 comments

Lets talk about people who inspire us. People who show us that anything is possible. People who prove that commitment, hard work and perseverance are true ingredients of a genius.

I am talking about Sachin Tendulkar. Those of you who never heard his name, he is the most prolific cricketer in the world. He is the leading scorer in both tests (15,921 runs) and one day matches (18,426 runs). Read more about him here.

Tendulkar has been an inspiration for me (and millions of others around the world) since I was a kid. The amount of dedication & excellence he has shown constantly motivates me. It is a pity that the great man is retiring from test cricket. He is playing his last test match (200th, most by any person) as I am writing this.

So as a small tribute, I have decided do something for him. Of course, I have never been a cricketer in my life. Once in college I was reluctantly asked to be a stand-by player in a game with seniors. I did not get a chance to pad up though. That is the closest I have been to a cricketer. So I did what I do best. I made an Excel dashboard celebrating Sachin’s test career.

Thank you Sachin – his test career in a dashboard

Here is a dashboard I made visualizing his test cricket statistics. It is dynamic, fun & awesome (just like Sachin).

(click on the image to enlarge)

Sachin Tendulkar 200 Tests - Visualized in an Excel Dashboard

Download the workbook

Click here to download the file and play with it.

How is this made?

Data:

The data for this dashboard is downloaded from espncricinfo.com and the trivia details are downloaded from in.msn.com

Data from Cricinfo website came in multiple tables. So it took a fair bit of massaging to get everything flow in to dashboard.

Formulas used:

This dashboard uses generous amounts of SUMIFS, COUNTIFS, INDEX, MATCH and VLOOKUP with an occasional LARGE.

For some of the calculations, I have also used Pivot tables.

PS: All the calculations & pivot tables are hidden. Unhide them to go Indian Jones on the dashboard.

Output:

The output dashboard is generated by using various ideas.

  • Thermo-meter chart for % charts in the report
  • Conditional formatting to show run heat map & India vs. Abroad bars.
  • Area charts to show cumulative runs over the years.
  • Form controls to capture user choices.
  • Sortable country list using pre-sorted pivot tables.
  • Picture links to show country flags.
  • Text areas & shapes to make the layout of the dashboard.

I have used similar concepts in earlier dashboards. So I am not explaining everything in detail. Instead, let me point you to few detailed tutorials so you get the idea.

Thank you Sachin

Thanks for inspiring me Sachin. For 24 years, if there is a cricket match on TV, I would invariably ask, “Is Sachin playing?”. It would be hard to watch the sport knowing that you will not grace it with your presence. But you have given me and lots of people in my generation something even more valuable. You motivated us to excel in our life. For that I thank you.

 

Dig sports & Excel? Then you will love these dashboards

If you dig sports & work with Excel, then you are going to immensely enjoy below dashboards too.

 

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

17 Responses to “Thank you Sachin [a small tribute]”

  1. Domnic says:

    awesome excel file!

  2. Nice looking excel we have there Chandoo :-)

    Good that you have put the excel on a CDN :-))

  3. chand dora says:

    nice way to say adieu

  4. Sajan says:

    Thanks Chandoo! But I thought Sunil Gavaskar was the best Indian cricket player ever! :-)

  5. Nath says:

    This is fantastic mate. Well done!

  6. Krishnasamy Mohan says:

    Hello Chandoo Ji!!
    Really an Excellent Tribute to an Excelling Legend by an Excel Legend! Wow! great!

  7. Rahim says:

    Excellent Tribute to an Excelling Legend

  8. Kalyan Verma says:

    Amazing Visualization!!!

  9. Jacob Barnett says:

    I was lucky enough to see the little master make a century against England in the tied game during the last world cup. The reaction from the crowd was like nothing I have ever seen!

    Great visualisation.

  10. Jordan G says:

    Like most Americans, I know next to nothing about cricket. But the dashboard is great.

  11. ranjith says:

    Dear sir,
    I admire u because of your skills in excel and I want a detailed explanation regarding the following
    1.macro and. Vba
    2.offset and index match conditional formatting

  12. Val says:

    im left as spell bound as one is when Sachin bats!

  13. Kiev says:

    Chandoo, nice post & great instruction, at least i get to know this person through Excel even i have no idea of cricket at all. Excel is cultural tool now…

  14. Suresh Burde says:

    Brilliant work my friend !!
    It’s a small and loverly tribute to the great master. Least we can do is to appreciate the stats and cherish the fact that we got to witness most of it, as it happened in our generation. Really lucky to be part of this era. :)

    Cheerss… thanks, for the stats. THere are many pages on Wikipedia, that spawn from sachin’s home page, and they contain a lot of stats and details, including that for ODI etc. Some of you may want to take a look at that too. It’s amazing how people contribute and keep the wiki pages updaded.

    • Suresh Burde says:

      Excel of course is great tool. I have used a lot of excel features, that I can see have been used for this sheet as well, it takes a lot of efforts and skill to make use of excel the way you did, I really appreciate your efforts. You have done a wonderful job. :)

  15. martin hakansson says:

    Awesome dashboard!
    Though what I can’t figure out is how the linked texboxes with a reference works?

  16. Sidhesh Mangle says:

    Created a Visualization of Sachin Tendulkar? – Test cricket records using Tableau Public

    http://public.tableausoftware.com/views/SachinTendulkar_TestCricketRecords/Sachin-TestCricketRecords?:embed=y

Leave a Reply