BUSI $650$ Business Analytics $$ Group Project $-2023$

$1$

Situation$/$Scenario:

The Black Lives Matter $($#BLM$)$ movement has been instrumental in bringing in the forefront police

brutality and accountability towards the people it is supposed to protect. There are several fatal police

shooting cases that go unreported in the US$.$ The Washington Post has been collecting and compiling

data of every case involving a police officer since Jan $2015($Police Killing dataset attached$).$

While working in the election campaign for your favorite presidential candidate, the campaign manager

has asked to put together a team to investigate this data and to find any insights that can be derived

from the data $($whether there is a pattern or not$)$ to help the candidate.

This dataset, combined with other sources such as household Income levels and racial distribution in

given cities can create a multidimensional overview of the fatal shootings in the US by police officers.

Based on your understanding of Tableau Software and Data Visualization for data$-$driven decision

making, provide a clear picture to the campaign team on what is going on in the US$.$ Your team need to

present to the campaign team including the presidential candidate and do a demo with Tableau to

highlight your findings.

Requirements:

$$ Perform ETL of the multiple datasets to build charts and dashboards for a visual presentation of

the incidents.

$$ Demonstrate critical thinking, highlight any trends, and present this data in a clear Dashboard$($s$)$

to the presidential candidate and campaign team members.

$$ Use at least $6$ different charts$/$graphs for your presentation including Area Charts, and Maps.

$$ Submit a PowerPoint Presentation of your report, and Tableau file. Only $1$ member can submit

before the due date.

Presentation Requirements:

$$ All team members must present.

$$ The maximum length of the presentation is $15$ minutes.

$$ Presentation must include:

o Introduction

o Agenda

o Content

o Conclusion on your findings

o Must provide a live demo of the findings using Tableau Software

IMPORTANT:

Submit your PowerPoint file and Tableau file in the Case Study Submission link.

Submit your Video recording $($or paste a working link$)$ in the Data Visualization Submission link.

BUSI $650$ Business Analytics $$ Group Project $-2023$

$2$

Marking Rubric:

Topics Comments Max.

Grade

Subject Matter

$(70\%)$

Subject Matter $(70\%)$

$$ Data cleaning, ETL, and dashboard presentation are

done.

$$ Content is comprehensive, accurate, persuasive.

$$ The core features of Tableau software are demonstrated

$$ Conclusions provided are logical and the

charts$/$graphs are appealing.

$70$

Presentation $(30\%)$ Organization $(30\%)$

$$ The requirements of the presentation are met.

$$ The team member presentation is professional. No

reading from slides or notes. The core features of

Tableau software are presented thoroughly in a live

demo.

$$ Pace of speech is acceptable.

$$ Shows teamwork and support for each other.

$30$

Grade on $100$ Subtotal $100$

Penalties