PowerVUG – Session 107: Turning data into Information with Db2 Web Query for IBM i

  • 9 June 2021, 14:00-15:30 UK time (BST)
  • Speaker: Doug Mack, Analytics Consultant, Db2 for i, IBM Systems Lab Services
  • Every BI/Analytics vendor shows you fancy visualization screens (including IBM) but not talk about where the real work is in making a BI/Analytics project successful. Most BI pundits say up to 70% of the work is in wrangling the data. Get that right, and the reporting/analytics becomes much simpler and efficient. Db2 Web Query contains multiple ways to wrangle your data while leveraging what you already have with RPG, SQL, or even Query/400. In this session we delve into use of Synonyms to describe your data, leveraging SQL when appropriate, and facilities to create data flows or ETL processes to cobble data together for your analytics projects. Many how-to demos will be included.
  • Relevant for IBM i environments.