Data Modeling Masterclass 2011

Do you already know data modelling basics and want more? Take the Master Class! You will first apply a best practices approach to building and validating data models through the Data Model Scorecard®, a tool for validating data model quality. Next we focus on a collection of intermediate and advanced modelling techniques, including advanced normalization and enterprise data modelling. The final section contains guidelines used to gain consistency across our data models in areas such as in abstraction and whether to star schema or snowflake.

Learning Objectives

How to apply the Data Model Scorecard®
Advanced normalization rules
Advanced dimensional concepts
A value-driven approach to building the enterprise data model
Techniques for converting the logical into an physical design
Factors to consider in deciding whether to Star Schema or Snowflake
Three key questions to ask yourself before you abstract
Where to apply a series of templates for capturing and validating requirements
When to use a surrogate key