|
|
|
|
|
|
Prerequisites
- Basic database knowledge
- Understanding of the internal reporting needs
Course duration:
4 days
Course outline:
Introduction
- Introduction to Data Warehousing
- Principles of Dimensional Modelling
- The Time Dimension and implementing Date Requirements
- Fact Table properties and implementing Measures
- Implementing Aggregate Tables
- Implementing Multiple Fact Tables
- Implementing solutions to Tracking History requirements
- Implementing Recursive Relationships
- Advanced Designer surgery to answer delegate questions about their own environments; Approach
to Data Warehousing projects; Data Quality and Data Loading issues
- End of Course Challenge to recap the key points of data mart design and implementation using
Fundamentals and Overview
- Activate Business Objects to log, find, open, view, and refresh reports.
- How to build and run simple queries to retrieve data through a universe, and how to use the drag-
and-drop report manager to interactively create new reports.
- Set up query conditions to limit the data returned from the underlying database.
- Build a single document that includes blocks of data from different data sources and different
universes.
- How to create the different block formats to view reports in ways that are most appropriate to your
data.
- Use the "slice and dice" feature, set variables, and set alerts and group values in a report.
- Use the drill function to analyze your data.
- Formatting for printing, add breaks to financial reports and tables, apply view/hide conditions,
- Use the report map, and apply advanced printing controls.
Architecture and Deployment
- Business Objects product line architecture and how the products are related.
- How to allocate a Business Objects repository or multiple repositories while building a Business
Objects solution.
- Understanding the client/server and distributed environments.
- Deployment scoping and hardware sizing to address sizing, scaleability, configuration,
- Access and security administrative tools for a safer system.
- A standard step-by-step guide deployment procedure to ensure a successful deployment
Designer
- Introduction to Designer and the key concepts underlying Business Objects and the universe-
development process.
- Create a file in which to build, name, and set a connection between the universe and it's underlying
database.
- Adding tables to the structure and ways to customize working with tables.
- How to add joins between tables, and the different types of join commands available.
- Creating and testing classes and objects to organize the universe.
- How to create measure objects and verify correct results in querries.
- How to identify loops in the structure of a universe and the tools used in resolution.
- Methods used to limit the scope or extent of queries for end users.
- How to use @ function.
- The purpose of hierarchies for data analysis in the user module, and how to provide the hierarchies
that end users need.
- The ways to modify the universe with pre-calculated aggregates from summary tables.
- The purpose behind including contexts in a universe, and how to use contexts and other
techniques to resolve chasm traps and fan traps.
Supervisor
- Introduction to the concept of the repository and its structure, the different types of users, and
various ways of issuing commands.
- How to create a repository for a Business Objects deployment, and the different domains that
make up a repository.
- Setting up groups and users for a Business Objects deployment, organizing and changing user
properties.
- How to define the access users have to the commands in the user, Designer, and Supervisor
modules of Business Objects.
- How to create a distributed repository with more than one universe or document domain, and when
more than one repository is useful.
- Allocating universe and document domains to groups of users and designers, as well as, how to
export a universe from the Designer module.
- How to allocate universes to groups and configure the universes on a group-by-group basis with
the different configuration changes you can make.
REPORTING
- Basic reporting.
- Slice and Dice Analysis.
- Cross tab Reports.
- Advanced Reporting Techniques
- Publishing reports
INTRODUCTION TO WEB INTELLIGENCE
|
|
|
|
|
