

The output dashboard is generated by using various ideas. Unhide them to go Indian Jones on the dashboard. PS: All the calculations & pivot tables are hidden. This dashboard uses generous amounts of SUMIFS, COUNTIFS, INDEX, MATCH and VLOOKUP with an occasional LARGE.įor some of the calculations, I have also used Pivot tables. So it took a fair bit of massaging to get everything flow in to dashboard. The data for this dashboard is downloaded from and the trivia details are downloaded from in.msn.comĭata from Cricinfo website came in multiple tables. It is dynamic, fun & awesome (just like Sachin).Ĭlick here to download the file and play with it. Here is a dashboard I made visualizing his test cricket statistics. Thank you Sachin – his test career in a dashboard I made an Excel dashboard celebrating Sachin’s test career. That is the closest I have been to a cricketer. Once in college I was reluctantly asked to be a stand-by player in a game with seniors.


Of course, I have never been a cricketer in my life. So as a small tribute, I have decided do something for him. He is playing his last test match (200th, most by any person) as I am writing this. It is a pity that the great man is retiring from test cricket. The amount of dedication & excellence he has shown constantly motivates me. Tendulkar has been an inspiration for me (and millions of others around the world) since I was a kid. He is the leading scorer in both tests (15,921 runs) and one day matches (18,426 runs). Those of you who never heard his name, he is the most prolific cricketer in the world. People who prove that commitment, hard work and perseverance are true ingredients of a genius. Lets talk about people who inspire us.People who show us that anything is possible.
