OnCommand Insight: Business Insights Training

  • Learn via: Classroom
  • Duration: 2 Days
  • Price: Please contact for booking options
We can host this training at your preferred location. Contact us!

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.

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


Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
08 June 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
13 June 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
01 July 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
02 July 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
07 July 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
02 August 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
05 August 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
12 September 2024
Istanbul, Ankara, London
2 Days
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.