Report Training

Report Users Group Meetings

Overview

Scheduled report user group meetings:

Please contact Dom D'Emilio for User Group information or meeting agenda ideas.

Legacy Training Material

• Data Warehouse Reporting - The Student Information System Data Areas
  PowerPoint presentation for data warehouse training course taught by Enterprise Applications

• Data Warehouse Reporting - The Human Resource and Financial Data Areas
  PowerPoint presentation for data warehouse training course taught by Enterprise Applications

• Data Warehouse Reporting - Housing Data within the Student Information System
  PowerPoint presentation for one-time course taught by Enterprise Applications

• Data Warehouse Reporting - Student Billing & Receivables Data within the Student Information System
  PowerPoint presentation for one-time course taught by Enterprise Applications

• Virtual Data Warehousing at the University of Toledo
  PowerPoint presentation presented at SETA and OHECC by Joe Sawasky

• University Course Catalog Reporting
  PowerPoint presentation for a SIS User Group Meeting presented by Karen Chadwick and Kathy Diegel

• Data Warehouse - Reporting of Test Score
  PowerPoint presentation for a SIS User Group Meeting presented by Kathy Page

• Using Translation Tables to Enhance Your Reports
  PowerPoint presentation for a SIS User Group presented by Karen Chadwick

• Enrollment Reporting using SIS HEI Flags
  Access database used for a demonstration at a SIS User Group Meeting by Dom D'Emilio

• Testing with New Test Data Warehouse Tables
  Instructions for testing your Access reports, queries, and forms using the SIS/ADM/GRD tables that have been modified for the SIS 119 upgrade.‚  Information was presented at a SIS User Group by Carylon Anteau.

• Creating Forms in Access using SIS Data
  Handout that was used in a presentation by William Pierce in Admissions on 9/04/2003.

• Converting Text to Upper or Lower Case
  Handout that was used in a presentation by Kathy Page in Admissions on 6/05/2003.

• Mail Merging with Access, Word, or Excel
  Handout that was used in a presentation by Kathy Page in Admissions on 3/06/2003.

• Admissions External Database Reporting and SIS
  PowerPoint presentation that was presented at SETA by Kathy Page on 3/10/2003.

• Linking HR Assignment Data to FR Account Data for Roll-up Info
  Access database used to demonstrate how to link active employee assignment data from HR to FR account data for roll-up information by Executive Level, Division, Department, and/or Account. Information was presented at the HR/FR User Group Meeting on 1/29/2004 by Dom D'Emilio.

• Example of a Query that uses the Same Table Twice
  Access database used to demonstrate how to use the same table twice in a query.  The query example displays students who have changed their primary college from one term to another. Information was presented at the SIS User Group Meeting on 6/3/2004 by Dan Snyder.

• Address Search Query Example
  Access database used to demonstrate how to use a query to search for a Permanent (P), Local (L), or Billing (B) address based on your own search order.  Information was presented at the SIS User Group Meeting on 2/3/2005 by Melinda Adler and Dom D'Emilio.