Decision Support Services

Partnering with business owners, data custodians, and users, the Decision Support Technology unit’s role is to provide services in Business Intelligence. Business Intelligence is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, and operational insights and decision-making.

In order to provide nontechnical users the ability to access information easily and from a single source of truth, we support the use of an enterprise data warehouse environment. Our current environment leverages the data from the University’s administrative systems and delivers information in reports using Microstrategy and the Research Reporting System. With the implementation of Enterprise Resource Planning (ERP) applications, we anticipate future development of the Oracle Business Intelligence Enterprise Edition platform.

    

Data Warehouse

About Us

Information Technology manages a data warehouse for the University community.  Our current environment leverages the data from the University’s administrative systems and delivers Information in reports using Microstrategy and the Oracle Business Intelligence Enterprise Edition (OBIEE). The Data Warehouse is a set of databases that can be used to prepare reports from data for which the user has authorized access.  The key feature of data warehouses is that the tools to prepare reports are very user-friendly (web-based, using point-and-click technology).  The warehouse includes data from major University systems - financial, student, human resources, and space management.  The data warehouse solution is composed of two parts: the data repository component and the reporting and analysis tool set.  The benefits of this combined solution are:

  • Easy to use - A data warehouse provides a common data model regardless of the data’s source. This makes it easier to report and analyze information than it would be if multiple data models were used to retrieve information.  Additionally, prior to loading data into the data warehouse, inconsistencies are identified and resolved. This greatly simplifies reporting and analysis.
  • Tools provided are easy to understand and use, with no intensive training being necessary.
  • Format of data - Data is understandable, both on a stand-alone basis, and in its relationship to other data. Information in the data warehouse is under the control of data warehouse users so that, even if the source system data is purged over time, the information in the warehouse can be stored safely for extended periods of time.
  • Availability of product - The tool is available most of the day, at least normal working hours, plus evening time.   Because they are separate from operational systems, data warehouses provide retrieval of data without slowing down operational systems.
  • Security - Administration is able to restrict data available to each user for their needs and responsibilities.

OBIEE will eventually replace the Microstrategy reporting tool; Student Admission, Current Student Reporting and Course and Enrollment data are already transitioned to OBIEE. Future development will include Human Resources, Financial and other data.   For additional information, please contact datawarehouse@miami.edu.

Training Guides

Access Forms

Requesting access to the Data Warehouse: The University has established an institution-wide system of computer data and information. University employees and faculty members are given certain types of access to certain databases consistent with their position and job responsibilities.

All system users must keep information obtained from system access confidential except as otherwise necessary to perform the task assigned. In all instances authorized system users and restricted access system users are responsible for having knowledge of and complying with all laws and University policies relative to confidentiality.

Access to the Data Warehouse requires a signature to indicate acceptance of the University of Miami data access policies. Additionally, access must be approved by the appropriate Data Custodian for most systems. The Controller’s office must approve access to Financial Records.

In order to request access, please complete a Data Warehouse Access Request Form. Once completed, please submit the form to Decision Support Services at datawarehouse@miami.edu.

Reports