BW / BI

• Extended star schema vs. classic star schema concept
• Data flow in BW: Data Source, InfoSource, Transfer Rules, and Update Rules.
• InfoSource: InfoSource types, creating and maintaining InfoSources.
• Update Rules: Creating Update Rules for Data Targets and the options available
• InfoObjects: InfoObjects Catalogue, Creating InfoObjects, Characteristics and Key Figures.
• Master Data: Texts, Attributes and Hierarchies. Use and maintenance of Master Data.
• Cube: Star Schema, Dimensions, Creating and Maintaining InfoCube.
• Data Targets: InfoObjects, Basic InfoCube and ODS Object.
• InfoProviders: MultiProviders, Virtual Cubes InfoSet.

• Source Systems: Connection with BW, Creating Source Systems (Flat File).
• Extraction from SAP Source systems: standard, customized, and generic extractors.
• Extraction form R/3: Extract structures, Transfer structure, Delta Process
• Customizing: Enhancing Business Content.
• User Exits: Transaction Data, Master Data, Texts and Hierarchies.

• Business content: installing and collecting objects, BW statistics.

• Queries: New queries, restricting characteristics, formulae, 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.

• WAD: Functions of WAD, Web Items window, template window, properties window.
• Web Applications: Creating Web Applications, settings, stylesheets, symbols and properties.
• Design: Designing the layout of Web Templates, working with library for Web Items.
• Web Items: tables, figures, checkboxes, dropdown boxes and other web items, and their
• attributes.

• Functions of BEx toolbar: open, save, change and refresh queries
  Evaluating query data: Navigating queries, selecting filter values, saving query variants.
  Workbooks: Cell areas, workbook templates, display options and more.

• OLAP vs. OLTP: the OLAP concept and differences between OLAP and OLTP.

• Scheduling Packages: creating package, assigning settings, variants with process chains.

• Resume building with sample resume.
• Frequently asked interview questions.
• Common production issues.