After the Course, we will be conducting mock interviews and give a report about your performance in the interviews.

Modeling – Fundamentals for Business Warehouse

• Overview of Data Warehousing
• Terminology and definitions of Objects in Business Warehouse
• Basics about Master Data – Attributes, Text, Hierarchies.
• Installation and Identification of Business Content
• Loading Master Data and Transaction Data Attributes from Flat File and ECC
• Loading Master Data Texts and Transaction Data from Flat File and ECC
• Loading Master Data Hierarchies and Transaction Data from Flat File and ECC
• InfoObject
• InfoSource
• Datasource/PSA
• Info Cube – Star Schema and Extended Star Schema
• Data Store Objects
• Transformations
• Data Transfer Process (DTP)
• Process Chains
• Administration of Data Targets – InfoCubes, Data Store Objects

Advanced Modeling in Business Warehouse

• Advanced Modeling Scenarios for Master Data
• Advanced InfoProvider Modeling
• Multiprovider
• InfoSets
• Designing the dimensions of Info Cube
• Data Store Objects
• Open Hub Destination
• Transport Organizer
• Process Chains Event Triggering
• Data Modeling Case Studies

Reporting - Business Explorer

• Query Designer
• Restricted Key Figures
• Calculated Key Figures
• Formulas
• Selections
• Structures
• Filters
• Variables
• Exceptions
• Conditions
• Hierarchies
• Bex Analyzer – Navigation
• Bex Web Analyzer – Navigation
• Information Broadcasting
• Navigation in reporting tools

Extraction/Data Acquisition

• Manage Data Sources
• Manage Extract Structures
• Identify BI Content Data Sources
• Transfer Data Sources to BW
• General Data Acquisition
• Logistics Data Extraction
• Delta Management
• Generic Data Sources

Performance Tuning & Implementation Strategies, Demo Projects, Assignments, Misc Topics

• Info Providers
• Info Providers Administration
• Reporting Performance
• Aggregates
• Data Acquisition Performance
• ASAP Methodologies
• Discuss Implementation Scearios, hurdles and best practices
• Guide in implementing a real time project scenario
• Assignments, Exercises, Quizzes which are necessary for training
• Difference between BW 3.x Version and BW 7.0 Version
• Explain BW 3.x Version Data Flow
• Migration of BW 3.x version object to BW 7.0 Version