Friday 22 February 2013

SAP BW Training | SAP BW Online Training | SAP BW Course



Why Todaycourses.com?


  • Take Courses from anywhere online.
  • More than 1000 Employers Registered Worldwide 
  • Assured Job Placements 
  • More than 200 Visa processing employers 
  • More than 1000 courses.
  • More than 100 Job Placements Every day.
  • Global Job Opportunity



SAP Business Objects Course Content

SAP Business Objects Course Content
  • Oracle Basics
  • SAP BO Web Intelligence and  BI Launch Pad 4.0
  • Web Intelligence Rich Client (Desktop)
  • SAP BO BI Information Designer Tool
  • SAP BO BI Universe Designer Tool
  • SAP BW Infocubes
  • Crystal reports
  • BO Project Migration
  • Connecting data Sources
SAP Business Objects Web Intelligence and BI Launch Pad 4.0.
  • SAP Business Objects Dashboards 4.0
  • BI launch pad: What's new in 4.0
  • Customizing BI launch pad
  • Overview of Interactive Analysis core functions
  • Creating Interactive Analysis documents with queries
  • Restricting data returned by a query
  • Designing Interactive Analysis reports
  • Enhancing the presentation of data in reports
  • Formatting reports
  • Calculating data with formulas and variables
  • Using multiple data sources
  • Analyzing data
  • Managing and sharing Interactive Analysis documents
  • Reporting from Other Data Sources
  • Introducing Web Intelligence
  • Accessing corporate information with Web Intelligence
  • Understanding how universes allow you to query databases using everyday business terms.
  • Managing documents in InfoView
  • Viewing a Web Intelligence document in InfoView
  • Customizing InfoView
  • Setting InfoView Preferences
  • Creating Web Intelligence Documents with Queries
  • Getting new data with Web Intelligence
  • Creating a new Web Intelligence document
  • Modifying a document's query
  • Working with query properties
  • Restricting Data Returned by a Query
  • Modifying a query with a predefined query filter
  • Applying a single-value query filter
  • Using prompts to restrict data
  • Using complex filters
  • Displaying data in tables and charts
  • Presenting data in free-standing cells
  • Enhancing the Presentation of Reports
  • Using breaks, calculations, sorts and report filters
  • Ranking data to see top or bottom values
  • Using alerters to highlight information
  • Organizing a report into sections
  • Copying data to other applications
  • Alternative Query Techniques Using Combined Queries Using Sub-Queries
  • Creating a Query based on another Query
  • Character and Date String Functions Using the character string functions Concatenating different data types Using date functions
  • Using If Logic
  • Grouping data using If() logic
  • Using If() to modify calculation behavior
  • Advanced Reporting Features Formatting breaks
  • Creating custom sorts
  • Displaying document data in free-standing cells
  • Alternative Query Techniques Defining Combined Query Types Using Combined Queries
  • Using Sub-Queries
  • Creating a Query on a Query
  • Character and Date String Functions Understanding Character Strings
  • Using Date Functions User-Defined Objects Creating User Objects
  • Using a User Object in a Query
  • Editing a User Object Deleting a User Object Storing a User Object Grouping Data


Web-Intelligence Rich Client 4.0

  • Introducing Web Intelligence
  • Accessing information with Web Intelligence
  • Understanding how universes allow you to query databases using everyday business terms
  • Create reports using webservises as a Data source
  • Understanding Web Intelligence core functionalities
  • Creating a document in the Web Intelligence Rich Client
  • Creating Web Intelligence Documents with Queries
  • Building a simple query
  • Restricting data with query filters
  • Applying a single-value query filter
  • Using prompts to restrict data
  • Using complex filters
  • Report Design
  • Working in the Report Panel
  • Displaying data in tables and charts
  • Presenting data in free-standing cells
  • Enhancing the Presentation of Data in Reports
  • Using breaks, calculations, and report filters
  • Formatting breaks and crosstabs
  • Using default and custom sorts
  • Ranking data to see top or bottom values
  • Tracking data changes
  • Using alerters to highlight information
  • Organizing a report into sections
  • Copying data to other applications
  • Formatting Reports
  • Preparing documents for PDF and print
  • Calculating Data with Formulas and Variables
  • Understanding formulas and variables
  • Understanding how Web Intelligence calculates data
  • Creating formulas and variables to calculate data
  • Using Multiple Data Sources
  • Adding a new query using a personal data provider
  • Creating multiple queries in a document
  • Synchronizing data with merged dimensions
  • Analyzing Data
  • Drilling into the data
  • Setting Web Intelligence drill options
  • Using sub-queries
  • Creating a query based on another query
  • Changing data sources
  • Using the query drill
  • Using query sampling
  • Understanding dimensions and details
  • Character and Date String Functions
  • Using character string functions
  • Concatenating different data types
  • Using date functions
  • Calculation Contexts
  • Understanding calculation contexts
  • Redefining calculation contexts
  • Using If Logic
  • Grouping data with If() logic
  • Using IF/ELSEIF
  • Additional Reporting Techniques
  • Using data tracking
  • Displaying data restricted by a filter or ranking
  • Using additional report functions
  • Linking to Documents
  • Linking to documents and URLs in Web Intelligence
  • Creating hyperlinks in the HTML Report Panel
  • Creating hyperlinks in the Web Intelligence Rich Client and Java Report Panel

