The Data Analytics and Reporting department performs data analytics and reporting activities in support of UMB’s mission, academic enterprise, operations, and administrative services. We participate in ensuring that well-defined, quality data is available for campus leaders, decision-makers, and the University at-large.

Our Vision

Data Analytics and Reporting will work with partners to transform data into a rich body of strategic intelligence that is accessible, well-defined and useful to the campus community (e.g., campus leaders, decision-makers at all levels, faculty, staff, students, and the public).  The office will promote a culture of data-driven decision-making, providing the basis for continuous improvement throughout the institution.

Our Strategic Goals and Objectives

• Expand the use of reporting and analytics into all areas of the university.
• Expand data availability and reporting, and allow for more cross-function analyses.
• Preserve all university data in the data warehouse.
• Improve data quality to ensure all information is reported accurately.
• Improve data literacy by leading the effort to define all data (University Data Glossary).
• Build predictive analytics and artificial intelligence capabilities to improve all aspects of the university’s core activities (e.g., instruction, student-learning, and administrative services).
• Establish and lead a data-governance program.
• Support business intelligence (BI) developers across campus in delivering data insights and their ability to perform self-service reporting.
• Utilize cloud-based services only.

Our Core Services and Activities

• Reports and Dashboards Development
• Reports and Data Documentation
• Data Warehouse Development
• Data Architecture and Modeling
• Data Governance
• Data Quality Assurance

Our Technologies

• Oracle Analytics Cloud (Reports, Dashboards, Semantic Data Layer, Machine Learning)
• Oracle Database (Data Warehouse)
• Oracle Data Integrator (ETL)
• Data Cookbook (Data and Report Documentation, Data Quality, Data Governance)
• HCM Analytics (Prebuilt analytics components for Human Resources data)
• Oracle Autonomous Data Warehouse

Active Universitywide/Enterprise-Wide Projects

• Student Reports Modernization
  • Objectives:
    • Retire Crystal Reports platform by migrating legacy reports to analytics platform
    • Modernized student reporting for Bursar’s Office
    • Build new and modernized dashboards for student data
      
      
  • Human Resources Reports and Analytics for new HR System
    • Objectives:
      • Implement reporting and analytics capabilities as part of the implementation of the new Human Resources system (Oracle HCM)

Supported Reporting and Analytics Subject Areas

The following reporting and analytics subject areas are available to authorized users.

• Quantum Financials Reporting (Quantum Analytics)
• Kauli Research Reporting (Proposals and Awards)
• Equity, Diversity, and Inclusion Public Dashboards (Faculty and Staff)
• Student Accounts Receivables Reporting (Bursar’s Office)
• SIMS/Banner General Ledger Reporting
• eUMB Financial Archives Reports
• eTravel Archives Reports
• Business Agreements (Compliance Office)