ERMIS: Architecture and reporting

ERMIS conceptual architecture

Selected subject areas from each source system have been integrated to create the foundation of the ERMIS database. Data extracts are obtained from each source system on an agreed upon scheduled frequency.

The figure below illustrates the various sources of information currently being utilized by ERMIS:

ERMIS Sources

* Corporate Data Warehouse

** National Fire Protection Association

It is important to note that the data reported by the ERMIS solution are not granular in nature. The system is not intended to replace or become a substitute for any of the existing source systems referenced. Rather, the system provides a high level perspective and directional trends which can be further investigated in respective source systems as needed.

Dashboards and report development

UCOP has identified ERMIS as the dashboard reporting solution that will be used to provide business users with relevant and actionable information regarding their KPIs. It will allow them to make decisions in a more efficient manner than they could with existing resources and without a dashboard reporting functionality.

Dashboard and Reports

ERMIS as a business intelligence tool will be an integral part of the data warehousing architecture that will be used to navigate through the data acquired from the various sources. The business intelligence derived from dashboard and scorecard reporting is far more than a technical project. It requires an understanding of the University's processes and the environments in which the information is produced and where it will be consumed.

A number of core functional requirements were gathered and examined prior to the development of the ERMIS dashboards. Those requirements describe functionalities and capabilities needed by such a system in order overcome existing basic business challenges.

View more information about ERMIS dashboards and KPIs.

Report types

When it comes to the exchange of data, it is understood that internal, operational, and consumer-facing reports are the primary vehicles for the communication of information in the UC environment. Capabilities of ERMIS include the following:

Report Types
  1. Standard Reports
  2. Dashboards
  3. Guided Analytics / Interactive Reports
  4. Personalized Reports
  5. Managed Ad hoc Reports
  6. Alerts and Notifications
  7. Syndicated Reports
  8. Cohort Analysis
  9. Visualizations

 

Report Visualizations 

Based on the results of user discussions on report types, the enterprise reporting solution should be intuitive enough to encourage broad adoption across various user communities in support of current and future risk management initiatives.

Implementation

The implementation of dashboard reports and associated data is expected to occur in waves. The initial launch of dashboard reports includes 11 KPIs focused on various aspects of Safety and is entitled "Safety Index". Future KPI dashboard reports will be developed and implemented during a system-wide growth phase. Subsequent rollouts will include both campus and medical center locations. With a continued focus on risk management, potential KPI development activities involve collaboration with the following subject areas:

  1. Medical Centers
  2. Human Resources
  3. Waste Reduction and Recycling
  4. Environmental Health and Safety

It is anticipated that among these subject areas, there will be other domains where dashboard and related reports can be specified to meet the specific needs of each location.

Access and support

Currently, the Office of Risk Services is able to provide access to ERMIS to additional users, based on requests from the UC Campus or Medical Center representatives. Once users are granted access, the ERMIS will make location-specific data available, in conjunction with enterprise trends based on user privileges. This will facilitate a better understanding and management of the cost of risks across the enterprise.

The ERMIS Dashboard Portal allows users the ability to find, manage, organize and view UC business intelligence content such as reports, scorecards and agents. A quick tour of these features is available by selecting "Quick Tour" once access to the application has been granted.

ERMIS Portal

The Office of Risk Services has created an ERM interest list for future project requests, dashboard and report development activities. Projects added to this list can involve the integration of new and existing data or the customization of the existing ERMIS dashboards to meet the needs of each location respectively.

For additional information, or to obtain a user name and password for the Enterprise Risk Management Information system, please email ERM.