SAP BI/BW ONLINE TRAINING USA,UK

What is SAP BI/BW ?
SAP Netweaver Business Warehouse (SAP NetWeaver BW) is the name of the Business Intelligence, analytical, reporting and Data Warehousing solution produced by SAP AG. It was originally named SAP BIW (Business Information Warehouse), then abbreviated to SAP BW, but is now known as “SAP BI” at the end user level. In contrast, “BW” is still used to describe the underlying Data Warehouse Area and Accelerator components. It is often used by companies who run their business on SAP’s operational systems.

SAP BI/BW Course Content:-

INTRODUCTION :

• Overview & Concepts
• Overview of SAP R/3
• Necessity of SAP BW & Version of BW
• OLAP & OLTP
• Data Ware Housing Concepts
• Landscape of SAP BW
• Integration of BW system with different systems
• ERM, MDM, Star Schema & Extended Star Schema.

Objects in SAP BW

• Info Area, Info Object Catalogs
• Characteristics
• Key Figures-Cumulative & Non Cumulative
• PSA- Transfer Structure/Data sources
• Transfer Rules
• Info Source/Communication Structure
• ODS- Info Cubes
• Types of Info Cubes- Update Rules

Data Loading Using Flat Files

• Master Data – Attributes, Texts, Hierarchies
• Transaction data-Delta data loading

Data Filtration Techniques

• Transfer Rules level
• Update Rules level
• Start Routines

PSA-Maintenance scheduling the data

• Data Packet by Packet
• Complete scheduling
• Scheduling in background
• Transfer Rules & Update Rules
• PSA-Processing Types
• Monitoring & scheduling data loading
• Scheduling the jobs on periodic values
• Cancellation & Deleting the back ground jobs

SAP-BI 7
Bi Concepts & Overview
Modeling: Data warehousing workbench
• Components of data warehousing workbench
• InfoObjects, data source,
• Types of DSO’s , Data Source Repository
• Migration of 3.X data sources & Recovery of 3.X Data sources
• Difference between ODS & DSO
• Data Loading – Master Data & Transactional Data.
• Concepts of Transformation & Its Types
• Controlling the data-flow with Infopackages (IP)& Data Transfer Process (DTP)
• Data Loading into DSO & InfoCubes
• Standard –Direct DSO –Write Optimized DSO.

Types of Info Cubes, Info Sets, MultiProvider

• Open Hub & Performance Issue
• Deleting data from data target
• Query performance & Load Performances

Business Content

• Important of business Content
• Business Content Installation & Activation
• Business Content Data Source, DSO’s, Cubes, Reports, etc…

Meta Data Repository

• Important of Metadata Repository

Extraction

• Flat file & LO Extraction
• Generic Extraction & Generic Delta
• FI-SL, Co-PA, DB Connect
• Business Content Extraction
• Data Enhancements- Tables, View, Query

Process Chain

• Types of Process Chains
• Process Groups & Meta Chain, etc…

Transport Mechanism

• Review of system Landscape
• Collecting Objects
• Creating Transports
• Releasing Transport
• Importing Transport
• Monitoring Transport

Authorization Concepts

• Authorization
• Creating & Assigning Roles

BI 7.0 Reporting

BEx Query Designer
• Introduction of BEx Query
• Filters, Columns & Rows
• Characteristic Restrictions & Free Characteristics
• Formulas & Calculated Key Figures
• Restricted Keyfigures & Variables with Texts.

www.saponlinetrainings.net - " SAP BI/BW Online Training " contact us:[email protected] or +919052666559,9052666558 By Real Time Experts from Hyderabad, Bangalore,India,USA,Canada,UK, Australia,South Africa.