TEDAMOH Academy
Design star schema-based data warehouses following the Kimball methodology — from grain definition through fact and dimension design to slowly changing dimensions and bridge tables. Ten sessions, two complete case studies, and a design presentation of your own.
New: the DMFC is now available as eLearning for pre-order — at the early-bird price.
New: the DMFC is now available as eLearning — start at your own pace.
In a data-driven business world, the ability to derive actionable insights from raw data is critical to success. Dimensional modeling is the proven methodology for structuring complex business data so it becomes optimally usable for analytics, reporting and business intelligence.
Developed by Ralph Kimball, this methodology has been the industry standard for designing the presentation layer in data warehouses and data solutions for over three decades.
The Dimensional Modeling Fundamentals Class on tedamoh.com →
The first five sessions cover the fundamentals. Sessions 6–9 deepen them through two complete case studies. In session 10 you present your own design.
Video material and all course materials are in English.
Complementing your self-study with the video materials, live sessions take place weekly — one hour each, for direct exchange with the trainer and the other participants.
The DMFC can be completed entirely through self-study. The live sessions are an additional offering.
Ask about the video content, discuss your exercise solutions and talk through your design decisions.
In German or English, depending on the participants. All sessions are recorded.
Each session contains hands-on exercises with realistic business scenarios. All exercises are thoroughly explained and come with sample solutions.
Plus bonus resources: decision trees, checklists and best practice guides. Please plan sufficient time for the assignments and for deepening the material between sessions.
Three routes to the Dimensional Modeling Fundamentals Class — all three are available.
An open, virtual training with other participants — bookable worldwide.
€1,990 net per person
Dates & bookingA closed, private training for your team — virtual or at your location, tailored to your use cases.
Send inquiryAt your own pace — all ten sessions as video material, with exercises, sample solutions and bonus resources.
Available shortly.
Available in three packages — depending on how much guidance you want alongside it.
from €1,000 net
Notify me Get the early bird Request order Compare packagesThe video materials are in English throughout. Live sessions are conducted in German or English depending on the participants.
The course content is identical in all three packages: ten sessions as video material, one year of access. What differs is how much personal guidance comes with it.
Learn at your own speed
€1,000 one-off, incl. one year of access
Most popular
Learn with weekly expert support
€1,490 one-off, incl. one year of access
Accelerate your results with personal expert guidance
Limited places
€1,990 one-off, incl. one year of access
The live calls take place online at fixed weekly slots; you can join at any time. After the first year, access can be renewed for €99 per year, or extended to lifetime access once for €199. Group discount for several people from one company: 10 % from three, 15 % from six participants. All prices net.
For everyone who designs, develops or works with data warehouses and business intelligence solutions. Ideal if one of these terms appears in your job title:
Project managers in BI and DWH projects, as well as anyone interested in dimensional modeling and data warehouse design, are equally welcome. Are you a student, apprentice or working at a university? Then ask Dirk about the educational discount.
No open dates listed at the moment. Sign up for updates or write to us for an individual quote.
For questions, in-house training and orders. Orders are confirmed by email; the contract is concluded with that confirmation.
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 recognised expert in BI architectures, data modeling and temporal data, and advocates flexible, lean and easily extensible data warehouse architectures. He is co-author of the book “Data Engine Thinking” and, as a Data Vault and FCO-IM pioneer in the German-speaking world, a sought-after speaker at international conferences.
No. No specific prior knowledge of dimensional modeling is required. A basic understanding of databases and business intelligence is helpful but not mandatory.
The DMFC is aimed at everyone who wants to design or develop data warehouses — from beginners to experienced practitioners who want to systematise their knowledge.
SQL knowledge is helpful but not required. The training focuses on designing dimensional models. SQL examples illustrate concepts, but you do not need to be able to write queries.
The focus is on conceptual and logical modeling, not on physical implementation.
To take part virtually you need a laptop, PC or tablet and the ability to use Microsoft Teams — in the browser or as a client.
For the exercises and your design presentation you need a tool for creating diagrams, for example PowerPoint, Lucidchart, draw.io or Visio.
The Data Modeling Master Class (DMMC) is a comprehensive training in general data modeling, covering conceptual, logical and physical modeling for relational and NoSQL databases.
The Dimensional Modeling Fundamentals Class (DMFC) focuses specifically on dimensional modeling for data warehouses following the Kimball methodology with star schema design.
The two complement each other: DMMC for general data modeling, DMFC for the presentation layer of the data warehouse. To the DMMC landing page →
After successfully participating in all sessions and giving your design presentation in a live session, you receive a certificate of participation from the TEDAMOH Academy.
You present a dimensional model you designed yourself, from your own professional environment, in a live session. You have 5 minutes of presentation time and then receive constructive feedback from the trainer.
You can choose the date freely — there are several live sessions to pick from. The presentation takes place live via Microsoft Teams. Detailed requirements and support are provided during the training.
The course content is the same in all three packages. They differ in how closely Dirk supports you:
Once a week, at fixed times, online. They are there for your own questions — they are not guided lessons. Sometimes you are alone in the call, sometimes several participants join. You can start at any time.
With Self-Paced you pick your three calls from the weekly slots of the first three months, whenever it suits you.
The live calls and 1:1 calls always run in the first three months after you start. After that they end. Videos, materials and exercises stay available for your whole access period.
You have access to the training for as long as the training exists. Without lifetime access, access ends after twelve months. You can still add lifetime access then (€199 net) or renew yearly (€99 net per year).
Instead of individual 1:1 calls there are team calls — six instead of three. You sit down together with Dirk and work on your own models and cases.
Use the form on this page: choose „Order", pick a date or package and enter your billing address. You receive a summary by email right away. Dirk checks the order and confirms it; the contract is concluded only with that confirmation. The invoice comes with it.
If you are a student, a pupil, an apprentice or work at a university, ask Dirk about the education discount.
If several people from one company sign up, there is a group discount: 10 % per person from three, 15 % from six participants.