Information Design Tool 4.0
  • What is the Information Design Tool (IDT)
  • Create a project
  • Create a connection to a relational database (Single and Multiple databases)
  • Create the data foundation with Single & Multiple databases
  • Define the different types joins in a data foundation
  • Create a business layer
  • Create folders and objects
  • Resolve Loops and Use alias
  • Resolve Loops Use contexts
  • Resolving the fan traps and Chasm traps problem
  • Define data restrictions
  • Work with LOVs
  • Use Parameters restrict data
  • Use @functions also Aggregate Awareness
  • Create Derived Tables and Index Awareness
  • Maintain universes
  • Deploy and manage and maintain universes
  • Documentation of the universes
Universe Designer Tool 4.0
  • Understanding Business-Objects Universes.
  • Understanding how universes allow users to query databases using their everyday business terms.
  • Creating Universe Connections.
  • The course database and universe.
  • Creating the universe.
  • Building and populating the Universe Structure.
  • Defining joins in a universe.
  • Creating Dimension Objects.
  • Understanding classes and objects.
  • Creating Measure Objects.
  • Understanding measure objects.
  • Using List of Values.
  • Resolving Loops.
  • Resolving loops using aliases.
  • Resolving loops using contexts.
  • Chasm traps and Fan traps.
  • Restricting the data returned by objects.
  • Using Functions with Objects.
  • Using @ Functions.
  • Using Hierarchies.
  • Working with hierarchies.
  • Aggregate Awareness.
  • Derived Tables
  • Securing Universes.
  • Managing Universes.

Basic BO Administration (CMC)
  • Understanding BusinessObjects Enterprise What is BusinessObjects Enterprise? Working in InfoView
  • Working in the Central Management Console BusinessObjects Enterprise Architecture
  • Understanding the BusinessObjects Enterprise architecture Busi nessObjects
  • Enterprise Security Creating users, groups, and folders
  • The Busi nessObjects Enterprise security model
  • Categories
  • Guidelines for planning security
  • Profiles
  • Publishing
  • Scheduling
  • Setting up groups and users
  • Organizing and changing Folders & Categories
  • Authentication
  • Managing Servers
  • Connections
  • Controlling Universes
  • Scheduling through CMC
  • User Security
  • Database Configuration
  • Modify Settings for Applications
  • Access Levels
  • Security

SAP Business Objects Dashboards 4.0 (Crystal Xcelsius 2011)
  • Crystal Xcelsius Overview
  • Creating Dashboards using Query As A Web Service (QAAWS) and Live Office
  • Create Drill Down dashboard reports
  • What's new in SAP Business Objects Dashboards 4.0
  • Creating a Visualization
  • Producing interactive visualizations
  • Getting around in Xcelsius
  • Working with your Excel workbook
  • Visualizing data with charts
  • Using Xcelsius Components
  • Formatting a Visualization
  • Applying formatting options
  • Using themes and templates to apply formatting
  • Adding Interactivity to a Visualization
  • Using selectors
  • Adding dynamic visibility
  • Using live data sources
  • Connecting to BO Universes using Query as a Web Service
  • Using Live Office data
  • Creating Complex dashboards

SAP Crystal Reports 2011
  • Creating reports
  • Selecting records
  • Organizing data on reports
  • Formatting & section formatting
  • Creating basic and complex formulas
  • Using variables
  • Using report templates
  • Applying conditional reporting
  • Building parameterized and specialized reports
  • Summarizing data with cross tabs
  • Using report sections
  • Representing data visually
  • Managing reports
  • Distributing reports
  • Using repository and repository data sources
  • Report processing
  • Linking Crystal Reports to Webi reports
  • Drill down reports

SAP BODS Course Content



