Loading Classes
OnCommand Insight: Advanced Report Creation with Report Studio (OCIARC)
New Age Technologies has been delivering Authorized Training since 1996. We offer NetApp’s full suite of authorized courses including courses pertaining to OnCommand Insight, NetApp E-Series, NetApp MetroCluster, SnapProtect, NetApp Data Protection and more. If you have any questions or can’t seem to find the NetApp class that you are interested in, contact one of our NetApp Training Specialists. Invest in your future today with NetApp training from New Age Technologies.
✉ NetApp Training Specialist | ☏ 502.909.0819
Current Promotion
COURSE INFORMATION
OnCommand Insight: Advanced Report Creation with Report Studio (OCIARC) Overview:
OnCommand Insight: Advanced Report Creation with Report Studio (OCIARC) hands-on course provides a technical deep dive on how to create highly customized reports from OnCommand Insight data warehouse using Report Studio.
Who Should Attend:
NetApp administrators with intermediate to advanced technical knowledge.
OnCommand Insight: Advanced Report Creation with Report Studio (OCIARC) Prerequisites:
Before attending this course, you must have:
- Basic to intermediate knowledge of Cognos Report Studio
- Knowledge of the OnCommand Insight data warehouse data marts, data models and database structure
- OnCommand Insight Business Intelligence – web-based training
- 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 expertise.
OnCommand Insight: Advanced Report Creation with Report Studio (OCIARC) Objectives:
After successfully completing this course, you should be able to:
- 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
OnCommand Insight: Advanced Report Creation with Report Studio (OCIARC) Outline:
Module 1: Report Studio Overview: Navigating, Creating List Reports, Grouping, and Subtotaling
- Change to Advanced view by logging in to the OnCommand Insight reporting portal
- Demonstrate a working knowledge of Report Studio’s functional areas
- List report creation
- 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
- Freeze list-report headers using HTML
- Remove the toolbar from the top of list reports using HTML
- Configure expandable and collapsible list-report column using HTMLs
- Create and configure tabbed list reports using HTML
Module 3: Working with Lists: Conditional Formatting
- Add list-report columns that include calculations of percentage of capacity used
- Add conditional formatting to list-report rows, to change row color according to thresholds
- Add conditional formatting 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
