(SAP Business Objects)
SAP BO Training
SAP BO Training Course includes basic to advanced level and our SAP BO course is designed to get the placement in good MNC companies. Our SAP BO trainers are SAP BO certified experts and experienced working professionals with hands on real time multiple SAP BO projects knowledge. We have designed our SAP BO course content and syllabus based on students requirement to achieve everyone's career goal. In our SAP BO training program, you will learn from the scratch to advanced level along with SAP BO. you will be awarded a course completion certificate but it is subject to your successful completion of classes and projects.
SAP BO TRAINING Training SYLLABUS
INTRODUCTION TO SAP
INTRODUCTION TO BUSINESS OBJECTS
- New features in SAP BO BI 4.0.
- Data Warehousing Architecture.
- Business Objects Architecture.
- SAP BO Data Modelling
- SAP BO ER Modelling
- SAP BO Dimensional Modelling
- Dimensional Tables.
- Fact Tables.
- Different types of Dimension Tables
- Conformed Dimension Tables
- Junk Dimension Tables
- De generative Dimension Table
- Schema
- Star Schema
- Snowflake Schema
- Galaxy Schema
- Slowly Changing Dimensional Tables.
- Fact Table.
- Fact less Fact Table.
- SAP BO Different Types of Facts or Measures
- Bridge tables.
- Lookup Tables.
- Top Down Approach
- SAP BO Bottom Up Approach
- ODS
- SAP BO Data Mart
- Dependent Data mart.
- SAP BO Independent Data Mart
- Staging Area
- Granularity
- Normalization
- De normalization
- OLTP
- OLAP
TYPES OF OLAPS
- Oracle 10g (SQL)
- SAP BO Introduction to Oracle Database
- Data Types
- SQL Statements
- DDL – Data Definition Language
- DML – Data Manipulation Language
- DQL – Data Query language
- DCL – Data Controlling language
- TCS – Transaction Controlling Language
BUILT-IN FUNCTIONS
- SAP BO Character Functions
- Numeric Functions
- Data Functions
- Conversion Functions
- Aggregate Functions
JOINS
- SAP BO Inner Join
- Left Outer Join
- Right outer Join
- Full outer Join
- Cartesian Join
- Self Join
- Natural Join
SET OPERATORS
- Union
- Union All
- Intersect
- Minus
SUB QUERIES
SAP BOBI 4.0 – INFORMATION DESIGN TOOL
- SAP BO Creation of Project
- Relational Connection
- OLAP Connection
- Data Foundation Layer
- Business Layer
- Edit Connection
- Shortcut Connection
- Secured Connection
- Publishing Connection
- Publishing the Business layer
- Converting Repository Universe from Unv into Unx
- Publishing the Universe to Repository
- Publishing the Universe to Local
- Retrieving the Universe from Repository
- Multi Source Universe
- Data Foundation
- Insert tables in Data Foundation
- Define Joins in Data Foundation
- Cordiality setting in Data Foundation
- Arrange Tables
- View Table values in Data Foundation
- Filter Table values in Data Foundation (Wont Impact in Reports O/P)
- Edit Table values (Removing Columns , Changing Data types & Keys)
- Calculated Column in Tables
- Sort and re-ordering the columns in Data Foundation
- Refresh Structure
- Derived tables
- Create Views
- Detect Join / Cordiality / Alias / Keys / Row Counts
- Resolving Loops
- Alias
- Context
- Business Layer
- Folders (Class)
- Sub Folder (Sub Class)
- Objects
- Dimension
- Measure
- Attribute
- Filter
- Native Filter
- Business Filter
- Hide Folders , Objects & filters
- Show Script
- Show Values
- View Tables and Object Dependency
- Custom Navigation Path
- Queries
- Parameters and List of values
- Check Integrity
- Data Security
- Business Security
SAP BOBI 4.0 BI LAUNCHPAD & WEB I RICH CLIENT
- BI launch pad: What’s new in 4.0
- Introducing Web Intelligence
- Creating BI workspace
- Folders
- SAP Steam
- Scheduling a Document
- Working with Thin Clients
- Creating Web Intelligence Documents with Queries
- Report Design in the Java Report Panel
- Enhancing the Presentation of Reports
- Formatting Reports
- Creating Formulas and Variables
- Drilling
- Filtering data
- Alerts
- Input Control
- Scheduling
- Sharing Web Intelligence Documents
- Filter
- Formula
- Functions
- Variable
- Merge dimensions
- Alert
- Rank
- Sort
- Break
- Section
- Hyperlink
- Page view
- View Structure
- Refresh
- Purge
- Drill Filter Tool bar
- Drill
- Snapshot
- SAP BO Download to PDF, Excel & CSV
- Export to CSV
- Scope of Analysis
- Database Rank
- Sub Query
- Combined Query
- Custom SQL
- Changing report source
- Hyperlink
SAP BOBI 4.0 UNIVERSE DESIGN TOOL
- Connections
- Connection Types
- Universe parameters
- Parameters
- Kinds of Joins
- Loops
- Context
- Aliases
- Class
- Sub Class
- Objects
- Condition Objects
- Functions
- @Functions
- @Prompts
- @Select
- @Where
- @Variable
- SAP BO Cascading Prompts
- Hierarchy
- LOV’s
- Cascading LOV’s
- Editing the LOV’s
- Derived tables
- Check Integrity
- Implementing Security
- Universe options
- Universe Locking
- Linking Universe
- Security Implementation
SAP BOBI 4.0 DASHBOARDS
- What’s new in SAP Business Objects Dashboards 4.0
- Connection to BO universe by using QAAWS Connection
- Using Live Office Data
- Connecting to Query Builder
- Canvas
- Components
- Component Properties
- Dynamic Visibility
- Drill option
- Developing Chart Dashboards
- Developing Maps Dashboards
- Using Containers
- Uploading Images
- Calling Hyperlinks in Dashboards
- Getting around in Xcelsius
- Working with your Excel workbook
- Visualizing data with charts
- Applying formatting options
- Using themes and templates to apply formatting
- Using selectors
- V lookup in Excel
- Adding dynamic visibility
- Troubleshooting interactivity
- Working with Business Requirements
ADMINISTRATION
- Setting up groups and users
- Taking Meta data backup
- Moving the code between environments
- Handling Services
- License Up gradation
- Organizing and changing Folders & Categories
- Time Out sessions
- Instance Management
- Managing Servers
- Connections
- Migrating from Lower version to Existing version
- Controlling Universes
- Scheduling through CMC
- Publication
- User Security
- Modify Settings for Applications
- Access Levels
- Security
Trainer Profile of SAP BO
Our Trainers provide complete freedom to the students, to explore the subject and learn based on real-time examples. Our trainers help the candidates in completing their projects and even prepare them for interview questions and answers. Candidates are free to ask any questions at any time.
- More than 10+ Years of Experience.
- Strong Theoretical Practical Knowledge.
- SAP BO Certified Professionals with High Grade.
- Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
- Trainers have Experienced on multiple real-time projects in their Industries.
- Our Trainers are working in multinational companies such as CTS, TCS, HCL Technologies, ZOHO, Birlasoft, IBM, Microsoft, HP, Scope, Philips Technologies etc
- Strong Theoretical & Practical Knowledge.
- Certified Professionals with High Grade.
- Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
- Trainers have Experienced on multiple real-time projects in their Industries.
