 |
Business Warehousing and Business Intelligence |
|
Software Version |
Latest version of SAP BWBI 7.0 + ECC 6.0 |
Course Duration |
5 Days or 40 to 50 Hours Approx. |
Course Type |
Class Room and On-Line (E-Learning) Hands-On Training |
|
Course Overview |
SAP BWBI: This course gives a complete understanding of how SAP BW works, how data is brought into SAP BW, organization of different components of SAP BW and complete understanding of how reports are built, how query creation is dependent on ODs and understanding of Cube Design, and Queries on Multi-Cubes. The layers that make the structure of ETL, Data Warehouse and Planning are covered in this course. |
Intended Audience for this course |
This course is designed for those who wants to become SAP BWBI functional consultants, IT management and staff, business analysts, end-users, graduate or undergraduate students and also for those who want to become SAP BWBI functional consultants. SAP Functional Courses require no prior SAP training or experience. |
|
Course Topics |
Overview |
|
-
Data Warehousing Introduction
- Business Intelligence Introduction
- Standard Naming Conventions
- Master data
- Attributes, Texts and Hierarchies
|
Data Modeling |
-
InfoObjects
-
InfoCubes
-
DataStore Objects
-
Types
-
Design
-
InfoSets
- MultiProviders
- Infocube VS DSO
|
Metadata and Document Management |
- BI Content Definitions
- Installing BI contents
|
Extraction |
- SAP Source Systems
- DataSources
|
Transformations |
- Transformations definitions
|
Data flow |
-
Data Transfer Process
-
Process Chains Creation
|
Scheduling and monitoring |
-
Process Chain
-
Extraction Processes
-
Data Transfer Processes
|
Performance optimization |
-
Creating the first aggregate for an InfoCube
-
Using the BIA index maintenance wizard
|
User management |
-
Standard Authorizations
-
Authorizations Analysis
|
Business Intelligence |
BEx Query Designer
-
Queries
-
Component Properties
-
Structures
-
Functions
|
Web Application Designer |
-
WAD Functions
-
Web Applications
-
Settings, Stylesheets, Symbols and Properties
-
Templates Design
-
Web Items and attributes
|
BEx Activities |
-
Analyzer
-
Web Application Designer
-
Report Designer
|
Platform |
-
Information Broadcasting
-
Broadcaster Functions
-
Exporting into Enterprise Portal
|
OLAP |
-
OLAPv OLTP
-
OLAP Functions
-
MetaData Repository
|
Planning |
-
SEM-BPS – Planning Overview
-
BPS components
-
Planning Models
-
Variables,Relationships
-
Data Slice
-
Web Interface and Planning Folders
|
Performance |
-
Data Model
-
BW Statistics
-
Reporting Performance
-
Query Design
-
Aggregates
-
Data Load
-
Partitioning
|
|