TATA IPL Mini Auction 2022 Analysis
Posted on: 20 December, 2022
IPL Mini Auction is an annual event that will be taking place in December '22. On 13th december TATA IPL 2023 Player Auction list was announced on BCCI's offcial site. Using this data Auctioneer, Bidders, Partners, & Fans can find information about the players. Excited about IPL 2023 Mini-auction I came across this IPL Dataset, considered making an simple dashboard as a fun project using MS Excel.
IPL(Indian Premier League), Quite possibly one among the most watched sporting events across the globe, has turned into an huge brand. According to a report by D and P Advisory, the worth of the IPL has reached $10.9 Billion & got the 'Decacorn' status. IPL not only gathers cricket enthusiasts from India, but it also endeavors to unite all cricket admirers in the world. The 2022 edition of the premier league was stirring with the introduction of two new teams. Now, all the 10 teams are ready for Mini-auction coming up in late December '22. Auctions are one of the USP of any premier league that involves trading, bidding, & evaluating players, offers a thrilling entertainment to fans.
The interactive dashboard was prepared using MS Excel. Here are the main functions that were used, GoTo Special & rank function to remove errors and make data consistent for analysis. Next, constructed a Pivot table to extract exact count of capped & uncapped players for KPI tiles. Also did same to extract batsmans, bowlers, wicket-keepers, & all-rounders count. Later, to make an interactive dashboard implemented a search column at bottom, thorugh the Vlookup function. By this user can enter the players' serial number to retieve complete information. At last, used conditional formating to sort and placed the two most important clustered column charts in the center, i.e Top5: T20 Caps, IPL Caps.
Resources:
1) TATA IPL 2023 Player auction list
2) Image by macrovector on Freepik
Free Learning Resources:
1) Free Excel Dashboard Course by Trump Excel
2) Basic concepts of Excel Technology for Teachers and Students on Youtube
3) Tips & Tutorials by Chandoo on Youtube