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

Northwest Kidney Centers - Designing a Predictive Analytics System for Quality Metrics at Northwest Kidney Centers
Due Date
Activities
Deliverables
Status
Action
Mon, 01/30/23
12:00 AM UTC
Project Kickoff
No Deliverables
No deliverables are required for this action item.
Location:
Fri, 02/03/23
12:00 AM UTC
Student Kickoff Evaluation
Required Evaluation
Evaluation submission is required.
Fri, 02/24/23
12:00 AM UTC
Student Temperature Check
Required Evaluation
Evaluation submission is required.
Fri, 02/24/23
12:00 AM UTC
Industry Temperature Check
Required Evaluation
Evaluation submission is required.
Fri, 03/31/23
12:00 AM UTC
Industry Temp Check #2
Required Evaluation
Evaluation submission is required.
Fri, 03/31/23
12:00 AM UTC
Student Temp Check #2
Required Evaluation
Evaluation submission is required.
Fri, 05/12/23
12:00 AM UTC
Industry Wrap Up Evaluation
Required Evaluation
Evaluation submission is required.
Fri, 05/12/23
12:00 AM UTC
Student Self Reflection
Required Evaluation
Evaluation submission is required.
Fri, 05/12/23
12:00 AM UTC
Student Peer Evaluation
Required Evaluation
Evaluation submission is required.

Teams

Team Name  Project Name  Team Members 
No Teams Available