The evolution of Db2 Web Query for i continues with a new version announced on October 3rd, 2017. With Version 2.2.1, both the Business Intelligence product set and the DataMigrator ETL (Extract, Transformation, and Load) component are enhanced - adding several new features to address user requests as well as bring new industry features for reporting and analytics to IBM i customers.
There have been several times in the history of this product where IBM has delivered minor changes, and other times when you could say the product capabilities took a major leap. An example of a big leap was when Db2 Web Query went from the Report/Graph Assist report authoring tools to the much more intuitive, powerful InfoAssist component. Another major leap was adding DataMigrator ETL with its integrated ability to un-tangle data into data marts or data warehouses.
Version 2.2.1 marks another major leap! This new version, available in mid-December, extends the community of users to the data analyst (or data scientist). New powerful “data discovery” analytics and visualizations make it even easier for analysts to navigate through data to understand what is driving the business.
End users will be more empowered by new features such as auto link, auto drill down, and dynamic parameter navigation. Version 2.2.1 makes it easier for the end user to iterate through data and across multiple reports without having to go back to the report author for changes in the original report(s). The ability to interactively select data on the report to create a filter will be very useful to analysts to focus on related data of interest – within the same report.
Were you aware of the geographical mapping visualizations in previous versions of Web Query? In 2.2.1, this gets even more interesting with additional enrichment to bring in information to your maps quickly and easily. New “layers” on the maps support such things as adding demographic data or bus or train routes for further geographically based analysis. Some layers are built into the product, others are purchasable.
Learning how to build new Data Visualizations will be easier with embedded video links to walk you through the steps. Here are a couple of short running video examples:
Upgrading to 2.2.1 is a no charge software update (assuming you are current on software maintenance). The Db2 Web Query EZ-Install package (ibm.biz/db2wqezinstall-info) will be updated to simplify that upgrade or install the complete product set under a 70 day trial.
Over the next couple of months we'll be providing more details in Version 2.2.1 but you may want to check out the current EZ-Install package today in preparation for the next major leap in functionality!