Upcoming ITS Training Services Data Warehouse Trainings

Upcoming training dates from ITS Training Services:

ITS Training Services are offering the following training sessions pertaining to using the Data Warehouse and the services/programs that access the data. 

iTwo:

All sessions are free. iTwo access is required.

 To sign up for any of these classes, visit http://portal.outreach.psu.edu/search/publicCourseAdvancedSearch.do?method=load

And search using the keyword ‘iTwo’

Introduction to iTwo (via Meeting@PennState powered by Adobe Connect)

  • November 12, 2014, Wed, 10:00AM – 11:00AM
  • December 3, 2014, Wed, 10:00AM – 11:00AM

 iTwo Queries: Basics

  • October 27, 2014, Mon, 1:00PM – 5:00PM and October 28, 2014, Tue, 8:30AM – 12:00PM (two-day session)
  • December 9, 2014, Tue, 1:00PM – 5:00PM and December 10, 2014, Wed, 8:30AM – 12:00PM (two-day session)

 iTwo Queries: Advanced

  • November 17, 2014, Mon,  1:00PM – 5:00PM and November 18, 2014, Tue, 8:30AM – 12:00PM (two-day session)

General Data Warehouse sessions:

 All sessions are free. Data Warehouse Student Data access is required.

 To sign up for any of these classes, visit http://portal.outreach.psu.edu/search/publicCourseAdvancedSearch.do?method=load

And search using the keywords ‘Data Warehouse’

The data warehouse training provided at the University level uses a few student warehouse tables (dummy data not tied to production tables – for example, student_sem, student_bio, etc.) Many more student warehouse tables are available on the warehouse.

Documentation concerning the warehouse tables is online at the University level via http://ais.its.psu.edu/services/warehouse/default.asp

Datawarehouse – Intro to Queries

  • uses Student_Sem, Student_Bio, and Transcript tables
  • December 2, 2014, Tue 1:00PM – 5:00PM and December 3, Wed, 8:30AM – 12:00PM (two-day session)

Datawarehouse – Advanced Queries

  • uses Enrollment, ISIS Codesets, and Student_Sem tables
  • October 20, 2014, Mon, 1:00 – 5:00 PM, and  October 21, 2014, Tue, 8:30 AM – 12:00 PM (two-day session)

 Datawarehouse – Reports

  • Same tables used as above.
  • November 14, 2014, Thu, 1:00PM – 5:00PM and November 15, Fri, 8:30AM – 12:00PM (two-day session)

 Free Non-Credit Data Training Workshop:

  • November 7, 2014, 8:30 – 10:30 AM in 23 Willard.

The workshop is NOT hands-on training, but is focused primarily on learning about the data available in the Non-Credit database, what tables and fields are accessible, and how to structure queries to retrieve the desired information.  This program covers concepts related to designing queries, joining tables, and specifics related to tables and fields within databases.  Please note Data Warehouse access specifically for the Non-Credit table is required.

This session will also be available via video conferencing.  Interested participants should send an email to itstraining@psu.edu to reserve a port.  Please include the following information in your email request:

  • Course Title
  • Course Date/Time
  • Campus Location
  • Building
  • Room Number

To register, go to:

http://portal.outreach.psu.edu/search/publicCourseSectionDetails.do?method=load&sectionId=1286981&paCode=PA0002#

Enrollment is limited and seating will be on a first come, first serve basis.