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 seminar was conducted very well. The instructor made the classes very interesting and lively. A fantastic teacher."

Sirajudeen Samsudeen

"I found the course content, structure and pace perfect. Steve's presentation style & charisma make the experience an extremely enjoyable one. Thanks a million."

Alex Dokter, Information Architect, Scottish Water Technology & Innovation

"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

"This course was what I needed to get up to speed on Data Modelling. From scratch to advance in 4 days, Steve Hoberman is very passioned about his work, and is able to get that across to the audience."

Chris Prins, British American Tobacco

"The course was enjoyable and informative and I found the relaxed atmosphere in which it was conducted helped my learning."

Brian White, Implementation Manager, Land Registry

"Excellent communication style, humour, informal but very knowledgeable. Best speaker on any training course that I have been on."

Steve Ruane, Data Modeler, Co-Operative Bank

"I did not have any background in data modeling before attending the seminar “ Data Modeling Fundamentals”. I found the seminar to be excellent for professionals with no prior data modeling knowledge: it is easy and simple to follow. The instructor, Steve Hoberman, not only masters the subject but makes it fun too! I will definitely recommend it to all professionals who are new to data modeling."

Nicholas Fofang, Project Manager, Petroleum Information Center, National Hydrocarbons Corporation (SNH) Cameroon

"I found the seminar to be very informative and was time well spent. I came away with a firm understanding of data modelling principles and techniques which have proved to be extremely valuable in my day-to-day role."

Dean Sumner, Senior Systems Analyst, Prudential plc

"Data management and modelling is now high on the public sector agenda.

This fundamentals course was just that, describing the areas I needed to know about at a level that was understandable. The whole course from minute 1 was interesting, enjoyable and relevant. The delivery by the effervescent Steve Hoberman was excellent and his subject knowledge shone through on both days."

Andy Parrett, Business Analyst, Land Registry Information Systems

"Steve's expertise and enthusiasm made it a great course."

Nicola Askham, Senior Consultant, Glue Reply

"Excellent for building foundation knowledge on data modelling. Excellent presenter. Kept the focus of the presentation."

Veronica Suta, BI & DW Consultant, Oracle Romania

"Very interactive. Captured the attention."

Laurence Maillet, Systems Engineer, National Bank of Belgium

"Excellent seminar. Interesting and fun."

Tracy Denley, Analyst, Land Registry

"Excellent seminar. A great introduction to data modeling techniques and issues."

Steve Hursell, Data Quality Officer, Metropolitan Police

"Best instructor of any course I have ever been on."

Trish Daniells, Designer, The AA

"Kept it interesting and explained things clearly."

Joanna Pyke, Data Quality Officer, MET Police

"Exceeded my expectations."

Margaret Gemmell, Application Support Specialist, Salford University

 

2-Day Seminar

Data Modelling Fundamentals
Build a Foundation in Data Modelling Concepts and Techniques!

Steve Hoberman

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

       

Register On-line:
7-8 October 2014, London
10-11 March 2015, London

   
Related Seminar:
Data Modelling Masterclass: Sharpen Your Data Modelling Skills!
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
Data Modelling Fundamentals contains a complete explanation of data modelling concepts and terminology, along with techniques for producing solid relational and dimensional data models. This course is designed to give you a practical understanding of data modelling that can be applied to your current projects.

Learning Objectives

  • Explain data modelling building blocks and identify these constructs by following a question-driven approach to ensure model precision

  • Describe relational and dimensional conceptual, logical, and physical data models
  • Build a relational conceptual data model and a dimensional logical data model
  • Demonstrate reading a data model of any size and complexity with the same confidence as reading a book
  • Validate any data model with key “settings” (scope, abstraction, timeframe, function, and format)

Seminar and Workshop Outline

Modelling Basics
Assuming no prior knowledge of data modelling, we introduce our first case study which illustrates four important gaps filled by data models. Next, we will explain data modelling concepts and terminology, and provide you with a set of questions you can ask to quickly and precisely build a data model. We will also explore each component on a data model and practice reading business rules. We will complete several exercises, including one on enhancing an existing data model. You will be able to answer the following questions by the end of this section:

  • What is a data model and what characteristic makes the data model an essential wayfinding tool?
  • How does the 80/20 rule apply to data modelling?
  • What six questions must be asked to translate ambiguity into precision?
  • What two situations can ruin a data model’s credibility?
  • What are five key skills every data modeller should possess?
  • Why are there at least 108 ways to model any situation?
  • What do a data model and a camera have in common?
  • What are entities, data elements, and relationships?
  • Why subtype and what are the differences between exclusive and non-exclusive subtypes?
  • How do different modelling notations represent subtypes?
  • What are candidate, primary, natural, secondary, and foreign keys?
  • What are the perceived and actual benefits of surrogate keys?
  • What is cardinality and referential integrity and how do they lead to better data quality?
  • How do you “read” a data model?
  • What are the different ways to model hierarchies and networks?
  • What is recursion and why is it such an emotional topic?
Conceptual, logical, and physical data models
The conceptual data model captures a business need within a well-defined scope, the logical data model captures the business solution, and the physical data model captures the technical solution. Relational and dimensional techniques will be described at each of these three levels. We will also practice building several data models and you will be able to answer the following questions by the end of this section:
  • How do relational and dimensional models differ?
  • What are the seven different types of data models?
  • Why are conceptual and logical data models so important?
  • What are five different ways of communicating the conceptual?
  • What are six conceptual data modelling challenges?
  • What is the difference between grain, base, and atomic on a dimensional data model?
  • What are the three different paths for navigation on a dimensional data model?
  • What are the differences between transaction, snapshot and accumulating measures?
  • What are the three different variations of conformed dimensions?
  • What are some dimensional modelling do’s and don’ts?
  • What is the difference between a star schema and a snowflake?
  • What is normalization and how do you apply the Normalization Hike?
  • Where should denormalization be performed on your models?
  • What are the five denormalization techniques?
  • What is the difference between aggregation and summarization?
  • What are the four different types of Slowly Changing Dimensions?

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

This course assumes no prior data modelling knowledge and, therefore, there are no pre-requisites.

IIBA Accreditation

The Data Modelling Fundamentals 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 Masterclass is a follow on course to the Data Modelling Fundamentals course.  Register on both Fundamentals and Masterclass and save £220.

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:
7-8 October 2014, London
10-11 March 2015, London

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.

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

Hotel Venue
7-8 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

10-11 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.

E-mail: info@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 Fundamentals 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 Made Simple
Steve Hoberman

Data Modeling Made Simple
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.