Division of Student Affairs Business Intelligence Project Site

About

This a is a division-wide effort to provide a reporting/decision support platform. A functional prototype is being iteratively developed and tested. The solution is currently built on the following technologies:

• Oracle DB
• Pentaho Mondrian - online OLAP interface
• MS Excel - advanced multi-dimensional analysis

Team

Dr.Heller, Dr.Blacknell, Xialing Wu, Lesia Chandler, Scott Levin, Jaro Klc

Work in Progress

- online reader request readerrequest.doc: MS Word document - Reader Request Form

- online report request

Documentation

• Generic JPivotuser documentation
• Excel Pivot Table Tutorial

Training

Please direct training requests to Flora (flora1977@gmail.com) We provide on-demand training sessions covering the following topics:

• system overview (the collection mechanism, the record structure, the available data elements)
• using the online analytical interface to generate reports and to perform analyses
• using MS Excel Pivot Tables to generate reports and to perform analyses

Links

• administrator interface - data uploads, event-type and location elements management, admin documentation
• public link for events data
• user interface
• Pentaho Mondrian - Mondrian home site

-- JaroKlc - 30 Jun 2009