Welcome to Nakshatra Software Training


SAP BW Online Training

Course Duration : 55 Hrs

SAP BW Course Content

Introduction

  • Data Warehouse Introduction
  • BW / BI Introduction
  • SAP Landscape
  • DSS
  • Standard Naming convention in SAP- BI
  • Discussion Groups

Part I: Data warehousing

    Unit 1: Data warehouse concepts and Overview

    • OLTP Vs OLAP
    • ETL
    • Star Schema
    • Snow Flake Schema

    Unit 2: Business Warehouse Concepts and Overview

    • Business Warehouse Architecture
    • Extended Star Schema
    • DIM / SID Tables
    • Data Storage
    • Data Acquisition
    • Reporting and Analysis Tools

Part II: Data Modeling

    Unit 3: Info Objects of Business Warehouse

    • InfoArea ,Info Object ,InfoObject Catalog
    • Info Object Definitions : Characteristics , Key Figures, Time and Unit
    • Dimension / Key Figures

    Unit 4: Data Storage of Business Warehouse

    • Basic Cube / Transactional Cube
    • Virtual/Remote Cube
    • Multi-Provider
    • ODS / Data Store Object ( DSO )
    • PSA
    • Aggregates
    • InfoSets
    • Compression
    • Indexes and Partition

    Unit 5: Understanding Business Content

    • Business Content, How to install BI contents.

Part III: Extraction, Transformation and Loading

    Unit 6: ETL Overview

    • R/3 Data ETL Process
    • Flat File ETL Process
    • Monitor
    • Source System

    Unit 7: Master Data Process

    • Master Data ( Attributes , Texts and Hierarchies )
    • Extract Structure – DataSource/Transfer Structure
    • Communication Structure
    • Transfer / Update Rules / Transformations
    • Info Package

    Unit 8: Transaction Data Process

    • R3 / Flat File Data
    • Delta Extraction
    • Standard BC
    • Custom Table Extraction
    • Creation of Data Transfer Process ( DTP )
    • Info Package
    • Process Chain

Part IV: Reports and Analysis Tools

    Unit 9: 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.

    Unit 10: BEx Analyzer

    • Workbook
    • Queries
    • Personalize Variables
    • Data Area and Query Area

    Unit 11: BEx Report Designer

    Unit 12: Portal Interface

    • Web Template iView Creation
    • Publish Web Template in the portal

We are providing SAP BW Online Training in Ameerpet Hyderabad. We are one of best Institute to provide Best High Quality SAP BW online training all over India. If you are staying in Hyderabad, Bangalore, Chennai, Pune, Delhi, USA, UK, Australia, Singapore etc. and unable to attend regular class room training programs then contact our training institute for information on online training. For more details on SAP BW Online Training please call to 9290971883 / 9247461324 or drop a mail to nakshatraonlinetraining@gmail.com

SAP BW online training institute address : B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India


Online Training Enquiry Form

Security-Code reload security code

Online Software Courses