Objective

To analyze data from diverse sources to support decision making. You will learn to use star schema to overcome poor system performance due to a large volume of data handling. Also, overcoming difficulties in extracting, transferring, transforming, and loading data (ETTL) from diverse sources into a data warehouse. You would feel the pain if you had ever tried to analyze SAP R/3 data without using SAP BW.

Minimum Prerequisites

Participants should have minimum 1 year business experience and fair knowledge of reporting and MS Excel.

Included Labs

As per the training manual provided

What will you learn?

Introduction to ERP and SAP

• Introduction to SAP.
• Overview of ERP and SAP - SAP Terminology
• Introducing frequently used SAP terminology.
• Logging in to a SAP system
• SAP logon process for Windows
• Basic SAP Navigation - the basic SAP screen components, moving between menus, T-code         searches and other commonly used functions.
• End User Customization - customizing some SAP screens. Using T-codes – View user       information, logged in users, user creation, sending messages, technical and functional modules.
• Various SAP functional modules, log off from SAP system - SAP logoff process for Windows,         SAP services, co-operative business scenarios, mySAP.com
• Enterprise Structure.


Modeling

Extended Star Schema vs. Classic Star Schema. Data Flow in BW: DataSource, InfoSource, Transfer Rules, Update Rules. InfoSource Types, Creating and Maintaining InfoSources. Update Rules: Creating Update Rules for Data Targets and the Options available. InfoObject Catalogue, Creating InfoObjects, Characteristics and KeyFigures. Master Data: Texts, Attributes and Hierarchies. Use and maintenance of Master Data. InfoCube: Star Schema, Dimensions, Creating and Maintaining InfoCubes. Data Targets: InfoObject, Basic InfoCube, ODS Object InfoProviders: MultiProviders, Virtual InfoCubes, InfoSet

Extraction

Source System: Connection with BW, Creating Source Systems (SAP, Extern al, Flat File) Extraction from SAP Source Systems: Standard, Customized, and Generic Extractors Extraction from R/3: Extract Structure, Transfer Structure, Delta Process Customizing: Enhancing Business Content, Maintaining Generic DataSources User Exits: Transaction Data, Master Data, Texts and Hierarchies

Warehousing Management

Transports: Transport Connection, BEx Objects and Roles, Versions of Objects Business Content: Installing and Collecting Objects, BW Statistics BI Suite: BEX Explorer

BEx Query Designer

Queries: New queries, Restricting Characteristics, Hierarchies, 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

Web Application Designer

WAD: Functions of WAD, Web Items Window, Template Window, Properties Window Web Applications: Creating Web Applications, Settings, Stylesheets, Symbols and Properties Design: Designing the Layout of Web Templates, working with Library for Web Items Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes

BEx Analyzer

Functions of BEx Toolbar: Open, Save, Change and Refresh Queries Evaluating Query Data: Navigating queries, Selecting Filter values, saving query variants Workbooks: Cell Areas, Workbook Templates, Display options and more.
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 vs OLTP: The OLAP Concept and differences between OLAP and OLTP OLAP Functions: Aggregation, Hierarchies, Currency Translation, Report -to-Report Interface MetaData Repository: Searching for MetaData and exporting as XML Files

Reporting Agent

Exception Settings: Creating a setting and defining a follow up action Print Settings: Defining Print Settings and Print Layout Scheduling Packages: Creating Package, signing Settings, Variants, with Process Chains Advanced Topics

Performance

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, and Partitioning. Aggregates: Creating Aggregates, Finding effective aggregates. Data Load Performance: Parallelism, Impact of Aggregates. Partitioning: Logical Partitioning, Table Partitioning.