SAP Business Objects Data Services 4.2 Training Program

Training Details

Course Duration: 40 hours Training + Assignments + Actual Project Based Case Studies

Training Materials: All attendees will receive,

• Assignment after each module, Video recording of every session
• Notes and study material for examples covered.
• Access to the Training Blog & Repository of Materials

Pre-Requisites:

• Knowledge of data warehousing and ETL concept
• Experience with SQL language
• Data Warehouse Fundamentals
• Data Warehouse Architecture and Modeling
• Basics of SQL, Database & Data Warehouse (Free Learning Materials provided for the same).

Who Should Join this Training?:

• Someone who is looking for a career in BUSINESS OBJECTS for SAP customers.
• Someone who is looking for a career in BUSINESS OBJECTS for Non SAP customers.
• Someone who is working as a SAP BW consultant and wants to learn SAP BODS skills.
• Someone who is working as a SAP BO consultant and wants to learn SAP BODS skills.

Training Format:

This course is delivered as a highly interactive session, with extensive live examples. This course is Live Instructor led Online training delivered using Cisco Webex Meeting center Web and Audio Conferencing tool.

Timing: Weekdays and Weekends after work hours.

• Focus on Hands on training
• Project Based Assignments & Case Studies
• Multi-User Environment(Local Repo Vs Central Repo)
• SAP HANA and SAP BODS 4.2 Integration
• Defining Data Integrator, Platform and Quality Transforms
• Setting up Error and Exception Handling
• SAP BODI Certification Guidance
• Certificate of Participation at the end.

How are we Different from other Training Institutes?

Role-specific training instead of Product-based training – We are the leaders in providing **Role-Specific training and e-learning solutions for individuals and corporations. Our curriculum are based on real-time job functions as opposed to being product-based. Real-time scenarios and troubleshooting techniques shown in class.

(**Role based training – Here our trainers share their real-time implementation experience in the class. The trainer will work with participant on several Case Studies based on a actual projects. This gives the participant an understanding of how things are accomplished in real-time environment. The idea is to get the participant familiar of the process, real-time.)

Longer Course Durations – We provide students with more detailed training with Assignments based on the real-time scenarios as well as case studies so that the students take away relevant experience in their respective platform.

We offer Training Blogs using Google Site – The Training Blogs are a common platform for both the trainer as well as the trainees to interact with, discuss queries with the trainers, upload assignments and referring assignments. Training Blogs helps the student to attend the sessions anywhere, anytime, using laptop, desktop or tabs/palmtops.

We provide study materials using Google Drive –We provide access to a Repository of materials for training using Google Drive Cloud. The students are given access to their respective modules using Google Drive for which they have access for lifetime and can be accessed anywhere any time.

For our SAP Trainings –We offer the longest duration of Courses in SAP as compared to any other training institute out there. Our SAP training programs are very detailed. Integration with other SAP modules is covered as a part of our training programs.

Never miss a session – We video record every online training sessions and post the Video recording on the training Blog after the session. So if a students misses a Live Online session, the Video is always available on the Blog. Other students can always go back to these video recordings for review purpose or just to go over.

Highly Qualified and Well Experienced Trainers – Our Trainers are highly qualified and are well experienced in their respective domains. We have trainers from USA, Canada, Australia, Singapore and many other countries.

Case Studies and Assignments Based on Real Scenarios – The Case Studies and Assignments assigned to the students are based on real-time scenarios out the Trainers Past Projects they were involved in.

Certification Assistance – During and at the end of training, the Sr. trainer will provide Certification questions and answers to help you clear the Certification (if required). They will guide each student the required Certification program as well as they themselves are Certified. Every student also receives a ZaranTech Training Completion Certificate as well.

Career Counseling – If you are New to IT and want career counseling to help you decide which stream to go into, please click the link, http://www.zarantech.com/free-career-counseling/ and fill out the Career Counseling form and one of our counselors will get in touch.

Placement Assistance – Our “After the training” team can also help you with Resume prep guidance, Interviews questions and Mock interviews after your training is complete.

Modules Covered in this Training

In this training, attendees learn:

Module 1. BODS overview

Module 2. BODS Designer concepts

Module 3. Batch Jobs

Module 4. Defining Data Integrator Transforms

Module 5. Defining Data Platform Transforms

Module 6. Defining Data Quality Transform

Module 7. Implementation of SCD

Module 8. Using Functions, Scripts, and Variables

Module 9. Data assessment

Module 10. Setting up Error Handling

Module 11. Setting up Exception Handling

Module 12. IF Conditional

Module 13. While-Loop Implementation

Module 14. Capturing Changes in Data

Module 15. Multi-User Environment(Local Repo Vs Central Repo)

Module 16. SAP Integration

Module 17. SAP HANA and SAP BODS Integration

Module 18. Information Steward

Attendees also learn:

1. Resume Preparation Guidelines and Tips

2. Mock Interviews and Interview Preparation Tips

Topics Covered

BODS overview

1. Over view of the Data services
2. Data services benefits, associated products, interfaces
3. Data services Architecture on single and distributed environment

