By using tdwi.org website you agree to our use of cookies as described in our cookie policy. Learn More

VIRTUAL TEAM TRAINING

Your Team,
Our Instructors
Anywhere, Anytime

The Dimensional Model Refactored: New Techniques for the 21st Century

Duration: Full Day Course

Prerequisite: None

Course Outline

Traditional dimensional modeling techniques are destined to fail in modern BI and analytics programs. Chris Adamson, the world's leading expert on dimensional modeling, will show you why and teach you what to do about it.

The best practices of dimensional modeling were established in the 1990s, before the advent of analytics, self-service, nonrelational data, agile methods, and data governance. Chris will demonstrate how these expanded interests conflict with classic dimensional approaches and provide you with new techniques for scoping, requirements, design, and refactoring. Nothing is sacred, not even conformed dimensions!

You will also learn how to adapt to new data architectures, changed organizational structures, agile development methods, and nonrelational data management technologies. Both data modelers and non-modelers will learn how to use dimensional concepts to drive requirements that are actionable and useful.

You Will Learn

  • How the dimensional model fits—and does not fit—in the expanded scope of modern BI and analytics programs
  • The place of dimensional data in expanded data architectures that include self-service, analytics, and data lakes
  • Why an enterprise scope can bog down modeling efforts and degrade business value
  • When to abandon conformed dimensions, and how to manage expectations accordingly
  • Changes to traditional modeling practices, such as establishment of grain, dimension population, and slow change rules
  • How business and technologists can work collaboratively for just-enough-modeling, and manage efforts so that future refactors don’t get anyone fired
  • Simple refactoring techniques and a debt matrix for agile scope management
  • Techniques to link dimensional data with big data that lives outside the data warehouse
  • What kind of information should be collected and validated so that models are useful and actionable (hint: don't think "conceptual-logical-physical")
  • A modern requirements process that acknowledges business organizations that often separate data management from BI and analytics teams
  • Templates for successful development of dimensional models

Geared To

This course is intended for anyone who contributes to data mart requirements and development, the publication of data sets, or data modeling:

  • BI, analytics, and DW program leadership
  • Business analysts and requirements analysts
  • Data modelers, data architects, and data engineers
  • Reporting and data pipeline developers and architects
  • Project delivery managers
  • "Power users" and business subject matter experts

Contact Us to Get Started Today

REQUEST INFORMATION

Yvonne Baho

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

TDWI Course Catalog

Download Our
Course Catalog

Download Now

REQUEST INFORMATION

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

Download Our Course Catalog

Download Now

Contact Us to Get Started Today