![Page 1: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/1.jpg)
Contact Us510.818.9480 | www.kpipartners.com© KPI Partners Inc.
Start Here
Kumar Krishnaswamy | GM, KPI Partners
Venkataramana Nidugondi | Product Manager, Oracle
Oracle Student Information AnalyticsOracle BI Applications 11.1.1.7.1
![Page 2: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/2.jpg)
2
Agenda
![Page 3: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/3.jpg)
3
① BI Apps 11.1.1.7.1 Overview
② Introduction to Student Information Analytics
③ Exploring Student Information Analytics
④ Demo
⑤ Q & A
AgendaAgenda
Oracle Student Information Analytics
![Page 4: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/4.jpg)
4
BI Applications 11.1.1.7.1Overview
![Page 5: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/5.jpg)
5Unpacking The New Oracle BI Apps (Now With ODI!)
Pre-built warehouse Designed for Analysis & Reporting
1
Pre-built ETL Extract Data From Popular ERP
3 4 Pre-built MetadataCalculations & Metrics
BI Applications 11.1.1.7.1 Overview
Pre-built MetadataCalculations & Metrics
Presentation layer
Logical business model
Physical sources
2
![Page 6: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/6.jpg)
6Unpacking The New Oracle BI Apps (Now With ODI!)
BI Applications 11.1.1.7.1 Overview
![Page 7: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/7.jpg)
New visualizations such as performance tiles
ODI as the data movement tool
Released on FMW 11.1.1.7
BI Apps Config Manager & other tools
Golden Gate for near real-time loads
Expansion of content and new products
Summary of Features
BI Applications 11.1.1.7.1 Overview
Oracle Student Information Analytics
![Page 8: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/8.jpg)
BI Applications 11.1.1.7.1 Overview - Takeaways
Oracle Student Information Analytics
BI Applications 11.1.1.7.1 – Significant new releaseGo to the KPI Partners website for several recordings, webinars and other material detailing this new release
![Page 9: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/9.jpg)
9
Introduction toStudent Information Analytics
![Page 10: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/10.jpg)
10
Business ValueDriving Student Success
Oracle Student Information Analytics
Measuring Institutional Performance• How can I improve Student Retention and define
Student Success across the Institution?• How do I measure student access, degree attainment
and cost of education.?
Operational Complexity• How do I simultaneously minimize cost of graduation
and ensure consistently high quality of education?• How do I meet the demands of new learning
methods?
Financial Resources• How can I provide adequate funding to maintain
quality, improve access, and increase student success?
• How can I effectively manage student billing, collections and financial aid?
Execution• How can I reduce the decision cycle for admissions?• How can I manage the wait lists and enrollments
efficiently?
![Page 11: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/11.jpg)
Application Content
Oracle Student Information Analytics
Major Content Areas
Recruitment and Admissions
• Admissions Funnel
• External Test Scores
• Applicants, Applications, Status
• Recruitment Performance
Student Records
• Academic Plan & Progress
• Courses & Enrollments
• Institutional Summaries & Demographic Analysis
Student Financials
• Charges & Payments
• Aging• Credit History• Transaction
Details
![Page 12: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/12.jpg)
Application Content
Oracle Student Information Analytics
Pre-built Dashboards
Admissions and Recruiting
Student Records
Executive Overview
Student Self-Service
![Page 13: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/13.jpg)
13
Roles Served University / Campus Executives
Institution / Campus President Campus Provost Deans of Admission, Administration, Academic Affairs
Bursar / Student Accounts Manager Registrar Students – Self Service Student Campus Solutions Administrator Many Others!
Oracle Student Information Analytics
Application Content
![Page 14: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/14.jpg)
14
Pre-built Content• Built on BI Applications
platform – • Common Information Model,
Conformed dimensions, next generation ETL(ODI), Security model etc.
17 Pre-built Dashboard pages, 130+ Reports
Nearly 400 Metrics
Foundation for Fusion Student Information Analytics
Oracle Student Information Analytics
Application Content
![Page 15: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/15.jpg)
15
Features Summary level KPIs with drill
down capabilities to identify exceptions
Cross-functional analysis capabilities with Financial Analytics, Procurement & Spend Analytics, HR Analytics and other BI Apps
Exalytics and BI Mobile certified
Certified through Campus Solutions 9.0, Bundle #27
Oracle Student Information Analytics
Application Content
![Page 16: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/16.jpg)
Application Content Takeaway
Unpacking The New Oracle BI Apps (Now With ODI!)
New Application with pre-built Analytic ContentFully Integrated with other BI AppsPre-built metrics/KPIs and role-based dashboards
![Page 17: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/17.jpg)
17
Exploring Student Information Analytics
![Page 18: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/18.jpg)
18Oracle Student Information Analytics
• Application Content
Business Objectives /
Issues
GainInsights
Take Action Target recruiting efforts to expedite applications
processing
Is the conversion ratio of Prospects to Enrolleestrending up?
Review Admissions Funnel for Prospects, Applicants,Admissions, Confirmations and Enrollment.
Optimize Recruiting Effectiveness
Drill to D
etail
Is there a delay in processing and confirmingadmissions?
Does Recruiter / center performance vary by Region, Recruiting category etc?
Drill to applications pending confirmation and recruiters below the target levels
Business Function: Recruiting and Admissions
Role: Director of Admissions
Objectives:– 1) Optimize
Recruiting Effectiveness
– 2) Resolve Bottlenecks
Sample Decision WorkflowRecruiting and Admissions
![Page 19: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/19.jpg)
19
Hierarchy of Pre-Built Metrics
Oracle Student Information Analytics
Exploring Oracle Student Information Analytics
Action LevelMetrics
OperationalLevel Metrics
Strategic Level Metrics
Student Population
Retention count
Graduation Count
Degrees Awarded
Applicant to Admit Ratio
Applications Received
Applications Accepted
Receivable outstanding from
Students
Average GPA
Class Enrollment
Waitlist
Application Count by Status
Grade Points
Application in Waitlist
% Chg Year Ago Enroll Count
Application Evaluation Count
Year Ago Average GPA
Student to Instructor Ratio
Year Ago Encumbered Amount
GL Assessment amount
Assignment Percentage
Week Workload Hours
Assignment FTE%
![Page 20: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/20.jpg)
20
Example Star Schema
Oracle Student Information Analytics
Exploring Oracle Student Information Analytics
Example Metrics• Admission Rate (derived)• Enrollment Rate (derived)• Offers of Admission Count (derived)• Yield (Applicants to Admits) (derived)• Yield (Admits to Enrollees) (derived)
Features This contains data on the application status changes and the effective dates. Each status change is represented as a row in the table.
Student Admission Application Status
Program Status
Academic Sub-PlanAction Reason
Academic Level
Program Action
PersonAcademic
Load
Campus Academic Plan
Academic Career
Academic Program
Academic Institution
![Page 21: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/21.jpg)
21
Multi-Source ETLExploring Oracle Student Information Analytics
Oracle Student Information Analytics
Sou
rce
Sys
tem
s
PeopleSoft Campus Solutions
Intermediary Table
Non-Oracle Sources Export to Flat File Staging Table
Warehouse Table
![Page 22: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/22.jpg)
Exploring Student Information Analytics - Takeaways
Oracle Student Information Analytics
Engineered to Answer Business Process QuestionsEngineered to Support Diverse Source Data Environments
![Page 23: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/23.jpg)
Final Takeaways
Oracle Student Information Analytics
Brand New Application Content to Support Student Information Analytic RequirementsFully Integrated & Conformed with other Oracle BI Applications New Architecture with Release 11.1.1.7.1
![Page 24: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/24.jpg)
24
Q & A
![Page 25: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/25.jpg)
Who Is KPI Partners?www.kpipartners.com
The Leader In Oracle BI & EPM 25
Strategic Consulting | Systems Implementation | TrainingTransform Data Into Insight
Staff built from Oracle/Siebel/Hyperion engineering teams
On-site, off-shore and blended shore delivery models
Exclusive pre-built solutions for Oracle BI & E-Business Suite
Oracle BI
Hyperion
Endeca
Exalytics
![Page 26: Student Information Analytics for Oracle Campus Solutions](https://reader033.vdocuments.us/reader033/viewer/2022051514/54923054b47959a12d8b4627/html5/thumbnails/26.jpg)
26
KPI World Headquarters39899 Balentine Drive
Suite #375
Newark, CA 94560
Phone: (510) 818-9480
Email: [email protected]
Web: kpipartners.com/contact
Customer CareContact Us
The Leader In Oracle BI & EPM
New York, NY
Chicago, IL
Boston, MA
Minneapolis, MN
San Diego, CA
Greensboro, NC
North America Offices
Bangalore, India Hyderabad, IndiaGlobal Offices