Revitalizing the Arts - Exploring Guaranteed Income and Artistic Insights in New York
This project focuses on analyzing survey data to explore guaranteed income and its impact on artistic communities in New York. The data visualization provides insights into applicant demographics, enrollment summaries, financial wellness, and the impact of COVID-19 on artists.
Interact with the Dashboard here:- View Power-BI Dashboard
The data visualization is structured into four main sections:
- Applicant Demographics: Covers metrics like LGBTQIAP+ representation, immigrant percentages, and counts of Deaf and Disabled applicants.
- Enrollment Summary: Provides insights into enrolled candidate figures, percentages involved in caregiving, recipients of public benefits, and individuals entangled with the legal system.
- Financial Wellness: Illuminates the financial landscape with survey responses, highlighting community-driven disparities, educational barriers, and debt metrics.
- Impact of COVID-19: Analyzes emergency needs, health insurance coverage, alternative income sources, and the effects on physical and mental health.
- Applicant Data: Handled missing values and standardized formats.
- City: Cleaned city names and standardized formatting.
- Race Ethnicity: Enhanced representation of multiracial identities.
- Gender: Categorized records with multiple identities.
- Provide Care: Created 'provide_care_status' column based on caregiving responses.
- Financial Safety Net: Transformed nuanced responses into quantifiable categories.
- Artist’s Practice: Ensured uniformity in artistic approach representation.
- Public Benefits: Calculated total benefits received.
- Survey Data: Formatted and standardized columns.
- Preprocessing: Jupyter Notebook, Python, SQL
- Visualization: Microsoft’s Power BI