Current Public Seminars
The seminar was conducted very well. The instructor made the classes very interesting and lively. A fantastic teacher."
"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
Data Modelling Fundamentals
Build a Foundation in Data Modelling Concepts and Techniques
10-11 September 2013, London
11-12 March 2014, London
- Learning Objectives
- Seminar Outline
- Speaker Biography
- 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.
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 seminar and workshop is designed to give you a practical understanding of data modelling that can be applied to your current projects. Delegates will receive a copy of Steve Hoberman’s book, Data Modelling Made Simple.
- 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)
Assuming no prior knowledge of data modelling, we introduce our first case study with an entertaining exercise that will illustrate 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 why is a data model a valuable wayfinding tool in describing something existing or proposed?
- 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, 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 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?
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. Both 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 several different conceptual modelling notations?
- What is normalization and how do you apply it?
- What are the differences between transaction, snapshot and accumulating measures?
- What are the three different variations of conformed dimensions?
- What are junk dimensions, degenerate dimensions, and behavioral dimensions?
- What are outriggers, measureless meters, and bridge tables?
- 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 denormalization techniques?
- 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 four different types of Slowly Changing Dimensions?
- Data Modellers
- Data Architects
- Data Analysts
- Enterprise Architects
- Solution Architects
- Application Architects
- Information Architects
- Business Analysts
- Database Administrators
- Project / Programme Managers
- IT Consultants
- Business Users
This course assumes no prior data modelling knowledge and, therefore, there are no pre-requisites.
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.|
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.
Hotel Venue and Accommodation
10-11 September 2013
VENUE: etc.venues Paddington
57 North Wharf Rd
Paddington Basin, London, W2 1LA
Sales: 020 7989 0590
Switchboard: 020 7989 0590
11-12 March 2014
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: firstname.lastname@example.org Tel +44 (0)84 5680 1138 Fax +44 (0)84 5680 1139.
- 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
Telephone: +44 (0)20 8866 8366
Fax: +44 (0)1923 828 770
Speaker: Steve Hoberman
Data Modelling Fundamentals is an endorsed course by the IIBA
Data Management Series
Data Modelling Fundamentals
- 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.