Contents
1 Introduction
2 Subject Areas
- Overview
- Higher Education - Admissions Applications Real Time
- Higher Education - Checklist Assignments Real Time
- Higher Education - Enrollment Real Time
- Higher Education - Person Attributes Real Time
- Higher Education - Person Real Time
- Higher Education - Service Indicators Real Time
- Higher Education - Sponsor Agreement Real Time
- Higher Education - Student Accounts Real Time
- Higher Education - Student Credentials Real Time
- Higher Education - Student Programs Real Time
- Higher Education - Student Results Real Time
- Higher Education - Task Assignments Real Time
- OTBI Performance Real Time
- OTBI Usage Real Time
- Security - Audit Real Time
- Security - Roles and Privileges Real Time
3 Business Questions
- Overview
- How many applicants have submitted an application?
- How many applications do we have?
- Who are the applicants and their contacts?
- What is our applicant diversity?
- How many applicants are in each program and academic group?
- What is the distribution of applicants per campus?
- Which forms are used most frequently?
- What are the feeding schools?
- What are the extracurricular types?
- Which types of extracurricular activities are most common?
- Who are the recommenders for each applicant?
- What is the status for each application?
- How many checklist assignments do we have for an institution?
- Who has checklist assignments?
- What is the address of checklist assignees?
- What is the status of the checklist assignments?
- When are the assigned checklists due?
- When were the assigned checklists completed?
- How many enrollments do we have with any combination of academic period, institution, campus, reporting period, and academic organization?
- Which sections have seat capacity field above or below a certain percentage?
- Which campuses have higher enrollment?
- What are the courses being offered?
- What is the trend of enrollment by academic period and/or reporting period?
- How many students does the institution have with any combination of academic organization, academic period, campus, institution, and reporting period?
- Which courses are students enrolled in and dropped from?
- How many students have dropped all sections?
- Who are all the students in all my sections?
- What is our student diversity?
- Who are the students' emergency contacts?
- How many attribute assignments do we have for a person?
- What is the address of the assignee?
- What is the phone number of the assignee?
- What are the service indicators used at the institution and/or academic organizations?
- What are the service impacts used?
- What are the service indicators and corresponding assignment dates for each student?
- Which students can't enroll due to existing service impacts?
- What is the average time between an assignment and release of a service impact and/or service indicator?
- What is the trend of service indicator and service impact assignments?
- What are the credentials awarded by the institution?
- How many credentials have been awarded on each campus of the institution?
- What programs award more?
- What are the top-k credentials awarded?
- What credentials were awarded by completion period?
- What are the programs available at the institution by campus and academic group?
- How many students are there in each program?
- What is the trend of student program by admit period?
- What are the diversity details for each program?
- How many students are active in a program, and how many discontinued or paused each of their programs?
- What is the grade roster for each section?
- How many courses have pending grades?
- What is the results breakdown for each section?
- How many students passed or failed in graded sections?
- How many units have students earned and enrolled in?
- Which campuses have better or more deficient result outcomes?
- What is the results trend by sections?
- What is the student load by institution and campuses?
- What is the trend of student load?
- Which students need tuition calculation?
- What are the fee groups used at the institution?
- Which students require tuition calculation and hold calculation?
- What are the reporting periods for the students with calculated tuition, and which ones are pending?
- What are the programs with students pending tuition calculation and calculation holds?
- What is the trend on calculation holds at the institution?
- How many students still owe us for the program?
- What is the trend of students selecting only add-ons?
- Can I get a list of all the students who have paid us?
- Which students are enrolled but not charged yet?
- Which external organizatons have agreements?
- What is the status on each agreement?
- How many task assignments do we have for an institution?
- Who has task assignments?
- What is the address of task assignees?
- What is the status of the task assignments?
- When are the assigned tasks due?
- When were assigned tasks completed?
- How many users run OTBI analyses?
- Who are the top N OTBI users?
- What is the weekly OTBI analysis usage trend?
- What are the top N most frequently-run OTBI analyses?
- How many predefined OTBI analyses have been run in the past month?
- How many custom OTBI analyses have been run in the past month?
- How many ad-hoc OTBI analyses have been run in the past month?
- What is the execution history of dashboard X in the past month?
- Which analyses have low usage in the past month?
- How many OTBI SOAP web services have been run in the past month?
- What are the long-running analyses in the past month?
- What is the OTBI execution time histogram in the past month?
- Which analyses have the longest response time?
- Which analyses have high data row count?
- Which analyses reached OTBI max row limit?
- What are the common execution errors in the past month?
- How many analyses and dashboards failed in the past month?
- What are the most commonly used OTBI subject areas?
- What are the least-used OTBI subject areas?
- Which subject areas have slow performance?
- Which subject areas have large data volume?
- Which analyses have low usage because of poor performance?
- What is the database SQL execution time and row count?
- Why am I not able to view certain subject areas with my login credentials?
- Which data security policy would provide access to the data I need to see?
- Can I view and edit a particular page? If yes, which functional security policy do I need to provide to a user who needs similar access?
- I have not added a specific role to a user, but the user seem to have this job role. Can I trace how has this been inherited by the user?
- What are all the data security privileges that a specific user added?
- Which roles were added with a specific functional security policy, and who added them?
4 Job Roles
- Overview
- Academic Coordinator
- Admissions Coordinator
- Admissions Manager
- Application Administrator
- Application Implementation Consultant
- Bursar
- IT Security Manager
- Registrar
- Student Adviser
- Student Services Manager
5 Duty Roles
- Overview
- OTBI Report Performance Transactional Analysis Duty
- OTBI Report Usage Transactional Analysis Duty
- Security Transaction Analysis Duty
- Student Account Inquiry Transaction Analysis Duty
- Student Application Inquiry Transaction Analysis Duty
- Student Credentials Inquiry Transaction Analysis Duty
- Student Enrollment Inquiry Transaction Analysis Duty
- Student Programs Inquiry Transaction Analysis Duty
- Student Results Inquiry Transaction Analysis Duty