DW Concepts
  • Definition
  • Methodologies
  • Dimensional Modeling
  • DW Lifecycle
  • DW Challenges

ETL Overview

  • ETL introduction
  • Staging Area
  • Business Rules
  • Performance
  • Slowly Changing Dimensions
  • Surrogate Keys
  • Facts and Dimension Tables
  • Different ETL Tools

Business Objects Overview

  • History
  • Components
  • Architecture

Data Services

  • Purpose of Data Services
  • Data Services architecture
  • Define Data Services objects
  • Data Services Designer interface

Data Services Objects

  • Object Hierarchy
  • Jobs
  • Workflows
  • Data Flows

Source and Target Metadata

  • Data Stores
  • File formats for flat files
  • File formats for Excel files
  • File formats for XML files
  • Lab Exercises

Environment setup

  • Creating repository
  • Setting Job Server
  • Setup for realtime operation
  • Setting multiple datastores
  • Starting Job servers
  • Lab Exercises

Batch Jobs

  • Work with objects
  • Create a data flow
  • Use the Query transform
  • Use target tables
  • Execute the job
  • Lab Exercises

Troubleshooting Jobs

  • Use descriptions and annotations
  • Validate and tracing jobs
  • Use View Data and the Interactive Debugger
  • Use auditing in data flows
  • Lab Exercises

    Functions, Scripts and Variables
    • Define built-in functions
    • Functions in expressions
    • Lookup function
    • Decode function
    • Variables and parameters
    • Data Services scripting language
    • Scripting custom functions
    • Lab Exercises
    Important Transforms
    • Map Operation transform
    • Validation transform
    • Merge transform
    • Case transform
    • SQL transform
    • Lab Exercises
    Other Transforms
    • Pivot transform
    • Hierarchy Flattening transform
    • Data Transfer transform
    • XML Pipeline transform
    • Lab Exercises
    Error Handling
    • Error Handling
    • Recoverable work flows
    Change Data Capture
    • Update data over time
    • Database native CDC mechanisms
    • Source-based CDC
    • Target Comparison
    • Lab Exercises
    Data quality Overview
    • Fundamentals of DQ and Data Cleansing
    • Built in DQ Transformations
    • Data Validation
    • Name & Address cleansing
    • De duplication
    • Cleansing other data
    • Lab Exercises
    Web-Services and Real-Time Integration
    • Real Time Jobs
    • SOAP Introduction
    • Web Services
    SAP Integration
    • Creating datastores for SAP databases
    • Accessing SAP data
    • Data extraction from ECC system to File, Table and SAP BI
    • Data extraction from ECC Extractors
    • Data Extraction from SAP BW




    SAP BW-BI COURSE CONTNENT


    SAP BI – Introduction to SAP Netweaver 2004s (7.0 BI) system

    SAP BI – DATA WAREHOUSING (DW)

    ·         Overview, Posting & Fundamental of Data Warehousing
    ·         Objects in the BI DW layer
    ·         Data Acquisition & Transformation from SAP Source Systems
    ·         Data Acquisition from other systems
    ·         Business Content
    ·         Other Info Providers
    ·         Administration of Data Targets
    ·         Introduction to Query Performance Optimization
    ·         BI System upgrade and migration of dataflow from BW 3.x to BI 7.0
    ·         Transformation &UoM conversions
    ·         Write routines in transformations and debugging routines
    ·         DTP & DTP Error handling
    ·         Bi Integrated planning
    ·         Concepte - BI Accelerator and Analysis Process Designer (APD)

    SAP BI - REPORTING & ANALYSIS

    ·         Introduction to BI Enterprise Reporting
    ·         Get to know BEx Query Designer
    ·         Key Figures, Characteristics, Variables, Exceptions and Conditions
    ·         BExAnalyzer
    ·         Enterprise Portal Integration and Document integration
    ·         Report - Report - Interface
    ·         Managing Query Objects
    ·         Business Content
    ·         Further SAP BI Reporting Tools
    ·         Information Broadcasting

    SAP BI - DATA STAGING & EXTRACTION

    ·         Overview of Data Staging in SAP BI - BW Content
    ·         Data Transfer with the service API
    ·         Delta Management
    ·         Transferring data from flat files
    ·         XML Based extraction
    ·         Data Mart Interface
    ·         Application Specific Extraction

    SAP BI - MODELING & AUTHORIZATION

    ·         Logical Model and BI Data Model
    ·         Tracking history and hierarchies
    ·         Modeling characteristics and key figures
    ·         Modeling ODS/DSO Objects and InfoCubes, Open Hub Service
    ·         Multidimensional Modeling
    ·         Changing Data Model
    ·         Special Modeling aspects
    ·         Authorizations - Setting up for reporting, standard roles and templates
    ·         Securing requirements in SAP BI
    ·         System Security

    SAP BI - PERFORMANCE & ADMINISTRATION

    ·         InfoProvidermodeling and administration for performane
    ·         Optimize and monitor query performance and data acquisition performance
    ·         Aggregates and rollup
    ·         Transport Management for BI Objects
    ·         Process chains - Development & Monitoring


    SAP BUSINESS OBJECTS COURSE CONTNENT



    DATA WAREHOUSING/DIMENSIONAL MODELING PRACTICAL CONCEPTS

    ·         OLTP vs. OLAP
    ·         Types of OLAP
    ·         Dimensional modeling
    ·         Data mart/Data warehouse Life cycle
    ·         Star/Snow/Extended Star schema design

    DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING

    ·         Joins & Cardinality
    ·         Views/Materialized Views
    ·         Date/Time Functions
    ·         Conversion functions
    ·         Package
    ·         Derived table & Stored Procedure

    BOXIR3 ARCHITECTURE

    ·         Architectural overview
    ·         Client tier components
    ·         Application tier components
    ·         Intelligence tier
    ·         Processing tier
    ·         Data tier
    ·         Security management
    ·         Information flow

    UNIVERSE DESIGN

    ·         Understanding Business Objects Universes
    ·         Creating the Course Universe
    ·         Building the Universe Structure
    ·         Creating Dimension Objects
    ·         Creating Measure Objects
    ·         Resolving Loops in a Universe
    ·         Resolving SQL Traps
    ·         Using List of Values
    ·         Applying Restrictions on Objects
    ·         Using @Functions with Objects
    ·         Using Hierarchies
    ·         Deriving Tables & Indexes
    ·         Working with Aggregate Awareness
    ·         Designing Advanced Objects
    ·         Creating Predefined Condition
    ·         LOVs & Joins
    ·         Securing Universes
    ·         Implementing Universe Life Cycle Mgmt
    ·         Maintaining & Optimizing Universes
    ·         Creating Universe from Other Data sources

    WEB INTELLIGENCE

    ·         Understand concepts of Web intelligence
    ·         Create Web Intelligence documents with Queries
    ·         Restrict data returned by a query
    ·         Design a report
    ·         Enhance the presentation of data in reports
    ·         Format a report
    ·         Calculate data with formulas and variables
    ·         Use multiple data sources
    ·         Analyze data
    ·         Manage and share Web Intelligence documents
    ·         Work with Advanced Query techniques
    ·         Work with calculation contexts
    ·         Create formulas with character & date string functions
    ·         Use "If" logic
    ·         Work with additional reporting techniques
    ·         Create hyperlinks


    CRYSTAL REPORTS

    ·         Planning a Report
    ·         Selecting Records
    ·         Formatting a Report
    ·         Representing Data Visually
    ·         Distributing Reports
    ·         Creating Basic Formulas
    ·         Organizing Data on a Report
    ·         Applying Section Formatting
    ·         Applying Conditional Reporting
    ·         Using the Repository
    ·         Using Report Templates
    ·         Creating Formulas
    ·         Building Parameterized Reports
    ·         Summarizing Data with Cross-Tabs
    ·         Using Report Sections
    ·         Managing Reports
    ·         Presenting Data Visually
    ·         Add hyperlinks to a report

    XCELSIUS(SAP DASHBOARD DESIGN)

    ·         Creating a Model
    ·         Adding Interactivity to a Model
    ·         Creating a Connected Model
    ·         Connect to Crystal Reports data and create Dashboard
    ·         Connect to Web intelligence report data and
    ·         Create Dashboard
    ·         Connect to Business Objects Universes
    ·         Using Query as a web service and create Dashboard
    ·         Use Live Office data and create Dashboard
    ·         Use other connectivity components and create Dashboard








    ADMINISTRATION

    ·         Understand the Business Objects
    ·         Enterprise interface & architecture
    ·         Manage Business Objects Enterprise content
    ·         Secure Business Objects Enterprise content
    ·         Secure application security
    ·         Schedule content
    ·         Publish reports
    ·         Identify Business Objects Enterprise architecture
    ·         Perform common server management tasks
    ·         Manage the Business Objects Enterprise servers

    WIDGETS

    ·         Installing BI Widgets
    ·         Using BI Widgets to Access BI Content
    ·         Working with widgets
    ·         BI Widgets Content Authoring Guidelines
    ·         Auto refresh of Widgets

    DESKTOP INTELLIGENCE

    ·         Introduction to desktop intelligence
    ·         Scope of analysis
    ·         ZABO
    ·         Report creation
    ·         Saving the reports in local repository
    ·         Publishing the report
    ·         Report conversion (desktop) to (Webi)





    VOYAGER

    ·         Getting Started with Business Objects Voyager
    ·         Using Queries to Analyze Cube Data
    ·         Using Charts to Visualize Data
    ·         Selecting Members to Display in Crosstabs and Charts
    ·         Sorting, Filtering, and Ranking Data
    ·         Highlighting Exceptions in Data
    ·         Saving and Sharing Voyager Workspaces

    SECURITY IMPLEMENTATION

    ·         Creating Secured users & group
    ·         Creation secured connections
    ·         Creation of Secured objects
    ·         Creation of security at Table, Column &row level
    ·         Creation of secured restriction set and mapping to users or groups

    OLAP UNIVERSE

    ·         Creation of OLAP Universe by connecting to an Info cube
    ·         Updating the OLAP Universe (Cube)
    ·         Creating the Custom Hierarchies in OLAP Universes.
    ·         Accessing multiple info cubes to create an OLAP Universe

    IMPORT WIZARD\PUBLISHING WIZARD

    ·         Using Import wizard
    ·         Creation of BIAR
    ·         Migrating the BO objects
    ·         From one CMS TO ANOTHER CMS
    ·         Migrating the objects from one
    ·         domain to another (dev/stage/Prod)
    ·         Backup & Maintenance Deployment

    BUSINESS VIEW MANAGER

    ·         Creation of Semantic layer for Crystal reports
    ·         Creation of Dynamic list of values in Crystal reports
    ·         Creation of Cascading list of values in Crystal reports
    ·         Creating Data connection and Dynamic data connection
    ·         Creation of Data foundation
    ·         Creation of Business Element
    ·         Creation of Business View
    ·         Creation of LOV
    ·         Saving the Business view to repository
    ·         Accessing the Business View in Crystal reports using Database expert
    ·         Creation of Crystal reports using Business
    ·         View

    PERFORMANCE MANAGEMENT

    ·         Creation of Metric Universe
    ·         Creation of Metrics & Analytics
    ·         Creation of Dashboard using Metric
    ·         Creating Performance dashboards using set analysis

    LIVE OFFICE REPORTING

    ·         Describe the benefits of using Live Office
    ·         Connect to the repository
    ·         Navigate the Live Office menu
    ·         Insert charts, crosstabs, and fields from a Crystal report
    ·         Insert report parts from a Web Intelligence document
    ·         Insert a new query based on a Universe
    ·         Insert Live Office objects into an email
    ·         Navigate and refresh Live Office objects
    ·         Enable consolidated prompts
    ·         Set refresh settings for objects
    ·         Set parameter binding
    ·         Take a snapshot
    ·         Save Live Office documents to the repository
    ·         Open and view Live Office documents from the repository

    BO-SAP INTEGRATION SERIES

    ·         Understanding BO-SAP Integration kit
    ·         Configuring single sign on authentication
    ·         Creating SAP Authentication in BO
    ·         Importing the roles of SAP into BO
    ·         Entitlement settings of SAP & BO System

    SAP WEBI/DASHBOARD REPORTING

    ·         Creation of Web intelligence reports using Info cube & BW Query

    COMPARISON OF ALL BO VERSIONS (5.X/6.5/XIR1/XIR2/XIR3)

    ·         Architecture changes
    ·         Report creation charges
    ·         Universe level changes
    ·         Security level changes
    ·         Addition of new features

    PERFORMANCE TUNING OF DATABASE W.R.T BO

    ·         BO Query tuning
    ·         BO Execution plan/Tracing
    ·         Combined Query
    ·         Views/Derived tables





    PERFORMANCE TUNING OF BO

    ·         Universe Tuning
    ·         Webi report Tuning
    ·         Database Tuning
    ·         Deployment methods
    ·         Crystal reports tuning
    ·         BO Query optimization & Customization

    POLESTAR/BUSINESS EXPLORER

    ·         Creating Polestar Reports
    ·         Configuring Pole star with BO System



    THANKYOU
    Email : info@todaycourses.com





    sap bw reporting tutorial
    sap bw tutorial
    sap bw training online free
    sap bw training download
    sap bw training material
    sap bw training material pdf
    sap bw training videos
    sap bw training hq