Question
The first step is to understand the data, interpret what the dataset is about, create at least four research (business) questions that you are interested
The first step is to understand the data, interpret what the dataset is about, create at least four research (business) questions that you are interested to find the answer for, identify the KPIs, and then create an organized dashboard with tables and charts to summarize the KPIs and answers to the research (business) questions. You might need to clean the data first (as you learn in week 2 practice lab), and/or add new columns to extract some information (as you did for example in HW2) to be used in the visualizations. You can use filters and slicers to make the dashboard interactive.
You need to submit your Excel file (including your data and dashboard) and a word file that includes: a) an introduction of the dataset that you used with a reference to a link where you get it (if applicable), b) an explanation of research (business) questions that you developed and the KPIs that you considered, c) the fields that you used to create the summary tables and the reason that you decided to create those tables, d) the type of charts you used to present each table and the reason why you selected that type of chart, and e) the answer you found for research (business) questions based on the interactive dashboard that you created. The word file acts as a process book for your project. Your group needs to prepare an organized and professional-looking dashboard and process book. One submission per team is enough.
DATASET:
| id | city | date | player_of_match | venue | neutral_venue | team1 | team2 | toss_winner | toss_decision | winner | result | result_margin | eliminator | method | umpire1 | umpire2 |
| 335982 | Bangalore | 4/18/2008 | BB McCullum | M Chinnaswamy Stadium | 0 | Royal Challengers Bangalore | Kolkata Knight Riders | Royal Challengers Bangalore | field | Kolkata Knight Riders | runs | 140 | N | NA | Asad Rauf | RE Koertzen |
| 335983 | Chandigarh | 4/19/2008 | MEK Hussey | Punjab Cricket Association Stadium, Mohali | 0 | Kings XI Punjab | Chennai Super Kings | Chennai Super Kings | bat | Chennai Super Kings | runs | 33 | N | NA | MR Benson | SL Shastri |
| 335984 | Delhi | 4/19/2008 | MF Maharoof | Feroz Shah Kotla | 0 | Delhi Daredevils | Rajasthan Royals | Rajasthan Royals | bat | Delhi Daredevils | wickets | 9 | N | NA | Aleem Dar | GA Pratapkumar |
| 335985 | Mumbai | 4/20/2008 | MV Boucher | Wankhede Stadium | 0 | Mumbai Indians | Royal Challengers Bangalore | Mumbai Indians | bat | Royal Challengers Bangalore | wickets | 5 | N | NA | SJ Davis | DJ Harper |
| 335986 | Kolkata | 4/20/2008 | DJ Hussey | Eden Gardens | 0 | Kolkata Knight Riders | Deccan Chargers | Deccan Chargers | bat | Kolkata Knight Riders | wickets | 5 | N | NA | BF Bowden | K Hariharan |
| 335987 | Jaipur | 4/21/2008 | SR Watson | Sawai Mansingh Stadium | 0 | Rajasthan Royals | Kings XI Punjab | Kings XI Punjab | bat | Rajasthan Royals | wickets | 6 | N | NA | Aleem Dar | RB Tiffin |
| 335988 | Hyderabad | 4/22/2008 | V Sehwag | Rajiv Gandhi International Stadium, Uppal | 0 | Deccan Chargers | Delhi Daredevils | Deccan Chargers | bat | Delhi Daredevils | wickets | 9 | N | NA | IL Howell | AM Saheba |
| 335989 | Chennai | 4/23/2008 | ML Hayden | MA Chidambaram Stadium, Chepauk | 0 | Chennai Super Kings | Mumbai Indians | Mumbai Indians | field | Chennai Super Kings | runs | 6 | N | NA | DJ Harper | GA Pratapkumar |
| 335990 | Hyderabad | 4/24/2008 | YK Pathan | Rajiv Gandhi International Stadium, Uppal | 0 | Deccan Chargers | Rajasthan Royals | Rajasthan Royals | field | Rajasthan Royals | wickets | 3 | N | NA | Asad Rauf | MR Benson |
| 335991 | Chandigarh | 4/25/2008 | KC Sangakkara | Punjab Cricket Association Stadium, Mohali | 0 | Kings XI Punjab | Mumbai Indians | Mumbai Indians | field | Kings XI Punjab | runs | 66 | N | NA | Aleem Dar | AM Saheba |
| 335992 | Bangalore | 4/26/2008 | SR Watson | M Chinnaswamy Stadium | 0 | Royal Challengers Bangalore | Rajasthan Royals | Rajasthan Royals | field | Rajasthan Royals | wickets | 7 | N | NA | MR Benson | IL Howell |
| 335993 | Chennai | 4/26/2008 | JDP Oram | MA Chidambaram Stadium, Chepauk | 0 | Chennai Super Kings | Kolkata Knight Riders | Kolkata Knight Riders | bat | Chennai Super Kings | wickets | 9 | N | NA | BF Bowden | AV Jayaprakash |
| 335994 | Mumbai | 4/27/2008 | AC Gilchrist | Dr DY Patil Sports Academy | 0 | Mumbai Indians | Deccan Chargers | Deccan Chargers | field | Deccan Chargers | wickets | 10 | N | NA | Asad Rauf | SL Shastri |
| 335995 | Chandigarh | 4/27/2008 | SM Katich | Punjab Cricket Association Stadium, Mohali | 0 | Kings XI Punjab | Delhi Daredevils | Delhi Daredevils | bat | Kings XI Punjab | wickets | 4 | N | NA | RE Koertzen | I Shivram |
| 335996 | Bangalore | 4/28/2008 | MS Dhoni | M Chinnaswamy Stadium | 0 | Royal Challengers Bangalore | Chennai Super Kings | Chennai Super Kings | bat | Chennai Super Kings | runs | 13 | N | NA | BR Doctrove | RB Tiffin |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Elementary Statistics
Authors: Robert R. Johnson, Patricia J. Kuby
11th Edition
978-053873350, 9781133169321, 538733500, 1133169325, 978-0538733502
