> > > OCIBI Detailed outline

OnCommand Insight: Business Insights (OCIBI)

Course Description Schedule Course Outline

Detailed 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