Enterprise Data Warehousing

• Introduction and OLAP concepts
• OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTP

Data Modeling

• Creating InfoObjects: Characteristics
• Creating InfoObjects: Key Figures
• Creating DataStore objects
• Creating InfoCubes
• Creating InfoSets
• Creating MultiProviders

Data Extraction and Monitoring:

• For SAP source systems: Maintaining Data Sources
• Or for files: Creating Data Sources for File Source Systems
• Creating transformations
• Using the data mart interface
• Creating open hub destinations
• Creating data transfer processes
• Creating process chains
• Checking process chain runs
• Jobs Scheduling
• Monitor for extraction processes and data transfer processes

Business Content and Metadata Repository

• Installing BI Content
• Exploring the metadata

Performance optimization

• Creating the first aggregate for an InfoCube
• Using the BIA index maintenance wizard
• BW Statistics: Query Analysis Tools, Performance Tables
• Reporting Performance: Effective query design, Line-Item, Compression, Partitioning
• Aggregates: Creating Aggregates, Finding effective aggregates
• Data Load Performance: Parallelism, Impact of Aggregates
• Partitioning: Logical Partitioning, Table Partitioning

Basic Functions

• Condition Technique
• Pricing with Scales
• Free Goods (Inclusive & Exclusive types)
• Material Determination
• Material Listing /Exclusion
• Dynamic Product Proposal
• Cross Selling
• Partner Determination
• Account Determination
• Output Determination
• TEXT Determination
• Credit Management / Risk Management
• Availability Check and TOR
• Incompletion Log

BI SUITE: Business Explorer
BEx Query Designer

• Queries: New queries, Restricting Characteristics, Formulas and Exception Cells
• Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures
• Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
• Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key
  Figures
• Structures: Creating Re-usable structures
• Functions on BW Server: Copying queries between Cubes, Deleting Query Elements

Web Application Designer

• WAD: Functions of WAD, Web Items Window, Template Window, Properties Window
• Web Applications: Creating Web Applications, Settings, Style sheets, Symbols and
  Properties
• Design: Designing the Layout of Web Templates, working with Library for Web Items
• Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their
  attributes

Activities

• Analyzer
• BEx Web Application Designer
• BEx Report Designer

Career Related Support

• Resume Building with sample resumes
• Frequently asked interview questions
• Common Production Issues

Advanced Topics (Bonus)

• Information Broadcasting
• Functions of the Broadcaster: Precalculating and Exporting into Enterprise Portal
• User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
• Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.
• Overview of Planning with SEM-BPS.
• Architecture of BPS components.

Technical Knowledge

• Reports
• IDOC
• Tables

Additional Topics

• SD Evaluation Test
• General Discussion related to SAP SD interview.

Experiences from Implementations (Case Studies/Project)