Courses
SAP
- SAP ABAP
- SAP BASIS
- SAP SECURITY
- SAP NETWEAVER
- SAP XI
- SAP FICO
- SAP FSCM
- SAP MM
- SAP WM
- SAP PP
- SAP SRM
- SAP BW
- SAP BI
- SAP BPC
- SAP MDM
- SAP SD
- SAP CRM
- SAP BO
- SAP HR
- SAP HR-ABAP
- SAP GRC
- SAP HCM
- SAP APO
- SAP EP ADMIN
- SAP IS UTILITIES
- SAP PLM
- SAP SCM
- SAP PC
- SAP QM
- SAP IS RETAIL
- SAP EP JAVA WEBDYNPRO
- SAP HANA
- SAP PS
- SAP PI
- SAP IS OIL & GAS
- SAP CS
Oracle
- ORACLE 10 g
- ORACLE APPS DBA
- ORACLE APPS FINANCIALS
- ORACLE APPS TECHNICAL
- ORACLE BPEL
- ORACLE OAF
- ORACLE APPS FINANCE FUNCTIONAL R12
- OBIEE
- ORACLE 11G
- ORACLE DBA
- PL-SQL
- ORACLE HRMS
- ORACLE ADF
Other Technologies
- MS.NET
- SHARE POINT
- JAVA
- SAS
- SAS BI
- SAS OC
- QA TESTING
- SQL SERVER
- TIBCO
- SIEBEL CRM
- SIEBEL ANALYTICS
- UNIX SHELL
- BIZTALK SERVER
- CCNA
- SAS FINANCIAL MANAGEMENT
- AJAX
- LINUX
- SALES FORCE
- CCNP
- MCSE
- VMWARE
- PEOPLESOFT HRMS TECHNICAL
- CRYSTAL-REPORTS
- PMP
- TERA DATA
- WEBSPHERE
- ANDROID
- HADOOP
Data Warehousing
- INFORMATICA
- COGNOS
- DATA STAGE
- BUSINESS OBJECTS
- BUSINESS ANALYST
- COGNOS TM1
- AB INITIO
- MICROSTRATEGY
- COGNOS PLANNING AND BUDGETING
- HYPERION ESSBASE
- HYPERION DATA RELATIONSHIP MANAGEMENT
- HYPERION FINANCIAL MANAGEMENT
- HYPERION INTERACTIVE REPORT
- HYPERION FINANCIAL DATA QUALITY MANAGEMENT
- HYPERION PLANNING
- HYPERION FINANCIAL REPORT
SAP - BW Course Content
Week 1
- Introduction to Data Warehousing
- Multidimensional Modeling
- BW Architecture
- Extended Star Schema
- Introduction to BW Objects and Administrative Work Bench
- Introduction to Characteristics and Key Figures
- Texts Attributes Hierarchies for Master Data
- Data Flow in BW( Info sources/Data Source)
- Introduction to different Info Providers ( Cubes/ODS etc)
- Loading Data to a Data Target through flat files
- Meta data repository.
Week 2
- Extraction of data from R/3 system
- Concept of Delta Queue
- Introduction to different Delta Types in R/3
- Debugging Extraction and Concept of Data Source in R.3
- Extraction using Generic Extraction (Table/View/Info set/ FM)
- Extraction from FI(GL/AP)
- Extraction of COPA Data
- Logistics Data Extraction (SD/MM)
- Extraction Performance Tuning Techniques
- BW Customization
At the end of the course you will get good expertise in below areas:
- Data modeling.
- Extraction techniques and creating data targets.
- BEx reporting
- Data scheduling with Process chains
- Performance tuning
Week 3
- Introduction to Business Explorer
- Understanding Bex Browser, Bex Query Designer, Bex Web Application Server
- Advance Reporting/Web Reporting Techniques
- Introduction to Reporting Agent (Precalculation)
- Overview of Reporting Authorization Objects and their Usage in Security
- Performance Techniques for queries by using Aggregates. OLAP cache
- Debugging queries using RSRT Tcode
- Open HUB
Week 4
- Introduction to Multi providers , Info set and Master Data Reporting
- Introduction to Process Chains for optimal data load scheduling
- Overview and Introduction of Metadata Repository
- Business Content usage and Object Version
- Introduction to the concept of delta for data loading process
- Transport Methodology
- Performance tuning( Aggregates , Compression etc)
- Real time scenarios.