SAP BW/BI ONLINE TRAINING Course, SAPTEQ Global Consulting Services, Bangalore
Karnataka India 560043
Course Details: SAP BW/BI ONLINE TRAININGCourse Fee: Not Mentioned
Course Duration: 30 Days
Placement Provided: Yes
SAP BI (SAP Business intelligence) is a broad category of applications and technologies for gathering, storing, analyzing, and accessing data. The reporting, analysis, and interpretation of business data is of central importance to a company in guaranteeing its competitive edge, optimizing processes, and enabling it to react quickly and in line with the market.
With SAP Business Intelligence (BI), SAP NetWeaver provides data warehousing functionality, a business intelligence platform, and a suite of business intelligence tools with which an enterprise can attain these goals. Relevant business information from productive SAP applications and all external data sources can be integrated, transformed, and consolidated in BI with the toolset provided.
BI provides flexible reporting, analysis, and planning tools to support you in evaluating and interpreting data, as well as facilitating its distribution. Businesses are able to make well-founded decisions and determine target-orientated activities on the basis of this analysis. Business information warehouse (BW) has features like and unlike typical data warehouses. Like most data warehouses, BW is a combination of databases and database management tools that are used to support management decision making. BW is a comprehensive business intelligence product centered around a data warehouse and optimized for SAP’s R/3 environment.
SAP BW also includes preconfigured data extractors, analysis and report tools and business process models. It is an integral component of the company’s mySAP Business Intelligence group of products.
Course Syllabus: SAP BW/BI ONLINE TRAINING
Data warehousing/ BW/ BI Introduction
Master data; Attributes, Texts, and Hierarchies.
Standard Naming conventions in SAP and BI
Types: Characteristics, Key Figures, Time, and Unit.
Types: Standards, real time, remote.
Design of Info cube: Star Schema concepts. Precautions.
DataStore objects (DSO):
Types: Standards, Real time.
MultiProviders: Scenarios to create Multiproviders.
Infocube VS DSO
METADATA AND DOCUMENT MANAGEMENT
BI Content: Definitions, How to install BI contents,
For SAP source systems: Creating Generic data Source and maintaining SAP delivered data Source.
Or for files: Creating Data Sources for File Source Systems
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
Creating the first aggregate for an Info Cube
Using the BIA index maintenance wizard
Setting up standard authorizations
Defining analysis authorizations
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 Key Figures
Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures
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 Web Application Designer
BEx Report Designer
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 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
HOT BONUS TOPICS:
Overview of Planning with SEM-BPS.
Architecture of BPS components.
Planning Models (Planning Area, Planning Level, Planning Functions, Planning Layouts, Packages).
Characteristic relationships, Variables.
Web Interface and Planning Folders.