SaP BI online training

Duration 60  days.(2 hours/day).
Contact:    Ramesh
Mail    :    chvramesh.as400@gmail.com
Mobile:   +918904430919
              +918121905424

SAP- Netweaver BI7.0 - COURSE CONTENTS

Introduction

       Data Warehouse Introduction

       BW / BI Introduction

       SAP Landscape

       Standard Naming convention in SAP- BI

Part I: Data warehousing

 Data warehouse concepts and Overview

       Business Warehouse Architecture

       OLTP Vs OLAP

       ETL

       Star Schema 

       Extended Star Schema

       DIM / SID Tables

       Measures, Dimensions and Facts

       Slowly Changing & Confirmed Dimensions

       Aggregates, Aggregation Strategy, Compression Ratio, Indexing Strategy

       Reporting and Analysis Tools

Part II: Data Modeling

Info Objects of Business Warehouse

       InfoArea ,Info Object  ,InfoObject Catalog

       Info Object Definitions : Characteristics , Key Figures, Time and Unit

       Info Providers: Cube, DSO, Multiprovider, Infoset

Data Storage of Business Warehouse

       Basic Cube / Transactional Cube

       Virtual/Remote Cube

       Multi-Provider

       InfoSets

       ODS / Data Store Object ( DSO )

       PSA

       Aggregates

Understanding Business Content

       Business Content in BI

       How to install BI content

Part III: Extraction, Transformation and Loading

ETL Overview

       R/3 Data ETL Process

       Flat File ETL Process 

       Source System

       DB connect

Types of Extraction:

       LO-Extraction

       Generic Extraction

       COPA Extraction

       FI data Extraction

Master Data Process

       Master Data ( Attributes , Texts and Hierarchies )

       Extract Structure – DataSource/Transfer Structure

       Communication Structure

       Transfer / Update Rules / Transformations

       Hierarchies

       Info Package

 Transaction Data Process

       R3 / Flat File Data

       Delta Extraction

       Standard BC

       Custom Table Extraction 

       Creation of Data Transfer Process ( DTP )

       Info Package

Part IV: Reports and Analysis Tools

BEx Query Designer

       Queries, Tabular Queries

       Query Properties

       Variables: variable wizard , variable types and processing types.  

       Restricted Key Figures

       Calculated Key Figures

       Structures: creating re-usable structures

       Cell Definition

       Conditions and Exceptions

       Query Copy/Delete between cubes.

BEx Web Application Designer

       WAD: Functions, web item window, template window, properties window 

       Creating web applications, settings, style sheets , symbols and properties.

       Report to Report Interface – RRI 

BEx Analyzer 

       Workbook

       Queries

BEx Report Designer

       Web Template iView Creation

       Publish Web Template in the portal

Performance Tuning Concepts:

       Data Loading Performance

       Query Performance

       BW Statistics

       Aggregates

       Compression

       Indexes and Partition

Part V: Admin & Monitoring

       Cube & DSO Admin & Monitoring

       Process Chain

       Transports Organizer : Real business scenario on system Environment and moving objects from one system to another.

 Advanced / general topics

      Integrated Planing

      Analysis Process Desinger(APD)

      Open Hub

       InfoSpoke

      ASAP Methodology, Implementation methods for SAP and Typical project Management 




Duration 60  days.(2 hours/day).
Contact:    Ramesh
Mail    :    chvramesh.as400@gmail.com
Mobile:   +918904430919
              +918121905424