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. Open class and in-house are available at any time; eLearning depends on the current status.
Several times a year as an open, virtual training with other participants — bookable worldwide.
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.
The video materials are in English throughout. Live sessions are conducted in German or English depending on the participants.
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 in-house trainings, individual dates or general questions. We will get back to you shortly.
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.