SAP BI Course Contents

Introducing Datawarehouse

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

Introducing SAP BI

  • General Introduction.
  • SAP introduction.
  • Data warehousing/ BW/ BI Introduction
  • Master data; Attributes, Texts, and Hierarchies.
  • Standard Naming conventions in SAP and BI.

 

Data Modelling

Info Objects

  • Characteristics
  • Key Figures

Data Flow (Transformation, Info Sources, Data Sources)

  • Dataflow in BI
  • Transformation Process
  • Datasource and Infosources 3.X
  • Emulated Datasources 3.X

Info Provider (Info Cubes, Multi Providers, Virtual Provider, Data Store Objects, Info Sets, Info Objects, Direct Access)

  • Infocubes
  • DSOs
  • Virtual Providers
  • Multiproviders and BI Infoset
  • Direct Access

Performance Tuning (Aggregates, Query Performance, BI Accelerator)

  • Aggregates
  • Query Performance
  • BI Accelerator

 

Scheduling & Monitoring (Process Chains, Real Time Data Acquisition, Data Load Monitor)

  • Process chains
  • RDA

Meta Data (Meta Data Repository, Remodeling Toolbox, BI Content)

  • Meta Data Repository
  • BI Content
  • Remodeling Toolbox

Source Systems (UD Connect, Service API, Flat File, DB Connect) & DTP

  • Service API
  • Flat File, BI Infosource and DTP (TBW 10 Unit 4 Page 260-318)
  • DB Connect

 

Data warehousing/Dimensional modeling & SAP BW 7.3 Concepts

  Database Concepts needed for Data warehousing

Defining extraction
  •  For SAP source systems: Creating Generic DataSource and maintaining SAP delivered DataSource
  • Or for files: Creating DataSources for File Source Systems

 

 

Metadata and Document Management
  • BI Content: Definitions, How to install BI contents
Defining transformations
  • Transformations and different scenarios
Defining the data flow
  • Creating data transfer processes
  • Creating process chains
Performance in depth
  • Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent.
  • BW Statistics: Query Analysis Tools, Performance Tables.
  • Reporting Performance: Effective query design, Line-Item, Compression.
  • Partitioning.
  • Introduction to Aggregates.
  • Data Load Performance: Parallelism, Impact of Aggregates.