Menu

SAP Business Objects

Course Information

This training course is designed to provide comprehensive understanding that can empower you to make effective, informed decisions based on data analysis. The goal of these professional development courses is to instill the students with a solid understanding of not only the core concepts of Business Intelligence, but also how to implement the core concepts in their business with SAP BusinessObjects BI.
Learning Objectives

• Introduction to SAP and its Portfolio Products.
• Enterprise Data Warehousing Concepts.
• Dimensional Modeling Concepts
• SAP Business Objects Web Intelligence and BI Launch Pad 4.1
• SAP Business Objects BI Information Design Tool 4.1
• Connecting to Data Sources
• Creating the Business Layer of a Universe
• Filtering Data in Objects
• SAP Business Objects Dashboards 4
• SAP Business Objects BI 4.1 CMC (Central Management Console)

Overview

What is ERP , SAP company History, SAP ERP, SAP Products Portfolio and SAP Certification overview.

• How to start the SAP program
• How to log on and off
• How to identify screen elements
• How to Use Help Functions
• How to recognize screen elements.

Enterprise 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

RDBMS & SQL Concepts:

• Relational Database Management System
• SQL Language introduction
• Use of basic SQL statement, clauses, operator, joins etc

SAP Business Objects Web Intelligence and BI Launch Pad 4.1:

• Introducing Web Intelligence
• BI launch pad: What’s new in 4.1
• Customizing BI launch pad
• Creating Web Intelligence Documents with Queries
• Restricting Data Returned by a Query
• Report Design in the Java Report Panel
• Enhancing the Presentation of Reports
• Formatting Reports
• Creating Formulas and Variables
• Synchronizing Data
• Analyzing Data
• Drilling
• Filtering data
• Alerts
• Input Control
• Scheduling (email)
• Data Refresh introduction
• Sharing Web Intelligence Documents

SAP Business Objects BI Information Design Tool 4.1:

• Create a project
• Create a connection to a relational database
• Create a data foundation based on a single source relational database
• Create a business layer based on a single relational data source
• Publish a new universe file based on a single data source
• Retrieve a universe from a repository location
• Publish a universe to a local folder
• Retrieve a universe from a local folder
• Open a local project
• Delete a local project
• Convert a repository universe from a UNV to a UNX
• Convert a local universe from a UNV to a UNX

Connecting to Data Sources:

• Create a connection shortcut
• View and filter data source values in the connection editor
• Create a connection to an OLAP data source
• Create a BICS connection to SAP BW for client tools
• Create a relational connection to SQL Server using OLEDB
providers

Building the Structure of a Universe:

• Arrange tables in a data foundation
• View table values in a data foundation
• View values from multiple tables in a data foundation
• Filter table values in a data foundation
• Filter values from multiple tables in a data foundation
• Apply a wildcard to filter table values in a data foundation
• Apply a wildcard to filter values from multiple tables in a data
foundation
• Sort and re-order table columns in a data foundation
• Edit table values in a data foundation
• Create an equi-join, theta join, outer join, shortcut join
• Create a self-restricting join using a column filter
• Modify and remove a column filter
• Detect join cardinalities in a data foundation
• Manually set join cardinalities in a data foundation
• Refresh the structure of a universe
• Create a calculated column using string values
• Create a calculated column using a date value
• Create a calculated column using numeric values

Creating the Business Layer of a Universe:

• Create business layer folders and subfolders
• Create a business layer folder and objects automatically from a
table
• Create a business layer subfolder and objects automatically from
a table
• Create dimension objects automatically from a table
• Create a dimension, attribute , measure
• Hide folders and objects in a business layer
• Organize folders and subfolders in a business layer
• View table and object dependencies
• Create a custom navigation path
• Create a dimensional business layer from an OLAP data source
• Copy and paste folders and objects in a business layer

Filtering Data in Objects:

• Create a pre-defined native filter
• Create a pre-defined business filter
• Create a pre-defined native filter using multiple objects
• Create a pre-defined business filter using multiple objects
• Working with Derived Tables
• Visualizing Data in a Universe
• Building a Multi-Source Universe
• Working with Parameters and Lists of Values
• Resolving Loops in a Universe
• Managing and Deploying Universes

SAP Business Objects Dashboards 4.1:

• What’s new in SAP Business Objects Dashboards 4.1
• 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
• Troubleshooting interactivity
• Creating a Connected Visualization
• Using live data sources
• Connecting to XML Data
• Connecting to BO Universes using Query as a Web Service
• Using Live Office data
• Working with Business Requirements

SAP Business Objects BI 4.1 CMC (Central Management Console):

• Setting up groups and users
• Organizing and changing Folders & Categories
• Time Out sessions
• Authentication
• Managing Servers
• Connections
• Controlling Universes
• Scheduling through CMC
• Publication
• User Security
• Database Configuration
• Modify Settings for Applications
• Access Levels
• Security

Find out how reasonably priced our trainings are

Name(Required)
This field is for validation purposes and should be left unchanged.
Individual customers
0 +
SAP Cloud Customers
0 +