Current Public Seminars
"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
| Register On-line: 6-7 March 2012, London 11-12 September 2012, London |
|
Click
Here To Download The 2012 .PDF Brochure
- Overview
- Learning Objectives
- Seminar Outline
- Audience
- Speaker Biography
- Testimonials
- Seminar Fee
- Multiple Seminar Booking Discount and Group Booking Discount
- Hotel Venue and Accommodation
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.
- Use data modelling constructs and employ the “6 Questions” approach to ensure model precision
- Demonstrate reading a data model of any size and complexity with the same confidence as reading a book
- Explain relational and dimensional subject area, logical, and physical data models
- Build a business subject area model for your organization
Modelling Basics
Assuming no prior
knowledge of data modelling, we will begin this section with an entertaining exercise
that will illustrate an important gap filled by data models. Next, we will
explain data modelling concepts and terminology. We will also explore each
component on a data model and practice reading business rules. You will be able
to answer the following questions by the end of this section:
- What is a data model and how can a piece of paper with boxes and lines be such a valuable wayfinding tool to our organizations?
- 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?
- What do a data model and a camera have in common?
- What are entities, data elements, domains, and relationships?
- Why subtype and what are the differences between exclusive and non-exclusive subtypes?
- What are the different types of keys on a model?
- What are the perceived and actual benefits of surrogate keys?
- What is cardinality and how are the relationships on a data model read?
- What are the different ways to model hierarchies and networks?
- What is recursion and why is it such an emotional topic?
Subject area, logical, and physical data models
The subject area 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. Each of these models will be explained in detail in
this section. 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 three types of subject area models and how are they built?
- What is normalization and how do you apply it?
- What are the differences between transaction, snapshot and accumulating measures?
- What are conformed dimensions, junk dimensions, degenerate dimensions, and behavioral dimensions?
- What are the different navigation paths needed to drill down, up, and across?
- What are some dimensional modelling do’s and don’ts?
- What is the difference between a star schema and a snowflake?
- Where should denormalization be performed on your models?
- What are the five ways of denormalizing?
- What is the difference between aggregation and summarization?
- What are views, indexing, and partitioning and how can they be leveraged to improve performance?
- What are the three different types of Slowly Changing Dimensions?
Special Features
- Attendees receive a copy of Steve Hoberman's newest book, Data Modeling Made Simple.
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.
Audience
This course assumes no prior data modelling knowledge and, therefore, there are no pre-requisites. Typical delegates include:
- Data Modeller
- Data Architect
- Data Analyst
- Data Manager
- Business Analyst
- Enterprise Architect
- Information Architect
- Solutions Architect
- Applications Architect
- IT Consultant
- Project Manager
- Programme Manager
- Developer
- Senior Designer
- Data Administrator
- Database Administrator
- Data Quality Manager
- Data Steward
|
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,095 + VAT (£219) = £1,314
OPTION: If both Data Modelling Fundamentals and Data Modelling Masterclass seminars are booked together, the fee is £1,970 plus VAT (£394) = £2,364.
Hotel Venue and Accommodation
6-7 March 2012
Venue: The DoubleTree Hilton
DoubleTree by Hilton London-West End
Southampton Row
WC1B 4BH London
Tel: +44 (0)20 7242 2828
Fax: +44 (0)20 7831 9170
Email: info@dtlondonwestend.com
http://www.crimsonhotels.com/doubletreelondon/
11-12 September 2012
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: 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)1923 828 770
Speaker: 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 |
|
Endorsed by |
 |
Data Modelling Fundamentals is an endorsed course by the IIBA |
Data Management Series
Defining and Executing Your Information Strategy
Information Process Quality Improvement
New Technologies and Architectures for Data Warehousing and Business Intelligence
Data Virtualization for Agile Business Intelligence Systems
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
20% discount for 5 or more registrations made at the same time.
We regret that this offer cannot be used in conjunction with the Multiple Seminar Discount or any other discount.
Special Feature Data Modeling Made Simple Related Books Data Modeling For the Business Data Modeler's Workbench Data Modeling Made Simple With CA ERwin r8 Available on Amazon US |
|
