Business Intelligence Training

Home >> Payroll >> Business Intelligence >> Business Intelligence Training

Welcome to SAP Business Intelligence (BI) Training.

  • BW/BI End Users and BI Power Users: The BI Custom Report Training Materials will provide a general understanding of BI, including basic report functionality and steps for running reports via the HRMS Portal.
  • BW/BI Power Users: The BI Power User workshop materials will provide an overview for creating Ad Hoc queries using the BEx reporting tools and an opportunity for BI Power Users to develop Ad Hoc queries with the assistance of BI Report Developers.

The BW/BI Custom Report Training Materials will provide a general understanding of BI, including basic report functionality and steps for running reports via the HRMS Portal.

BW/BI Course Schedule Course Code Updated
BW/BI Power User Workshops
(For BW/BI Power Users only-see prerequisites)
01-04-BI01 07/20/2015 
BW/BI End User Workshops
(For accessing & running BI reports via the HRMS Portal & covers the same content as the Custom Report Training Materials)
01-04-BI02 07/20/2015 

 

BW/BI Custom Report Training Materials (for BW/BI Power and End Users)

These lessons are most effective when you have access to the BW/BI application, but you may find them useful as a tool for understanding how the BI application is designed. The lessons are designed to be taken in sequence, but will work great as a reference for less frequent users of the BI application.

BW/BI Custom Report Training Materials Format Updated
BW/BI Introduction PDF 8/13/2015
BW/BI Concepts and Security PDF 8/13/2015
BW/BI Architecture PDF 8/13/2015
BW/BI Custom Reports PDF 8/13/2015
BW/BI Logging on to the HRMS Portal PDF 8/13/2015
BW/BI Running Reports from HRMS Portal PDF 8/13/2015
BW/BI Elements of a Report PDF 8/13/2015
BW/BI Report Context Menu PDF 8/13/2015
BW/BI Printing Report Results PDF 8/13/2015
BW/BI Exporting Report Results PDF 8/13/2015
BW/BI Basic Glossary of Terms PDF 8/13/2015
BW/BI Additional Info/FAQ PDF 8/13/2015
BW/BI Financial InfoCube (AFRS InfoProvider) PDF 8/13/2015
BW/BI Grievance InfoCube
PDF  8/13/2015

 

BW/BI Custom Report Exercises Format Updated
BW/BI Custom Report - Exercise 1 PDF 8/13/2015
BW/BI Custom Report - Exercise 2 PDF 8/13/2015
BW/BI Custom Report - Exercise 3 PDF 8/13/2015

 

The Materials will be listed according to the BW/BI Power User Workshop Outline below.  

BW/BI Power User Workshop Outline  Format Updated
BI PU Workshop - Outline  PDF 8/13/2015

 

BW/BI Power User Modules Format Updated
BW/BI PU Workshop - Introduction  PDF 8/13/2015
BW/BI PU Workshop - Concepts PDF 8/13/2015
BW/BI PU Workshop - Environment PDF 8/13/2015
BW/BI PU Workshop - Business Explorer (BEx)  PDF 8/13/2015
BW/BI PU Workshop - Ad Hoc Query Fundamentals-Part I  PDF 8/13/2015
BW/BI PU Workshop - Ad Hoc Query Fundamentals-Part II PDF 8/13/2015
BI PU Workshop - Ad Hoc Query Fundamentals - Part III PDF 8/13/2015
BW/BI PU Workshop - Security  PDF 8/13/2015

 

BW/BI Power User Non-Financial Exercises Format Updated
BW/BI PU Workshop Exercise 1 - Basic Query PDF 8/13/2015
BW/BI PU Workshop Exercise 2 - Modifying Query 1 PDF 8/13/2015
BW/BI PU Workshop Exercise 3 - Modifying Query 2 PDF 8/13/2015
BW/BI PU Workshop Exercise 4 - Security Objects PDF

 

8/13/2015
BW/BI PU Workshop Exercise 5 - Deleting Queries PDF

 

8/13/2015

 

BW/BI Power User Financial Exercises Format Updated
FI Exercise 1: Creating a Basic Ad Hoc Query PDF 8/13/2015
FI Exercise 2: Modifying a Basic Ad Hoc Query PDF 8/13/2015
FI Exercise 3: Modifying a Basic Ad Hoc Query (Restricted Key Figures and Formulas) PDF 8/13/2015
FI Exercise 4: Adding Confidential InfoObjects PDF  8/13/2015
FI Exercise 5: Deleting Queries PDF  8/13/2015

 

BW/BI Data Crosswalks Format Updated
AFRS Payroll (Financial) (ZPY_C51) PDF Excel 8/13/2014
Employee Specific Payroll Data (ZPY_M01) PDF Excel 8/13/2014
Employee Specific Payroll Data with Personnel Administration (ZPY_M02) PDF Excel 8/13/2014
Grievance (ZGR_M01) PDF Excel 8/13/2014
Headcount and Personnel Actions with Education Data (ZPA_M50) PDF Excel 8/13/2014
Headcount and Personnel Actions (ZPA_M03) PDF Excel 8/13/2014
Headcount and Personnel Actions with Military Service Date (ZPA_M60) PDF Excel 8/13/2014
Quota (ZPT_M02) PDF Excel 8/13/2014
Staffing Assignments (ZPAOS_C01) PDF Excel 8/13/2014
Time and Labor (ZPT_M01) PDF Excel 8/13/2014

Contact Us

Phone: (360) 407-9100
Email: 
support@watech.wa.gov

Related Links