IBM Db2 Web Query for i Dashboard Videos

IBM's Db2 Web Query for i provides an end to end analytics solution integrated with IBM i. The product suite includes Query/400 modernization facilities, easy to learn query/report/dashboard building tools, and an integrated ETL (Extract, Transformation, and Load) product to automate data cleansing and consolidation.

Dashboards are one of the most popular features of Db2 Web Query. Dashboards range from personal  use pages (think my favorite reports) to highly visual, interactive dashboards. Below you'll find video demonstrations of some of the new dashboard capabilities and also catch a glimpse at just some of the many charting and mapping capabilities you can use in your dashboards! 

A reminder that the Db2 Web Query EZ-Install package is the recommended method of installing Db2 Web Query, and it also comes with a large number of sample dashboards. Once installed you can also use the Wizard Analytics feature to create even more dashboards automatically!

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 vs. COGs for products (animation) (00:05:06)
• Scatter matrix – profit vs. COGs (00:05:17)
• Stacked bar – sales by month and product category (00:02:19)
• Stacked bar – units sold by stores vs. web (animation) (00:02:57)
• Treemap – revenue and average margin for models (00:04:12)

Active Dashboards

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

Interactive Dashboards

• 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)