OnCommand Insight: Advanced Report Creation with Report Studio Training

OnCommand Insight: Advanced Report Creation with Report Studio Training (OCIARC)


OnCommand Insight: Advanced Report Creation with Report Studio Training Course Description

This OnCommand Insight: Advanced Report Creation with Report Studio Training course provides a technical deep dive on how to create highly customized reports from OnCommand Insight data warehouse using Report Studio. It is 90% hands-on creating and customizing complex reports using Report Studio and designed to give the learner a solid, and deep technical hands-on experience with Report Studio that will enable them to start generating custom reports.

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience/Target Group

Intermediate to advanced technical. NetApp employees, Professional Services, Channel Partner Professional Services

OnCommand Insight: Advanced Report Creation with Report Studio Training (OCIARC)Related Courses:

Duration: 2 days

Class Prerequisites:

● OnCommand Insight Reporting Concepts for Business Intelligence - WBT
● Basic knowledge and expertise with Report Studio as it relates to OnCommand Insight data warehouse
● Moderate skill level in SQL, HTML and Java. This course does NOT teach SQL, HTML or Java. It assumes you have this expertis

Skills Gained:

● Explain how Report Studio enables customized reporting
● Use Report Studio to create reports and dashboards from the OnCommand Insight data warehouse
● Use Report Studio to customize reports and Dashboards
●Use SQL and HTML to generate and customize report data and report functions

Course Content:

Module 1: Report Studio Overview: Navigating, Creating List Reports, Grouping, and Subtotaling

Log in to the OnCommand Insight reporting portal and change to Advanced view
Launch Report Studio and demonstrate a working knowledge of its functional areas
Create a list report
Apply sizing and grouping techniques to a list report

Module 2: Working with Lists: Formatting and Usability

Configure scroll bars on list-report output
Configure and position scroll bars on a list report in Report Studio
Configure alternating gray and white row backgrounds to ease the readability of list reports
Use HTML to freeze list-report headers
Use HTML to remove the toolbar from the top of list reports
Use HTML to configure expandable and collapsible list-report columns
Use HTML to create and configure tabbed list reports

Module 3: Working with Lists: Conditional Formatting

Add list-report columns that include calculations of percentage of capacity used
Add conditional formating to list-report rows, to change row color according to thresholds
Add conditional formating to list-report columns, to create ambient orbs that change color according to status

Module 4: Top 10 Reports, Value Prompts and prompt pages and Drill through

Create a “Top 10” array chart and list report
Add a value prompt to filter by manufacturer
Create a chart that shows capacity and used-capacity trending across the enterprise, filtered by manufacturer
Create a prompt page to filter by multiple manufacturers
Create drill-through reports that show all the hosts and storage that belong to a selected array

Module 5: Creating and Customizing Dashboards

Create and format a custom dashboard for report elements
Add bar, line, and pie charts to the dashboard
Customize charts for better usability
Add a capacity gauge to the dashboard
Add a raw-storage gauge to the dashboard
Add a utilization-percentage gauge to the dashboard
Copy and edit report dashboard elements for re-use
Export a report in HTML format for import into other OnCommand Insight Data Warehouses

Module 6: Embedding Graphics

Embed percentage-used and commit-ratio graphics into columns

Request More Information

Time Frame: 0-3 Months4-12 Months

Print Friendly, PDF & Email

No Comments Yet.

Leave a comment