SAP BI/BW (Business intelligence / Businees Warehouse)

SAP BI
Module 1: Modelling
• Introduction to Data Warehousing
• Star Schema and Extended Star Schema
• Info Area
• Info Object Catalogs
• Info Objects(Characteristics & Key Figures)
• Application Component
• Data Source
• Transfer Rules
• Info Source
• Update Rules
• Info Package (All options)
• Real Time Info Package
• Transformations
• Data Transfer Process(DTP)
• Error DTP
• Direct Access DTP
• Real Time DTP
• Activation of Business Content Objects
• Metadata Repository
• Transportations
• Open Hub Destination
• Info Spoke
• Aggregates
• Compression
• Reconstruction
• Process Chains
• Analysis Process Designer
• Currency Translations
• Daemon

Module 2: Info Providers Types

• 7.0 Info Providers
• Standard DSO
• Write-optimized DSO
• Direct Update DSO
• Standard Info Cube, with data perseistence in the BW system
• Real-time Info Cube
• Virtual Providers (Virtual Cubes)
• InfoSet
• MultiProvider
• Aggregation Level
• 7.3 – New Info Providers
• Standard, SAP HANA-optimized DSO*
• Semantically partitioned DSO
• Standard, with data perseistence in the BWA*
• Standard, SAP HANA-optimized Info Cube*
• Semantically partitioned Info Cube
• Based on an SAP HANA Model*
• Hybrid Provider Based on a DataStore object
• Hybrid Provider Based on direct access
• Composite Provider*
• Other
• Data Flow
• Data Flow Template
• New options in Info Package
• New Options in Transformations
• New Options in DTP
• Insert Characteristic as Info Provider
• Using Queries as InfoProviders*
• Transient Providers*

Module 3: Extraction (Master data & Transaction Data)

• Flat file Extraction
• LO Extraction
• FI Extraction
• Generic Extraction
• COPA Extraction
• Enhancement of Data sources
• Real Time Data Acquisition

Module 4: Reporting

• Bex Query Designer
• Rows, Columns, Free characteristics
• Filter
• New Selection
• New Formula
• Restricted key figure
• Calculated Key figure
• Exceptions and conditions
• Structures
• Cells
• All Types of Variables
• Offset Variables
• Variable Processing Types
• Report to Report Interface(RRI)
• Customer Exits
• BEx Analyzer
• Web Application Designer
• Different Types of Web Items
• Web Templates

Module 5: Support

• Errors & Activities

Module 6: Real Time

• Business Examples
• Real Time Scenarios
• Interview Questions
• Resume Points

SAP BW

Module 1: Introduction
• Introduction to SAP HANA
• SAP In-Memory Strategy
• HANA compare to BWA

Module 2: Look &Feel

• In-Memory Computing Studio
• Administration view
• Navigator View
• System Monitor
• Information Modeler

Module 3: Architecture

• Architecture Overview
• IMCE and Surroundings
• Row Store
• Column Store
• Loading data into HANA
• Data Modeling
• Reporting
• Persistent Layer
• Backup & Recovery

Module 4: Data Provisioning

• Replication Server
• Replication Process
• Replication Architecture
• Data Services
• SAP BODS and HANA
• Basic Data service Connection types
• New to Data services 40
• Full Extractor though ODP
• Configure Import server
• Create and execute a Data Service Job to Populate HANA