This interactive seminar and workshop is for anyone who already knows modelling fundamentals and is seeking more advanced techniques.  In this Masterclass, delegates 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. Delegates will then 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 data models in areas such as in abstraction and whether to star schema or snowflake. Delegates will learn: How to apply the Data Model Scorecard™Advanced normalization rules and limitations of the logical data modelA value-driven approach to building the enterprise data modelTechniques for converting the logical into an physical designFactors to consider in deciding whether to Star Schema or SnowflakeThree key questions to ask yourself before you abstractWhen to use a surrogate key