Project Title: Designing a Predictive Analytics System for Quality Metrics at Northwest Kidney Centers

Northwest Kidney Centers

Details
Project Title Designing a Predictive Analytics System for Quality Metrics at Northwest Kidney Centers
Project Topics Data Management Product Design & Development Research & Development Software Design & Development
Skills & Expertise
Project Synopsis: Challenge/Opportunity
Northwest Kidney Centers (NWK) is one of the nation’s leading nonprofit dialysis providers, serving thousands of patients and maintaining decades of clinical data. Despite the richness of this data, it remains siloed, inconsistently formatted, and difficult to leverage for continuous quality improvement (QI).

Currently, NWK tracks multiple quality indicators—such as infection rates, hospitalizations, transfusions, vaccinations, and anemia—but the organization lacks a repeatable process for integrating, analyzing, and reporting on these metrics. This hampers the ability of clinical and operational teams to proactively identify trends, intervene early, and measure the effectiveness of corrective actions over time.

This project offers students the opportunity to build a foundational, scalable analytics framework to transform NWK’s quality data into actionable insights. By cleaning and modeling decades of historical data, centralizing it in a usable database, and building predictive reporting workflows, students will help NWK shift from retrospective reporting to proactive quality management. The outcome will be a critical tool that strengthens clinical decision-making, improves patient outcomes, and supports NWK’s mission to deliver exceptional kidney care.

Project Synopsis: Activities/Actions Required
Audit Current Data Ecosystem

  • Inventory all data sources used for QI metrics.

  • Assess data quality, completeness, and consistency.

  • Identify a reliable “source of truth” for each metric.

Design Data Architecture & Pipeline

  • Propose a standardized data model for quality metrics.

  • Develop an ETL (extract-transform-load) plan to unify legacy datasets.

  • Implement cleaned datasets within NWK’s Oracle database.

Develop Predictive and Descriptive Analytics

  • Design statistical models to forecast key quality metrics (infection, hospitalization, transfusion).

  • Create calculation logic using R, Python, or similar tools.

  • Validate accuracy using historical trend analysis.

Build Reporting Framework

  • Automate monthly and quarterly reporting.

  • Design clear, user-friendly dashboards and slide decks (PowerPoint) for leadership use.

  • Include alerts/thresholds to flag concerning trends.

Document Processes and Train Staff

  • Create SOPs for ongoing data management and analysis.

  • Provide training materials and walkthroughs for internal staff.

Project Synopsis: Expected Results
Establish a centralized, clean, and validated dataset covering at least 10 years of historical quality data by the end of the first semester.

Achieve >90% accuracy in predictive models when back-tested on historical data by mid-project.

Deliver an automated, repeatable monthly reporting system to NWK’s leadership by project conclusion.

Enable real-time access to visualized trends and forecasts through user-friendly dashboards.

Produce a fully documented analytics pipeline and SOPs that NWK can maintain and scale internally.

Project Timeline

Touchpoints & Assignments Date Type

Project Kickoff

Jan 30 2023 Event

Student Kickoff Evaluation

Feb 03 2023 Evaluation

Student Temperature Check

Feb 24 2023 Evaluation

Industry Temperature Check

Feb 24 2023 Evaluation

Industry Temp Check #2

Mar 31 2023 Evaluation

Student Temp Check #2

Mar 31 2023 Evaluation

Industry Wrap Up Evaluation

May 12 2023 Evaluation

Student Self Reflection

May 12 2023 Evaluation

Student Peer Evaluation

May 12 2023 Evaluation

Teams

Team Name  Project Name  Team Members 
No Teams Available