Obtaining Student Data Warehouse Access

To request access to the Student Data Warehouse, complete the Student Data Warehouse Request Form. The form provides Institutional Effectiveness and Analytics (IEA) and Information Technology (IT) with information about your data needs and confirms that you have completed the required data security training.

After the appropriate user role has been determined, an electronic document is circulated to your manager and the data stewards (the offices of Undergraduate Admissions, Graduate Admissions and Program Evaluations, and the Registrar.)

If all requests are approved, you will receive an e-mail confirmation.  If your request is not approved at any point in this process you will also receive an e-mail. The access request and approval process is summarized in the diagram below.



Student Data Warehouse Training February Schedule

Hello Everyone,

Below is the monthly schedule of our Student Data Warehouse training sessions. If you are interested in attending the training and you have a scheduling conflict, please contact me (jose.lema@sjsu.edu) to schedule a one on one meeting.

If you have already attended training or scheduled training at another time, you may disregard this notification.

Additionally, you may view a recorded Introduction to the Student Data Warehouse training or join us remotely using the Zoom link.

Student Data Warehouse Open Lab  Date/Time: FridayFebruary 14 (10:00AM – 11:30 AM)
Location: Student Services Center 400L Training Lab (behind Academic Advising)

– This is an open lab session for faculty and staff who have previously used the Student Data Warehouse. At the open lab, you will have an opportunity to run reports for your department or college. If you have never used the Student Data Warehouse or if you are interested in a more structured session going over the basic features, you may want to view the recorded Introduction to the Student Data Warehouse training, schedule a one on one meeting, or attend the training scheduled for January 16.

Introduction to the Student Data Warehouse  – Date/Time: Tuesday, February 18 (2:00PM – 3:30 PM)
Location:  Student Services Center 400L Training Lab (behind Academic Advising)

– This session is for faculty and staff who have not previously attended training or those who would like to review the basic features of the Student Data Warehouse.

A prerecorded video of this training session is available at : Introduction to the Student Data Warehouse

Student Data Warehouse for Intermediate Users Date/Time: Thursday, February 20 (2:00PM – 3:30 PM) Location: Student Services Center 400L Training Lab (behind Academic Advising)

– This session is for faculty and support staff who have previously attended a Student Data Warehouse training session. We will go into more detail on the data in the individual dashboards and compare similar reports available outside the Student Data Warehouse on the CSU Student Success Dashboard and the SAMI Gateway

About the Student Data Warehouse 

The Student Data Warehouse leverages Oracle Business Intelligence Enterprise Edition to deliver customized dashboards and reports built with student records data. Combining records from PeopleSoft, the enrollment census, and other sources, the Student Data Warehouse facilitates access to student data for analysis and many college and department operational needs. Listed below are some sample topics the Student Data Warehouse can help you explore:

• What are the enrollment numbers in the individual colleges/departments/courses/sections ?
• What are the trends in course fill rates/FTE?
• In which courses have students been more/less successful?
• Which student populations/colleges/departments/majors have higher graduation rates?


Scheduled Maintenance February 7 3:00 – 5:00 PM

Hello Everyone,

Due to scheduled maintenance, you may experience intermittent connectivity issues accessing the Student Data Warehouse this afternoon between 3:00 and 5:00 PM. In most cases refreshing your browser should resolve the problem. However, if you experience any difficulties in running reports, please do not hesitate to contact me.