SAP BW 7.4 On SAP HANA Online Training

Training Details

Course Duration: 60 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:

• Basics of SQL, Database & Data Warehouse (Free Learning Materials provided for the same).

Who Should Join this Training?:

• Someone who is looking to start their career in SAP
• Someone who is looking for a career in SAP BW 7.3 , 7.4 for SAP customers
• Someone who is working as a SAP consultant and wants to learn SAP BW 7.3 and 7.4 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 with lot of assignments, practice exercises and quizzes
• Assignments, Case Studies & Study Material
• Quality Study material
• SAP BW 7.4 with HANA Concepts covered for better understanding
• Case Studies based on Real-time project based Scenarios
• SAP BW 7.4 with HANA 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:

Unit 1: Introduction

Unit 2: Migration to BW on HANA and BW Data Management

Unit 3: SAP BW on HANA Architecture

Unit 4: SAP BW on HANA Data Management

Unit 5: Optimization Areas in BW on HANA

Unit 6: Modeling of SAP BW 7.4 with SAP HANA

Unit 7: Modelling with SAP’s Reference Architecture LSA++

Unit 8: Hybrid Modeling in Mixed Scenarios

Unit 9: Data Provisioning into SAP HANA and SAP BW

Unit 10: Additional Enhancements of SAP BW 7.4

Attendees also learn:

1. Resume Preparation Guidelines and Tips

2. Mock Interviews and Interview Preparation Tips

Topics Covered

Unit 1: Introduction

• Evolution of HANA Landscape
• SAP HANA Basics
• SAP NetWeaver BW 7.3/7.4
• SAP HANA Vs. BW Accelerator
• BW Modeling in SAP HANA Studio
• SAP HANA Modeling

Unit 2: Migration to BW on HANA and BW Data Management

• Migration Strategies and Tools
• SAP BW Migration Cockpit

Unit 3: SAP BW on HANA Architecture

Unit 4: SAP BW on HANA Data Management

• Multi-temperature Data Management
• Optimizing BW Data Management (WARM Data)
• Optimizing BW Data Management (COLD Data)

Unit 5: Optimization Areas in BW on HANA

• Introduction
• HANA-Optimized Data Modeling: InfoCubes
• HANA-Optimized Data Modeling: Advanced DataStore Objects
• HANA-Optimized Data Modeling: CompositeProviders
• HANA-Optimized Data Staging
• HANA-Optimized Analysis Manager
• HANA-Optimized Analysis Process

Unit 6: Modeling of SAP BW 7.4 with SAP HANA

• Models in SAP BW 7.4
• Data Extraction and Data Flow within SAP BW 7.4 NW 2004S
• New Data Source Concept of BW 7.4
• Transformation in BW 7.4 (ETL)
• DTP (Data Transfer Process)
• From 3.X to BW 7.4
• Business Content Upgrading Dataflows
• COPA
• Logistics Extraction
• Administration of InfoCubes and Aggregates
• ODS view and advanced DSO (Data Store Objects)
• Virtual Cubes and Multi Providers

Unit 7: Modelling with SAP’s Reference Architecture LSA++

• Review of the Layered Scalable Architecture
• From LSA to LSA++: Streamline Core Layers
• LSA++: Open Operational Data Store Layer
• LSA++: Agile Data Mart and BW Workspace Layer

Unit 8: Hybrid Modeling in Mixed Scenarios

• Generation of HANA-views for BW InfoProviders
• Mixed Scenarios
• SAP HANA Live
• HANA-Optimized BI Content

Unit 9: Data Provisioning into SAP HANA and SAP BW

• Overview of Data Provisioning into SAP HANA
• SLT Replication into SAP HANA
• SLT Replication into SAP BW
• Operational Data Provisioning into SAP BW
• DB-Connect and Open Hub Destination

Unit 10: Additional Enhancements of SAP BW 7.4

• InfoObject Enhancements
• Authorization Enhancements
• Process-chain Monitoring
• HANA-Optimized BW Search
• HANA-Optimized BW Planning
• Obsolete BW Object types
• Mobile Enablement Enhancements
• SAP HANA Versus BW Accelerator

About Trainer Ganesh :

• Certified BO/BW/HANA 1.0 consultant with rock solid experience in Delivery/Consulting/Assessment/POC projects with fortune 500 companies and as a Solution Architect.
• More than 11 years of Consulting & Teaching experience in SAP BO (5.0/6.0/XI R1 , XI R2, 3.0 4.X ) BW versions (2.0B, 2.1, 3.0B, 3.1C, 3.5, BW 7.0 NW 2004S), Hana SP4 ,SP5 , SP6).
• Certified SAP BW, SAP BO Consultant with (a) WEBI XI 3.0 level 1 & 2 and Hana SP5.
• With a strong background in training and deep knowledge of the core subject and techniques on getting certification successfully completed many batches around the globe.
• Trained over 120 + batches in BW/BO/HANA and 80% of the students accomplished in getting jobs in various domains.

About Trainer Sunil:

