Current Public Seminars
"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
2-Day Seminar
Data Modelling Masterclass
Sharpen Your Data Modelling Skills
Register On-line:
22-23 September 2010, London
3-4
March 2011, London
Click
Here To Download The .PDF Brochure
- Overview
- Learning Objectives
- Seminar Outline
- Audience
- Speaker Biography
- Testimonials
- Seminar Fee
- Group Booking and Series Discounts
- Hotel Venue and Accomodations
Click here for an in-house quote request or for further information regarding in-house training.
Overview
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.
- 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 organizations leverage industry data models
- A value-driven approach to building the enterprise data model
- Top Down vs. Bottom Up vs. Hybrid techniques
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
- When to use each type of Slowly Changing Dimension
- 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
Audience
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.
Special Features
- Attendees receive a copy of Steve Hoberman's classic book, Data Modeler's Workbench.
IIBA Accreditation
This course has been endorsed by The International Institute of Business Analysts. As such, this course has been approved as being aligned to the Business Analysis Body of Knowledge (BABOK) and hence are recommended training for business analysts who wish to sit the exam to become Certified Business Analysis Professionals (CBAP). For further information on how to register for the CBAP examination please refer to certification at www.theiiba.org.
|
Steve Hoberman is a world-recognized innovator and thought-leader in the field of data modelling. He has worked as a business intelligence and data management practitioner and trainer since 1990, and is a popular and frequent presenter at industry conferences, both nationally and internationally. Steve is a columnist and frequent contributor to industry publications, as well as the author of Data Modeler's Workbench and Data Modeling Made Simple. He is the founder of the Design Challenges group and inventor of the Data Model Scorecard™. |
Seminar Fee
£1,095 + VAT (£191.63) = £1,286.63
Hotel Venue
and Accomodations
22-23 September 2010
Venue: Crowne Plaza London Kensington, 100 Cromwell Rd, London SW7 4ER
Tel: +44 (0)20 7373 2222 Fax: +44 (0)20 7373 0559
www.cpkensington.co.uk
3-4 March 2011
Venue: TBA London
London Accommodation: 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)84 5680 1138 Fax +44 (0)84 5680 1139.
In-House Training
If you require a quote for running
this course in-house, please contact us with the following details:
- Subject matter and/or speaker required
- Estimated number of delegates
- Location (town, country)
- Number of days required (if different from the public course)
- Preferred date
Please contact:
Jeanette Hall
E-mail: jeanette.hall@irmuk.co.uk
Telephone: +44 (0)20 8866 8366
Fax: +44 (0)1923 828 770
Speaker: Steve Hoberman

| Endorsed by |
DAMA International![]() UK Chapter |
Endorsed by |
Data Modelling Masterclass is an endorsed course by the IIBA |
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.
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%
Data Management Series
Data Modelling Fundamentals
Successful Master Data Management
New Technologies and Architectures for Data Warehousing and Business Intelligence
Information Quality Improvement


