Data Warehouse Training
University data is complex. Training gives you the framework you need to understand
and use the Data Warehouse effectively.
Penn Data Warehouse Introduction for New Users -- This brief ( 30 minutes) online course in Knowledge Link will help you answer the following 'big picture' questions about the Data Warehouse:
Relational Database System Concepts -- This 35-minute tutorial (not in Knowledge Link!) will introduce you to basic concepts about relational database management systems, such as tables, primary keys, and indexed columns.
- What is the Data Warehouse?
- What does it contain?
- How can I use it?
- What user support services are available?
Data Collection Training Options
In addition to BusinessObjects training, recommended if you write or
edit queries, you definitely need to familiarize yourself with the kind
of data you plan to use. Occasional classroom workshops are offered in addition to the recommended and always-available online options below.
Knowledge Link Courses (login required)
Using the Student Data Collection in the Data Warehouse (required for data access!)
Introduction to the General Ledger Data Collection and Using the FINQUERY Universe at Penn (optional)
Introduction to the Salary Management Data Collection and Using the RSALMGT Universe at Penn (optional)
Introduction to the PennERA Proposals Data Collection and Using the PennERA Proposals Universe (optional)
Query Tool Training Options
Formal classroom-based training is available for BusinessObjects - see University Data and BusinessObjects training. Also, a number of self-service resources for using BusinessObjects InfoView and WebIntelligence are available, including
How-To quick guides
Tips and Frequently-Asked Questions (FAQs)
Building a Query? (how to create a data query to answer specific Penn business questions)