NKC Power BI Dashboard, 60% transparent
Data Wrangling

Data for Paws - Opportunities Dashboard

Wrangling and visualizing raw animal shelter and rescue data from Colorado into actionable insights to improve animal welfare.

Industry
Nonprofit
Completion
October 2025

Project Overview

No Kill Colorado is a nonprofit animal welfare advocacy organization working hard to get Colorado to 100% no-kill. Data Changemakers, a nonprofit of data visualization professionals and enthusiasts focused on employing their powers for good, is helping No Kill Colorado to transform the vast, complex world of animal shelter data into a compelling story that could motivate action and reform.

As part of this effort, I developed a dashboard that turned complicated, multi-year datasets from over 300 shelters and rescues into clear, actionable insights.

My work shines a light on opportunities for improvement, empowering the public, policymakers, and the media to understand and engage with the current landscape of animal welfare in Colorado. By bridging technical solutions with advocacy, the project not only increased transparency but also strengthens No Kill Colorado's position as a trusted leader driving positive change for pets statewide.

The Challenge

  • Inconsistent data formatting across 21 annual shelter statistics files spanning from 2007 to 2024.
  • Lack of standardized unique facility identifiers, complicating analysis.
  • Integration of statistics, regulatory facility list and, if available, updated location data.
Screenshots of 21 Excel stats files, stacked

The Solution

Solution Approach

I unified and cleaned complex shelter and nonprofit data using Python and Jupyter, then built a Power BI dashboard to visualize key animal welfare metrics and facilitate actionable insights.

Opportunities Dashboard in Power BI

  • Implemented a comprehensive, automated data wrangling pipeline in Jupyter Notebook to unify and clean disparate datasets.
  • Built an interactive Power BI dashboard with alert features to identify opportunities for improving animal welfare in Colorado.

Technologies Used

Data Wrangling

  • Python
  • Jupyter Notebook

Development

  • Power Query
  • DAX
  • HTML

Visualization

  • Power BI

Skills Applied

Data Collection Data Modeling ETL Development Data Wrangling Dashboard Design Time Series Analysis Data Visualization User Experience Design Requirements Analysis

Results & Impact

  • Delivered user-friendly maps and dashboards that highlight underperforming regions and life-saving opportunities.
  • Enhanced public transparency and engagement—tools published for community and stakeholder access.
  • Provided policymakers with robust, evidence-based insights for guiding strategic animal welfare reform.
  • Strengthened No Kill Colorado's presence in state, national, and media advocacy through data-driven storytelling.

Get In Touch

Interested in discussing this project or how I can help with your data analytics needs? Send me a message!