A A A
  • Link to Facebook
  • Link to X
  • Link to Instagram
  • Link to LinkedIn
Aliados Health
  • home-icon
  • Who We Are
    • About Us
    • Board of Directors
    • Contact Staff Members
    • Careers
    • Contact Us
  • Enrollment Services
    • Outreach and Enrollment Services
    • CalFresh
    • Covered California
    • Medi-Cal
      • Medi-Cal Resources (English)
      • Recursos de Medi-Cal (Español)
  • Partner Health Centers
    • Find a Health Center
    • Locations and Mobile Clinics
      • Sonoma County Health Centers
      • Marin County Health Centers
      • Yolo County Health Centers
      • Napa County Health Centers
      • Contra Costa County Health Centers
      • Solano County Health Centers
  • Initiatives
    • Community Health Workers (CHWs)
    • Emergency Preparedness Resources
    • Health Informatics
      • Data Analytics and Governance
      • Health Center Controlled Network
    • North Bay Area Health Education Center (AHEC)
    • Peer Collaboration
    • Quality Improvement
      • Population Health Improvement Framework
      • Promising Practices
      • The QI Chat Room Podcast
      • Quality Improvement Resources
  • Policy and Advocacy
    • Get Involved
  • News and Events
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu

Data Analytics and Governance

HRSA

What We Do:

Aliados Health is working with participating health centers in the Contra Costa, Marin, Mendocino, Napa, Solano, Sonoma, Yolo County regions and with HCCN (Health Center Controlled Network) members beyond these regions towards forming a collaborative regional system of value-based care that makes data-driven decisions using robust analystic to achieve a health community for all.

We currently manage a growing analytics platform and a standard set of measures that are developed with the governance of our member driven Data Standards and Integrity Council and support through peer workgroups.

Aliados Health Staff and Health Center Staff:  Have a question? Need access or a report fix? Need to request staff access to the aggregated data*?
Please use the Aliados Health request form: Data / Access / Report Fix Request Form

*For health center staff access to the aggregate, please complete this form and attach it to the electronic request form.

PROGRAM

Data Standards and Integrity Council:

Aliados Health’s Data Standards and Integrity Council (DSIC) meets bi-monthly with the objectives of improving data quality, increasing data literacy and maximizing the use of data for common measure sets and programs.  The Council is made up of a representative from each health center who has the authority to make decisions related to the health center data reporting and governance.

Additional Resources and Companion Documents

If you need a password for the locked content please contact us.

  • Aliados Health Data Standards and Integrity Group Charter(July 2023)
  • DSIC Topical Index
  • Comparison_annual_reports_v23 (July 2025)
  • Aliados Health Analytics Guide-2023 (January 2023)

Data Workgroup and Report Documentation:

This is Aliados Health’s longest running data peer group and historically is the forum where Aliados Health has shared measure documentation, how to use new standard reports, validation practices, benchmarking and assistance with questions around standard report sets such as the Uniform Data System (UDS Federal Reporting) and Office of Statewide Health Planning and Development (OSHPD State of California Reporting), as well as other shared standardized reports.

Additional Resources and Companion Documents

If you need a password for the locked content please contact us.

  • Quality Measure Updates (2026)
    • Changes to Relevant Quality Measure Sets(recording, 3/2026)
    • QM_Changes (slides, 3/2026)
    • Comparison_annual_reports_v25
    • 2026_Value_Set_Lists_v1
  • UDS Federal Reporting (2026)
    • UDS_Changes_Relevant(slides, 10/2026)
    • UDS_Changes_Relevant (recording, 10/26)
    • UDS_Validation_Strategies_Relevant_11-10-2026 (slides, 11/2026)
    • UDS_Validation_Strategies_in_Relevant (recording, 11/2026)
  • UDS Federal Reporting (2025)
    • End of Year UDS Preparation(recording, 11/2025)
    • End of Year UDS Preparation(slides, 11/2025)
    • Early Stages UDS Validation PIP Pediatric(recording, 8/2025)
    • Early_Stages_UDS_Validation_PIP_Pediatric_8-12-25(slides, 8/2025)
    • UDS_Manual_2025
    • 2025UDSChangesWebinar_V6_6.13.25_508C_ADA
    • 2025 UDS 1 Year High-Low
    • 2025 UDS 5 Year High-Low
  • HCAI State Reporting
    • OSHPD Preparation from Scratch (recording, 2/2026)
  • Partnership Reporting
    • PHP_Report_Set_Brief_v2(slides 7/2026)
    • QIP_EHR_Comparison_Report_Brief_v2(9/2026)
    • Relevant_PHP_Claims_Tools (slides 7/2026)
    • Relevant Tools for Partnership Claims(recording 7/2026)
    • PHP Report Set Implementation Guide (slides 5/2026)
    • PHP Implementation Guide(recording 5/2026)
    • PHP_Reports_Max_Insight_BF_(slides 4/2026)
    • PedCaseManagement_QIPEHRComparison(recording, 4/2025)
    • New_Reports_PedCaseManag_QipEhrCompare(slides, 4/2025)
    • QIP 2025 Measures (recording, 3/2025)
    • QIP_2025_Report_Set(slides 3/2025)
  • Population Health Management Initiative
    • PHMI Report Instructions(recording, 10/2023)
    • Instructions_PHMI2023(slides, v1, 10/2023)
  • PIP Reporting (Fiscal Year 2025-26)
    • PIP Fiscal Year 2025-26-Program Document  (Final 6/2025)
    • PIP Fiscal Year 2025-26-Program Document Amendment  (Amendment 8/20/2025)
  • PIP Reporting (Fiscal Year 2026-27)
    • PIP-FY2026-27-Hierarchical-Condition-Category-Coding-Attestation.pdf (06/26)
    • PIP Fiscal Year 2026 – 27 Program Document (Final 06/26)

