Information Technology Strategic Planning

Projects

Project Title:

Merced Academic Resource System (MARS)

Project Advocate:

Mariette Araya

Project Manager:

Mariette Araya

Project Overview:

Develop and support datamart to enable reporting and analysis in the areas of faculty workload, instructional space utilization, and TIE course categorization.

Key Stakeholders:

Office of Institutional Planning and Analysis

All administrators who can benefit from analysis of the data.

Benefits:

Provides support for planning and decision making related to academic resources.

Project Deliverables:

Integrated datamart containing student, PPS and facilities data.
Metadata and supporting documentation to support use of datamart.
Reports and data file outputs using datamart as source.

Initiative(s) Supported:

Related Projects:

Milestones:

Identify (and possibly establish) systems of record for source data.
Development of ETL processes from systems of record to MARS datamart.
Design and build datamart data model
Document ongoing procedures for periodic refresh of datamart.
Develop metadata, reports and data file outputs.

Costs & Funding (Capital & Operational):

MARS primarily leverages other systems (ODS, Business Intelligence Platform), without introducing additional costs.

Project Team:

Nancy Ochsner, IPA
Chris Speckens, IPA
Gary Lowe, IPA
John Souza, IT
Members of functional offices responsible for source data (Registrar, Academic Personnel, others).

Issues/Risks:

Difficulty of identifying system of record for some required data, such as instructional space data could impact project success.
Data quality problems in systems of record could impact project success.
Competing priorities of project team members could delay progress.
Dependency on implementation of Business Intelligence Platform project could delay progress.
Data governance issues could delay project or cause it to fail.


Looking for help?

We offer a number of tutorials and FAQs available in the Guides & FAQs section.

If you have any questions, problems, or comments, please contact the IT Help Desk via email at helpdesk@ucmerced.edu, via phone at 209.228.HELP (4357), or visit them in the Classroom and Office Building room 132A.