SAP NetWeaver BW BI 7.3 Certification Training

Description

SAP BW is a Data Warehouse tool. In simple terms, it integrates data from different sources, transforms and consolidates, cleanse and stores data as well. It also includes data modeling, administration and staging area. The content-rich SAP BW sets a precedent for speed and ease of implementation and maintenance because it’s pre-configured with intelligence about a company’s business process, providing a faster return on information. SAP BW remains open to the different source system, and it will also come as a pleasant surprise for its ease of introduction and maintenance. The demand from end user companies needing expertise in the integration of ERP data into corporate data warehouses is growing exponentially. Thus resulting in great opportunities for certified SAP BW professionals in defining their career path.

Did you Know

1.  SAP BW 7.3 is shipped with a graphical data modeling tool set. The goal of this toolset is to drastically reduce the manual work effort in creating dataflows
2.  SAP BW 7.3 is a wizard-based system configuration that supports copying data flows, process chains etc.
3.  Load times into DSO objects has been reduced by up to 40% when compared to BI7 and the loading of Master Data has been accelerated
4.  BW Accelerator performance is improved with the help of automated creation of Semantic Partitioned Objects

Why learn and get Certified in SAP BW 7.3?

1.  The SAP Business Warehouse software is an extremely versatile data extraction, reporting, and aggregation tool. Therefore this training and certification that follows can help a professional pursue and obtain a great job in this industry.
2.  Data is growing by leaps and bounds, companies are competing more and more using Analytics where Analytics companies are innovating and simplify the way to get answers easily thus there is a huge demand for SAP BW professionals.
3.  SAP has a huge amount of market share in BI/BW with complex ecosystem of products, and so professionals with skills in this area are always going to be in great demand.

Pre-requisites

1.  Basic knowledge of Data Warehousing (Learning Materials Provided)
2. Pre-requisites Materials provided:SQL Tutorial (SQL Tutorial)
3. Pre-requisites Materials provided Data Modeling and DW concepts (Data Modeling and DW concepts)

Course Objective

After the completion of this course, Trainee will:

1.  Expertise their skills in Modelling concepts like DSO, DTP, and Multi-dimensional model
2.  Attain knowledge in basic concepts of Data Extractions
3.  Understand basics and advanced concepts of Reporting
4.  Enhance their knowledge in new features of SAP BW like Hybrid Provider, Open Hub Services, etc.
5.  Gain ability to perform Web Reporting using new Web Application Designer

Who should attend this Training?

This comprehensive course is meant for professionals who aspire to build a career or upgrade knowledge in SAP BW on HANA. This course is best suited for the following professionals:

1.  Business Intelligence and Data Warehousing professionals
2.  SAP Technical & OLAP Consultant
3.  Software Analysts and Mainframe professionals
4.  Project Managers and Business Objects Professionals
5.  Those aspiring for a career in SAP BI/BW

Prepare for Certification!

Our training and certification program gives you a solid understanding of the key topics covered on the SAP BW. In addition to boosting your income potential, getting certified in SAP BW demonstrates your knowledge of the skills necessary to be an effective SAP BW Professional. The certification validates your ability to produce reliable, high-quality results with increased efficiency and consistency.

I. MODELING

Unit 1: The Multi-dimensional Model in SAP BI

1. The SAP BW Star Schema Concept
2. Data warehousing Workbench (DWB)
3. Info Objects
4. Info Cubes

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

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

Unit 3: New Data source Concept of BI 7.3

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

Unit 4: Transformation in BI 7.3(ETL)

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

Unit 5: DTP (Data Transfer Process)

1. Overview of DTPST
2. rouble shooting techniques in
3. DTPSDebugging ABAP routines Using DTPS

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

1. Business Content (BCT)

Unit 8: Administration of InfoCubes and Aggregates

1. Managing Basic Cubes
2. Aggregates
3. BI Accelerators

Unit 9: DSO (DATA STORE OBJECTS)

1. DTP and its role in loading data to InfoCube in Extraction mode
2. Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes

Unit 10: SLT Configuration, MultiProviders and Extractions

1. Steps for performing SLT ConfigurationData Store Objects concept

Unit 11: Virtual Cubes and Multi Providers

1. Virtual Cubes
2. Multi Providers

Unit 1: Overview of ECC6.0 Extractions

1. Types of ECC extractions

Unit 2: Generic Extractions Generic Extraction using a.Database Table b.View c.Classical Info sets d.Functional Module Unit 3: Business Content Extractions

