SAP makes a dramatic difference in your HR Performance, if you know how to use it ! Perfect Resources helps you get the most from SAP with over 500 interactive videos. From beginner to expert, learn at your own pace from the comfort of your home or office.





  • General Introduction.
  • SAP introduction.
  • Data warehousing/ BW/ BI Introduction
  • Master data; Attributes, Texts, and Hierarchies.
  • Standard Naming conventions in SAP and BI.

Metadata and Document Management

  • BI Content: Definitions, How to install BI contents

Defining transformations

  • Transformations and different scenarios

Defining extraction

  • For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource
  • Or for files: Creating DataSources for File Source Systems

Defining the data flow

  • Creating data transfer processes
  • Creating process chains

Scheduling and monitoring

  • Checking process chain runs
  • Monitor for extraction processes and data transfer processes

Performance optimization

  • Creating the first aggregate for an InfoCube
  • Using the BIA index maintenance wizard


  • BEx Analyzer
  • BEx Web Application Designer
  • BEx Report Designer

BI Platform

  • Information Broadcasting (Overview)
  • Functions of the Broadcaster : Precalculating and Exporting into Enterprise Portal
  • User Guide : Distributing Queries and Web Templates, Scheduling Broadcasting


  • Web Applications : Creating Web Applications, Settings, Stylesheets, Symbols andProperties
  • Design : Designing the Layout of Web Templates, working with Library for Web Items
  • Web Items : Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes


  • OLAP v OLTP : The OLAP Concept and differences between OLAP and OLTP
  • OLAP Functions : Aggregation, Currency Translation, Report-to-Report Interface
  • MetaData Repository : Searching for MetaData

User management

  • Setting up standard authorizations
  • Defining analysis authorizations


  • Example Scenarios : Monthly Sales Reports, Ad-hoc Distribution Options.

Transports Real business scenarios on different system environments, Moving objects from one system to another. BI SUITE: Business Explorer BEx Query Designer

  • Queries : New queries, Restricting Characteristics, Formulas and Exception Cells.
  • Query Design : Defining Exceptions, Conditions, Restricted and Calculated KeyFigures.
  • Variables : The Variable Wizard, Variable Types and Processing Types, query Properties.
  • Component Properties : Properties of Characteristics, Attributes, Structure, Formula,KeyFigures.
  • Structures : Creating Re-usable structures.
  • Functions on BW Server : Copying queries between Cubes, Deleting Query Elements.
  • Web Application Designer.
  • WAD : Functions of WAD, Web Items Window, Template Window, Properties .

Performance in depth

  • Data Model for Performance : Line Item Dimensions, Navigational attributes, Time-Dependent.
  • BW Statistics : Query Analysis Tools, Performance Tables.
  • Reporting Performance : Effective query design, Line-Item, Compression.
  • Partitioning.
  • Introduction to Aggregates.
  • Data Load Performance : Parallelism, Impact of Aggregates.