Current Public Seminars

Enterprise Architecture
Zachman Enterprise Architecture: Modelling Workshop Zachman Certification
Understanding Enterprise Architecture
Applied TOGAF: Beyond Certification to Practical Application
TOGAF™ 9: Certification Level 1 and 2
 
IT Strategy & Management Skills
The Corporate Strategy for IT
Enterprise Investment
   
Business Analysis
Working with Business Processes: Discovery, Mapping, Redesign and Requirement
Business Architecture: Building Alignment for Rapid Change
Mastering the Requirements Process
Business Rules and Decisions: Analysis Techniques
   
Data Management
Business Intelligence, Big Data, and Data Warehousing: New Technologies and Developments Explained
Data Modelling Fundamentals
Data Modelling Masterclass
Defining and Executing Your Information Strategy
Ten Steps to Data Quality


Testimonials:

"The opening example on leverage using data model was fantastic. Steve is an awesome teacher; He uses lots of analogues, personal examples to keep the classes lively. I am so impressed with the Data Model Scorecard and the entire class structures around it."

Sirajudeen Samsudeen

"I thought the course was very worthwhile. It brought a new perspective to Data Modelling and Steve Hoberman is a natural teacher. He used analogies from real life, such as the settings on a camera, that made all of the examples easy to understand and remember. The Masterclass is a natural follow on to the Fundamentals class and, unlike other courses, time wasn't wasted going over old ground from the previous two days. I would recommend this course to anyone wanting to breath new life into their data modelling skills."

Sara-Louise Ewen, Data Governance Manager, ACCA

"An extremely interesting and engaging course - I enjoyed it immensely! You are a very gifted trainer and managed through your enthusiasm for the subject and interesting anecdotes, to make the course a very enjoyable experience."

Jonathan J Hall, Data Analyst, HSBC Bank Plc

"IRM courses are always taught by top professionals. In this case it was Steve Hoberman for the Data Modelling Masterclass. Even though I am a seasoned data modeler I walked out of the course with new techniques and concepts to aid in my daily work activities. Steve Hoberman is indeed an international thought leader in this area and I recommend his classes highly."

Angelo R Bobak, Director, Business Intelligence, Siemens IT Solutions and Services, Inc.

"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

Steve Hoberman

Click here to hear Steve give a short overview of this seminar

       
Register On-line:
9-10 October 2014, London
12-13 March 2015, London
   
Related Seminar:
Data Modelling Fundamentals: Build a Foundation in Data Modelling Concepts and Techniques!
Steve Hoberman

PDF File IRM UK Seminars 2014-2015 Brochure

Click here for an in-house quote request or for further information regarding in-house training.

Overview
The Masterclass starts off with an overview of the Data Model Scorecard®, ten categories for validating data model quality. Each of these categories is then discussed, with an emphasis on advanced techniques and guidelines within data modelling and requirements elicitation. You will know not just how to build a data model, but also how to build a data model well. Two case studies and many exercises reinforce the material and will enable you to apply these techniques in your current projects.

Learning Objectives

  • Build relational and dimensional conceptual and logical data models, and know the tradeoffs on the physical side (including with NoSQL), through two case studies
  • Validate any data model through the Data Model Scorecard®
  • Apply requirements elicitation techniques including interviewing and prototyping
  • Practice finding structural soundness issues and standards violations
  • Recognize situations where abstraction would be most valuable and situations where abstraction would be most dangerous, and where industry data models can prove an important head start
  • Use a series of templates for capturing and validating requirements, and for data profiling
  • Express how to write clear, complete, and correct definitions
  • Leverage the Grain Matrix, Data Vault, and enterprise data model for a successful enterprise architecture

Seminar & Workshop Outline

  • 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 the perspectives of both the modeller and reviewer, and you will be provided with a template to use on your current projects.
  • Reviewing conceptual, logical, and physical data models.
    The conceptual data model captures a business need within a well-defined scope; the logical data model captures an application-independent business solution; and the physical data model captures the technical solution by focusing on factors such as performance and security.
  • Ensuring the model captures the requirements.
    There is no one way to elicit requirements – rather it requires knowing when to use certain elicitation techniques such as interviewing and prototyping. We will focus on techniques to ensure the data model meets the business requirements. All of the techniques discussed are consistent with the Business Analysis Body of Knowledge (BABOK).
  • Validating model scope.
    We will focus on techniques for validating that the scope of the requirements matches the scope of the model. If the scope of the model is greater than the requirements, we have a situation known as “scope creep.” If the model scope is less than the requirements, we will be leaving information out of the resulting application.
  • Following acceptable modelling principles.
    If someone showed you a blueprint for a house, you would probably catch some obvious errors, such as if the blueprint depicted a bedroom in the middle of the kitchen! This is the same category for the data model – we are looking for obvious errors on the data model. We will focus on techniques for building sound designs.
  • Determining the optimal use of generic concepts.
    Abstraction is a technique for redefining business terms into more generic concepts such as Party and Event. This module will explain abstraction and cover where it is most useful.
  • Applying consistent naming standards.
    Consistent naming standards will get your organization one step closer to a successful enterprise architecture. We will focus on techniques for applying naming standards.
  • Arranging the model for maximum understanding.
    A data model is a communication tool and if the model is difficult to read it can hamper communication. We will focus on techniques for arranging the entities, data elements, and relationships to maximize readability.
  • Writing clear, correct, and consistent definitions.
    Although definitions may not appear on the data model diagram itself, the definitions are integral to data model precision. We will focus on techniques for writing useable definitions.
  • Fitting the model within an enterprise architecture.
    A data modeller is not only responsible to the project for capturing the application requirements, but also responsible to the organization to ensure all terms and relationships are consistent within the larger framework of the enterprise data model. We will focus on techniques for ensuring the data model fits within a “big picture”.
  • Comparing the metadata with the data.
    A logical or physical should not be considered complete until at least some data analysis has been done on the data that will be loaded into the resulting data structures. We will focus on techniques for confirming the data elements and their rules match reality. Does the data element Customer Last Name really contain the customer’s last name, for example?
  • Modelling workshop.
    To further reinforce the content of this seminar, we will build a series of data models and validate them with the Data Model Scorecard.

