APBS Data Warehousing

1
APBS Data Warehousing

• Regional Summit 1
• May, 2004

2
Agenda

• Introductions/Logistics
• Demystifying Data Warehousing
• Terminology
• Context
• Demonstrations
• Break
• APBS Data Warehouse
• Content Overview
• Development Schedule
• APBS (HRIS) Training Overview
• General Question / Answer
• Technical Break-out Session

3
APBS Information Access Hierarchy
Lawson Portal
Standard Report
Query Library
Ad Hoc Report
4
APBS Information Access Hierarchy
Lawson Portal
5
Lawson Form

• Definition
• Lawson application screen
• Interface
• Lawson Portal (web browser)
• Data Source
• Lawson Operational Database (live)
• Development Responsibility
• Lawson Corporation (Function)
• UW System (Look/Feel modifications)
• Use
• Specific Information for a single person
• Example
• HR11 - Employee Base Information

6
APBS Information Access Hierarchy
Lawson Portal
Screen
Screen
7
Lawson Drill-around

• Definition
• The Lawson application function used to view a
  series of screens related to a specific employee
• Interface
• Lawson Portal (web browser)
• Data Source
• Lawson Operational Database (live)
• Development Responsibility
• Lawson Corporation
• Use
• View Pre-determined Information about a single
  person
• Examples
• Positions, Jobs (Appointment)
• Deductions
• Benefits

8
APBS Information Access Hierarchy
Lawson Portal
Screen
Screen
9
Lawson Standard Report

• Definition
• A report delivered as part of the Lawson
  application
• Interface
• Lawson Portal (web browser)
• Data Source
• Lawson Operational Database (live)
• Development Responsibility
• Lawson Corporation
• Use
• Lists/Counts
• Example
• HR211 - Employee Listing

10
APBS Information Access Hierarchy
Lawson Portal
Screen
Screen
Standard Report
11
Lawson Enterprise Reporting

• Definition
• Customized reports, developed by UW System,
  delivered via the Lawson application
• Interface
• Lawson Portal (web browser)
• Data Source
• Lawson Operational Database (live)
• APBS Data Warehouse
• Any Oracle data base
• Development Responsibility
• UW System
• Use
• Lists/Counts
• Drill-around
• Example
• UW Employees by Campus

12
APBS Information Access Hierarchy
Lawson Portal
Screen
Screen
Standard Report
13
UW System Query Library

• Definition
• Human and technology infrastructures and
  processes allowing business specialists to
  develop, document, and share reports,
• comprising card catalog and repository functions,
• leveraging ad-hoc report development
• Interface
• World-wide Web (browser)
• Lawson Portal
• Data Source
• APBS Data Warehouse
• Any Oracle Database
• Development Responsibility
• UW System (application)
• End Users (content)
• Use
• Lists/Counts
• Example
• Current Employees at a Campus

14
APBS Information Access Hierarchy
Lawson Portal
Screen
Screen
Standard Report
15
Ad-Hoc Reporting

• Definition
• A report developed for the particular end or case
  at hand without consideration of wider
  application
• Interface
• Via the reporting tool (e.g. BrioQuery)
• Data Source
• APBS Data Warehouse
• Any Networked Database
• Local Files (e.g. Excel spreadsheets, CSV)
• Use
• Lists/Counts
• Example
• Current Employees at a Campus

16
APBS Information Access Hierarchy
17
Informatica
Web Browser
Web Browser
ERWin
Brio
Brio
Query
Query
Report
Report
Transform
Transform
Source (Staging)
Source (APBS)
Target (Staging Area)
Target (Mart)
Query
Catalog
ETL (APBS gt Staging)
ETL (Staging gt Mart)
18
Break Time
19
APBS Data Warehouse Overview

• APBS Data Warehouse Scope - March 2004
• http//systemwide.uwsa.edu/apbs/

20
APBS Data Warehouse Overview
Person / Employee
Benefit
Calendar/Time Period
Position
Payroll
Organization
Absence Management
InfoAccess Appointment
InfoAccess Payroll
InfoAccess Benefits
21
APBS Data Mart
Employee Demographic
Employee Directory
Position
Employee
Position Profile
Degree
Calendar/Time Period
Organization
22
APBS Data Mart
Employee Demographic
Employee Directory
Position
Position
Position Profile
Degree
Calendar/Time Period
Organization
23
APBS Data Mart
Employee Demographic
Employee Directory
Position
Education Level
Position Profile
Degree
Calendar/Time Period
Organization
24
APBS Data Mart
Dimension
Fact
Dimension
Dimension
Education Level
Dimension
Star Schema
25
APBS Data Mart
Star Schema
26
HRIS Education Plan

• Syllabus
• Overview Navigation
• Human Resources
• Benefits
• Payroll
• Method
• E-Learning Courses
• WisLine Sessions
• Classroom Training
• Regional Sessions
• Fill in the gaps
• Individual Campus Visits
• One per Institution
• Reengineering

27
Future Regionals

• Employee/Position Data Mart
• June 2004
• Payroll Data Mart
• July 2004
• Benefits
• Aug 2004
• Absence Management
• Oct 2004

28
Discussion
29
Technical Break-out

• Lawson Application
• System Requirements
• Browser
• Hyperion (Brio)
• System Requirements
• Query Library
• Administration