BODS Designer concepts

1. Creating the repository (Local, Central repository
2. Exploring the menu options in the designer
3. Creating the project, Job flow, Data flow, Work flows etc., defining different types of Data stores (Source and destination data stores)
4. Use data store and system configurations
5. Defining file formats for flat, Excel, XML files

Batch Jobs

1. Creating Batch Jobs
2. Work with objects
3. Create a data flow
4. Adding the Query transform to the data flow
5. Use target tables
6. Execute the job

Defining Data Integrator Transforms

1. Date Generation Transform
2. Pivot Transform
3. Reverse Pivot Transform
4. XML_Pipeline Transform

Defining Data Platform Transforms

1. Query Transform
2. Case Transform
3. Merge Transform
4. Validation Transform
5. Row Generation Transform
6. SQL Transform

Defining Data Quality Transform

1. Address Cleanse
2. Geocoder

Implementation of SCD

1. SCD Type0
   • Query Transform
2. SCD Type1
   • Table Comparison Transform
   • Map_Operation Transform
3. SCD Type2
   • Table Comparison Transform
   • History Preserving Transform
   • Key Generation Transform

Using Functions, Scripts, and Variables

1. Define built-in functions
2. Use functions in expressions
3. Use variables and parameters
4. Create Custom functions
5. Use Data Services scripting language

Data assessment

1. Using the data profiler
2. Using the validation transform

Setting up Error Handling

1. Set up recoverable work flows

Setting up Exception Handling

1. Try/Catch Techniques

IF Conditional

While-Loop Implementation

Capturing Changes in Data

1. Update data over time
2. Use source-based CDC
3. Use target-based CDC
   • SCD Type 2

Multi-User Environment(Local Repo Vs Central Repo)

SAP Integration

1. Data extraction from ECC system to File, Table and SAP BI
2. Data extraction from ECC Extractors
3. Data Extraction from SAP BW
4. ABAP Workflows

SAP HANA and SAP BODS Integration

1. Introduction to SAP HANA
2. Introduction to SAP HANA Studio
3. Create Data Store for SAP HANA
4. Perform the load into SAP HANA
5. Store the data in Column Store
6. Preview the data in SQL console of SAP HANA Studio

Information Steward

1. Data Insight
2. Metadata management
3. Metapedia

About the trainer

• Certified HANA 1.0 consultant with exclusive experience in POC (Proof of Concept) projects with BIG 5 consulting companies and a Sr. SAP consultant.
• More than 12 years of Consulting & Teaching experience in different modules of SAP BW versions (2.0B, 2.1, 3.0B, 3.1C, 3.5, BW 7.0 NW 2004S, BW 7.3), BPC 10, CRM (5.0, CRM2007), SD, ABAP/4. SAP Business Objects, primarily SAP BI 4.0.
• Certified SAP BO Consultant with WEBI and Crystal reports Certifications.
• With a strong back ground in training and deep knowledge of the core subject and techniques on getting certification successfully completed many batches in US and Canada.
• Trained over 500 students and 80% of the students accomplished in getting certification in various modules.
• Taught more than 50 BW/BI batches in various versions 2.X, 3.0B, 3.1, 3.5, BI 7.0 NW 2004S in US and Canada for major consulting companies like CGI, DELLOLITE, etc.

CASE STUDY #1 – “Creation of Universe”

Creation of Universe from scratch (Manufacturing Domain):

In this Case study we will be creating a Universe from the beginning for a Manufacturing Domain. This Case Study also illustrates different types of challenges you will face while designing the Universe in the real-time working environment.

Tasks:

• Designing the schema
• Defining cardinalities and Joins
• Defining Classes and Objects and setting the properties according to business requirements
• Detecting and resolving the loops using aliases and context
• Detecting and resolving SQL traps like chasm and fan traps
• Applying restrictions on Objects and Using @Functions
• Using Hierarchies and List of values and Managing Universe

CASE STUDY #2 – “Creation of Web-i Report”

Creation of Web intelligence report with auto scheduling:

The Purpose of this Case Study is to explore all the features of Web Intelligence while working on real-time projects. Here are some of the tasks involved in creation of a Web-i report.

Tasks:

• Creating Web Intelligence documents with queries
• Restricting Data returned by a Query.
• Enhancing the presentation of data in the reports
• Different types of Formatting Options
• Calculating the data with Formulas and Variables.

CASE STUDY #3 – “Creation of Corporate Dashboard”

Creation of Corporate dashboard for Supply chain mgmt (Banking Domain):

This case study is an Example of how to create the Corporate dashboard report by exploring different types of charts in Xcelcius like Line charts, Column charts, Pie Charts.

How to be a certified SAP BODS certification?

Certification for SAP BODS can be attained by the aspirant in the following steps:

Step 1: Once training is over, Registration must be done for BODS15 exam.

Step 2: Complete the exam and hence you shall be certified.

What are the requirements for the certification?

Basic Degree is desired along with the basic understanding of the concepts and functionalities of Business intelligence shall be an advantage.