1. Overview of Business Content Extractions
2. 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)

1. SAP CRM extractions Marketing Extractions
2. CRM SALES Extractions
3. CRM SERVICE Extractions (CRM Extractions are Very High in demand)

Unit 7: Delta Management

1. Business Content (BCT)

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

1. Managing Basic Cubes
2. Aggregates
3. BI Accelerators

Unit 9: Datasource Enhancement

1. DTP and its role in loading data to InfoCube in Extraction mode
2. Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes

Unit 10: Process Chains in Detail covering all process Types

1. Steps for performing SLT ConfigurationData Store Objects concept

Unit 10: Virtual Cubes and Multi Providers

1. Real time examples on process Chains (Meta Chains)
2. Multi Providers

III. REPORTING Unit 1: Introduction to BI Enterprise Reporting

1. The SAP BI Overview

Unit 2: Navigating in Reports Unit 3: First Steps in Query Designer

1. Query Designer
2. Info providers in query Designer

Unit 4: Key Figures

1. Restricted Key Figures
2. Calculated Key Figures
3. Properties of Key Figures
4. Structures and cells

Unit 5: CHARACTERSTICS

1. Properties and Attributes of Characteristics
2. Integrating attributes and hierarchies in reports

Unit 6: Attributes

1. Characteristic Variables
2. Hierarchy variables
3. Hierarchy Node variables
4. Formula Variables
5. Text variables
6. Variable Processing types

Unit 7: Exceptions and Conditions

1. Exceptions
2. 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

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

NEW ENHANCEMENTS OF SAP BW 7.3 UNIT 1: Hybrid provider UNIT2: New monitors in BW Administration cockpit UNIT 3: Generic delta functionalities for further types of Data Sources UNIT 4: Hierarchies a.Integration of hierarchies into process flow (DTP, Transformation) b.Remote hierarchies for direct access to hierarchies in the source system c.Loading hierarchies from flat file using the new Data Source and Transformation technology UNIT 5: Data Transfer Process (DTP) UNIT 6: Open Hub Service a.SAP Net Weaver BW data can be exported in XML format b.Possibility to change the format and length of BW data for export even into a non-SAP specific format c.Hierarchy extraction supported by Open Hub UNIT 7: Transformation a.Semantic grouping possible in Transformations (in addition to semantic grouping in DTPs) b.Possibility to select the Info Objects (fields) the user wants to use in a Start- / End routine c.Currency and unit conversion for Data Store object and Info Source as target of a Transformation d.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 e.Automated generation of a proposal by mapping fields of the Data Source to Info ObjectsUNIT 8: SAP BODS (New ETL Tool of SAP) Integration

About SAP BW 7.3 Certification

SAP BW 7.3 certification verifies the knowledge in the area of the SAP NetWeaver Business Intelligence solution for the consultant profile in SAP NetWeaver Business Intelligence. This certificate builds on the basic knowledge gained by a BI Consultant and preferably refined by practical experience within a BI team. The BW Consultant can implement this knowledge in the specialized areas practically in the projects.

SAP Certified Application Associate - Business Intelligence with SAP BW 7.3 and SAP BI 4.0

SAP Certified Application Associate certification validates a professional’s ability to work on SAP BW 7.3. The trainee can apply the knowledge to implementation activities as an Application Consultant under expert supervision.

Pre-requisites

• 1. There is no such pre-requisite to take up this certification

Exam Details

• 1. Exam duration is 180 minutes
• 2. There are 80 Questions
• 3. Passing mark is 69 percent
• 4. This is Associate level Certification Exam

Generic SPVT Training Faqs:

Who are the Instructors and what are their qualifications?

All Instructors from ZaranTech are working professionals from leading organizations who have minimum of eight years of real-time consulting experience working on live projects and good subject knowledge. They have more than three years of experience in training. Most of our trainers are certified professionals as well and help the students to get certified.

How will I do my practicals?

We will help you to setup Virtual Machine in your system with local access. The detailed installation guides will be provided for setting up the environment. In case, your system doesn’t meet the prerequisites e.g. 4GB RAM, you will be provided remote access to the Server for the practicals. For any doubt, our 24*7 support team will promptly assist you.

How soon I would get access to the learning content after Signing up?

As soon as you enrol to the course, an immediate access to our course content in the form of Videos, PPTs, Assignments and Assessments will be provided so that you can start learning right away.