VIDEOS TO LEARN ABOUT OUR UNIQUE TRAINING PROCESS:

Facebook Recommendations

Training Details

Course Duration: 65-70 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:

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 for SAP customers.
  • Someone who is working as a SAP consultant and wants to learn SAP BW 7.3 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.

Training Highlights

  • Focus on Hands on training with lot of assignments, practice exercises and quizzes
  • Assignments after each Module
  • Quality Study material
  • SAP BW 7.3 Concepts covered for better understanding of SAP BOBJ integration with SAP BW
  • Case Studies based on Real-time project based Scenarios
  • Certification Guidance
  • Certificate of Participation at the end.

SAP-BW-BI-7.3-Training-Roadmap

How are we Different from other Training Institutes?

Role-Specific Training – Traditional training focuses on an overall business process, without regard for the individual’s role. By contrast, ZaranTech’s series of role-based courses delivers in-depth training on a specific role within the business process.

Hands-on Mentoring – Our expert trainer’s work side-by-side with each trainee and teach proven discipline and techniques for successful delivery. Mentoring is “hands-on” as part of actual projects to gain real-time experience.

Real-time Project Experience – Comprehension of practical skills is both reinforced and demonstrated in our training programs by completing Case studies of actual projects.

Certification Exams –Our trainers are all certified and provide expert industry level guidance to certification exams with tips and tricks to guarantee consistency of skills and practices for a successful completion of certification.

Ongoing Education – ZaranTech continues to offer new courses so you can keep up-to-date on latest technologies and best practices.

After reviewing your goals, and assessing your current IT skills capability, ZaranTech will tailor an after-the-training program and placement plan that will meet your needs in successful placement. This includes Resume preparation assistance, Mock interviews (technical and project based), Soft Skills and On-the-job support.

Modules Covered in this Training

In this training, attendees learn:

I. MODELING
Unit 1: The Multi-dimensional Model in SAP BI 7.3
Unit 2: Data Extraction and Data Flow within SAP BI 7.3 NW 2004S
Unit 3: New Data source Concept of BI 7.3
Unit 4: Transformation in BI 7.3(ETL)
Unit 5: DTP (Data Transfer Process)
Unit 6: UPGRADING DATAFLOWS FROM 3.X TO BI 7.3
Unit 7: Business Content
Unit 8: Administration of InfoCubes and Aggregates
Unit 9: DSO (DATA STORE OBJECTS)
Unit 10: Virtual Cubes and Multi Providers
Unit 11: New Enhancement of SAP BW 7.3

Mini project: The student has to work on 5 dataflows given by the Instructor.

II. DATA EXTRACTIONS (ETL)
ECC Extractions Using BI 7.3 Dataflows
Unit 1: Overview of ECC6.0 Extractions.
Unit 2: Generic Extractions.
Unit 3: Business Content Extractions.
Unit 4: CO-PA Extractions (COST PROFITABLE ANALYSIS)
Unit 5: LO-COCK PIT Extractions (LOGISTICS)
Unit 6: FI-SL Extractions (Financial special purpose ledger)

SAP CRM Extractions.
Unit 7: Delta Management
Unit 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)
Unit 9: Datasource Enhancement
Unit 10: Process Chains in Detail covering all process Types
Unit 11: Upgrading process Chains from 3.x to BI 7.3
Unit 12: APDS (Analysis Process Designers)
Unit 13: New Enhancement of SAP BW 7.3

III. REPORTING
Unit 1: Introduction to BI Enterprise Reporting.
Unit 2: Navigating in Reports
Unit 3: First Steps in Query Designer
Unit 4: Key Figures
Unit 5: CHARACTERSTICS
Unit 6: Attributes
Unit 7: Exceptions and Conditions.

ADVANCED REPORTING Topics
Unit 8: RRI (report to report interface)
Unit 9: Bex Analyzer
Unit 10: Bex Web Analyzer
Unit 11: Overview of Information Broadcaster.
Unit 12: Web Reporting using new Web Application Designer
Unit 13: New Enhancement of SAP BW 7.3

Overview of Integrated Planning in BI 7.3 (IP) Transporting Objects (CTO).

NEW ENHANCEMENTS OF SAP BW 7.3
  UNIT 1: Hybrid provider
UNIT 2: New monitors in BW Administration cockpit
UNIT 3: Generic delta functionalities for further types of Data Sources
UNIT 4: Hierarchies
UNIT 5: Data Transfer Process (DTP)
UNIT 6: Open Hub Service
UNIT 7: Transformation
UNIT 8: SAP BODS (New ETL Tool of SAP) Integration

Main Project Will be given to the students once they finished the course.

Attendees also learn:
1. Resume Preparation Guidelines and Tips
2. Mock Interviews and Interview Preparation Tips

Topics Covered

I. MODELING