• Certified BW and HANA trainer with more than 15 years of consulting experience (Experience in SAP ABAP, BW, CRM, APO, HANA, BODS and BOBJ tools).
• Have the experience of working with big 5 consulting firms and worked on several projects for fortune 500 companies.
• Involved in multiple native HANA and BW on HANA implementations. Managed several HANA implementations.
• Involved in multi-lingual and multi-regional implementation of SAP systems. Has implemented SAP Projects for North America, South America, Germany etc.
• Experience of working with both public sector and Private sector organizations.
• Strong background in training. Has trained a lot of students both in HANA and BW on HANA.

CASE STUDY 1 – “Fashion Wear”

Data Warehouse Management with SAP BW for “Fashion Wear”:

Introduction: Our company produces Fashion wear and maintains a world-wide distribution of its products. Three product groups are offered – Jeans, Boots, and Bags. Each product group comprises of a number of products. Company’s organization is divided into one production plant and four areas of distribution.
Each area consists of two or more regions, which again has their own distribution centers.

The company’s customers are resellers who are grouped into following customer types: web shop, specialized store, retail store, shopping clubs.
Customers are attributed to at least one distribution centre.
Company’s cost controlling differentiates three cost groups – variable costs, partly fixed costs, and fixed costs.

Responsibility: You are employed as a consultant to design and implement a data warehouse for our company according to the information given Star Schema.

Tasks: You should create a Info Cube FW00_SA in the following info area where “00” stands for the user number: Info Area – FASHION_WEAR_00.

The cube has five dimensions with three navigation attributes, which can be seen from star schema. Additional it should have key figures according to data file. The dimension organization has a hierarchy, which will be retrieved from the master data. It is not time-dependent. The dimension time should have following characteristics. Any further required information can be extracted from data file structure. The source system and application component should be named as follows. The data will be manually imported from a flat file system. The info sources shall have the same notation as the info objects. The transfer data shall be directly imported into the data warehouse. The sequence of transfer data can be reviewed in flat file. Data flow can be seen in figure below: Source system: FW00_SOSY, Application component: FW00_APPCOMP

Data Flow Chart:

CASE STUDY 2 – “Inventory Disposal Planning System”

Develop an “Inventory Disposal Planning System” for a global:

The Client: A large consumer products company with major manufacturing facilities in the US and Europe, and operating in 200 countries.

The Challenge: The client wanted to improve upon its SKU Management process for the disposal of inventory, to be able to identify its slow-moving products and make timely decisions as to when an item must be taken off the shelf and disposed off.

The Solution:Company partnered with the client to carry out end-to-end development of a monitoring tool with pre-defined reports needed to support the process of tracking and execute the process of disposal of rationalized SKUs. The SKU management process utilizes a simplified market level profit valuation of the demand plan of the individual SKU. This profitability is aggregated across all markets within a region to determine the regional profitability of the SKU. If the regional profitability of the SKU overtime does not meet the defined hurdle rate, then the SKU must be identified for elimination. Company’s solution involved generating reports and trigger processes that would help make critical decisions and take action at the appropriate time to reduce or manage the inventory of SKUs. The reports are as follows:

Action Report: It lists all rationalized SKUs that require the set up of a disposal plan. Disposal plans include sell off, break down, disposal, charity, transfer, etc. They have a clearly defined execution period by which all remaining inventory should be disposed off.

Monitor Report: This ensures the follow-through and completion of the disposal process. It indicates the progress against each planned disposal.

Escalations Enabled Report: Failures to adhere to the applied disposal plan or to meet the deadline are identified from the Monitor Report and escalations enabled using this report.

Slow-moving Report: This report identifies the slow-moving SKUs and lists demand, inventory and months of forward coverage.

Non-working Inventory Summary Report: This report is used by Management at the regional and higher levels within the global value chain organization, to understand the exposure the company has in the form of inactive and potentially inactive inventory. The report is also used by financial organizations in preparing and tracking inventory reserves.

The Benefits:

1. Quick ramp-up to meet various technology skill requirements, at relatively lower costs

• Significant reduction in IT spending by having key resources onsite and coordinating with the offshore team through the offshore model
• End-to-end project responsibility resulting in a single vendor contact.

2. Rationalization to provide USD 3m in annualized carrying cost-savings

3. Process will enforce disposal of promotional goods within one quarter of completion of the promotion. This is much faster than the current practice and will result in an additional USD 1.3m generated from reduced carrying costs.

The Technology: SAP BW, Front End – BeX, Database- Oracle 8.1, Autosys.

How to be a certified SAP BW on SAP HANA certification?

Certification for SAP BW on SAP HANA can be attained by the aspirant in the following steps:

Step 1: Once training is over, Registration must be done for BW 362R exam.

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

What are the requirements for the certification?

Degree is desired along with the basic understanding of the concepts and functionalities of Object oriented programming shall be an advantage.

What are the pattern for the exam and the duration for the test?

The examination would consist of 80 multiple choice questions, the duration for the examination is 180 minutes and the passing score is 64%.