Your Team,
Your Location,
Our Instructors

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

Duration: One Day Course

Prerequisite: None

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 datavault-based data warehouses? How does data streaming and the IoT work together with the data warehouse? 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? Will an analytical SQL database server solve all our query performance problems? 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

  • What the use cases are of Hadoop and Spark in a data warehouse architecture?
  • To distinguish between five levels of BI in the Cloud and how they differ.
  • What the advantages are of using datavault as design technique.
  • Whether data warehouse automation is a hype or reality.
  • How Spark can be used to boost query performance and 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
E-mail: ybaho@tdwi.org


Check out the Onsite Brochure

Download Now


“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

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.