Special Notices

NetApp Learners Account - information needed at booking stage

In order for you to get the most out of NetApp Training and Certification, we require your NetApp Support ID for us to correctly assign your training enrolment. If you do not have an account, it is important you register for an account before the start of the course. This can be done via the following link: http://support.netapp.com/eservice/public/now.do

For all new and existing accounts, please login to your account, then whilst you are logged in follow this link http://learningcenter.netapp.com to validate your account by accepting NetApp Terms & Conditions (this is an important step to ensure registration synchronization).

If both classroom and virtual dates are available for this course please specify your preference when booking.


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.



Delegates will learn how to

  • 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


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


  • 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

Please complete this form and we'll be in touch

Hide form
Please enter a date or timescale
Please type in a preferred location or region...

Your course has been added to your basket

Proceed to checkout Continue shopping