This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | OD050 | Skill level | Intermediate |
|---|---|---|---|
| Duration | 3.0 days | Delivery type | Classroom
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $2,235.00 plus tax | ||
Whether you want to learn about using basic DB2 Web Query Reporting and Graphing function or take your DB2 Web Query Knowledge to the next level this class is for you.
Hands on labs will teach you to use the highly productive DB2 Web Query Report Assistant and Graph Assistant to provide web based reporting and graphing functions. Drill Downs, chaining, and advanced parameterized reports/graphs will also be created. You'll also learn how easy it is to direct your output to a PDF, to automatically produce an Excel spreadsheet or to direct your output to one of thirteen other formats. Hand-on labs will teach you how to easily convert and extend your Query for iSeries Reports into browser based DB2 Web Query Reports. You'll extend those Query reports with traffic lighting, you'll also direct output to Microsoft Excel and take the queries to a whole new level with Active Reports.
Learn how to use slice, dice, and pivot Online Analytical Processing (OLAP) enabled reports to show relationships in your existing data. You'll see demonstrations of Executive Dashboards and Key Performance Indicator (KPI) Reports that are created by Developers Workbench components.
Developers will learn how to use the Developer's Workbench to develop Executive Dashboards KPI reports through hands on labs. You'll learn how to utilize DB2 Web Query Developer Workbench functions for joining, validating, and giving your end users function that's consistent across all of the DB2 Web Query Environment. You'll also learn how to consolidate data from multiple i partitions or systems. With hands on exercises you'll learn how to use some of the advanced i 6.1 Performance tuning and database functions such as SQL Views, SQL Joins, and Materialized Query Tables (MQTs) to make your queries run more effectively.
Administrators will learn to effectively manage and secure the DB2 Web Query Environment. Techniques for exporting your environment to other IBM i systems will also be discussed.
View this course in other countries
Training Paths that reference this course are:
Audience
This is a intermediate/advanced course for End Users, Developers, and Administrators who need to analyze the data in their environment and want to turn it into a business asset.
Prerequisites
You should have:
- Getting Started with DB2 WebQuery class (OD040) or
- experience with DB2 WebQuery Graph Assistant and Report Assistant.
Skills taught
Learn to create from a single i5/OS, mutiple i5/OS or other Systems:
- Dashboards
- Scorecards
- Key Performance Indicators (KPI)
- Drill downs
- Operational reports
- taking into consideration performance tuning techniques.
Course outline
- DB2 Web Query Overview
- Report Assistant
- Active Reports
- Converting Existing Query Reports
- Graph Assistant
- Developers Workbench
- OLAP
- Building KPIs and Dashboards
- Power Painter
- Performance Techniques
- Advanced Database Topics
- Tips and Techniques
- Installation, Management
- Q&A
- Next Steps
- Summary
Remarks
Special Note for IBM Business Partners authorized to remarket IBM IT Education Services public classes and on-site classes: This course is excluded from the IBM Technical Training Services for Public Education Program and the IBM Training Services for Enterprise - on-site Education Program for IBM Business Partners.
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
