Hi Ashish ,
This will take some time to evaluate ; however 2 quick points :
1. The dashboard cannot be just a tab ; it has to be a presentation. You will have to bring all the charts together , along with their slicers / dropdowns / other controls , so that only the displays are available to view. All of the pivot tables and other data columns will have to be moved out to a remote area of the tab.
2. I was taking a look at the winning percentage , and I would suggest a different view ; if you look at South Africa's percentage , it is 64% , which tells a completely false story.
I think how these percentages should be worked out is as follows :
Total the number of matches in every World Cup that a team has played ; suppose South Africa has participated in 4 World Cups , and the total number of matches a winning team would have played in each tournament is 9 ; this means the total number of matches a team would have played in those 4 World Cups would be 36 ; if a team was a winner in all 4 of them , it could have won all 36 , or it would have won a lesser number , due to losing matches in the league stage or in matches being abandoned. What ever be the case , dividing the number of matches won by 36 would give the correct percentage , and you would find that the top 5 winners would have the top 5 percentages.
If you see the present percentages , New Zealand has a winning percentage of 59 % , without being either the winners or runners-up even once , while Sri Lanka have won the Cup once , but have a winning percentage of just 49 %.
Narayan