1 / 29

APBS Data Warehousing

APBS Data Warehousing. Regional Summit #1 May, 2004. Agenda. Introductions/Logistics Demystifying Data Warehousing Terminology Context Demonstrations Break APBS Data Warehouse Content Overview Development Schedule APBS (HRIS) Training Overview General Question / Answer

dougal
Download Presentation

APBS Data Warehousing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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. Form Drill Around Enterprise Report APBS Information Access Hierarchy Lawson Portal Standard Report Query Library Ad Hoc Report

  4. Form APBS 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. Form Drill Around Screen APBS 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. Form Drill Around Screen Standard Report APBS 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. Form Drill Around Screen Enterprise Report APBS Data Warehouse 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. Form Drill Around Screen Enterprise Report APBS Data Warehouse Query Library 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. Form Drill Around Screen Enterprise Report APBS Data Warehouse Query Library Ad Hoc Report 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. Lawson Portal Form Drill Around Screen Screen Screen Standard Report Enterprise Report APBS Data Warehouse Query Library Ad Hoc Report APBS Information Access Hierarchy

  17. Data Warehouse Designer Informatica Developer Report Developer Business Specialist Metadata Exchange WiscNet Data Mart APBS SFS Informatica Staging Area Brio On_Demand Server UW System Query Library SA Data Warehouse ERP Systems (Oracle Database) Informatica Web Browser Web Browser ERWin Brio Query Brio Query Report Report Transform Transform Source (Staging) Source (APBS) Target (Mart) Target (Staging Area) Query Catalog ETL (Staging > Mart) ETL (APBS > Staging)

  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. Employee Demographic Degree Employee Directory Calendar/Time Period APBS Data Mart Dimension Fact Dimension Dimension Education Level Dimension Star Schema

  25. Position Position Employee Directory Position Profile Employee Demographics Calendar/Time Period Organization 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

More Related