Course description: SAP Netweaver BW BI 7.3 certification preparation
-
Individualized support in Spanish
-
Access duration: 3 months
-
Duration in hours: approximately 170 hours, for an average participant with a certain level of basic knowledge of technical English language and technology
- Fee: Request offer
-
Laboratories, practices and activities: As indicated in the attached video
Introduction
SAP BW is a data warehouse tool. In simple terms, it integrates data from different sources, transforms and consolidates, cleanses and stores data as well. It also includes data modeling, administration, and staging. Content-rich SAP BW sets a precedent for speed and ease of implementation and maintenance as it is pre-configured with intelligence about a company's business process, providing faster return on information. SAP BW remains open to different source code system, and also has ease of implementation and maintenance. Enterprise demand for end users who need expertise in integrating ERP data into corporate data warehouses is growing exponentially. This creates great opportunities for certified SAP BW professionals in defining their professional career.
Course objectives
After completing this course, the participant will be able to:
- Become an expert by developing skills in modeling concepts such as DSO, DTP and multidimensional modeling
- Gain insights from data extractions
- Understand the basics and advanced concepts of Reports
- Improve your knowledge in new features of SAP BW such as hybrid provider, Open Hub Services, etc.
- Get the ability to run web reports with the new Web Application Designer
Course content
Unit 1: The Multi-dimensional Model in SAP BI
The SAP BW Star Schema Concept
Data warehousing Workbench (DWB)
Preview
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 sources 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
Preview
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)
DTP and its role in loading data to InfoCube in Extraction mode
Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes
Unit 10: SLT Configuration, MultiProviders and Extractions
Steps for performing SLT ConfigurationData Store Objects concept
Unit 11: Virtual Cubes and Multi Providers
Virtual Cubes
Multi Providers
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
Business Content (BCT)
Unit 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)
Managing Basic Cubes
Aggregates
BI Accelerators
Unit 9: Datasource Enhancement
DTP and its role in loading data to InfoCube in Extraction mode
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
Steps for performing SLT Configuration Data Store Objects concept
Unit 10: Virtual Cubes and Multi Providers
Real time examples on process Chains (Meta Chains)
Multi Providers
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: CHARACTERISTICS
Properties and Attributes of Characteristics
Integrating attributes and hierarchies in reports
Unit 6: Attributes
Characteristic Variables
Hierarchy variables
Hierarchy Node variables
Variable Formula
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
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)
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
Previous requirements
-
Proficient in basic data storage concepts.
This course is best suited for the following professionals:
- BI & Data Warehouse Managers
- Consultants
- Implementation experts
- Architects
- Developers
Language
Contents: An important part of the course is in the English language as well as the practices and laboratories.
Fee
If you are interested in taking this course in any training modality, please contact us.
