This project is an illustration in ETL and analysis, a masked version of consultant "market research" I performed on behalf of a client opening a family violence shelter. My work accessing and utilizing data from several sources with incompatible filetypes and table structures generated insights as to how their resources could be deployed to maximize impact.
DATA MASKING POLICY:
I've removed the client organization, the city, the police department and any other geographic details present in the scripts or files. The table being used and the transformations being performed answer a set of questions about the data while preserving the privacy of the victims and the shelter that represents them. I chose to showcase this project because it allows me to show my thought process in code for providing new insights to stakeholders involved in executive decision making to address a high-impact issue.
I wanted to show off this project, despite its sensitive subject matter, because it displays a top-to-bottom customized approach in extracting, transforming, and loading data from several external datasets into a visualization tool.
ETHICAL CONSIDERATIONS:
The subject of domestic violence, too, is in its own respect worthwhile discussing in public. Part of the work I did on this project was qualitative, and a good degree of the scholarship on this issue is critical of how domestic violence is often dismissed from public discourse as a "private" or "women's" issue.
It wasn't until the feminists of the 1960s and 70s pushed for social intervention that domestic violence shelters became possible through a mix of philanthropic and government funding. Even still, many shelters around the United States, where this project was completed, face underresourced budgets or bare-minimum accomodations.
There is a hope that sharing this work inspires action on a civic level. Remember that you, too, can help end domestic vioence through philanthropic donations, your vote at the local level, and your support of local nonprofit organizations in your community.