OnCommand Insight: Business Insights Training

None

• 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
• 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