Business Intelligence
Overview
Business Intelligence or BI is a broad category of applications and technologies for gathering, storing, analysing and providing access to data to help enterprise users make better business decisions. At the university BI is part of Planning and Performance Reporting's portfolio and the capabilities developed will be used to support Performance Reporting and the Institutional Planning and Performance Framework.
Business Intelligence is delivered via both the Oracle BI Discoverer tool and the Cognos Business Intelligence platform. Oracle's BI Discoverer is the university's "self service" ad-hoc querying tool that empowers data savy business users to gain immediate access to information. Cognos Business Intelligence is the University's strategic platform for BI and will be used to deliver all new capabilties moving forward. It is an integrated platform that provides tools for:
- Ad-hoc Querying and Analysis
- Online/Prompted reporting
- Pixel Perfect Reporting and Briefing Books
- Dashboards/Scorecards/Metrics
- Planning, Budgeting and Forecasting
Both these environments draw on integrated data sets from the university's data warehouse.
BI Discoverer
BI Discoverer provides access to the following areas in the data warehouse: Student Profiling, DEEWR data and the results of the Australian Graduate Survey (CEQ/GDS).
University Staff Access Only
BI Discoverer is only available to current University of Adelaide staff who have completed Discoverer Data Warehouse training. This course, comprised of two half-day sessions, can be booked through the University Course Booking System.
Although anyone who completes the training will be granted access, managers and supervisors should carefully consider which staff in their area are suitable. Staff chosen to attend training should have a good understanding of the business processes that collect data in PeopleSoft systems and be familiar with database concepts. Additionally business units are encouraged to implement the "power user" concept where only one or two appropriately skilled individuals become experts extracting information on behalf of the area.
To create/view/modify your own reports connect to Discoverer below:
- Launch Discoverer via the Start Menu > Oracle Discoverer 10.1.2 v003
Discoverer User Reports
The BI team, with valuable direction from the user community, has developed a series of generic investigations that are focussed on the various processes run throughout the University. These reports will aid the University in accessing a single source of data revolving around a particular process - for example: tracking student enrolments. Users are encouraged to save the shared workbooks for their own use and refine the investigations to suit their specific purposes.
The workbooks are available to BI Discoverer users who have attended the appropriate course and have appropriate user access. Access is available to those who have attended and completed the BI Discoverer training provided by the University. They use the latest available information from the data warehouse while also offering the ability to analyse underlying data, amend presentation formats and export to other desktop tools.
If you have any comments or suggestions please contact Planning and Performance Reporting on 831 30552.
- Academic Performance
This workbook comprises sheets exploring academic performance and progress, highlighting opportunities for follow up with specific target cohorts.
- School Prizes
- Honours Target
- Multiple Course Failures
- Enrolment Previous Pass
- Grade Distribution Subject Area
- Selected Course History
- Progam Trasnfers (All)
- Program Transfers (Inter Fac)
- Progression (Specific)
- Progression (Undergraduate)
- Cohort Tracking
This workbook tracks cohorts from various bridging programs like Degree Transfer Programs (DTP), Eynesbury Foundation Studies, Bradford Foundation Studies and Pre-Enrol English Program (PEP).
One shows University wide information and the other prompts you for the cohort's first University of Adelaide degree plan.- DTP Cohort GPAs - Uni Wide
- PEP Cohort GPAs - Uni Wide
- Bradford FSP - Uni Wide
- DTP Cohort GPAs - Specific Plan
- PEP Cohort GPAs - Specific Plan
- Bradford ESP - Plan
- Eyenesbury FSP - Uni Wide
- Eyenesbury FSP - Specific Plan
- Course Analysis
This workbook tracks students who have enrolled in a specific course in a specific term and then lists all their subsequent course enrolments details after that term.
- Course Analysis
- Availability of Course & Term
- Enrolment Tracking
Follows the progress of how many students are currently enrolled in programs.
- Students in Plans - Program Owner
- Teaching Spread for Program Owners
- Student in Plans - CourseVsProg Owner
- Program Owner Spread for Teaching
- Students and Load - Teaching Faculty
- Course Owner Spread for Program Owner
- Outstanding Re-Enrolments (Sum)
- Outstanding Re-Enrolments (Sum)
- GPA Performance Analysis
This workbook has various worksheets calculating the GPA.
- Award Ranking
- Award Improvers
- Award Summary
- Demographics
- Course Analysis by GPA
- Course Teaching Analysis
- Source Inst Summary
- Source Inst Detail
- International Book
This workbook comprises investigations focused on monitoring known performance measures and business needs for the International Office related to the management of Students and their performance. Note that all sheets in this workbook use a common filter to restrict results to international students only.
- Course Enrolment Trend
- Course Measure Trend
- Country Analysis
- Enrolment Growth
- Take up Analysis
- Take up Rates
- Program Enrolment Growth
- Performance Variance
- Performance Correlation
- Program Review & Monitoring Reports *
The workbook details data gathering required for program reviews.
* The Covering Notes should be read before attempting to run the various workbooks. The notes explain the contents of each worksheet and how to interpret them.
- Offer Rate
- Number EFTSL
- Home Country
- Gender
- Equity
- Completions
- Funding Group
- Admissions
- Pass Rate
- Students Lost
- Students Retained
- Grades
- Student Profiling Course Enrolments
Follows the progress of how many students are currently enrolled in programs.
- Load Performance
- Program Performance
- Basic Load On/Off Shore
- International BCOM IELTS
- High Drop Rate
- Fund Cluster Summary
- Companion Course Analysis
- Grade Distribution
- Student Profiling Regular Reports
Follows the progress of how many students are currently enrolled in programs.
- Offer Acceptance Rate University
- Offer Enrolment Rate Program
- Equity Enrolments
- Load Pass Rate Teaching
- Funding Group Teaching
- Narrow Program Teaching
- International Home Regions
- Time Tabling Aids
This workbook attempts to provide those connected with the challenging task of timetabling some flexibility in analysing course combination pathways. Ideally, inclusion of timetabling metrics direct from the source system into the warehouse would provide the most effective access, but some improvements can be delivered through the examination of student enrolment information, and that is what is presented here. Note these sheets are very similar, as the first restricts the investigation to pathway for a specific academic plan; the second allows analysis of pathways for all plans related to the selected courses.
- Plan Course Combinations
- Course Combinations Plans
- Course Combinations Analysis
- Course Combination Trend
- Updated Reports *
* The Covering Notes should be read before attempting to run the various workbooks. The notes explain the contents of each worksheet and how to interpret them.
Further reports that are available:
- Full & Part Time for UG/PG
- Mail Merge Student Records
- Graduation Rate
- Subject Catalogue Review
- Unsatisfactory Academic Progress
- Attrition Rate Report
- Academic Performance
Cognos BI
Cognos BI is user licensed and therefore only available to staff who require access to one of the following areas as part of their core job function:
- Student Load Performance Reporting (actuals, targets and projections)
- LMM - Load Management Model (program, teaching and funding targets)
- Program Performance Reporting (consolidated KPI's for each program)
- Course Review templates
- Payroll and Commitments Reporting
- SMM - Salary Management Model (budget and forecast)
The following link will open the Cognos BI portal for authorised users:
- Connect to Cognos (Staff only)
For access enquires contact Adam Gardner (Manager, Business Intelligence): adam.gardner@adelaide.edu.au
BI University Reports
The following reports have been compiled to provide access to information required regularly by university management and decision-makers. They use the latest available information while also offering the ability to analyse underlying data, amend presentation formats and export to other desktop tools.
If you have any comments or suggestions please contact Planning and Performance Reporting on 831 30552.
University Staff Access Only
- Student Profiling Information
Explanatory Notes
(all reports contain data from 2002 onwards) - Survey Information
Benchmarking (Institution) from 2002; University of Adelaide (Faculty) from 2004
Please note: It is recommended that you read the GCCA Code of Practice
before accessing the GDS/CEQ information.Graduate Destination Survey (GDS) Course Experience Questionnaire (CEQ) % Working Full-Time and % in Further Study by Institution Core Scales % Agreement by Institution % Working Full-Time and % in Further Study by Faculty Core Scales % Agreement by Faculty % Working Full-Time and % in Further Study by Program/Plan Core Scales % Agreement by Program/Plan - DEEWR/DIISRTE Information
User Support for Census Products not in Discoverer or Pivot Tables
A significant amount of information can be found in Excel pivot tables on the statistics pages. This information is updated on a timely basis.
Assistance
Each data subject area has a designated PPR staff member who can provide assistance when your requirement cannot be met by the Excel pivot tables. For details see the Help & Contacts tab.
Help & Contacts
- Cognos BI: Exporting to Excel PDF
- Open the Internet explorer Browser
- Click Tools
- Click Internet Options (the following box will appear)
- Go to the Security Tab (the tabs are at the top of the box), the following box will appear
- Click Custom Level
- Under Settings look for Automatic Prompting for File Downloads
a) Check the Enable Circle
b) See the following box
- Click OK
- Click Apply
- Click OK
Note: If you still cannot export to Excel check and make sure that you do not have any additional toolbars installed or pop-up blocker's enabled.
To uninstall toolbars
- Open your Internet Explorer browser
- Go to View>Toolbars
- Uncheck inappropriate toolbars
a. The only necessary toolbars are Menu, Status bar, and Adobe PDF
b. Uncheck (Google, Yahoo, and others like these) - Uninstall toolbars (only if you had any to uncheck)
- Go to Start > Control Panel
- Click Add or Remove Programs
- Search for the toolbar that you want to uninstall and Click on them
- Click Remove
- Close out when finished
To turn off pop-up blocker
- Open your Internet Explorer browser
- Go to Tools>Pop-up Blocker>Turn Off Pop-up Blocker
- Trouble logging into BI Discoverer (Java Issue)
In order to run Discoverer, please ensure the following setting is turned on in the Java Control Panel by following these simple steps or download the PDF user guide.
After connecting to 'Production Warehouse' this is where the Java Security setting error occurs as shown in the diagram below or a red cross withinn a new window
Please go through the following steps:
- Close existing Internet Explorer (Recomended browser)
- Select Start > Control Panel > Java (not Java Plug-in) - If you do not have Java in your 'Control Panel' please place a call to ITS on ext. 33000.
- Select the Advanced tab > drop down Security > General as seen the screen above.
- You will see the following screen
- Select the checkbox titled 'Use SSL 2.0 compatible ClientHello format' to activate it.
- Log back into Discoverer as well as the 'Connect to OracleBI Discoverer' page and log back into 'Production Warhouse'
- If a security message appears press yes to 'Run'
If you are having further difficulty running Discoverer, then please call ITS on ext. 33000
- Follow the steps in the attachment to turn on a Java setting. If you still have problems then:
- Phone or email the ITS help desk and check that you have been added to a Vista group called GPO_OracleDiscoverer1012. You will need to re-boot your PC after you have been added to this group.
- Direct ITS to uninstall and re-install Java via remote logging as specified by Business Intelligence, Planning and Performance Reporting
- If you are still having difficulty, you can call BI Team on ext. 35588.
- Contacts for Student Data & BI Discoverer Queries
Planning and Performance Reporting has a team of experts in specific areas as listed below:
Business Area Planning and Performance Reporting Staff Phone Research Statistics Federico Santa Ana 831 38386 DEEWR/DIISRTE (Students Statistics) Senaka Arachchi 831 34823 DEEWR/DIISRTE (Staff & Publications) Ming Goh 831 34719 Survey Information (CEQ/GDS) David Hirst 831 30552 - Contacts for Cognos Business Intelligence Queries
For any queries concerning Cognos BI please notify the following staff:
Business Area Contact Details Phone Changes or more reports? BI Manager - Adam Gardner
BI Team email - dadmin02@adelaide.edu.au831 33257 Payroll & Commitment Reports Human Resources - Workforce Information Unit 831 33111 SMM Queries Financial Services - Greg Edmonds 831 34669 LMM Queries Planning & Performance Reporting - Mary-Anne Craddock 831 36431
