Enterprise Data Warehousing

Introduction

1. General Introduction.
2. SAP introduction.
3. Data warehousing/ BW/ BI Introduction
4. Master data; Attributes, Texts, and Hierarchies.
5. Standard Naming conventions in SAP and BI

Data Modeling

• InfoObjects: Definitions
• Types: Characteristics, Key Figures, Time, and Unit.
• InfoCubes: Definitions.
• Types: Standards, real time, remote.
• Design of Infocube: Star Schema concepts. Precautions.
• DataStore objects (DSO):
• Types: Standards, Real time.
• InfoSets
• MultiProviders: Scenarios to create Multiproviders.
• Infocube VS DSO

Metadata and Document Management

• BI Content: Definitions, How to install BI contents,

Defining extraction

• For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource.
• Or for files: Creating DataSources for File Source Systems

Defining transformations

• Transformations and different scenarios.

Defining the data flow:

• Creating data transfer processes
• Creating process chains

Scheduling and monitoring:

• Checking process chain runs
• Monitor for extraction processes and data transfer processes

Performance optimization:

• Creating the first aggregate for an InfoCube
• Using the BIA index maintenance wizard

User management:

• Setting up standard authorizations
• Defining analysis authorizations

Transports:

Real business scenarios on different system environments, Moving objects from one system to another.

BI SUITE: Business Explorer

BEx Query Designer

• Queries: New queries, Restricting Characteristics, Formulas and Exception Cells
• Query Design: Defining Exceptions, Conditions, Restricted and Calculated KeyFigures
• Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
• Component Properties: Properties of Characteristics, Attributes, Structure, Formula, KeyFigures
• 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, Stylesheets, 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

• BEx Analyzer
• BEx Web Application Designer
• BEx Report Designer

BI Platform

• 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.

OLAP

• OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTP
• OLAP Functions: Aggregation, Currency Translation, Report-to-Report Interface
• MetaData Repository: Searching for MetaData

Career Related Support

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

Advanced Topics

BUSINESS OBJECTS XI 3.X

• Overview of Business Object (BOBJ) XI 3.x
• BOBJ Terminology.
• Architecture of Business objects (BOBJ) XI 3.x
• BOBJ XI 3.x Hybrid solutions and its various tools
  • BOBJ Universe XI designer
  • BOBJ Data Integrator XI
  • BOBJ Web Intelligence (WebI) : Report Design
  • BOBJ Crystal Reports
  • BOBJ Xcelsius
  • BOBJ Voyager
• Visual Demonstration on integrating BI and BOBJ.
• Detail Overview and visual demonstration of the powerful key features of the reporting tools over BI BEx and other various type of reports using BOBJ Xcelsius – Dashboard, BOBJ Crystal Reports, BOBJ WebI
• Real-Time Reports using Xcelsius and Data Integrator.