Audience
Typical delegates to this seminar include:

  • Data Modellers
  • Data Architects
  • Data Analysts
  • Enterprise Architects
  • Solution Architects
  • Application Architects
  • Information Architects
  • Business Analysts
  • Database Administrators
  • Developers
  • Project / Programme Managers
  • IT Consultants
  • Business Users

Course Pre-requisite
Data Modelling Fundamentals is a pre-requisite course to the Data Modelling Masterclass course. Register on both Fundamentals and Masterclass and save £220. Delegates who do not attend the Fundamentals course should, at a minimum, have an understanding of data modelling concepts.

IIBA Accreditation

The Data Modelling Masterclass seminar 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 is recommended training for business analysts who wish to sit the exam to become Certified Business Analysis Professionals (CBAP). By attending this course, you will earn 12 PDs (Professional Development hours) or 12 CDUs (Continuing Development Units). For further information on how to register for the CBAP examination please refer to certification at www.theiiba.org.

 
Data Modelling Fundamentals is a pre-requisite course to the Data Modelling Masterclass course.  Register on both Fundamentals and Masterclass and save £220. Delegates who do not attend the Fundamentals course should, at a minimum, have an understanding of data modelling concepts.

Speaker Biography

Steve Hoberman

Steve Hoberman is the most requested data modelling instructor in the world. Introduced at over 50 international conferences as everything from a “data modelling guru” to “data modelling rock star”, Steve balances the formality and precision of data modelling with the realities of building software systems with severe time, budget, and people constraints. In his consulting and teaching, he focuses on templates, tools, and guidelines to reap the benefits of data modelling with minimal investment. He taught his first data modelling class in 1992 and has educated more than 10,000 people about data modelling and business intelligence techniques since then, spanning every continent except Africa and Antarctica. Steve is known for his entertaining, interactive teaching and lecture style (watch out for flying candy!), and is the author of five books on data modelling, including the bestseller Data Modelling Made Simple. He is the founder of the Design Challenges group, inventor of the Data Model Scorecard®, and CEO of Technics Publications.

Seminar Fee
£1,145 + VAT (£229) = £1,374

Register On-line:
9-10 October 2014, London
12-13 March 2015, London

OPTION: If both Data Modelling Fundamentals and Data Modelling Masterclass seminars are booked together, the fee is £2,090 plus VAT (£418) = £2,508.

Group Booking Discount

  • 2-3 Delegates - 10%
  • 4-5 Delegates - 20%
  • 6+ Delegates - 25%

Multiple Seminar Booking Discount

Attend more than one of our seminars and you will be entitled to the following discounts:

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

Please note, only one discount can be applied at any one time.

Hotel Venue
9-10 October 2014
VENUE:  etc.venues Paddington
57 North Wharf Rd
Paddington Basin, London, W2 1LA
Sales: 020 7989 0590
Switchboard: 020 7989 0590
Email: paddington@etcvenues.co.uk
http://www.etcvenues.co.uk/venues/paddington

12-13 March 2015
VENUE:  etc.venues Paddington
57 North Wharf Rd
Paddington Basin, London, W2 1LA
Sales: 020 7989 0590
Switchboard: 020 7989 0590
Email: paddington@etcvenues.co.uk
http://www.etcvenues.co.uk/venues/paddington

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.

Email: jane@jpetem.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) 2036 277202

Speaker: Steve Hoberman
Steve Hoberman

Click here if you would like to receive a copy of all Steve Hoberman’s articles that have appeared in our free monthly e-newsletter.  To subscribe to this e-newsletter click here.


Endorsed by
DAMA International
DAMA INTERNATIONAL
  UK Chapter
 

Endorsed by

The International Institute of Business

Data Modelling Masterclass is an endorsed course by the IIBA
v2.0 of the BABOK as registered under Steve Hoberman Associates.


Data Management Series
Business Intelligence, Big Data, and Data Warehousing: New Technologies and Developments Explained
 
Data Modelling Fundamentals
 
Data Modelling Masterclass
 
Defining and Executing Your Information Strategy
 
Ten Steps to Data Quality

Multiple Seminar Booking Discount
Attend more than one of our seminars and you will be entitled to the following discounts:

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

Group Booking Discount

  • 2-3 Delegates - 10%
  • 4-5 Delegates - 20%
  • 6+ Delegates - 25%

We regret that this offer cannot be used in conjunction with the Multiple Seminar Discount or any other discount.

Special Feature
Attendees receive a copy of

Data Modeling For the Business
Steve Hoberman

Data Modeling For the Business
Descriptions and Ordering from AMAZON


Related Books
Click on an image below for further information

 

IRM UK Conferences

Enterprise Data and BI Conference Europe 2014
3-5 November 2014, London

2 co-located conferences
MDM Summit Europe 2015
Data Governance Conference Europe 2015
18-21 May 2015, London

2 co-located conferences
Enterprise Architecture Conference Europe 2015
BPM Conference Europe 2015
15-18 June 2015, London

Business Analysis Conference Europe 2015
21-23 September 2015, London

Click here to purchase past conference documentation.