- Data warehousing Architecture
- Dimensional Data Modeling
- Dimensional modeling as the driver for all DW services
- Fundamental roles of dimension tables and fact tables
- Key structures of dimension tables and fact tables
- Introduction to OLAP Technologies (ROLAP, MOLAP, DOLAP and HOLAP)
|
| Business Objects |
- What is Business Objects Enterprise?
- Business Objects XIR2 Architecture
- Business Intelligence Platform Tiers
- Business Objects XI Functional Architecture
|
| Business Objects Administration |
- Creating Business Objects Repository and Enable the services in CMS
- Creating Security through CMC (Central Management Console)
- Creating Groups
- Creating Users
- Creating Folders
- Creating User Security and Privileges
- Creating Security on Universe and Universe Connections
- Creating Security on Applications wise
- Creating Scheduling of the Reports
|
| Universe Design |
- Universe designers role
- Understanding how universes allow users to query databases using their everyday business terms
- Building the universe structures
- Creating the Universe
- Defining Joins
- Creating Classes & Dimension Objects
- Creating Measure Objects
- Resolving Loops in a Universe
- Applying Restrictions on Objects
- Working with hierarchies
- Deployment - Learn how to distribute, document, and maintain universes
|
| Report Building in Info view |
- Understanding how universes allow you to query databases using everyday
business terms
- Managing documents in InfoView
- Viewing a Web Intelligence document in InfoView
- Creating a new Web Intelligence document
- Modifying a document’s query
- Working with query properties
- Modifying a query with a predefined query filter
- Using prompts to restrict data
- Using complex filters
- Displaying data in tables and charts
- Using breaks, calculations, sorts and report filters
- Ranking data to see top or bottom values
- Using Alerters to highlight information
- Copying data to other applications
- Using formulas and variables in the Java Report Panel
- Creating multiple queries in a document
- Drilling in the Java Report Panel
- Scheduling a Web Intelligence document
|
| Report Building in Desktop Intelligence |
- Understanding core functionality of Desktop Intelligence
- Creating Desktop Intelligence Documents
- User-Defined Objects
- Managing documents
- Modifying a document’s query
- Modifying a query with a predefined query filter
- Using prompts to restrict data
- Using complex filters
- Displaying data in tables and charts
- Using breaks, calculations, sorts and report filters
- Ranking data to see top or bottom values
- Using Alerters to highlight information
- Creating multiple queries in a document
- Concepts of combining data from multiple sources
- Drill Down and Drill Up Reports
- Slice & Dice Reports
- Scheduling a DeskI document
- Reporting from Other Data Sources
|
| Migration |
- Migration Overview
- Migration Phases
- Challenges in migration
- Using the Import Wizard
- Migrating Users, groups and security
- Migrating Universes and connections
- Migrating BusinessObjects full-client documents
- Migrating Web Intelligence documents
- Migration Validation
|
