POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Wednesday, May 22 • 8:00am - 9:00am
41AL Stop Building Data Extracts for BI/Analytics!

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Building work files, temp files, and extracts can be unproductive, add extraneous processing, and creates too many copies of (unsecure?) data. In this session we will talk about simplifying and automating processes to eliminate custom extract programs. We'll cover tools like DataMigrator, why the data warehouse might make sense, and streamlining creation of PDFs or Excel files outputs w/o having to reverse engineer spool files.

Learning Objectives:

  1. Learn about simplifying and automating data transformations and replication.
  2. Understand how Db2 Web Query can eliminate many extra steps currently in place to get data into a spreadsheet or visualization tool.
  3. Learn about an IBM i based ETL tool that you probably haven't heard of.

avatar for Doug Mack

Doug Mack

Consultant LAB Services, IBM
Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design... Read More →

Wednesday May 22, 2019 8:00am - 9:00am PDT
Fantasy Tower North Ballroom A
  • Focused Education Roadmap Data Analytics
  • Level Intermediate
  • Operating System IBM i
  • Audience RPG Developers, Business or Data Analysts, Query/400 report developers, I/T and Business Managers