The SPD is seeking vendor assistance to modernizing internal and external Tableau Dashboards. In addition to overhauling the look and feel of these tools to promote engagement, the SPD has recently acquired two new Tableau Servers (internal and external) with additional computing capacity to accommodate advanced functionality such as integration with Python and R. The full resources of the SPD Performance Analytics & Research (PA&R) team and infrastructure would support this engagement. The PA&R maintains a large cloud-based data warehouse, two well provisioned Tableau Servers and a robust data/analytics governance infrastructure. Subject Matter Experts (SME's) in all critical areas of analytics (crime, calls for service, officer performance, arrest, case clearance, crisis, terry stops, complaints, early intervention, etc.) would support the vendor and guide implementation of advanced functionality.
Beginning with the SARS-CoV-2 pandemic, the Seattle Police Department (SPD) began observing significant impacts to key performance measures (e.g., response time, investigative case clearance, homicide, “shots fired”, etc.). Conventionally, these shocks have been addressed through blunt saturation and/or investigative emphasis policing; however, with significant impacts to staffing realized in the “post-Floyd” period (Adams, Mourtgos & Nix, 2023), resource intensive solutions are no longer an option.
Additionally, as Seattle closes out a decade long period of court ordered reform, such blunt, enforcement-forward approaches to crime control are generally considered to be of a bygone era. As highlighted by the events of the summer of 2020, anything short of Goldilocks policing (Sherman, L. W., 2022), that just right approach to public safety, is unacceptable.
Whatever the reason, the SPD can no longer address record homicides (the last three years running), record criminal shots fired incidents, an epidemic of opiate overdoses (fatal and non), increased response time for high priority calls, and increased time to follow-up and close criminal investigations by assigning more resources or allocating more overtime. Innovative uses of technology are the only solution available.
For the last twenty-four months, the considerable analytical resources of the SPD have been focused on rapid operationalization of the principles of Evidence-Based Policing (EBP). Last November, the departments Data Analytics Platform (DAP) completed a cloud migration, enabling the efficient industrialization of intelligent decisions support, targeting, testing, and tracking using the latest the science has to offer. With so much technical focus devoted to supporting EBP in operation, we need assistance to increase engagement inside and outside the department.
Over the last decade, the SPD has discovered data curiosity to be a force multiplier in the field. Socializing analytics and providing the right tools to those with operational context helps generate better questions, which in turn drives the next generation of analytics. Engaging data visualizations also support trust, legitimacy, and perceptions of efficacy through our engagement of open data, while at the same time building shared understanding of critical problems.
This request is for technical assistance in modernizing and enhancing our internal and external Tableau dashboards. Like sworn staffing, civilian staffing of professional positions is an ongoing struggle. What limited civilian analyst and research scientist positions we have are committed to providing critical business intelligence. Additionally, during the pandemic, the SPD lost the five sworn crime analysts (one per precinct) to attrition and backfill of vacancies in patrol. We are fortunate to possess a wealth of data, expertise, and technical tools but we do not have the capacity to make the most of our self-service resources.
Adams, I. T., Mourtgos, S., & Nix, J. (2023). Turnover in Large US Police Agencies Following the George Floyd Protests.
Sherman, L. W. (2022). Goldilocks and the three “Ts”: Targeting, testing, and tracking for “just right” democratic policing. Criminology & Public Policy, 21(1), 175-196.
Please check the box next to the following questions if the answer is 'yes'.
Please enter the applicable Event Date if there is an Event associated with this TTA.
When entering an Event Date, the Time is also required.
If the TTA is targeted to a particular audience or location, please complete the questions below.
Milestones are an element, activity, work product, or key task associated with completing the TTA (e.g. kick-off meeting, collect data from stake holders, deliver initial data analysis).
Please complete the fields below, if applicable, to create a milestone for this TTA.
Please respond to the Performance Metrics below. The Performance Metrics questions are based on the TTA Type indicated in the General Information section of the TTA.
Please submit a signed letter of support from your agency’s executive or other senior staff member. The letter can be emailed to or uploaded with this request. The letter should be submitted on official letterhead and include the following information:
- General information regarding the request for TTA services, i.e., the who, what, where, when, and why.
- The organizational and/or community needs specific to the request for TTA services.
- The benefits or anticipated outcomes from the receipt of TTA services.
By submitting this application to BJA NTTAC, I understand that upon approval of this application for TTA, the requestor agrees to keep BJA NTTAC informed of any circumstances that may impact the delivery of the TTA, including changes in the date of the event, event cancellation, or difficulties communicating with the assigned TTA provider.
Please call [site:phone] if you need further assistance completing this application.