How A University Leveraged Oracle R Enterprise for Enhanced Insight into Graduation Rates
We followed CRISP-DM or Cross-Industry Standard Process for Data Mining. The general CRISP-DM process model includes six phases that address the main issues in data mining. The six phases fit together in a cyclical process designed to incorporate data mining into your larger business practices.
|
To mine, model, and predict we used Oracle R Enterprise. For visualization of the results we used OBIEE. R is an open-source language and environment that supports:
As mentioned previously, R is a statistics language that is similar to SAS or SPSS.
|
|
Oracle R Enterprise (ORE) contains a statistics engine, and provides transparent access to database-resident data from R
We gathered data from different sources into R, joined them into a table and ran several multivariable regressions.
After running several iterations and omitting insignificant variables we got to the final model:
|
Factors such as high school GPA, student's ethnicity, or the amount of financial aid needed had the most significant coefficients. Our level of significance was 0.05. Our final model then consists of parameter filler where by loading new student data we can identify at risk students. |
|
The results and graphical analysis can then be projected into Oracle Business Intelligence Enterprise Edition (OBIEE). The reports and functions are dynamically generated through execution of the SQL query that invokes the R function stored in the database R script repository. Oracle R Enterprise enables graphical, analytical, and statistical insights to be deployed throughout the enterprise using OBIEE.
Results
Teachers and administrators can now identify at-risk students and constructively intervene with personalized assistance. Predict which intervention activities will have the optimal impact on students. At least 25 hours cut off the workload.
Partner SpotLight
Oracle
Oracle has the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce cost..
Our Clients
Acme Brick
Acme Brick turned to MindStream Analytics for help implementing OneStream to replace their outdated TM1 solution.
Alterra
Alterra sought the expertise of MindStream to address the challenges they faced in their Capital Planning process.
ATCO Group
Energy conglomerate ATCO operates worldwide in utilities, power generation, and related services.
Avalon
Working with MindStream Analytics, Avalon Healthcare Solutions adopts NetSuite Planning and Budgeting to accelerate budgeting and forecasting processes.
Bayer Health Care
Bayer Healthcare implemented Hyperion Planning and Workforce Planning in 10 weeks to dramatically streamline their Income Statement budget and Workforce Planning process..
Celgene
An Oracle Hyperion Planning Upgrade provides multi-national organization Hyperion Application optimization and stabilization.
Cleaver Brooks
OneStream XF was chosen as the platform that would transform Cleaver-Brooks' Finance processes.
CoorsTek
The collaboration between CoorsTek and MindStream resulted in significant improvements in CoorsTek's financial consolidation and reporting processes.
Enlyte
Enlyte, a merger of Mitchell, Genex, and Coventry, faced challenges with disparate financial solutions and the need for combined reporting.
Interface
Interface used a complex, manual, excel-based FP&A process for monthly review, and the summary data was loaded in OneStream.
Kymera International
Thanks to Mindstream Analytics' assistance, Kymera was able to load all of their data into OneStream and validate it successfully.
MEPPI
MindStream's expertise and experience were sought to conduct a vendor selection initiative focusing on MEPPI's F2023 planning process.
Plaskolite
By migrating to OneStream, Plaskolite has achieved a material reduction in consolidation time and overall Financial Close cycle, eliminated the hours spent compiling and verifying data in Excel, streamlined its Planning, Budgeting and Forecasting model and delivered flexible and timely reporting that enables more strategic analysis of their financial data.
Simon
Simon's existing corporate Hyperion Financial Management (HFM) production application was consolidating at a rate of seven hours, a performance issue causing great headache to corporate Accounting.
UPenn
MindStream Consulting and AppCare team members are proud be working side by side with UPenn university in accomplishing this implementation and along with continuing our AppCare services after go-live.
USG
USG was an Oracle Hyperion customer realizing that it needed more specialized support for its various Oracle Hyperion applications.
Vantiv
DIVIDING A HYPERION PLANNING APPLICATION, EXPANDING THE HYPERION FOOTPRINT TO FORECAST ON THE BUSINESS? CUSTOMER CATEGORIES
Versant Health
Versant Health engaged MindStream to help resolve the challenges they were experiencing with their consolidation, close, and financial reporting processes
WeWork
MindStream Analytics determined that the best solution was to implement Oracle Essbase Cloud as part of the Oracle Analytics Cloud (OAC) platform-as-a-service
WindStream
INNOVATIVE USE OF ESSBASE TO STREAMLINE AND CONNECT HYPERION FINANCIAL MANAGEMENT FOR ENHANCED FINANCIAL ANALYSIS