MICROSTRATEGY DATA WAREHOUSE

Information Technology manages a data warehouse for the University community.  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.

The University of Miami Data Warehouse uses the MicroStrategy Business Intelligence Software Platform. In addition to the web version, there is also a client-server option that can be used by "power users" to do more sophisticated analyses.   For additional information, please contact datawarehouse@miami.edu.