Unit 1: The Multi-dimensional Model in SAP BI

  • The SAP BW Star Schema Concept
  • Data warehousing Workbench (DWB)
  • Info Objects
  • Info Cubes

Unit 2: Data Extraction and Data Flow within SAP BI 7.3 NW 2004S

  • 3.x Dataflow
  • Overview of BI 7.3 Dataflow
  • Comparison of 3.x and BI 7.3 Data flows
  • Loading Master Data (Attributes, Texts, Hierarchies)
  • Loading Transaction Data

Unit 3: New Data source Concept of BI 7.3

  • Overview of new Datasource
  • Emulation of Data source in BI 7.3
  • Datasource Lifecycle with In BI 7.3 NW 2004S
  • Migration of 3.x data source to BI 7.3 data source

Unit 4: Transformation in BI 7.3(ETL)

  • In depth coverage of Transformation
  • Routines in Transformations (Start routine, End routine, Expert routine, transformation routine) with different Real Time examples
  • Transformation Groups
  • Unit and currency Conversions

Unit 5: DTP (Data Transfer Process)

  • Overview of DTPS
  • Trouble shooting techniques in DTPS
  • Debugging  ABAP routines Using DTPS

Unit 6: UPGRADING DATAFLOWS FROM 3.X TO BI 7.3

Unit 7: Business Content

  • Business Content (BCT)

Unit 8: Administration of InfoCubes and Aggregates

  • Managing Basic Cubes
  • Aggregates
  • BI Accelerators

Unit 9: DSO (DATA STORE OBJECTS)

  • Data Store Objects concept

Unit 10: Virtual Cubes and Multi Providers

  • Virtual Cubes
  • Multi Providers

Mini project:  The student has to work on 5 dataflows given by the Instructor.

II. DATA EXTRACTIONS (ETL)

ECC extractions using BI 7.3 Data flows
Unit 1: Overview of ECC6.0 Extractions

  • Types of ECC extractions

Unit 2: Generic Extractions.

  • Generic Extraction using
    • Database Table
    • View
    • Classical Info sets.
    • Functional Module.

Unit 3: Business Content Extractions

  • Overview of Business Content Extractions.
  • Examples from Financial, Logistics, HRMS modules.

Unit 4: CO-PA Extractions (COST PROFITABLE ANALYSIS)

Unit 5: LO-COCK PIT Extractions (LOGISTICS)

Unit 6: FI-SL Extractions (Financial special purpose ledger)

SAP CRM extractions.

  • Marketing Extractions
  • CRM SALES Extractions
  • CRM SERVICE Extractions (CRM Extractions are Very High in demand)

Unit 7: Delta Management

Unit 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)

Unit 9: Datasource Enhancement

Unit 10:  Process Chains in Detail covering all process Types

  • Real time examples on process Chains (Meta Chains)

Unit 11: Upgrading process Chains from 3.x to BI 7.3

Unit 12: APDS (Analysis Process Designers)

III. REPORTING

Unit 1: Introduction to BI Enterprise Reporting.

  • The SAP BI  Overview

Unit 2: Navigating in Reports

Unit 3: First Steps in Query Designer

  • Query Designer
  • Info providers in query Designer

Unit 4: Key Figures

  • Restricted Key Figures
  • Calculated Key Figures
  • Properties of Key Figures
  • Structures and cells

Unit 5: CHARACTERSTICS

  • Properties and Attributes of Characteristics
  • Integrating attributes and hierarchies in reports.

Unit 6: Attributes

  • Characteristic Variables
  • Hierarchy variables
  • Hierarchy Node variables
  • Formula Variables
  • Text variables
  • Variable Processing types.

Unit 7: Exceptions and Conditions.

  • Exceptions
  • Conditions

ADVANCED REPORTING Topics
Unit 8: RRI (report to report interface)

Unit 9: Bex Analyzer

Unit 10: Bex Web Analyzer

Unit 11: Overview of Information Broadcaster.

Unit 12: Web Reporting using new Web Application Designer

  • In depth of Web reporting using New Web Application Designer,
  • Detail Coverage of Dash Board Reports and each and every Web item of new WAD.

Overview of Integrated Planning in BI 7.3 (IP) Transporting Objects (CTO).

NEW ENHANCEMENTS OF SAP BW 7.3
  UNIT 1: Hybrid provider
UNIT 2: New monitors in BW Administration cockpit
UNIT 3: Generic delta functionalities for further types of Data Sources
UNIT 4: Hierarchies

  • Integration of hierarchies into process flow (DTP, Transformation)
  • Remote hierarchies for direct access to hierarchies in the source system
  • Loading hierarchies from flat file using the new Data Source and Transformation technology

UNIT 5: Data Transfer Process (DTP)

  • Data Transfer Process supports data extraction from Multi Providers
  • Option to only load the last request from a given source (available for full load DTPs)
  • Data Transfer Process supports referential integrity checks tor navigational attributes of the target
  • Enhanced load performance by possibility to Re-package small data packages within a request to bigger packages

