Information Services

Prerequisites

• You must have taken the Data Warehouse Basics course and be eligible for FIS Banner General Query access
• You must have a working knowledge of Banner FIS and the Data Warehouse FIS.
• You must have a completed and approved Request for Access form on file

Training Format

Workshop (90 minutes)

• Step 1: Register at the OSU Professional Development website
• Step 2: Download the Data Warehouse for OSU and the Data Warehouse FIS handouts
• Step 3: Attend the 90 minute workshop

Registration

Register now at the OSU Professional Development website

Description

This workshop 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.