In this course you will become familiar with some of the most important features of OnCommand Insight relevant to the day-to-day management, monitoring, and trouble-shooting of data infrastructures. This course concentrates on the reporting features of OnCommand Insight and the OnCommand Insight Data Warehouse. This course demonstrates how to use OnCommand Insight to perform operational reporting that aid in daily administrative tasks. This course will also demonstrate how to use IBM Cognos Workspace Advanced to perform Business Reporting. You will also learn how to create customized reports and a basic understanding of how to extend Insight to meet other business reporting needs.

Who should attend

• Customers
• Infrastructure Engineer
• NetApp Partners
• Sales Engineers

Prerequisites

None

Course Objectives

• Describe general organizational-based reporting needs
• Use queries, widgets, and dashboards to display day-to-day operational reporting information
• Describe the OnCommand Insight data warehouse structure (DWH)
• Address business reporting requirements relating to chargeback, virtualization, and storage pool topics
• Describe where to find data warehouse reference documentation and how to maintain a healthy data warehouse

Course Outline

Module 1: Introduction to Reporting

• OnCommand Insight overview
• Product portfolio
• OCI Discover
• OCI Perform
• OCI Assure
• OCI Plan
• OCI architecture
• Data warehouse report-authoring tools
• Report challenges
• Technical
• Department or business unit
• Executive
• OCI vs. OCI data warehouse
• Dashboard and reports
• Storage manager dashboard
• Storage automation store
• Importing reports

Module 2: Operational Reporting

• Queries
• Widgets
• Query table
• Dashboards
• Asset
• Violations
• Custom
• Custom dashboard creation

Module 3: Data Warehouse

• Overview
• Features
• Components
• MySQL
• Cognos report engine
• Administration portal
• Reporting portal
• ETL process
• Data warehouse database overview
• Architecture
• Data mart and data warehouse
• Contents of data warehouse
• Database schema
• Data model definitions
• Data mart inventory
• Built-in data models
• Storage capacity
• Data model file system utilization
• Data retention and consolidation

Module 4: Business Reporting: Chargeback

• Business level reporting: five elements
• Annotations
• Business entities and applications
• Hierarchical reporting
• Managing applications
• IBM Cognos workspace advanced
• Launching
• Package selection
• Report type
• Selections

Module 5: Business Reporting: Virtual Machine Performance

• Controlling report contents
• Report formatting
• Filter criteria
• Adding charts
• The toolbox
• Customizing charts
• Adding links

Module 6: Business Reporting: Storage and Storage Pool Capacity Report

• Forecasting reports
• Drill down detail - report addition
• Conditional formatting
• Report formatting

Module 7: Maintaining OnCommand Insight Reporting Capabilities

• Reporting portal
• Public folders
• Tutorials
• My folders
• Data warehouse admin portal
• ELT schedule
• Data warehouse manual back up/restore
• Data warehouse online documentation
• Schema description and diagrams
• MySQL database
• REST APIs

Labs:

• Log into lab environment, access the data warehouse adminstration and reporting portals
• Import a report from the storage automation store
• Create an application resource operations dashboard
• Create a host and virtual machine operation dashboard
• Create a storage capacity operations dashboard
• Create a report in IBM Cognos workspace advanced centered on application chargeback
• Create a report in IBM Cognos workspace advanced centered on virtual machine performance
• Create a report in IBM Cognos workspace advanced centered on storage use