.::| eWebStudy.com |::.

Customer Care - USA: 703-738-9900 Customer Care - Canada: 416-907-6613 Toll Free: 1-888-326-2767 Customer Feedback

Home

K-12 Tutoring

BOXI (Duration: 50 Hrs)
(Administration, Architect and Report Development)

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
Derived table & Stored Procedure

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

DASHBOARD BUILDER

Understanding Dashboard Manager
Setting Up Dashboard Manager
Creating Metrics
Automating Dashboards with Rules
Creating Analytics
Creating Personal Dashboards
Creating Corporate Dashboards
Guiding Dashboard Navigation

MIGRATION TO BOXIR3
MIGRATION FUNDAMENTALS

How Business Objects Enterprise XI 3.0
Migration concepts
Import Wizard Concepts
Understanding object migration
Understanding user and group migration
Migration planning and assessment
After migration with the Import Wizard

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
Report creation
saving the reports in local repository
publishing the report
Report conversion (desktop) to (Webi)

WEBI-RICH CLIENT

Installing Web Intelligence Rich Client
Web Intelligence Rich Client working modes
Launching Web Intelligence Rich Client
To set user preferences in Web Intelligence Rich Client
Working with documents
Working with universes in Web Intelligence Rich Client
Accessing Web Intelligence from Info View
Working with queries in Web Intelligence Rich Client
Working with reports

UNIVERSE BUILDER & QUERY BUILDER

Universe Builder basics
Building universes from XML metadata sources
Updating XML metadata source universes
Exporting a universe to a XML file format

QUERY AS WEB SERVICE

Configuring the QWS with BO System
Creating Webservice report from Universes
Creating WSDL reports
Using WSDL reports in external application

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

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

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

SAP WEBI/DASHBOARD REPORTING:

Creation of Web intelligence reports using Info cube & BW Query

INTRODUCTION TO BO-SDK

Introduction of BO Enterprise SDK
Choosing the right SDK
Customizing the Webi reports using SDK

INTRODUCTION TO BO EXTENSION POINTS

HOW TO USE & LEVERAGE BO EXTENSION POINTS IN BUSINESS OBJECTS

Comparison of all BO Versions (5.x/6.5/XIR1/XIR2/XIR3)
Performance Tuning of Database w.r.t BO
Installation of BOXIR3 suite with System/Audit/Performance mgmt repositories
Using Oracle/SQLSERVER/SAPBW
Testing & Migration of BO components from Dev/Stage/Production environment

BO XI R3 CERTIFICATION GUIDELINES:

Sample questions on Business Objects Certified Professional � Business Objects Web

INTELLIGENCE XI 3.0 � LEVEL ONE

Sample questions on Business Objects Certified Professional � Business Objects Web
Intelligence XI 3.0 �Level two