A computer software application and methods for facilitating analysis of clinical data (e.g., patient or patient care information) stored in a clinical database is disclosed. The application includes a process extracting clinical data from the clinical database and loading the extracted data into an analytics database. The application further configures the analytics database in accordance with a data model that is optimized for business intelligence reporting tools, e.g., in the form of multidimensional data cubes which can be derived from tables of data. The application further includes procedures (e.g., SQL procedures) for applying clinically related logical rules to the clinical data and storing flags associated with the logical rules in the analytics database.