OnCommand Insight: Business Insights, Singapore

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

Upcoming Trainings

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

Classroom / Virtual Classroom

02 August 2024