UW Business Intelligence (UWBI), also known as Oracle Business Intelligence Enterprise Edition (OBIEE), is a comprehensive business intelligence and analytics platform replacing the legacy, system-wide reporting tool, Hyperion Interactive Reporting. This primarily impacts HR users of the Query Library tool. UW–Madison will be utilizing the HRS Shared Queries replacing most of the HR/Payroll/Benefits reports in the Query Library, while other reports will be created in Tableau.
Tableau is the primary reporting tool used by UW–Madison for data that comes from the Student Information System (SIS), Shared Financial System (SFS), and InfoAccess. HR Professionals will need to access reports in Tableau that include HR data along with data that comes from other campus systems. These reports are located in the UW–Madison Repository for Administrative Dashboards and Reports (RADAR). For example:
- Reports with NetID (coming from InfoAccess)
Example: Employee Job Detail - Reports with funding data (coming from Shared Financial System)
Example: Salary Funding - Reports with student data (coming from Student Information System)
Example: Current Funding for Graduate and Professional Students IDE - Reports with supervisor data
Example: Employee Supervisor Detail
Additionally RADAR has reports in the Employee Data area that provide both overview and details of a variety of HR metrics. For example:
- Employee Headcount Turnover
Example: Workforce Dynamics - Employee Compensation Information
Examples: Employee Base Compensation Rate Adjustments and Employee Lump Sums
More information about business intelligence and reporting at UW is available from UW System and UW–Madison.
Accessing UWBI and Tableau
For information on requesting security roles to access UWBI, refer to HRS Security.
Search RADAR for Tableau reports
For information on requesting access to a specific report in Tableau, refer to the access role identified on the report. If you cannot access the report, you need to request access for the specific data group listed on the report.
| HRS Security UWBI Role |
Automatically provisions access to Tableau group |
|---|---|
| BI HRS Qry-Non-Sensitive | Employee Record Data-Internal |
| BI HRS Queries-Sensitive | Employee Record Data-Sensitive |
Training and Resources
- HRS Shared Queries in OBIEE (YouTube video)
- HRS Shared Queries in OBIEE (PDF)
- UWBI Quick Guides (UW System)
- How to use a Tableau Visualization (PDF)
- Query Library Crosswalk
This crosswalk includes student reports in addition to HR/Payroll/Benefits. - List of HR Reports in HRS (UWSS KB)
This job aid contains a list of HR reports and queries, a brief description, and a hyperlink to the reports KnowledgeBase document. - Resources for Campus Use of Employee Demographic Data (PDF)
Contact
-
HR Information Systems
Office of Human Resources