skip page navigationOregon State University
OSU HomeCalendarFind SomeoneMapsSite Index

Professional Development

You are not logged in [Login]
  • View Course

Data Warehouse FIS II (Queries)

This hands-on workshop is a continuation of the Data Warehouse FIS I (Reports) class. Is is 'part two' for the Finance Information System (FIS) user who will develop ad-hoc queries and reports in the FIS Data Warehouse. The presentation includes FIS Data Warehouse model orientation, followed by demonstration and practice in using the model. The focus of the hands-on portion will consist of an introduction to the finance data through exploratory queries, query techniques, and query refinement for financial reporting.
Administrative Software - Data Warehouse
Administrative Computing
OSU and Extension Faculty and Staff

You must have successfully completed the Data Warehouse Basics CBT to attend this course.

You must also have taken the FIS Banner and Data Warehouse FIS I (Reports) workshops, have parallel access in Banner, and have a working knowledge of the Banner Financial Information System.

Additional Information

The handouts used in this class are: Data Warehouse for OSU and The Finance Information System Data Warehouse. Participants are expected to print them and bring them to class.

FIS Data Warehouse access is contengent upon submiting a Request for Access form and mastering this class content.

The course Data Warehouse Extras is also recommended for FIS Data Warehouse users that develop complex queries.