|
This 3-day course is designed to teach you the essentials of querying relational and multidimensional databases, building reports and dashboards, and analyzing data with Hyperion Intelligence Dashboard Builder and either Hyperion Intelligence Explorer or Hyperion Intelligence Designer. You advance your skills from beginner level to intermediate level report developer. Exercises help you practice the skills taught. This course is also appropriate for beginning users of version 6.x Brio Insight, Explorer, or Designer.
In this class, students will learn:
- Hyperion Intelligence Overview
- Business Intelligence Overview
- Components of Hyperion Intelligence
- Hyperion Intelligence Licenses
- Architecture of Hyperion Intelligence
- Manipulating BQY Documents
- BQY Documents
- Hyperion Intelligence Tools Interface
- Opening and Closing Local BQY Documents
- Opening BQY Documents in the Browse Module
- Opening BQY Documents in a Document Repository
- Saving BQY Documents
- Processing and Canceling Queries
- Exporting Report Sections
- Copying Data to the Clipboard
- Adding, Duplicating, and Deleting Sections
- Hiding and Renaming Sections
- E-mailing Documents
- Printing Sections
- Querying Relational Databases
- Query and Report Building Process
- Data Models
- Adding Query Sections to BQY Documents
- Investigating the Underlying Data
- Building the Request Line
- Limiting Queries
- Sorting Data on the Database
- Applying Data Functions to Request Items
- Optimizing the Query Building Process
- Manipulating Results and Creating Tabular Reports
- Results and Table Sections Overview
- Formatting Data
- Sorting Data
- Suppressing Duplicate Values
- Applying Local Limits
- Creating Date Groups
- Creating Grouping Columns
- Removing and Hiding Data
- Creating Grand Totals and Break Totals
- Importing Data from Files
- Creating and Analyzing Pivot Reports
- Creating Pivot Reports
- Formatting Pivot Reports
- Creating Totals
- Sorting Pivot Reports
- Creating Charts from Pivot Reports
- Modifying Data Functions
- Drilling into Data
- Spotlighting Values in Pivot Reports
- Grouping, Focusing, and Hiding Labels
- Creating and Analyzing Charts
- Creating Charts
- Formatting Charts and Modifying Chart Properties
- Setting Export Properties
- Creating Pivot Reports from Charts
- Analyzing Chart Data
- Creating Free-Form Reports
- Creating Reports in the Report Section
- Formatting Reports
- Adding Totals to Report Group Headers
- Sorting Reports
- Focusing and Hiding Reporting Group Labels
- Modifying Data Functions
- Spotlighting Values
- Adding Graphics
- Embedding Pivot Reports and Charts
- Preparing Reports for Printing
- Setting Export Properties
- Querying Multidimensional Databases
- OLAP, Metadata, and Multidimensional Databases
- Navigating the OLAPQuery Section
- Creating OLAP Queries
- Processing OLAP Queries
- Formatting in the OLAPQuery Section
- Adding Totals
- Sorting Data
- Filtering Data
- Specifying Slicers
- Drilling into Data
- Charting OLAPQuery Sections
- Creating Computed Items
- Computed Items Overview
- Creating Computed Items in the Query Section
- Creating Computed Items in the Results and Table Sections
- Creating Computed Items in the Pivot Section
- Creating Computed Items in the Chart Section
- Creating Computed Items in the Report Section
- Creating Dashboards
- Analyzing Data in Dashboards
- Building Dashboards
- Customizing the Dashboard Template
- Adding Graphics
- Modifying Color Schemes
- Modifying Filter and Tooltip Graphics
- Adding Simple Features to Dashboards
- Annotating Dashboards
- Defining Auto Z Columns in Pivot Reports and Charts
- Spotlighting Charts
- Combining BQY Documents and Dashboard Templates
- Importing and Merging Templates and BQY Documents
- Importing and Merging Templates and Executive Suite Master Documents
- Importing and Merging BQY Documents
- Adding Components to Dashboards
- Components Overview
- Importing Components into Dashboards
- Configuring Dashboard Components
Lab exercises are provided throughout the course to reinforce comprehension and retention of the material.
Prerequisites:
Familiarity with Windows conventions. Some knowledge of data warehouse and database concepts.
|
