TDWI Chicago Conference

M1 Dimensional Models: What’s New in the Big Data EraNEW!

May 7, 2018

9:00 am - 5:00 pm

Duration: Full Day Course

Prerequisite: This course assumes a basic understanding of dimensional models (including concepts such as facts, dimensions, grain, and the basics of slowly-changing dimensions).

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?

Join Chris Adamson, the world’s leading expert on the dimensional model, for a tour of what has (and has not) changed in the era of big data and analytics.

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

Register Online

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

Subscribe to Receive email notification when the Agenda is updated

TDWI Chicago

Hilton Chicago
Chicago, IL
May 6–11


  • Download on the App Store
  • Get it on Google Play