SAP BI/BO Bur Dubai, Dubai

Course details

The course provides in-depth knowledge of business intelligence, business warehousing and business objects engaging best training resources which make sure the learners quickly grasp, sustain the knowledge and carry it back to their desks. The topics covered in the course include business process performance, a web-intelligence dashboard for data Modelling at customer services level, process chain, OLAP & OLTP and more. A combination of highly talented Industry expert trainers, Practical and real scenarios-based training, specially customized course material and tools will offer nothing but the best training experience ensuring highest levels of productivity from the classrooms.

Course Objective
Upon completion of the course, one will be able to confidently develop, deploy/implement SAP projects and achieve needed ; One will be able to analyse existing SAP systems; Processes configuration of modules suggest changes and support end users. One will develop skills and confidence to work as a BI/BO consultant by demonstrating high-quality programming skills and the level of expertise to troubleshoot and provide technical support.

Course Outline

R/3 Architecture.

• Landscape of SAP.
• BW - Introduction, DWH Introduction
• SAP Business Warehouse concepts and Overview
• Different Source Systems
• Star Schema and Extended Star Schema
• Difference between OLAP and OLTP Processors

 
Objects

• Info area
• Info object catalogue
• Info Objects
• Application component
• Info source
• Data source
• Transfer rules
• Communication structure
• Update rules
• Info Cubes
• ODS
• Info Package

 
Objects

• Info Area
• Info Object catalog
• Info objects
• Data source
• Source system
• Application component
• Data source
• Transformations
• Info Cube
• DSO
• Info package
• DTP

 
Flat file extractions ( & )

• Master data extraction
• Attribute
• Text
• Hierarchy
• Transaction data extraction
• To DSO
• To Info Cube
• DSO to Info Cube
• Data Flow difference between and
• Migration Strategyfrom to
• Data mart concept.

 
Info Providers: ( & )

• Info Objects
• Introduction to InfoCubes
• Types of InfoCubes .
• Standard InfoCube
• Real time Infocube
• Virtual Providers

 
Introduction to Datastore Object(DSO)

• Types of DSO's .
• Standard DSO
• Direct-Update DS
• Write Optimized DSO
• Multi Providers & Info set

 
Analysis Process Designer Transformations

• Introduction to Transformations
• Transformation Rule types (Direct assignment,
• Routines, Initial value, Time Distribution, No update,
• Constant, read master data, Read from DSO)
• Transformation Rule Groups

 
Open Hub Destination

• Destination As Table(Local & Application server)
• Destination As Data Base Table.
• Concepts of Info spoke(in )

 
Re-modeling
 
Error Stack
 
Process Chain

• Introduction to Process Chain
• Creating Master Data Process Chains
• Creating Transactional Data Process Chain
• Scheduling Process Chains
• Creating Meta Chain
• Monitoring process chains
• Removing from schedule and rescheduling the process
• chains

 
Performance Management

• Types of Performance Optimization Techniques
• Backend or Data Loading Performance Techniques
• Deleting Indexes.
• Line - item Dimension & High cardinality
• Aggregates & Collapse.
• Partitioning & Re-Partitioning
• DB Statistics
• BI Performance Tuning Activities

 
Transportation

• Introduction to Transportation.
• BW system Landscape
• Creating of Package and Transport requests
• Collecting the objects in BW across the Landscape
• Transporting the Objects across the BW Landscape
• Deleting and reimporting Transport requests.
• Finding transportation Logs and return cods.
• Transportation error and Solutions

Updated on 28 April, 2019