About Course :
This Training Course touches upon all the important aspects of the SAP Business Intelligence and Business Warehousing domains. You will be trained in SAP Architecture, SAP BW Modeling, Application of SAP, extracting data from SAP BW, and study of SAP BW Data Schema.
Module of Training
LIVE ONLINE TRAINING
- Live presentation of theory, demonstration of tool, features & tasks
- We are connecting Online via Goto Meeting
- Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern.
CORPORATE TRAINING
- Learn as per day-wise & customized schedule with discussions & lab exercises included
- One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes
- World-class learning material & case studies for the course
- Completely customizable course content & schedule as per convenience
- Certification guidance provided if necessary
Curriculum
MODELING
The Multi-dimensional Model in SAP BW
- The SAP BW Star Schema Concept
- Data warehousing Workbench (DWB)
- Info Objects
- Info Cubes
Data Extraction and Data Flow within SAP BW 7.4 NW 2004S
- 3.x Dataflow
- Overview of BW 7.4 Dataflow
- Comparison of 3.x and BW 7.34 Data flows
- Loading Master Data (Attributes, Texts, Hierarchies)
- Loading Transaction Data
New Data source Concept of BW 7.4
- Overview of new Datasource
- Emulation of Data source in BW 7.4
- Datasource Lifecycle with In BW 7.4 NW 2004S
- Migration of 3.x data source to BW 7.4 data source
Transformation in BW 7.4(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
DTP (Data Transfer Process)
- Overview of DTPS
- Trouble shooting techniques in DTPS
- Debugging ABAP routines Using DTPS
UPGRADING DATAFLOWS FROM 3.X TO BW 7.4
Business Content
- Business Content (BCT)
Administration of InfoCubes and Aggregates
- Managing Basic Cubes
- Aggregates
- BI Accelerators
DSO (DATA STORE OBJECTS)
- Data Store Objects concept
Virtual Cubes and Multi Providers
- Virtual Cubes
- Multi Providers
DATA EXTRACTIONS (ETL)
ECC extractions using BW 7.4 Data flows
Overview of ECC6.0 Extractions
- Types of ECC extractions
Generic Extractions.
- Generic Extraction using
- Database Table
- View
- Classical Info sets.
- Functional Module.
Business Content Extractions
- Overview of Business Content Extractions.
- Examples from Financial, Logistics, HRMS modules.
CO-PA Extractions (COST PROFITABLE ANALYSIS)
LO-COCK PIT Extractions (LOGISTICS)
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)
Delta Management
Extracting Master Data from CC (Attributes, Text, Hierarchies)
Datasource Enhancement
Process Chains in Detail covering all process Types
- Real time examples on process Chains (Meta Chains)
Upgrading process Chains from 3.x to BI 7.3
APDS (Analysis Process Designers)
REPORTING
Introduction to BI Enterprise Reporting.
- The SAP BI Overview
Navigating in Reports
First Steps in Query Designer
- Query Designer
- Info providers in query Designer
Key Figures
- Restricted Key Figures
- Calculated Key Figures
- Properties of Key Figures
- Structures and cells
CHARACTERSTICS
- Properties and Attributes of Characteristics
- Integrating attributes and hierarchies in reports.
Attributes
- Characteristic Variables
- Hierarchy variables
- Hierarchy Node variables
- Formula Variables
- Text variables
- Variable Processing types.
Exceptions and Conditions
- Exceptions
- Conditions
We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.