Business Information Warehouse (BIW) (Certificate)

Montreal College of Management and Technology
Montreal, Quebec, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Business Information Warehouse (sometimes shortened to "Business Warehouse" or BW) is a packaged, comprehensive business intelligence product centered around a data warehouse that is optimized for (but not limited to) the R/3 environment from SAP. Like most data warehouses, BW is a combination of databases and database management tools that are used to support management decision making. BW supplies the infrastructure typical of data warehouses, but also includes preconfigured data extractors, analysis and report tools, and business process models. Among the other features of BW are: Business Application Programming Interfaces (BAPIs) that enable connections to non-R/3 applications; preconfigured business content; an integrated OLAP processor; automated data extraction and loading routines; a metadata repository; administrative tools; multiple language support; and Business Explorer, a Web-based user interface. SAP Business Warehouse is an integral component of the company’s mySAP Business Intelligence group of products.

This program consists of three parts

PART 1: DATA MODELLING
PART II: BW DATA EXTRACTION
PART II: BW REPORTING




Introduction Class
BW Architecture
BW System Landscape

PART-1

DATA MODELLING:

Types of data

Master data
Transaction data
Meta Data






Data Model

Star Schema
Extended star schema
SID tables
BW Master data Tables
Structure of Dimension Tables
Dimension Modeling
BW Transaction data tables










BW Objects:

Info Area
Info object catalog and Types

InfoObject With in BW

Characteristics/Attributes
Key Figures




InfoObject Definition

Definition
Attributes and types
Texts
Hierarchies
Compounded InfoObjects








Storage objects in BW

InfoProviders
Infocube and Types
ODS
Using Different InfoProvider Types
MultiProviders
Infosets
PSA










Data Flow in BW

Involved Objects
Transfer Structure
Info source
Transfer Rules
Update Rules
Business requirements
ABAP Routines










Warehouse Management: Administrator Workbench Functions

AWB
Scheduler
Infopackage
Infopackage Group
Process Chains
Monitor
Source Systems
Performance
BW Statistics












Business Content

Definition
Activation




Storing Data in BW

Data Targets
Types
Architecture
Data Target - Administration
Aggregate Maintenance








Metadata Repository

Architecture
Functionality




PART �2

BW DATA EXTRACTION:

Master Data Extraction
Transaction Data Extraction

Extraction from SAP Source Systems

Transfer Methods (PSA/ IDOC)
DataSources
Data Extraction Logistics
- LO Cockpit Functions
- LO DataSources Data Flow in R/3
- Structure of Delta Method for LO Cockpit DataSource
Delta Management in extraction
- Delta Method
- Delta Method Properties
- Delta Queue Functions
Data Extraction FICO
Data Extraction CO/PA
Data Extraction LIS
















SAP Defined Info Structures
User Defined Info Structures

Generic Extraction
- Data Types
- Data Sources
Enhancing Business Content and Cubes
Enhancing Generic Datasouce and Cubes








Extraction from NON-SAP Source Systems
Extraction with Flat Files

Extracting Master Data using Flat Files
Extracting Transaction using Flat Files
Data Types that Can be Extracted using Flat Files




DB Connect
Universal Data Integration
XML Integration
Data Mart Interface
Open Hub Service
Virtual Info Cubes

PART-3

BW REPORTING

BEx Reports
Business Content
Report/Report Interface






Business Explorer

The BEx Browser
BEx Query Designer
Analysis and Reporting in the BEx Analyzer
Bex Web Application Designer






Query Designer

Calculated and Restricted Key Figures
Properties of Key Figures
Navigation
Characteristics
Properties and Attributes
Hierarchies
Query Properties
Variables
Exceptions and Conditions












Reporting Agent

Exceptions
Printing
Additional Functions
Pre-Calculating Web Templates






4. Real Time scenarios

Production support issues
Development Issues
Loading Errors
Documentation





SAP Project with examples
...''

Phone:1 514 312 2383

School Address:

1255 University Street, Suite 510
Montreal, Quebec, Canada
H3B 3V8


Jobs & Resumes: Montreal
Houses & Roommates: Montreal

Developing Applications for the J2EE Platform
Web Component Development With Servlet and JSP Technologies
Advanced Business Component Development With Enterprise JavaBeans Technology
J2EE Applications
Sun Certified Java Associate (SCJA)
Sun Certified Java Programmer (SCJP)
Sun Certified Java Developer (SCJD)
Sun Certified Web Component Developer (SCWCD)
Sun Certified Business Component Developer (SCBCD)
SAP ABAP
TEST DIRECTOR (TD)
QUICK TEST PROFESSIONAL (QTP)
Quality Assurance and Testing
Data Warehousing
Informatica
Informatica PowerCenter 8.0 Development
Business Intelligence
SAS Programming I: Essentials
SAS Programming II: Data Manipulation Using the Data Step

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.