Learn through hands on labs, skills transfer and collaborative design sessions how to build reports and dashboards, work with metadata, secure your reporting environment and manage Db2 Web Query for i Business Intelligence.
Audience
This workshop can be tailored to the audience, but it's typically those responsible for report writing and administration of the report writing environment. End Users can partake in modules of the workshop that make sense for them (like spreadsheet integration, using different report types, and report authoring) while IT will be more focused on the administration, meta data development, job scheduling and security aspects of the workshop.
Back to top
Prerequisites
Familiarity with report writing tools, SQL, Query/400 and your database is helpful but not a requirement. A good document to peruse prior to the workshop is the Db2 Web Query Nuts and Bolts Redbook at http://www.redbooks.ibm.com/abstracts/sg248379.html?Open
Back to top
Workshop outline
This workshop will help you get started with designing, developing, and running reports using Db2 Web Query. An IBM Lab Services consultant will help you install the software, create and import meta data, help you import QUERY/400 definitions and assist you in building reports using report and/or graphing assistant components.
Activities will include:
- Re Verification of installation of the Db2 Web Query for i software
- Knowledge and skills transfer through lectures, lab exercises and discussions on Db2 Web Query topics such as:
- Developing Meta Data
- Administering Db2 Web Query
- InfoAssist Report Authoring Tool
- Report Deployment Options (Excel, Active Reports, Auto Drill Down)
- Performance tips and techniques
- Dashboard building options
- Report Distribution Options
- Accessing non Db2 Databases
- Setting up Run Time Groups
- Integrating reports/charts with custom application through REST Web Services
Back to top