Your Team,
Your Location,
Our Instructors

Modern Data Warehouse Architectures: From A - Z (NEW)

Duration: One Day Course

Prerequisite: None

Course Outline

There was a time when a data warehouse architecture consisted of a chain of databases all running on one or two machines in our own data center. Handwritten ETL programs were used to copy and transform data from one database to another. But so much new technology offering innovative opportunities has become available, there are so many new BI requirements, and we have new ways to design our data warehouse architectures.

Data warehouse architects are struggling with all these new developments. They have to find answers for an almost endless list of questions. Should the data warehouse be developed with Hadoop? Do we still need data marts if the BI tools read data into memory? Can we use Spark as query performance booster? What does it mean to design data vault-based data warehouses? Should we move the entire architecture into the cloud? Can we replace the data warehouse by a data lake? What is the role of the logical data warehouse? And so on, and so on.

This session discusses all the architectural and technical developments. How are they interrelated? How to migrate to a modern architecture? What are the pros and cons of all these developments?

You Will Learn

  • The use cases of Hadoop and Spark in a data warehouse architecture
  • How to distinguish between five levels of BI in the cloud 
  • The advantages are of using a data vault as a design technique
  • Whether data warehouse automation is hype or reality
  • How Spark can be used to boost query performance and whether it may even replace data marts
  • How a logical data warehouse and virtual data lake can work together
  • How analysis of streaming data can be embedded in a more classic architecture
  • Why operational BI demands a new architecture

Geared To

  • Business intelligence specialists and data warehouse designers who want to know about all the new developments.
  • Data scientists, data analysts, and business analysts who use and work with data every day and who want to know which of all these developments may help them.
  • Technology planners, technical architects, and enterprise architects who need to know how the evaluate all these new developments on their technical merits.
  • Database developers and database administrators who need to know what the impact is of Hadoop and Spark on database aspects.
  • IT Managers who need to be informed about all these new developments to see what the potential business benefits are.

Contact Us to Get Started Today


Yvonne Baho

Yvonne M. Baho Director, Enterprise Learning
Phone: 978.582.7105
Email: ybaho@tdwi.org


"The instructor was very responsive to input from the class and adapted to meet the needs specific to our context. I especially appreciated the many case studies and focus on assessment."

S. Bessias UNC Healthcare

"Very good overall view of DW concepts and provided valuable insight for such a varied audience."

Jerry Bundt Nestle Purina

"This was the best training class I’ve had in my 20 year career."

Tim Grieb Seattle Children’s Hospital

"The instructor did an excellent job and demonstrated an understanding of real world applications."

Sean Dewulf Con-way Freight


Yvonne Baho Yvonne M. Baho
Director, Enterprise Learning
Phone: 978.582.7105
E-mail: ybaho@tdwi.org
TDWI Onsite Brochure Download

Download the Onsite Brochure

Download Now

Contact Us to Get Started Today

Discover the impact Onsite Education has had on real Fortune 500 clients through practical in-depth training.

  • Banking
  • Healthcare
  • Manufacturing
TDWI has provided education to 95% of the Fortune 100 companies.
Our expert instructors will help your company surge ahead of the competition.