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