SAP BW 3.X, BW 7.0 to BW 7.3 Delta Professional Competency Development Program

C.

We focus on delivering Role-Specific training rather than Product based Training

SAP BW 7.3 Delta Professional Role Based Training Timings: Weekdays & Weekends (after work hours) Mode of Training: Live Instructor-led Online training using Cisco WebEx Meeting Center tool.

LL

Course Duration: 25 hrs. + Assignments + Project Based Case Studies Prerequisite: SAP BW 3.X or BW 7.0

Za ra n

Te

ch

How Are We Different?  We just don’t teach SAPBW 7.3 DELTA Concepts but we share our real-time implementation experiences to get the audiences ready to face customers and Implement Solutions.  We don’t just teach SAP BW 7.3 but we make them Complete & Full-fledged SAP BW 7.3 Consultants by training them on Development, Administration & Application Design with Project based real-time scenarios and several Case Studies for practice  Our faculties are not just technical developers or trainer’s, they are industry experts and consultants for fortune 500 companies who are highly capable of understanding the business and know how technology can be closely connected with people and business.  Our Role-Specific training differs from any other training company in the world

Training Highlights: Benefits:  Focus on Hands on training.  Quality Course Material & E-books Project basedAnalyst Assignments and Case studies  24 x 7 Online access to trainers for Doubts CourseTitle: Business Competency Development Program Video Recordings each session provided CourseDuration: 45 hours of Training Clarification, Training attendees  Materials: SAP BW 7.3AllPowered by would HANA receive (all the  Project based training with hands on exp concepts with HANA including Migration)  Resume Preparation Guidance   Training of each SAP BWpresentation 7.3 integration withsession, SAP BODS DX 4.0  Mock Interviews from Professional Consultants,  Source Code covered all for theexamples seniors covered.  Marketing one-on-one with a Recruiter  SAP BW 7.3 integration with SAP BO Training Format: This course is delivered as a highly interactive with extensive live examples. This course is  SAP BW 7.3 all new features  session, Real-time Project Documents delivered in Online using Web and Audio Conferencing. Onsite Job assistance for 3-4 months  Certificate Guidance for SAP BW Delta What will youlearn?  Special Project training programs for trained OPT’s and CPT’s

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 1 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

SAP BW 3.X, BW 7.0 to BW 7.3 Delta Professional Competency Development Program We focus on delivering Role-Specific training rather than Product based Training

ch

LL

SAP Net Weaver BW 7.3 Features Overview Graphical Data Modeling Advanced Info providers SAP Net Weaver BW 7.30 and BW Accelerator 7.20 SAP Net Weaver BW and In-Memory Technology (SAP HANA) New SAP Net Weaver BW 7.3 Hierarchy ETL SAP Net Weaver BW 7.3 and SAP business Objects (SBO) BW Archiving with Near –line Storage Administrator Cockpit and technical Content in SAP Net Weaver BW 7.3 BW Operations: Process Chain Monitor EDW Performance Improvements Authorizations in BW: Improvements and Migration Integration with SAP BO DS 4.0 (ETL with SAP BO DS 4.0) Upgradation Concepts.

Attendees also learn: 1. 2.

Resume Preparation Guidelines and Tips Mock Interviews and Interview Preparation Tips should attend?

Za ra n

Who should plan on joining?  

Te

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14.

C.

In this training, attendees will learn:

SAP BW Consultants working with BW 3.X and BW 7.0 version Professional who already got trained in BW 7.0

About the trainer: 1. 2.

3. 4. 5.

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.

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 2 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

SAP BW 3.X, BW 7.0 to BW 7.3 Delta Professional Competency Development Program

C.

We focus on delivering Role-Specific training rather than Product based Training

LL

Graphical Data Modeling

Data Flow Copying

Data Flow Generation

Data Flow Migration

Advanced Info providers

ch

SAP Net Weaver BW 7.3 Features Overview

SAP Net Weaver BW 7.30 and BW Accelerator 7.20

SAP NetWeaver BW 7.3 & SAP BusinessObjects (SBO)

Te

Hybrid Providers

New SAP NetWeaver BW 7.3 Hierarchy ETL

BW Archiving with Near –line Storage

SAP.3 integration with SAP BO DS 4.0 BW 7

Dataflows using SAP BO DS 4.0 from SAP Non-SAP

OPENHUB (BW SOURCE) to external system SAP BODS 4.0

SAP BW 7.3 on HANA

ABAP data flows in SAP BO DS 4.0 with BW 7.3

BW Operations process Chain Monitor

Up gradation Concepts

EDW Performance Improvements

Authorizations in BW: Imprvmnts & Migration

Enhancements in Transformations & DSO’S

Za ra n

New SAP BW 7.3 DELTA Training Program Features

SAP BW 7.3 DELTA TRAINING PROGRAM ROADMAP

25 hrs plus Assignments Sample Questions, Case Studies SAP BW 7.3 DELTA Certification Guidance ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 3 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

SAP BW 3.X, BW 7.0 to BW 7.3 Delta Professional Competency Development Program

C.

We focus on delivering Role-Specific training rather than Product based Training

Topics covered:

ch

UNIT 2: Graphical Data Modeling a. Graphical Data Modeling Basics b. Data Flow Copying c. Data Flow Generation d. Data Flow Migration

LL

UNIT 1: SAP Net Weaver BW 7.3 Features Overview a. SAP Net Weaver BW 7.3 Overview

