Platforms and Architecture
09/05/2025 TDWI Data Warehouse Automation: Better, Faster, Cheaper … You Can Have It All
September 5, 2025
9:00 am - 12:30 pm CT
Half-Day (Morning)
Prerequisite: None
John L Myers
Research Analyst
Blue Buffalo Group
John Myers is an industry analyst in the areas of analytics, business intelligence, and big data with nearly 20 years of experience working in areas related to analytics in professional services consulting and product development. He helps organizations solve their business analytics problems, whether they relate to operational platforms (such as customer care or billing) or applied analytical applications (such as revenue assurance or fraud management).
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