MU Student Information System Task Force Presentation

1
University of MissouriTask Force on Reporting
Strategies

• MU Student Information System Task Force
  Presentation
• June 5, 2003

2
University of MissouriTask Force on Reporting
Strategies

• The Charge
• 1. How can the University enhance reporting
  capabilities and respond to the data needs of
  faculty, administrators, students, and staff?
• 2. How can the University address these reporting
  needs in the short-term during PeopleSoft
  implementation and in the long-term once
  PeopleSoft is fully implemented?

3
University of MissouriTask Force on Reporting
Strategies

• The Charge (cont.)
• 3. What strategies are needed to leverage new
  technologies and best practices to support
  reporting?
• 4. What resources, if any, are needed to
  implement any proposed interim and long-term
  reporting strategies?

4
University of MissouriTask Force on Reporting
Strategies

• Task Force Members
• MU
• Barb Breen, Manager Business Fiscal Operations
• Michael Nolan, Professor (Social Science Unit
  Leader)
• Pat Morton, Provosts Office
• Pat Schwartz, Asc Director, SIS
• Members from Academic Area
• Kandis Smith, Ast VP UMSa
• Steve Graham, Asc VP UMSa
• Larry Kaptain, Ast Provost UMKC
• Laura Stoll, Registrar UMR
• Tom Eyssell, Dean UMSL (Business)

5
University of MissouriTask Force on Reporting
Strategies

• Process
• Examined current environment to identify causes
  of problems
• Identified internal and external Best Practices

6
University of MissouriTask Force on Reporting
Strategies

• Process (cont.)
• More than 30 Focus Group sessions involving over
  350 faculty, staff, students, and administrators
• Formulated short- and long-term recommendations

7
University of MissouriTask Force on Reporting
Strategies

• Findings
• Inconsistencies
• Duplication of effort
• Highly complex data structures

8
University of MissouriTask Force on Reporting
Strategies

• Findings (cont.)
• Person dependency
• Problems with cross application reporting
• Problems with academic administration
  information needs

9
University of MissouriTask Force on Reporting
Strategies

• Best Practices - Internal
• Web reporting
• Sharing
• Simple queries
• Legacy warehouses
• Some drill down

10
University of MissouriTask Force on Reporting
Strategies

• Best Practices External
• Well developed strategies
• Separate but coordinated from transaction system
• Integrated data
• New processes, functions, and roles
• University-wide reporting environments

11
University of MissouriTask Force on Reporting
Strategies

• Conclusions Needed Strategies
• Central repository for information needed
• User Driven meeting a variety of user needs and
  technical skill levels
• Includes cross-functional reporting solutions

12
University of MissouriTask Force on Reporting
Strategies

• Conclusions Needed Strategies (cont.)
• Includes historical and external data
• Fosters collaboration between functional,
  technical, and end-users
• Separate from transaction system

13
University of MissouriTask Force on Reporting
Strategies

• Outcomes
• Reduce inefficiencies and duplication of effort
• Empower users information available in an
  intuitive format
• Flexible reporting environment for end-users

14
University of MissouriTask Force on Reporting
Strategies

• Outcomes (cont.)
• Continuous improvement and growth
• Long-term support from multiple systems

15
University of MissouriTask Force on Reporting
Strategies

• Recommendations
• Technology
• Organization
• People
• Processes

16
University of MissouriTask Force on Reporting
Strategies

• Recommendation Technology
• Information Repository
• Current Reporting Instances
• Data Warehouse
• Data Marts
• Report Library

17
University of MissouriTask Force on Reporting
Strategies
18
University of MissouriTask Force on Reporting
Strategies

• Recommendation Organization
• Executive Sponsor
• Primary Point Person
• Similar model on each campus

19
University of MissouriTask Force on Reporting
Strategies

• Recommendation People
• Work teams
• Collaborative system and campus efforts
• Continuing investment in people

20
University of MissouriTask Force on Reporting
Strategies

• Recommendation Processes
• Sharing of needs, issues, and solutions
• Continuous processes to enable feedback to and
  from end users
• Formal processes for Repository maintenance and
  access

21
University of MissouriTask Force on Reporting
Strategies

• Next Steps
• VPs meeting
• Quick wins
• Working Group to provide details, costs, and
  time-lines
• http//www.system.missouri.edu/planning/taskforce.
  html