IBM Db2 Web Query for i

IBM's Db2 Web Query for i family of products provide end-to-end analytics solutions integrated with IBM i. The product suite includes Query/400 modernization facilities, easy to learn report and dashboard building tools, and an integrated ETL (Extract, Transformation, and Load) product to automate data cleansing and consolidation. Some of the features of the Web Query family include:

• Import or consolidate antiquated Query/400 Reports into modern Business Intelligence applications.
• Leverage powerful report types that let users drill down, and around interactively with the data.
• Deliver data to users in many different formats, including spreadsheets, PDF, HTML, or powerful web visualizations.
• Automate report execution and distribution with job scheduling and email integration functions.
• Enable BI as part of the day to day process by integrating reports into line-of-business applications through the ability to embed report execution calls directly from traditional 5250 or web-based applications.

Multiple Editions

Express Edition is the entry level edition containing web-based report authoring while supporting all the output types (spreadsheet, PDF, HTML Analytical Documents, PowerPoint, and more).  Scheduler Edition adds automated report execution and distribution. You can push data out to consumers through email or send the output to a network drive. RunTime User Edition adds a runtime only user licensing option based on IBM i Group Profiles to support potentially thousands of runtime users. Standard Edition is the most robust, enterprise package including all the functions of Express, Scheduler and RunTime User Editions plus access to non-Db2 databases and application integration capabilities, supporting thousands of users. 

Automate Data Prepping and Integration

Db2 Web Query DataMigrator ETL Extension provides extract, transformation, replication, and load capabilities integrated into Web Query and running within IBM i. It simplifies data movement and transformations to support your analytics applications.

Designer

•  Building Reports
• Building Charts and Visualizations

• Formatting Charts
• Assembling Pages from Existing Content

EZ-Report

• Create Fast Report over SQL Statement with EZ-Report

Reports

• Margin by product category (00:04:04)
• Quantity sold by stores (00:04:03)

• Sales metrics year to date (00:03:41)
• Yearly product metrics (00:05:29)

Charts

• Bar – highest margin products (00:04:30)
• Choropleth map – sales by state (00:03:11)
• Heatmap – average margin product by country (00:03:51)
• Line – product revenue by month – sized by discount (00:02:48)
• Pie matrix – quantity by region (00:05:55)
• Proportional symbol map – sales by store (00:01:55)

• Scatter – profit and COGs for products (animation) (00:05:06)
• Scatter matrix – profit versus COGs (00:05:17)
• Stacked bar – sales by month and product category (00:02:19)
• Stacked bar – units sold by stores versus web (animation) (00:02:57)
• Treemap – revenue and average margin for models (00:04:12)

• Sales by region dashboard (00:10:15)

Visualizations

• Analytical dashboard (00:06:49)
• Executive dashboard (00:04:14)

• Sales by country and product (00:04:16)
• Store and product profits over time (00:03:36)