Health Center Analytics for Small and Medium Health Centers:

Analysts and Quality Improvement leads meet bi-monthly to discuss new development in Relevant, share reporting and ask questions.  The group is co-hosted by Aliados Health Analytics Team and Relevant.

Relevant Peer Group for Epic sites:

This group is self-led, but hosted by Aliados Health to allow peers with a common EHR platform to work together through analytics coding issues providing insights and peer support.

Aliados Health Analytics Academy:

The Aliados Health Analytics Academy includes trainings for providers using the Relevant tool, as well as for coders, data analysts and others using SQL coding to work in the Relevant tool.

Analytics Academy Training Resources and Companion Documents

If you need a password for the locked content, please contact us.

Trainings:

  • Charlson Comorbidity Index Q&A Charlson Comorbidity Index Q&A (recording, 10/2024)
  • Relevant Data Explorer Demo (recording, 1/2024)Relevant Data Explorer Demo
  • HITEQ Analytics Academy AI / Predictive Analytics Training
    • AI Predictive Analytics Training (recording, 11/2023)
    • HITEQ Aliados AI Training(slides, 11/2023)
  • Relevant Bi-Directional Outreach Tool:
    • Relevant Bi-Directional Outreach Tool Demo
  • Using Relevant: Provider Trainings
    • Quality Measures  (time 12:26)
    • Visit Planning (time 11:20)
  • AI Data Storytelling (2026)
    • Numbers to Narrative (slides, 6/2026)

Analytics Academy:

2026 Analytics Academy:

  • Analytics Academy: Aliados Health Road Map(recording, 4/2026)
  • Analytics Academy: Aliados Health Road Map(slides, 4/2026)
  • Analytics Academy: Value Based Care(recording, 4/2026)
  • Analytics Academy: Value Based Care(slides, 4/2026)
  • AVH Analytics Academy 2026 Presentation(slides, 4/2026)
  • Analytics Academy: Health Center Presentations(recordings, 4/2026)
  • PHP_Reports_Max_Insight_BF (slides, 4/2026)

2025 Analytics Academy: (slides)

  • 2025 Analytics Academy AI Presentation by Mark Sendack(recording, 5/2025)
  • External Using AI for Data Analysis(slides, 5/2025)
  • External New Dashboard Features for QI (slides, 5/2025)
  • External New Dashboard Features for Analysts(slides, 5/2025)
  • Back_to_Basics_Using_Relevant(slides, 5/2025)
  • Effective_Use_Pop_CG_RM(slides, 5/2025)

2024 Analytics Academy

  • 2024 Analytics Academy(slides)

2023 Analytics Academy: 

  • Relevant Dashboards(recording)
  • Vegalite(recording)
  • Telling Stories With Data(recording)

