SAP BW 7.4 Online Training Institute in Hyderabad India

SAP BW 7.4 Online Training Institute in Hyderabad India

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. The IT Professionals and Students from India and abroad who are unable to attend regular classes can attend our SAP BW online training from their home in their convenient timings. For more details on SAP BW Online Training please call to 9290971883 / 9247461324, or drop a mail to nakshatraonlinetraining@gmail.com  or Whatsapp to us on : 9290971883

SAP BW Course Content

Course Duration : 56 Hrs

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