SAP BI ONLINE TRAINING | BY BEST TRAINERS WITH LIVE EXAMPLES PDF  | Print |  E-mail

Introduction

  1. General Introduction.
  2. SAP introduction.
  3. Data warehousing/ BW/ BI Introduction
  4. Master data; Attributes, Texts, and Hierarchies.
  5. Standard Naming conventions in SAP and BI

Data Modeling

  • InfoObjects: Definitions
    • Types: Characteristics, Key Figures, Time, and Unit.
  • InfoCubes: Definitions.
    • Types: Standards, real time, remote.
    • Design of Infocube: Star Schema concepts. Precautions.
  • DataStore objects (DSO):
    • Types: Standards, Real time.
  • InfoSets
  • MultiProviders: Scenarios to create Multiproviders.
  • Infocube VS DSO

Metadata and Document Management

  • BI Content: Definitions, How to install BI contents,

Defining extraction

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

Defining transformations

  • Transformations and different scenarios.

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

User management:

  • Setting up standard authorizations
  • Defining analysis authorizations

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 Window
  • Web Applications: Creating Web Applications, Settings, Stylesheets, Symbols and Properties
  • 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

Activities

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

BI Platform

  • Information Broadcasting
  • Functions of the Broadcaster: Precalculating and Exporting into Enterprise Portal
  • User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
  • Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.

OLAP

  • 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

Career Related Support

  • Resume Building with sample resumes
  • Frequently asked interview questions
  • Common Production Issues

Advanced Topics

Hot Bonus Topics:

  • Overview of Planning with SEM-BPS.
  • Architecture of BPS components.
  • Planning Models (Planning Area, Planning Level, Planning Functions, Planning Layouts, Packages).
  • Characteristic relationships, Variables.
  • Data Slice
  • Web Interface and Planning Folders.

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
  • Aggregates: Creating Aggregates, Finding effective aggregates
  • Data Load Performance: Parallelism, Impact of Aggregates
  • Partitioning: Logical Partitioning, Table Partitioning