By using tdwi.org website you agree to our use of cookies as described in our cookie policy. Learn More

TDWI Chicago Update

At TDWI, we have been working hard to navigate this ever-changing landscape in the face of COVID-19, and we want to assure you that the health and well-being of our employees, customers, and vendor partners is our top priority. Therefore, due to the growing concern around the coronavirus (COVID-19), and in alignment with the guidelines laid out by the CDC and WHO, we have decided to merge this year’s TDWI Chicago Conference (May 10-15) with TDWI Orlando 2020 (November 8-13), where it can be a successful experience for everyone. The Chicago 2020 agenda will be replicated at TDWI Orlando 2020.

Our registration team will be in contact with individual registrants and sponsors directly.

Course Description

Platforms & Architecture, Onsite, TDWI Foundations

M4P TDWI Data Warehouse Automation: Better, Faster, Cheaper … You Can Have It All

May 11, 2020

1:45 pm - 5:00 pm

Duration: Half Day Course

Level: Beginner to Intermediate

Prerequisite: None

John L Myers

Research Analyst

Blue Buffalo Group

Preview Course Materials Course Outline

Building a data warehouse is among the most labor-intensive and time-consuming activities of BI development. There are many moving parts—requirements, source data analysis, source-target mapping, data acquisition, data transformation logic, ETL design, database loading, scheduling, error handling—and getting it right the first time isn’t easy. When you finally do get it right, something changes. One of the most pervasive problems in BI today is the fact that data warehouses take too long to build and they are hard to change!

Data warehouse automation (DWA) is a relatively new class of technology that accelerates warehouse development and change cycles while simultaneously assuring quality and consistency. More than simply generating ETL scripts, DWA automates the entire life cycle from source system analysis to testing and documentation. Productivity gains, cost savings, and quality improvement are all possible with DWA.

You Will Learn

  • Concepts, principles, and practices of data warehouse automation (DWA)
  • The current state of DWA technology
  • Automation opportunities and benefits when building or managing a data warehouse
  • How to get started with DWA
  • Best practices and mistakes to avoid with DWA

Geared To

  • BI and data warehousing program and project managers
  • Data integration architects, designers, and developers
  • Data warehouse operations, maintenance, and support personnel
  • Data and technology architects