Your Team,
Your Location,
Our Instructors

Dimensional Models: What’s New in the Big Data Era (NEW)

Duration: One Day Course

Prerequisite: Exposure to some IT projects is helpful.

The dimensional model is a product of a simpler age—one where BI was all about the data warehouse and a terabyte of data was unimaginable.

How has this aging discipline been impacted by advances in technologies, the advent of agile methods, and the expansion of BI programs to include analytics, performance management, and data governance?

You Will Learn

  • A refresher on dimensional modeling techniques (including the types of fact tables, dimensional intricacy, bridge design, and change handling)
  • How principles and best practices have changed (Spoiler: principles have not changed, but best practices have)
  • Agile dimensional techniques for requirements, scope, and design (including business dimensional modeling techniques and a rethinking of design best practices)
  • How to integrate with analytics and other BI services (including techniques for analytics-friendly warehouse design, multidirectional data integration, and KPI management)
  • How to incorporate nonrelational data sources (including techniques for incorporating unstructured data in dimensional designs and for extending the warehouse to include both dimensional and nonrelational data)
  • Modern data architectures that support multiple BI services and leverage new technologies including NoSQL and virtualization
  • How to make sure “modeling” is not a dirty word by shifting the modeler’s role away from gatekeeping and toward consensus building
  • Templates for capturing business needs, collaborative design, and KPI definition

Geared To

This course is intended for anyone who contributes to data mart requirements and development, including:

  • Business analysts and requirements analysts
  • Data modelers and architects
  • Reporting and ETL developers and architects
  • BI program and project managers
  • Database administrators
  • "Power users" and business subject matter experts

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.