Abstract: A patient access determination system configured to extract health related data from a data source to form extracted health data, generate a plurality of data pipelines for conveying the extracted health data, and store the extracted health data conveyed over one or more of the data pipelines in a data model to form stored health data. The data model includes tables for organizing and storing the extracted health data. The system also determines from at least the patient encounter data forming part of the stored health data a number of lost appointments that can be recovered by the healthcare facility and apply one or more machine learning models to the stored health data to generate predictions therefrom. The system can also generate one or more user interfaces for displaying selected portions of the stored health data and the predictions.