The Pennsylvania State University - Administrative Information Services, a unit of Information Technology Services

Training Opportunities

Data Warehouse Training is offered by ITS Training Services. ITS Training Services will maintain a listing of all Data Warehouse Training seminars available, dates and times, and instructor names, as well as how many seats are still available. 

  1. If you click on the following link:  http://its.psu.edu/training/
  2. Then select the ‘Register for Training’ link on the home page.
  3. You will be prompted for your Penn State Access account and password.
  4. You could be prompted to enter in contact information. This is only done one time and will get your information into the ITS Training System.
  5. Click on the Seminars button.
  6. Then click on ‘Administrative Computing’ link, or enter Data Warehouse in the search box.

This will give you a listing of all Data Warehouse classes and the dates/times they are being offered. 

The suggested training sequence is:  

  1. Data Warehouse & EIS: An Overview and Comparison

    This course describes Penn State's Data Warehouse and the Enterprise Information Systems (EIS); it does not include hands-on computer training. This course provides an overview and comparison of the EIS and the Data Warehouse. It is designed to help learners choose which solution is best for them for accessing data. Participants will learn about the advantages and disadvantages of each option and will be shown sample queries using each as a source for data. Topics:
    • Data available using each option
    • Steps for accessing each option
    • Security issues
    • Current and future training opportunities for each option
  2. Data Warehouse Instructional materials (PowerPoint presentations)
    • Introduction to the Data Warehouse
    • Selecting a Query Tool
    • Learning the Data
  3. Data Warehouse: Introduction to Queries Using MS Access

    Prerequisite(s): Data Warehouse access is required; Data Warehouse & EIS: An Overview and Comparison or equivalent knowledge and skills.

    This course is designed for new users of Microsoft Access who will use Access to retrieve data from Penn State's Data Warehouse. The program covers only those features of Access that are needed to retrieve and manipulate Data Warehouse data effectively and efficiently. While learning Access, you will also learn how to use Web resources to identify the databases, tables, and fields needed to retrieve data. This course makes use of a training database that includes tables from the Student Database. The program emphasizes those tables and fields in the Student Database that are most commonly used. Even if you do not use Student data, this course will provide you with skills that you can apply to the data that you work with. A course manual will be provided in this workshop.

    Objectives:
    • Describe Database fundamentals
    • Describe Penn State Data Warehouse fundamentals
    • Connect to the Data Warehouse
    • Create simple queries
    • Create new tables from a query
    • Sort and filter query results
    • Explore the basics of table joins
    • Describe Data Warehouse security
  4. Review of the Data Warehouse Documentation for the database you'll be using
  5. Data Warehouse: Advanced Queries Using MS Access

    Prerequisite(s): Data Warehouse access is required; Data Warehouse: Introduction to Queries Using MS Access or equivalent knowledge and skills.

    The program covers only those features of Access that are needed to retrieve and manipulate Data Warehouse data effectively and efficiently. This course makes use of a training database that includes tables from the student Database. However, even if you do not use Student data, it will provide you with skills and concepts that can be applied to the data that you work with. A course manual will be provided in this workshop.

    Objectives:
    • Use Mathematical, Relational, Boolean, String, and Miscellaneous Operators
    • Explore query types including Update, Append, Delete, Parameter and Find Duplicates Queries
    • Use Multiple Joins to eliminate duplicate records
    • Pull User IDs in order to create mass email lists
    • Use the ISIS and IBIS codeset databases
    • Transfer SQL code from an email into an Access query
  6. Data Warehouse: Introduction to Reports Using MS Access

    Prerequisite(s): Data Warehouse access is required; Data Warehouse: Introduction to Queries Using MS Access and Data Warehouse: Advanced Queries Using MS Access or equivalent knowledge and skills.

    This course builds upon the knowledge and skills presented in Data Warehouse: Introduction to Queries Using MS Access and Data Warehouse: Advanced Queries Using MS Access. Only those features of Microsoft Access that are needed to effectively and efficient retrieve and manipulate Data Warehouse data are covered. This course uses a training database delivered from the Student Database in the Data Warehouse. Even if you do not work with the Student data, the concepts and skills from this program may be applied to any data with which you work. A course manual will be provided in this workshop.

    Objectives:
    • Edit Reports in Design View
    • Use Expressions in Reports
    • Use Conditional Formatting
    • Set properties for the various sections of a report
    • Create mailing labels
    • Insert calculations into a report

Tutorials and Additional Training: 

  • Tutorial: Setting up MS Access for use with the Data Warehouse
    The first time you access the Data Warehouse, you will need to complete the steps illustrated here in this tutorial. It describes the process of configuring Microsoft Access to be able to import data from the Warehouse.
  • Microsoft Access Training available from ITS Training Services
    Free seminars and on-line training tutorials in Access and Excel.
  • Free E-Learning courses at Microsoft.com
    As part of the Microsoft Campus Agreement for Office, our faculty and staff are entitled to online E-Learning courses at Microsoft.com.  These courses are meant to help you keep up-to-date with the latest major E-Learning--Applications software releases.
    To gain initial access to the Microsoft E-Learning courses, go to https://downloads.its.psu.edu/ and click on the Training link. Then, click on the E-Learning courses--Other Platforms link to view instructions and get access code.

Suggested courses:

  • Course 5451: Getting Started with Microsoft Office Access 2007
  • Course 5452: Importing and Exporting Information in Microsoft Office Access 2007
  • Course 5453: Working with Forms in Microsoft Office Access 2007
  • Course 5454: Locating Specific Information in Microsoft Office Access 2007
  • Course 5455: Keeping Information Accurate and Secure in Microsoft Office Access 2007
  • Course 5456: Working with Reports in Microsoft Office Access 2007
     

Content Questions: AIS Support | Support Questions: AIS Support