SAP BODS Training

SAP BODS Training Course Details

DW Concepts

• Definition
• Methodologies
• Dimensional Modeling
• DW Lifecycle
• DW Challenges

ETL Overview

• ETL Introduction
• Staging Area
• Business Rules
• Performance
• Slowly Changing Dimensions
• Surrogate Keys
• Facts and Dimension Tables
• Different ETL Tools

Business Objects Overview

• History
• Components
• Architecture

Data Services

• Purpose of Data Services
• Data Services architecture
• Define Data Services objects
• Data Services Designer interface

Data Services Objects

• Object Hierarchy
• Jobs
• Workflows
• Data Flows

Source and Target Metadata

• Data Stores
• File formats for flat files
• File formats for Excel files
• File formats for XML files
• Lab Exercises

Environment Setup

• Creating repository
• Setting Job Server
• Setup for realtime operation
• Setting multiple datastores
• Starting Job servers
• Lab Exercises

Batch Jobs

• Work with objects
• Create a data flow
• Use the Query transform
• Use target tables
• Execute the job
• Lab Exercises

Troubleshooting Jobs

• Use descriptions and annotations
• Validate and tracing jobs
• Use View Data and the Interactive Debugger
• Use auditing in data flows
• Lab Exercises

Functions, Scripts and Variables

• Define built-in functions
• Functions in expressions
• Lookup function
• Decode function
• Variables and parameters
• Data Services scripting language
• Scripting custom functions
• Lab Exercises

Important Transforms

• Map Operation transform
• Validation transform
• Merge transform
• Case transform
• SQL transform
• Lab Exercises

Other Transforms

• Pivot transform
• Hierarchy Flattening transform
• Data Transfer transform
• XML Pipeline transform
• Lab Exercises

Error Handling

• Error Handling
• Recoverable work flows

Change Data Capture

• Update data over time
• Database native CDC mechanisms
• Source-based CDC
• Target Comparison
• Lab Exercises

Data quality Overview

• Fundamentals of DQ and Data Cleansing
• Built in DQ Transformations
• Data Validation
• Name & Address cleansing
• De duplication
• Cleansing other data
• Lab Exercises

Web-Services and Real-Time Integration

• Real Time Jobs
• SOAP Introduction
• Web Services

SAP Integration

• Creating datastores for SAP databases
• Accessing SAP data
• Running ABAP programs
• R/3 Data flows

SAP BODS training is intended for:

• IT & business intelligence professionals who want to hone their skills in SAP Business Objects or SAP BODS
• Students & individuals who wants to make their career in Business Intelligence.

We guarantee learning at your convenience & pace.

• Instant Access:
  Get instant access to self-paced training after signup.
• Streaming video recording:
  Watch lessons any time at your schedule, free recording.
• Exercises:
  Practical exercises help you test what you are learning as you go.
• Free Demo:
  Sign up for free demo to check whether the course is right for you and interact with the faculty live.
• Experienced Trainers:
  We only hire the industry’s best trainers
• Live free interactive web sessions:
  Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course.
• Structured Curriculum Schedule:
  Progress with your complete daily interactive lessons and assignments.
• Faculty Mentoring:
  Turn in daily and weekly homework for personalized feedback from faculty.
• Virtual Office Hours:
  Live interaction with the faculty and other students around the world.
• Hands on Live Projects:
  Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.

N/A