Built with datascienceportfol.io

INVESTIGATIVE MURDER ANALYSIS

Project photo

Project links

Skills

About this project

The mystery murder was developed by Joon Park and Cathy and the objective was to  Identify the Murderer by using SQL to analyze the various information provided in the data source to located the suspect responsible for the murder and the Mastermind behind the murderer.

PICTURES OF THE SQL QUERY

 

The Conclusion and Key findings showed through the use of advanced SQL analysis and data-driven techniques includes:

  • Jeremy Bowers, residing at Washington PI, Apt 3A, was confirmed as the murderer through concise analysis of interviews, surveillance footage, personal details, driver's license records, financial transactions, and communication records.
  • Miranda Priestly, a wealthy individual with distinctive physical characteristics (5'5" or 5'7" with red hair) and a Tesla Model S owner, was revealed as the mastermind behind the crime. Her attendance at the SQL Symphony Concert in December 2017 was a crucial piece of evidence.

This investigation demonstrates the power of data-driven approaches in solving complex criminal cases. By leveraging comprehensive data analysis and SQL expertise, the perpetrators were brought  to book and the case closed.

Link to the Project:https://drive.google.com/folderview?id=1jrp1PeFtVDAkw5KBmkoijolQ_zN4YxwO

https://drive.google.com/folderview?id=1jrp1PeFtVDAkw5KBmkoijolQ_zN4YxwO