Infrastructure

Improving CalAnswers

Aswan Movva, Office of Vice Chancellor of Finance

Our current applications are not the best when it comes to building an ad-hoc queries to answer simple high level questions like "What is current employee head count of economics department". Campus would love to have a BI tool where ad-hoc queries can be built in a easier and simple way to answers some of the critical questions. We want to build an interactive ad-hoc BI Reporting solution where users can get high level data with a simple search query against the data source (Oracle Database, Flat File). The main aim of this application will be to simplify the way users build ad-hoc queries using key words (similar to twitter hashtags) such Year, Month, Department, Employee Count, Average Years of Service, Enrollment, Revenue, Budget etc. Application search / query page we want to display some example keywords and canned Queries. The system should be able to identify the key words and if a not a exact match system should be able to recommend the best possible match. 

Mutiple Majors and Major Migration Visualization Tool

Sara Quigley, Office of Planning and Analysis 

Using the D3(link is external) JavaScript library and data from Cal Answers(link is external), OPA analysts have created several interactive visualizations(link is external) showing double and triple majors, as well as migration among different major programs.

Jupyterhub Discovery Engine

Joshua Quan, University Library 

UC Berkeley Library and the Division of Data Sciences are creating Jupyterhub extensions to facilitate discoverability and reuse of datasets for research, course modules, and assignments along with contributing to reproducibility newly published research.