TDWI New York Seminar

Advanced Dimensional Modeling: Techniques for Practitioners (Day 1)

September 24, 2017

Duration: Two Day Course

Prerequisite: This course assumes a basic understanding of dimensional modeling concepts, techniques, and terminology.

Chris Adamson


Founder and BI Specialist

Oakton Software LLC

When planning and building data marts, your entire team must be fluent in dimensional modeling—not just the data modelers! This course immerses students in the principles, processes, and deliverables of dimensional modeling, equipping you for a successful implementation. You will learn the complete set of best practices—from multiple fact table designs, to bridge tables, to advanced slow change processing. Students learn to match these techniques to real-world business complexity, and explore their impacts on BI and data integration tools. The course explores the reasons behind best practices, and teaches students to make pragmatic decisions when facing design choices.

Students also learn how to fit dimensional modeling into varied development frameworks (including agile), and receive templates for capturing requirements and designs.

You Will Learn

  • Why dimensional design requires collaboration between modelers, analysts, DBA’s, and ETL & reporting developers
  • Why most subject areas require multiple fact tables, and how to identify them
  • When to use alternatives to the basic transaction fact table, including periodic snapshots, accumulating snapshots, and type-specific stars
  • How to cope with dimensional intricacy with advanced techniques including bridge tables, minidimensions, and advanced slow change responses
  • Techniques to ensure your data warehouse will scale as new subject areas are added
  • How design fits into development approaches, and what tasks and outputs should be incorporated

Geared To

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

  • BI program & project managers
  • Business analysts
  • Data modelers and architects
  • BI reporting & ETL developers
  • DBA’s
  • “Power users” and business subject matter experts

Register Online

Rest easy—online registrations for this seminar are secure. Our secured server environment keeps your information private.

Subscribe to Receive seminar updates via email

TDWI New York Seminar

India House
New York, NY 10004
October 23–25