UNIT 6: Open Hub Service

  • SAP Net Weaver BW data can be exported in XML format
  • Possibility to change the format and length of BW data for export even into a non-SAP specific format
  • Hierarchy extraction supported by Open Hub

UNIT 7: Transformation

  • Semantic grouping possible in Transformations (in addition to semantic grouping in DTPs)
  • Possibility to select the Info Objects (fields) the user wants to use in a Start- / End routine
  • Currency and unit conversion for Data Store object and Info Source as target of a Transformation.
  • Navigation attributes of Info Cubes/Data Store objects can be used as source fields in the Transformation and as filter/select options in the DTP 
  • Automated generation of a proposal by mapping fields of the Data Source to Info Objects

UNIT 8: SAP BODS (New ETL Tool of SAP) Integration

Main Project Will be given to the students once they finished the course.

About the trainer

  • 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), BPC, CRM (5.0, CRM2007), SD, ABAP/4. Primarily SAP BI with SAP BOBJ.
  • Certified SAP  BO Consultant with (a) WEBI XI 3.0 level 1 & 2 (b) SAP Crystal reports level 1 & 2 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 – “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.


What is the Difference between Live training and Video training?

These Videos here will help you understand the difference,
VIDEO – What is Instructor led LIVE Training -http://www.youtube.com/watch?v=G908QvF-gVA
VIDEO – What is Instructor led VIDEO Training – http://www.youtube.com/watch?v=naPdAyKvAI0

How soon after I Enroll would I get access to the Training Program and Content?

Right after you have Enrolled, we will send you an Email to your Gmail id with a Video on How To login to the training blog and get access to the training program and content.

What are the pre-requisites of taking this training?

- Someone who is looking to start their career in SAP.
- Someone who is looking for a career in SAP BW 7.3 for SAP customers.
- Someone who is working as a SAP consultant and wants to learn SAP BW 7.3 skills.

Who are the instructors and what are their qualifications?

All our instructors are Senior Consultants themselves with a minimum of 10 years of real-time experience in their respective fields. Each trainer has also trained more than 100 students in the individual and/or corporate training programs.

How will be the practicals/assignments done?

Practicals/assignments will be done using the training blog. Instructions will be sent after you enroll.

When are the classes held and How many hours effort would I need to put in every day/week?

Online Live sessions are held weekdays evening CST (Central Standard Time GMT-6) or on Weekends. The schedule is posted for each batch on the website. You have to put in a effort of 8-10 hrs per week going thru the videos once again and completing your assignments.

What if I miss a class?

We Video record every Live session and after the session is complete, we will post the Video recording of that session in the blog. You will have access to these Video recordings for 6 months from the date you start your training. Material access will be provided using Google Drive Cloud for lifetime.

How can I request for a support session?

You can do that by posting a question on the training blog.

What If I have queries after I complete this course?

You can post those questions on the training blog.

Will I get 24*7 Support ?

You will get 24*7 accesss to the blog to post your questions. Trainers will answer your questions within 24 hrs of time. Normally they answer very frequently, like about 1-2 hrs. You can also approach your training coordinator for the same.

Can I get the recorded sessions of a class from some other batches before attending a live class?

Yes, you can. Or you can see our Youtube page for previous batch session recordings.

How will I get the recorded sessions?

It will be provided to you through the trainng blog.

How can I download the class videos?

You wont be able to download any videos. They are available for you to View using the training blog 24*7.

Is the course material accessible to the students even after the course training finishes?

Yes.

Do you provide Placements as well

We are infact, a Consulting company which provides training so we are mainly looking for trainees who are looking for Placement after training.
After the Training Process explained (Video): http://www.youtube.com/watch?v=BrBJjoH46VI
Our 6-step training to placement process (Video): http://www.youtube.com/watch?v=BrBJjoH46VI

How can I complete the course in a shorter Duration?

Yes you can. Go for the Video Training.
VIDEO – What is Instructor led VIDEO Training – http://www.youtube.com/watch?v=naPdAyKvAI0

Do you provide any Certification? If yes, what is the Certification process?

We provide Certification guidance at the end of each course. You will also receive a “Certificate of Completion” from ZaranTech at the end of the course.

Are these classes conducted via LIVE video streaming?

We have both the options available

What internet speed is required to attend the LIVE classes?

1Mbps of internet speed is recommended to attend the LIVE classes. However, we have seen people attending the classes from a much slower internet.

What are the payment options?

We accept Credit Cards, Paypal, Bank payments from anywhere in USA, Money orders, International Wire transfer, ACH transfers, Chase Quickpay, Bank of America transfers, Wellsfargo Surepay. All the payments details are mentioned on the Enrollment page.

What if I have more queries?

Call the number listed on the Course Details page of our website.