It contains match-level information for each and every match held in IPL from 2008 to 2017.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

You work as a data analyst at IFP, a nationally recognised news agency, which is based out of New Delhi, and provides news reports and feeds to magazines, newspapers and TV broadcasters all over the country. The Sports Editor of the agency has approached you to build a Tableau dashboard of IPL statistics over the years since its inception in order to create an infographic for a newsletter that their team is working on. For this newsletter, in some cases, they will use the visual representations as you have created in Tableau directly for their infographic, and in a few other cases, they will use important statistics after trying out the different filters and customisations that you have provided for interactivity. Therefore, you are expected to build an interactive dashboard in Tableau for this purpose

You are expected to use two datasets

• matches.csv - It contains match-level information for each and every match held in IPL from 2008 to 2017.

• deliveries.csv - It contains ball-by-ball information for each of the matches.

Combining the information in these two data sets, you will be creating an interactive dashboard that highlights some of the important statistics of IPL over the years. 

The final dashboard can be broken down into several categories and sub-categories. The ones which you need to focus on for this assignment are as follows: 

1. Match Statistics

• Toss outcome vs Match outcome (for each Ground/Venue)

• Biggest wins (by runs and by wicket)

• Highest totals (across all the seasons)

 2. Player Statistics

• Orange Cap contenders (The batsmen who have scored the maximum number of runs in a particular season)

• Purple Cap contenders (The bowlers who have taken the maximum number of wickets in a particular season)

• Batsmen who have hit the most number of fours and sixes (per season and overall)

3. Team Statistics

• Season-wise team performance (wins vs losses)

• Win %age ( home vs away)

The ‘deliveries.csv’ file contains ball-by-ball information for all the matches across all the seasons of IPL. Each row in this data set contains:

• Match related information (batting team vs bowling team)

• Player information (Bowler, Batsman, Non-striker)

• Delivery information (Runs scored, Wickets, Extras, etc.)

 Similarly, the ‘matches.csv’ file contains the following data:

• Teams involved

• Results (which team won, win type, player of the match, etc.)

• Match specifics (umpires, ground, etc.) 

Using these two datasets, you need to create visualisations pertaining to the different types of statistics mentioned in the assignment sub-tasks section. The final objectives and the expected results/submission are given below 

Results Expected

• A tableau workbook containing 3 dashboards pertaining to the 3 categories - Match statistics, Player statisticsand Team statistics.

• Each dashboard should contain the visualisations from the sub-category worksheets. For example, in the Match statistics dashboard, the visualisations should be from the Toss Outcome vs Match Outcome, Biggest Wins and Highest Totals worksheets. Similarly, you need to prepare the dashboards for Player statistics and Team statistics.

• The dashboards and the corresponding visualisations should be well-detailed.

• A PPT file containing the summary of the entire visual analysis for this assignment. This ppt should contain all the visualisations that have been used along with the necessary insights and details.

 You need to submit the following two files.

• A tableau workbook containing the three dashboards. Make sure that you save it as a packaged workbook with the connection kept as an extract. This is important or else your workbook won't open on our evaluation systems.

• A PPT file containing the summary of the entire analysis in PDF format.

Attachments:

Expert's Answer

686 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme