DATA MODELLING MASTER CLASS Sharpen Your Data Modelling Skills 2 Day Seminar	Endorsed by DAMA INTERNATIONAL UK Chapter
Dates: 25-26 September 2008 Location: London To Book ONLINE Now, Click Here!   18-19 February 2009 Location: London To Book ONLINE Now, Click Here! Speaker: Steve Hoberman

"Excellent speaker. Used various examples. Good stuff."
Adebukonla Onabadejo, NSPIS Custody System Analyst, National Policing Improvement Agency

"Steve was enthusiastic, very knowledgeable, humourous and a great instructor."
Jacqueline Tomlinson, Data Analyst, Pension Protection Fund

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.

This course is for anyone who already knows modelling fundamentals and is seeking more advanced techniques. Roles include:

• Data Modeller
• Data Architect
• Data Analyst
• Data Manager
• Enterprise Architect
• Information Architect
• Solutions Architect
• Applications Architect
• IT Consultant
• Business Analyst
• Project Manager
• Programme Manager
• Developer
• Senior Designer
• Data Administrator
• Database Administrator
• Data Quality Manager
• Data Steward

Seminar Pre-requisite
Data Modelling Fundamentals or similar training or a working knowledge of data modelling. You need to have an understanding of data modelling concepts and components.

• How to apply the Data Model Scorecard™
• Advanced normalization rules and limitations of the logical data model
• 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
• When to use a surrogate key

Overview to the Data Model Scorecard™
The Scorecard is a set of ten categories for validating a data model. We will explore best practices from both the perspectives of the modeler and reviewer, and you will be provided with a template for use on your current projects. Each of the following categories heavily impacts the usefulness and longevity of the model, and will be discussed accompanied by many examples:

• Understanding subject area, logical, and physical data models
• Ensuring the model captures the requirements
• Validating model scope
• Applying acceptable modelling principles
• Determining the optimal use of generic concepts
• Using consistent naming standards
• Arranging the model for maximum understanding
• Writing clear, correct, and consistent definitions
• Matching the model with the enterprise
• Comparing the meta data with the data

Intermediate and Advanced Data Modelling Techniques
We will explore a number of modelling techniques to sharpen your data modelling skills. Techniques including

• Useful templates for capturing and validating business requirements
• Rapidly reaching Fifth Normal Form (5NF)
• Business rule limitations on the data model
• How should we model time and geography?
• A value-driven approach to building the enterprise data model
• Variations of data modelling notations and tools

Data Modelling Guidelines
We will end the day by discussing a series of modelling guidelines, in areas such as:

• Guidelines on converting subtypes in the physical
• Factors to consider in deciding whether to Star Schema or Snowflake
• Three key questions to ask yourself before you abstract
• When to use a surrogate key

• Attendees receive a copy of Steve Hoberman’s classic book, Data Modeler’s Workbench.

Data Management Series

Data Modelling Fundamentals
23-24 September 2008, 16-17 February 2009, London

Data Modelling Masterclass
25-26 September 2008, 18-19 February 2009, London

DW 2.0: Architecture for the Next Generation of Data Warehousing
2-3 December 2008, London

Unstructured Data: Creating the Analytical Environment
4-5 December 2008, London

Master Data Management
15-16 September 2008, London

SERIES DISCOUNTS
Attend more than one course in this series and you will be entitled to the following discounts:

2nd course 10%
3rd Course 15%
4th Course 20%
5th Course 25%

Group Booking Discounts
If 5 delegates from the same organisation register at the same time for the same or various seminars, then the 5th delegate is free. We regret that this offer cannot be used in conjunction with the Series Discount.

£995 + VAT (174.13) = £1169.13

25-26 September 2008
Venue: myhotel Chelsea, 35 Ixworth Place, London, SW3 3QX
Tel: +44 (0)20 7225 7500
Fax: +44 (0)20 7225 7555
Website: http://www.myhotels.com/default.asp?section=10&page=1509

18-19 February 2009
Venue: myhotel Chelsea, 35 Ixworth Place, London, SW3 3QX
Tel: +44 (0)20 7225 7500
Fax: +44 (0)20 7225 7555
Website: http://www.myhotels.com/default.asp?section=10&page=1509

IRM UK in association with JP Events Ltd has arranged special discounted rates at all venues and at other hotels nearby the venue. Please visit the JP Events website for further information.
E-mail: enquiries@jpeventsltd.com Tel +44 (0)20 7428 9911 Fax +44 (0)20 7428 9966.

For an in-house presentation of this or any other IRM UK seminar, please e-mail jeanette.hall@irmuk.co.uk or call +44 (0)20 8866 8366.

© Copyright IRM UK Strategic IT Training, Bishops Walk House, High Street, Pinner HA5 5PJ UK, Tel +44 (0)20 8866 8366, Fax +44 (0)20 8866 7966, enquiries@irmuk.co.uk, www.irmuk.co.uk.