Te

UNIT 3: Advanced Info providers a. Advanced Info providers b. Semantically Partitioned Objects (SPO) c. Hybrid providers d. Transient Provider

Za ra n

UNIT 4: SAP BW 7.3 SAP BODS Integration a. SAP BO DS 4.0 overview and Architecture b. Creating Data Stores in SAP BODS 4.0 designer for SAP ECC, NON SAP and BW as Source and Target c. SAP BOD 4.0 data flows with different Transforms to load the data from SAP and non-SAP to sap BW 7.3 d. ABAP data flows to load the data from tables cluster and pooled cluster to sap BW 7.3 e. Data flows in SAP BODS 4.0 Using Open hub tables (BW as source) TO External systems. UNIT 5: SAP Net Weaver BW 7.30 and BW Accelerator 7.20 a. SAP Net Weaver BW 7.3 Analytical Engine b. SAP Net Weaver BW Accelerator 7.20 UNIT 6: SAP Net Weaver BW and In-Memory Technology (SAP HANA) a. SAP Net Weaver BW and HANA b. The Future of SAP Net Weaver BW, BWA and SAP HANA

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 4 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

SAP BW 3.X, BW 7.0 to BW 7.3 Delta Professional Competency Development Program

LL

UNIT 7: New SAP Net Weaver BW 7.3 Hierarchy ETL a. Understanding SAP BW 7.3 Hierarchy Frame Work b. Segmented Hierarchy data source c. SAP BW 7.3 Hierarchy Data source

C.

We focus on delivering Role-Specific training rather than Product based Training

UNIT 8: SAP Net Weaver BW 7.3 and SAP business Objects (SBO) a. SAP BO DS (EIM) capabilities b. SAP BI 4.0 and BW 7.3 integration

ch

UNIT 9: BW Archiving with near –line Storage a. Near –line Storage Solutions for SAP Net Weaver BW b. Near –line Storage Evolution by release c. Near-line Storage Configuration and Best Practices.

UNIT 10: Administrator Cockpit and technical Content in SAP Net Weaver BW 7.3

Te

Unit 11: BW Operations: Process Chain Monitor a. Monitoring Process Chains. b. Enhancement in process Chains

Za ra n

UNIT 11: EDW Performance Improvements

UNIT 12: Authorizations in BW: Improvements and Migration

SAP BW 7.3 Delta Certification Guidelines PROJECTS

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 5 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

SAP BW 3.X, BW 7.0 to BW 7.3 Delta Professional Competency Development Program We focus on delivering Role-Specific training rather than Product based Training

C.

CASE STUDY – 5 Complex Dataflows using Graphical Modeling

LL

DataFlow 1: 2 years transaction data, from Jan2006 to Dec2007, will come from a flat file source system and stored first in an ODS object, and then moved to 5 different info cubes based on the date of transaction. [Note: The ODS object will be write optimized when implementing the solution in BI.7 scenario. Also, use the DTP’s select options rather than the code logic when moving data from DSO to infocubes.]

ch

DataFlow 2: Transaction data is coming from 2 different source systems, an ECC system and a flat file source system. The data source structure is the same in both cases. The data will merge in an ODS object before moving on further to 2 different infocubes based on the value of debit/credit indicator field. The debit /credit indicator field is not coming from any of the source systems nor is it part of the ODS object structure but rather it will be derived from the values of debit post and credit post fields coming from the source systems.

Te

DataFlow 3: Transaction data pertaining to 3 Sales Areas is coming to BI from 2 different source systems, an ECC system and a flat file source system. The data from each source system will be stored first in separate ODS objects, rd rd then it will be merged in a 3 ODS object. From the 3 ODS object the data will be separately stored in 3 infocubes based on the Sales Area. st

nd

Za ra n

DataFlow 4: Plan and Actual Transaction data pertaining to 1 and 2 quarters of 2008 is coming from an R/3 (ECC) source system and some data is also coming from a flat file source system. The data from the ECC system is detailed and each transaction indicates the revenue generated by each employee in each Sales Area whereas the data from the flat file is summarized and gives a total revenue figure at Sales Area level only. The data from the ECC source system will go to an ODS object whose fields contents are the same as in the datasource. The data from the flat file will go to another ODS object whose structure is similar to the structure of the first ODS object and therefore includes employee field also. This employee field is not on the flat file therefore it will have to be included using ‘RETURN rd TABLE’ concept. Once the data has been transferred to the 2 ODS objects, it will be merged and stored in a 3 ODS rd object. Now the 2 quarter’s combined detailed data residing on this 3 ODS object has to be separately stored onto th th another two ODS objects (the 4 and 5 ODS objects) based on the quarter. This is not the end of the story as we still th have to separate the ‘Plan’ and ‘Actual’ data existing in the 4 ODS object and store it separately in 2 different th infocubes (Infocube # 1 and infocube #2). Similarly data from the 5 ODS object will go to Infocube #3 and infocube #4. The infocube will have a field Plan/Actual Indicator field whose value will be derived from the Vtype field. st

nd

DataFlow 5: The transaction data pertaining to 1 and 2 quarters of 2008 is coming to BI from 3 source systems, an ECC system, a DB Connect source system and a flat file source system. This data has to be stored in 2 ODS objects based on the quarter. Then, it has to be further segregated and stored in different infocubes based on the value of the Customer Group.

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 6 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA