Data Warehousing

SAP BODS Training

SAP BODS or BODI is an enterprise solution that allows delivering trusted data for critical business processes. It enables enterprises to data quality and gain access to heterogeneous sources and application with a single solution. SAP BusinessObjects Data Services is utilized by enterprises to maximum operational efficiency & lower TCO. SAP BODS or BODI can be used for both real-time and batch jobs.

  • Course Overview
  • Target Audience
  • Why choose us
  • Trainer Profile

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

You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

* Name:
* Email:
* Phone:
* Location:
* Course:
* Enquiry:
* Captcha:

 

Client Feedback

Thanks, you guys provided the best online training in SAP BODS. The hands on training is very informative and helpful.

- David Sergi, Camaga Ltd; U.K