ONSITE EDUCATION

Your Team,
Your Location,
Our Instructors

The Logical Data Warehouse: Design, Architecture, and Technology (NEW)

Duration: One or Two Day Course

Prerequisite: None

Classic data warehouse architectures are made up of a chain of databases. This chain consists of numerous databases, such as the staging area, the central data warehouse and several datamarts, and countless ETL programs needed to pump data through the chain. This architecture has served many organizations well. But is it still adequate for all the new user requirements and can new technology be used optimally for data analysis and storage?

Integrating self-service BI products with this architecture is not easy and certainly not if users want to access the source systems. Delivering 100% up-to-date data to support operational BI is difficult to implement. And how do we embed new storage technologies, such as Hadoop and NoSQL, into the architecture?

It is time to migrate gradually to a more flexible architecture in which new data sources can hooked up to the data warehouse more quickly, in which self-service BI can be supported correctly, in which OBI is easy to implement, in which the adoption of new technology, such as Hadoop and NoSQL, is easy, and in which the processing of big data is not a technological revolution, but an evolution.

The architecture that fulfills all these needs is called the logical data warehouse architecture. This architecture, introduced by Gartner, is based on a decoupling of reporting and analyses on the one hand, and data sources on the other hand.

The technology to create a logical data warehouse is available, and many organizations have already successfully completed the migration; a migration that is based on a step-by-step process and not on full rip-and-replace approach.

In this practical seminar, the architecture is explained and products will be discussed. It discusses how organizations can migrate their existing architecture to this new one. Tips and design guidelines are given to help make this migration as efficient as possible.

You Will Learn

  • What are the practical benefits of the logical data warehouse architecture and what are the differences with the classical architecture.
  • How can organizations step-by-step and successfully migrate to this flexible logical data warehouse architecture?
  • You will learn about the possibilities and limitations of the various available products.
  • How do data virtualization products work?
  • How can big data be added transparently to the existing BI environment?
  • How can self-service BI be integrated with the classical forms of BI?
  • How can users be granted access to 100% up-to-date data without disrupting the operational systems?
  • What are the real-life experiences of organizations that have already implemented a logical data warehouse?

Geared To

  • Business intelligence specialists; data analysts; data warehouse designers; business analysts; data scientists; technology planners; technical architects; enterprise architects; IT consultants; IT strategists; systems analysts; database developers; database administrators; solutions architects; data architects; IT managers

Contact Us to Get Started Today

REQUEST INFORMATION

Yvonne Baho

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

TESTIMONIALS

"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

REQUEST INFORMATION

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.