Business Objects - Data Warehousing Training

Training/Coaching/Tuition by Big Classes Hyderabad View Contact

Request Info

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 Wizardpublishing 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

Course Overview

SAP Business Objects training is an integrated query, reporting and analysis solution for business professionals that enable you to access the data in your company databases directly from your desktop and present and access this information in a very SAP Business Objects document. SAP Business Objects makes it easy to access this information; as a result of you are employed with it in business terms that are acknowledged to you, not technical information terms like SQL.
BusinessObjects Enterprise is a report-deployment platform:

• Supports a variety of report types (e.g. Crystal Reports, WebI, OLAPi/Voyager)

Providing Crystal Reports Training:
Crystal Reports is a design tool–you use it to create and maintain reports. It is similar to Desktop Intelligence and Microsoft Access is this regard. It also has an SDK (COM, .Net, Java) for programmatical access.

• Uses a desktop metaphor, called Info View (nee ePortfolio), to allow people to access reports

• Has an Administrative console, called the Central Management Console (nee Crystal Management Console), to manage various aspects of these reports, including DB authentication.

• Comprise of a number of Windows/Unix/Linus services (e.g. Job Server, Central Management Server, and File Repository Server).

• Enforces access privileges (via NT, AD, LDAP, or Enterprise authenitcation)

• Runs reports on a schedule.

• Distributes reports (via email, ftp, and other mechanisms)

• Has an SDK (COM, .Net, Java) to manage these aspects of the reports.

Big Classes

BigClasses.com is been into the IT market since a decade. We have started our career 10 years back as a class room training provider. After 5 years in the classroom training, as a part of expansion in 2008, we have moved to online training. We are offering the services globally with local and international standards with real time exposure. Now, after 10 years of expertise in software training, we are one of the best online training service portals of the industry. This shows our standards and commitment towards the software learners.

Since inception of BigClasses.com, it has evolved into a cherished and most reliable retail and Corporate Training Company.

BigClasses.com Training is one training institute where online interactive training is a common experience and many students in the past have learnt, mastered, got certified and landed excellent jobs on their way to their careers. Our training takes place with well-prepared training materials. We provide documentation and the best interview preparation materials for learners.

BigClasses.com has access to a faculty of esteemed and highly qualified consultants to deliver the courses. These instructors are not in any way academics, but rather specialists actively involved in consulting to business in their particular fields. This gives the learners a fuller insight of the needs and as well as knowledge about actual and future trends in the market, and makes the courses extremely practical and relevant.

We don’t just give training and leave you on your own but support you even after you get into the job. We are providing web based online training in major IT Courses, where you can sit at home in front of the system and learn without travel or relocate during the training program. You can practice exercises and real-time projects which are given by our esteemed instructors.

Training is conducted by experienced and certified Instructors. Prestigious clients are included in our Clientele list and 100% Successful placement for excellent candidates.

BigClasses.com Institute is an online provider of IT technologies training products for individual and for corporate groups our training manuals and programs are designed to be used in a self-study or home based training environment. This allows any student the ability to learn at their own pace and on their own schedule.

Self-paced training is a very effective method of training and can be used with any schedule and with no previous experience. Effective results can be achieved in as little as 15 minute blocks of time not hours or days as is common with seminars and schedule courses.

All our materials are available with instant download which means you can get started on your training within minutes. The result is that you can show noticeable improvement in less than a day with our training Bigclasses.com.

Our materials are designed to be used in a self-study or home based environment so anyone can fit this training into any schedule no matter how busy it may be. Self-study also allows an individual the ability to train at their own pace and not have to worry about missing any concepts or being forced to proceed too slow like what might happen in a class or schedule group class.

We are dedicated to providing the very best in Bigclasses.com training while providing quality training at affordable prices. Our goal is to product training that is within the budget of anyone who desires to improve their IT skills.

Corporate Group Training: For companies or large groups who wish to provide quality Customer Service training for their employees, Bigclasses.com online training Institute is proud to announce their Corporate! Under our Corporate Training Program, we offer our Training package at group rates. This course encompassing 6 training modules covering both basic fundamentals and advanced techniques.

Bigclasses.com Training Certificate Program: A complete course in Bigclasses.com Training from Basic fundamentals through advanced skills, this complete course offers a single source for all your requirements and needs. Each module is designed as either a stand lone module or as part of a complete series so the student can target their most pressing needs first for maximum benefit. Upon successful completion of the program and the passing of a short test, a full color Certificate of Completion will be issued to the student.