01
Foundations
- Advantages of data modeling
- Five prerequisites for creating a model
- Components: entities, attributes, representatives, relationships
- Subtyping, keys, hierarchies and networks
TEDAMOH Academy
Information Modeling — All about Information Modeling
Good business data models are the bridge between business and IT. In the Data Modeling Master Class you learn to read, build and validate them — with over 30 exercises.
New: the DMMC modules are now available as eLearning for pre-order — with an early-bird price.
New: the DMMC modules are now available as eLearning — start at your own pace.
Why information modeling?
Why do we spend a lot of money every year and thousands of hours building solutions that don't fit in the end? Often it comes down to business requirements that were captured and formulated poorly.
Good business data models prevent this waste. They capture business terminology and requirements precisely and at different levels of detail — ensuring smooth communication between business and IT.
The modules of the Data Modeling Master Class
Three modules that build on each other — from the foundations through building schemas to assessment with the Data Model Scorecard®.
02
Schema
- Conceptual, logical and physical models
- Relational and dimensional data models
- Distinguish NoSQL models from classic approaches
- Choose structure and methodology deliberately
03
Scorecard
- Best practices based on the Data Model Scorecard®
- Ten categories: correctness, completeness, schema, structure
- Abstraction, standards, readability, definitions
- Consistency and data
3modules
30+exercises
20teaching hours
What you can do afterwards
- Explain the components of data modeling and identify them in your projects through targeted questions.
- Read a data model of any size and complexity as confidently as a book.
- Validate any data model using key parameters — scope, abstraction, time frame, function, format — and the Data Model Scorecard®.
- Build relational and dimensional, conceptual and logical data models — and know the trade-offs of physical implementation for RDBMS and NoSQL.
- Apply requirements elicitation techniques: interviews, artifact analysis, prototyping and workplace observation.
Exercises & material
Over 30 hands-on exercises accompany the modules. Each one is explained in detail, with enough time to work through it yourself. A workbook guides you through every task.
30+ exercises
From "Modeling a book" and "Fun with cardinality" to the Six Questions.
Workbook
To work through all exercises — explained step by step.
Normalization & reservation
Examples like "Identify the normalization issues" and "Making a reservation".
Data Model Scorecard®
Template to validate your own models against ten categories.
Choose your format
Three ways to take the Data Modeling Master Class. Online training and In-House are available at any time; eLearning depends on the current stage.
Online training
Live training with other participants, virtual. Offered openly twice a year (Open Class).
Dates & bookingIn-House
Private training for your team — virtual or on-site, tailored to your use cases.
Send inquiryeLearning
At your own pace — recorded DMMC modules with all exercises and SQL tutorials.
Available soon.
€1,000 incl. 1 year of access
- + €199 Lifetime Access
- or €99 / year (Yearly Subscription)
DMMC Open Class in German. In-House also in English on request.
Further trainings
FCO-IM Fundamentals Class
German version coming soonFact Based Modeling
A three-day training on fact-oriented information modeling: capture business knowledge precisely together with domain experts, verbalize it in natural language with concrete examples, add rules and constraints, transform models and generate artifacts. Delivered with CaseTalk.
Upcoming dates
No open dates listed right now. Sign up for updates or contact us for an individual offer.
Send inquiry
For In-House trainings, individual dates or general questions. We'll get back to you shortly.
Your trainer
Dirk Lerner
Founder of TEDAMOH · consultant & trainer for data modeling
Dirk is an independent consultant and coach with more than two decades of experience in BI projects. He is a recognized expert in BI architectures, data modeling and temporal data, and advocates for flexible, lean and easily extensible data warehouse architectures. As a Data Vault and FCO-IM pioneer in the German-speaking region, he has published numerous works and is a sought-after speaker at international conferences.
What participants say
"The webinar series prepares you for the DMC certification in an entertaining way. Lots of questions, helpful exchange between participants. And Dirk, who always seems to know the answer!"
"The course covers the basics through to detailed information about data modeling and is suitable for both beginners and advanced users. Highly recommended!"
Frequently asked questions
Is prior knowledge required?
No. The Data Modeling Master Class requires no prior knowledge of data modeling — there are no special prerequisites for attending.
Is SQL required?
No. The Master Class is independent of any specific physical implementation of the data models. Knowledge of SQL or other programming languages is not required to attend.
What are the technical requirements?
For the virtual training you need a laptop, PC or tablet with access to Microsoft Teams (browser or client).
Online, In-House or eLearning — which fits?
Online training (Open Class): fixed date, mixed participants, in German. In-House: your team only, dates and content individual, English on request. eLearning: recorded DMMC modules at your own pace.
What's the difference between DMMC and the FCO-IM Fundamentals Class?
The Data Modeling Master Class focuses mainly on business-oriented modeling (conceptual, logical, physical; relational, dimensional, NoSQL). The FCO-IM Fundamentals Class teaches fact-oriented information modeling with CaseTalk — a German edition is currently in preparation.