SAP BW/BI
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
o Types: Characteristics, Key Figures, Time, and Unit.
* InfoCubes: Definitions.
o Types: Standards, real time, virtual.
o Design of Infocube: Extended Star Schema concepts. Precautions.
* DataStore objects (DSO):
o Types: Standard, Write Optimized, Direct Update.
* 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
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
o Types: Characteristics, Key Figures, Time, and Unit.
* InfoCubes: Definitions.
o Types: Standards, real time, virtual.
o Design of Infocube: Extended Star Schema concepts. Precautions.
* DataStore objects (DSO):
o Types: Standard, Write Optimized, Direct Update.
* 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
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
Advanced Topics
* Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent
* 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.
* 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
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
Advanced Topics
* Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent
* 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.
-------
C-Point
#402, 4th Floor, Siri Plaza, Opp: RS
Brothers, Above Bank of India,
KPHB Main Road, Hyderabad-72
Ph: 66332737,
9290929394
website: http://www.cpointss.com Email: cpointss@gmail.com
No comments:
Post a Comment