Course Overview

This online training course provides you an in-depth knowledge on various areas of this subject, some of them are an overview to Interactive Reporting, Creating a sample query, Working with Tables, Querying Multidimensional Databases, Cube query, Charting data, Designing Reports, Analyzing Data with Pivot Tables, Applying Sorts, Connectivity in Interactive Reporting, Data Modeling, Security for Interactive reporting, Introduction and Migrating reports with dashboards, etc.

Course Duration

40 hours of training with two convenient options (weekday or weekend sessions)

Training Materials

  • Facilitates study with an instructor on a real time basis and provides 24*7 access to the course content online anywhere
  • Extensive practice and practical exposure on real equipment
  • Offers hands on experience on advanced set of tools and technology
  • Prepares a student for the workplace with the help of presentations and collaborative projects

What’s Needed To Join This Course?

To pursue this training course a candidate is required to have basic knowledge of database and data warehouse concepts. He/she should be able to write SQL queries on several database objects. Basic knowledge of Javascript is also essential.

Who Are Ideal Candidates?

This course can be pursued by graduate, fresher, working professional, software developer with basic knowledge of SQL, data warehouse and Javascript.

Course Info

This online training course provides you an in-depth knowledge on various areas of this subject, some of them are an overview to Interactive Reporting, Creating a sample query, Working with Tables, Querying Multidimensional Databases, Cube query, Charting data, Designing Reports, Analyzing Data with Pivot Tables, Applying Sorts, Connectivity in Interactive Reporting, Data Modeling, Security for Interactive reporting, Introduction and Migrating reports with dashboards, etc.

Hyperion Interactive ReportCurriculum

Viewing Results.

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

Charting data.

  • Sorting Charts.
  • Inserting Text Labels.

Designing Reports.

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

Inserting Sections and Breaks.

Changing Views.

Formatting Text and other elements.

Setting interactive reporting options.

Exporting document as web page.

Export to HTML Wizard.

Spot lighter.

Querying

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

Results

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

Working with Tables.

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

Querying Multidimensional Databases

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

Cube query:

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

Analyzing Data with Pivot Tables.

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

Report Designer.

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

Computed Items.

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

Applying Sorts.

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

Understanding Connectivity in Interactive Reporting.

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

Data Modeling.

  • About Modeling.
  • Building a data model.
  • Understanding joins.
  • Working with Data Models.
  • Security for Interactive reporting.
  • Introduction to dashboards.
  • Migrating reports with dashboards
Hyperion Interactive Report Roadmap
Reviews

“I had a wonderful learning experience here at this training institute. Their comprehensive course material and advanced knowledge delivery tools made learning easier and interesting” – Shailaja Mathur

“Being a non IT graduate, this online training course has provided immense practical exposure of software field that helped me to learn the complexities and intricacies of software in a simple way. Looking forward for yet another specialization course from this institute”- Arnav Maheshwari

Hyperion Interactive Report Faqs
Open chat
1
Need Instant help?
Hello 👋
can we help you?