Brio Technology was a San Francisco Bay area software company cofounded in 1984 by Yorgen Edholm and Katherine Glassey. The company is best known for their business intelligence software systems, starting with DataPivot on the Apple Macintosh. Brio Software was acquired by Hyperion in 2003. Hyperion was in turn acquired by Oracle four years later, absorbing Brio into the Oracle Hyperion Performance Management applications.

• Training by Realtime Expert trainer
• Live Online Classes
• Free study material
• Online virtual Classes available in morning, evening and weekend

Prerequisties

• BrioQUery Explorer 6.x
• data warehouse design principles
• star schema database design

Duration

Online

• The format is 40% theory, 60% Hands-on.
• It is a 20 days program and extends up to 2hrs each.

Corporate

• The format is 40% theory, 60% Hands-on.
• It is a 5 days program and extends up to 8hrs each.

Classroom

• Private Classroom arrenged on request and minimum attendies for batch is 4.

Course Content

Starting Interactive Reporting.

• Starting Interactive Reporting.

Working with Tables.

• Table Section.
• Creating Tables.
• Manipulating Table Data.
• Working with Table Components.

Opening and Saving a Sample File.

• Opening and Saving a Sample File.

Creating a sample query

• Creating a sample query

Querying Multidimensional Databases

• Olap Query Section
• Defining OLAP Query Options
• Building OLAP Queries.
• Refining OLAP Query data.
• Processing OLAP Queries.
• Applying Filters.

Viewing Database Tables.

• Viewing Database Tables.

Adding Topics to query

• Adding Topics to query

Cube query:

• Cube Query Catalog.
• Member selection.
• Query options.
• Showing as Chart.
• Exporting a Cube query.

Viewing Results.

• Reordering Columns.
• Sorting Columns
• Filtering Data.
• Calculating Data.
• Pivoting Data.
• Drilling Down.
• Hiding Data.
• Adding Color.

Analyzing Data with Pivot Tables.

• Creating Pivot Table.
• Charting a Pivot table.
• Working with Pivot table.
• Pivoting Data.

Charting data.

• Sorting Charts.
• Inserting Text Labels.

Designing Reports.

• Creating smart Reports.
• Sorting Columns.
• Setting up a Report page.

Report Designer.

• Report Section.
• Creating a custom report.
• Working with a report page.
• Formatting report items.

Inserting Sections and Breaks.

• Inserting Sections and Breaks.

Changing Views.

• Changing Views.

Computed Items.

• About Computed Items.
• Adding Computed items.
• Common computed item example.

Formatting Text and other elements.

• Formatting Text and other elements.

Applying Sorts.

• Sorting Data.
• Simple Sort.
• Sort lines.
• Complex Sorting.
• Nested Sorting.

Setting interactive reporting options.

• Setting interactive reporting options.

Understanding Connectivity in Interactive Reporting.

• About IR Database connection files.
• Working with interactive reporting connection.
• Connecting to database.

Exporting document as web page.

• Exporting document as web page.

Data Modeling.

• About Modeling.
• Building a data model.
• Understanding joins.
• Working with Data Models.

Export to HTML Wizard.

• Export to HTML Wizard.

Security for Interactive reporting.

• Security for Interactive reporting.

Spot lighter.

• Spot lighter.

Introduction to dashboards.

• Introduction to dashboards.

Querying

• Query Section.
• Building queries.
• Processing Queries
• Saving Queries
• Derived Tables.
• Working with query section data.

Migrating reports with dashboards

• Migrating reports with dashboards

Results

• Results section.
• Enhancing your results set.
• Working with results table.
• Saving Results set.
• Exporting Results set