Agile Data Warehouse & ETL Combo

Join us in New York, NY for all or part of this 4-day course, October 21-24, 2013, featuring two unique workshops from industry experts. Lawrence Corr and Joe Caserta will lead a two-part course covering Agile Data Warehouse and ETL Design.

  • October 21-22 Agile Data Warehouse, Lawrence Corr
  • October 23-24, 2013 ETL Design, Joe Caserta
New York Executive Conference Center
1601 Broadway at 48th St.
Times Square
New York, NY 10019

Find full course information below:

October 21-22 Agile Data Warehouse, Lawrence Corr

Dimensional modeling is the proven technique for designing comprehensive, high-performance Business Intelligence/Data Warehouse (BI/DW) systems. Agile dimensional modeling is dimensional modeling done iteratively, incrementally and collaboratively.

This course provides in depth coverage of agile dimensional modeling techniques for improving communication between BI/DW teams and business stakeholders as well as responding to changing DW requirements. Specifically the course covers BEAM*, the powerful, yet simple method for ModelStorming directly with BI stakeholders described in the book ‘Agile Data Warehouse Design: collaborative dimensional modeling, from whiteboard to star schema’.

You will learn to:

  • Model data requirements directly with stakeholders
  • Translate common cross-industry data analysis requirements into efficient, flexible dimensional models
  • Maximize the usability and performance of your data warehouse or data mart designs
  • Plan, design and incrementally develop agile data warehouse solutions

Audience

This course is for anyone interested in learning the latest agile techniques for designing and managing dimensional data warehouses and ETL processes. Beginner, intermediate and experienced data warehouse practitioners, data architects, DBA’s and ETL designers & developers will all benefit from this course.

About the Instructor

Lawrence Corr has worked in decision support for more than 20 years and has specialized in data warehouse design since 1996. He has worked on numerous data warehouse projects in Europe, USA, the Middle East and Africa and has developed, reviewed and enhanced designs for clients within aerospace, insurance, pharmaceuticals, telecommunications, engineering, manufacturing, television, financial services, e-commerce and retail.

Lawrence held the position of data warehouse practice leader at Linc Systems Corporation, CT, USA and vice-president of data warehousing products at Teleran Technologies, NJ, USA. In 2000 he was invited by Ralph Kimball to become an associate and taught data warehousing classes for Kimball University in Europe and South Africa during 2000 and 2001. He now works independently through DecisionOne Consulting based in the UK providing dimensional data warehouse consultancy and education worldwide.

He is the author of ‘Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema’.

For full course outline, click here.

October 23-24, 2013 ETL Design, Joe Caserta

The data warehouse is best known for taking disparate and disordered transaction data and presenting it in a cohesive, orderly way for the business to make intelligent, fact-based decisions. The data warehouse ETL designer is charged with the task of applying a set of consistent techniques for delivering conformed dimensional data. Precisely designing and building reusable processes to extract, clean, conform and deliver dimensional data is the foundation for a successful, reduced cost, data warehouse implementation.

You will learn:

  • Practical steps of data warehouse ETL including extracting, cleaning, conforming, and delivering data and its associated metadata
  • Design and development, architecture, operations and management aspects of scheduled and real-time ETL
  • The steps, and sub-steps, required to successfully obtain, prepare and publish data in a dimensional data warehouse

Audience

This course is for anyone interested in learning the latest ETL techniques for designing and managing data warehouses and ETL processes. Beginner, intermediate and experienced data warehouse practitioners, data architects, DBA’s and ETL designers & developers will all benefit from this course.

About the Instructor

Joe Caserta is the author of the best-selling book The Data Warehouse ETL Toolkit. the de facto standard for building dimensional data warehouses. Joe offers more than 25 years of IT experience and over 15 years of delivering dimensional data warehouse solutions with experience in the finance, insurance, healthcare, retail, e-commerce and education sectors. Joe delivers his published best practices in a way that encourages participants to immediately apply his techniques in real-life situations. During the course, Joe Caserta will strive to provide examples and exercises that are relevant the customer’s industry.

For full course outline, click here.