Infra - Report Designer Advanced (INFRDA)

This one day course is suitable for anyone who needs to learn how to create basic reports using the report builder tool.

To understand the content and successfully complete this course, a student must have a suitable knowledge base/skill set. The student must have an understanding of the functionality of Infra to successfully complete this course. Knowledge of SQL and at least one database system would be advantageous.

A list of specific prerequisite courses can be found in EMC Education Services Learning Management System.

Upon successful completion of this course, participants should be able to:

• Manage reports using Reports Designer
• Create a new report from an existing report
• Edit existing reports
• Add data to reports
• Create and edit report filters
• Create report templates
• Create database views
• Format reports
• Add charts to reports
• Manipulate the data source
• Create sub-reports
• Perform advanced scripting

The reporting facility within Infra allows for both standard and customized reports to be generated from the system. This one day course will provide the foundations for building basic reports using the report builder tool. Additional materials for further reference will be provided in this course.

Upon successful completion of this course, participants should be able to:

• Manage reports using Reports Designer
• Create a new report from an existing report
• Edit existing reports
• Add data to reports
• Create and edit report filters
• Create report templates
• Create database views
• Format reports
• Add charts to reports
• Manipulate the data source
• Create sub-reports
• Perform advanced scripting

Modules

These modules are designed to support the course objectives. The following modules are included in this course:

• Report Designer Basics
• Report Designer
• Report Editor Overview
• The Data Tab
• The Params Tab
• The Design Tab
• Report Formatting
• Views for Reporting
• Advanced Report Design
• Charts
• Data Source Manipulation
• Sub-reports
• Advanced Scripting

Labs

Labs reinforce the information you have been taught. The labs for this course include:

• Copy an existing Report
• Create a new Report from an existing Report
• Create a new Report with Filters
• Changing the Layout of a Report
• Create a new Report with Calculations
• Create a new Report with Grouping and Summary Fields
• Add a Chart to a Report
• Modify the Report Formatting
• Joining Data Sets
• Add a Sub-report and use Advanced Scripting

Assessments

Assessments validate that you have learned the knowledge or skills presented during a learning experience. This course includes a check for understanding at the end of each module along with review questions.