2022 Analytics Academy:

  • AH Analytics Academy 2022(flyer)
  • AH Analytics Academy Event Description 2022
  • Don’t Risk it, Stay Relevant (Risk Scores):
    • Don’t Risk it, Stay Relevant (recording)
    • Population Explorer & Risk Models (slides)
    • CCI Q&A Session with Relevant.mp4 (recording)
  • Can’t Wait for the SQL:
    • Can’t-Wait for the SQL Handout  (handout)
    • Cant Wait SQL Part2 Answers (handout)
    • AH_Academy_Cant_Wait_SQL_Training(handout)
    •  Can’t Wait for the SQL (Recording)
  • Getting Messy With SQL:
    • Getting Messy with SQL Reporting – Setup Guide (set up guide)
    • Getting Messy With SQL(Recording)
    • Hands-On SQL Exercise(handout)
    • Presentation Slide Deck(slides)
    • demo_clinics
    • demo_doctors
    • demo_external
    • breast_imaging
    • demo_patients
    • Code-Along Solution
    • Code-Along
    • CREATE-DEMO-TABLES
    • DROP-DEMO-TABLES
    • Chart Samples (5-12-22 Results)

2021 Analytics Academy

  • Improving your Data Literacy and SQL Comprehension
    A deep exploration of entity diagram relationships, the SQL blueprint, and writing SQL queries.  The goal of this session is to touch upon and improve data literacy.  Attendees will also learn how to translate SQL queries into natural language. (Target audience: 0-1 years’ experience coding)
    2021 Slides   
    2021 Recording
  •  If There Is a Will, There Is a SQL Query That Will Get It Done.                                                                                                                                                          This session is for users with 1 to 2 years of experience. Some of the topics that will be covered are: eCW and NextGen table structure and relations, Intermediate Postgres commands, Query optimization and Integrating external data.                                                                                                                                                             
    • 2021 Intermediate Slides  
    • 2021 Intermediate Recording

2020 Analytics Academy

  • Getting Relevant with Relevant
    A deep exploration of the features of Relevant software.  This session will include a walk through the use of less commonly used tools such as Population Health Explorer and Productivity Screens.  Attendees will also learn how to translate SQL queries into English. (Target audience: QI Directors, Operations Leads or Beginning Relevant Users)
    Recording – April 2020
  • SQL Learning Lab
    Take your SQL skills to the next level! This session will start with SQL basics and quickly move to writing your own report or quality measure.  This will be a hands on experience with real health center challenges. (Target audience: Coders and Data Analysts with 0-1 years’ experience)
    Slides
    Recording
  • Code and Conquer
    This session will be hands on tips, tricks and problem solving from an experienced health center data analyst (Target audience: Coders and Data Analysts with more than 9 months experience)
    Slides
    Coding Examples
    Recording
  • Stump the Programmer
    Coders submitted their most difficult SQL challenges!  Come with your computer and questions in hand as our experts will be on hand to help you troubleshoot. (Target audience: Coders and Data Analysts with more than 9 months experience)
    Recording

This training is supported by the Health Resources and Services Administration (HRSA) of the U.S. Department of Health and Human Services (HHS) as part of an award totaling $650,000 with 0% financed with nongovernmental sources. The contents are those of the author(s) and do not necessarily represent the official views of, nor an endorsement, by HRSA, HHS or the U.S. Government.

Funders

This work is supported in part by the Health Resources and Services Administration (HRSA) of the U.S. Department of Health and Human Services (HHS) under grant number U86CS45894 Health Center Controlled Networks. This information or content and conclusions are those of the author and should not be construed as the official position or policy of, nor should any endorsements be inferred by HRSA, HHS or the U.S. Government.

PROJECT PARTNERS

Health Centers:

  • Alexander Valley Healthcare
  • Alliance Medical Center
  • Anderson Valley Health Center
  • CommuniCare + OLE
  • Community Medical Centers
  • El Dorado Community Health Center
  • Indian Health Center Santa Clara Valley
  • Long Valley Health Center
  • Marin City Health and Wellness Center
  • Marin Community Clinics
  • Petaluma Health Center
  • Redwoods Rural Health Center
  • Ritter Center
  • Santa Rosa Community Health
  • Shasta Cascade Health Center
  • Shasta Community Health Center
  • Sonoma County Indian Health Project
  • Sonoma Valley Community Health Center
  • West County Health Centers
  • Winters Healthcare Foundation

PROJECT CONTACT

For more information, please contact Colleen Petersen

Search Search
  • Emergency Preparedness Resources
  • Peer Collaboration
  • Health Informatics
    • Data Analytics and Governance
    • Health Center Controlled Network
  • Quality Improvement
    • Evidence Based Care
    • Promising Practices
© Copyright - Aliados Health
  • Link to Facebook
  • Link to X
  • Link to Instagram
  • Link to LinkedIn
  • Terms of Service
Scroll to top

Contact form

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*