The Dimensional Modeling Fundamentals Class (DMFC) is a comprehensive training in dimensional modeling that teaches practical techniques for creating star schema-based data warehouses following the proven Kimball methodology.

You'll learn systematically how to translate business requirements into optimal dimensional models that are both performant and business-friendly. From grain definition through dimension and fact design to advanced patterns like Slowly Changing Dimensions and Bridge Tables – you'll master all aspects of dimensional modeling.

The DMFC consists of ten sessions with approximately 15-20 hours of video material (in English), two complete case studies (Retail and Accounting), and numerous hands-on exercises. Additionally, weekly live sessions are offered where you can ask questions and discuss your designs.

After the Dimensional Modeling Fundamentals Class, you'll not only know how to create dimensional models, but also how to design them optimally for Business Intelligence and Analytics.

The Dimensional Modeling Fundamentals Class consists of ten sessions with approximately 15-20 hours of video material (in English) and extensive hands-on exercises.

The first five sessions cover the fundamentals of dimensional modeling. Sessions 6-7 deepen this knowledge through a complete Retail case study. Sessions 8-9 address Financial Data Warehousing. In Session 10, you'll present your own design in a live session.

The Dimensional Modeling Fundamentals Class offers optional weekly live sessions that perfectly complement your self-study with the video materials.

The live sessions take place weekly, last one hour each, and provide you with the opportunity for direct exchange with the trainer and other participants.

The Dimensional Modeling Fundamentals Class combines theory with intensive practice through numerous exercises and two complete case studies.

Each session contains practical exercises where you immediately apply what you've learned. You'll work with realistic business scenarios and progressively develop complete dimensional models. All materials are in English.

Some of the hands-on exercises include:

All exercises are thoroughly explained and provided with sample solutions. Additionally, you'll receive bonus resources such as Decision Trees, Checklists, and Best Practice Guides.

Please plan sufficient time for completing the assignments and deepening the course material between sessions.

By participating in the Dimensional Modeling Fundamentals Class, you create value for yourself and your organization!

Your newly acquired skills enable you to design data warehouses that are both performant and business-friendly. You'll master the proven Kimball methodology and can develop star schema-based solutions that enable intuitive analysis while being technically robust.

This includes:

After the Dimensional Modeling Fundamentals Class, you can independently design and implement dimensional data warehouses.

You'll master the Kimball methodology and can demonstrate that dimensional modeling is in good hands with you.

The Dimensional Modeling Fundamentals Class is aimed at everyone who designs, develops, or works with data warehouses and business intelligence solutions.

The training is ideal for everyone who has one or more of the following terms in their job title:

Project managers in BI/DWH projects as well as anyone interested in dimensional modeling and data warehouse design are also warmly welcome.

Are you a student, high school student, apprentice, or working at a university? Then ask Dirk about our educational discount!

DIRK LERNER is an independent and experienced 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. Dirk advocates for flexible, lean, and easily extensible data warehouse architectures.

As part of the TEDAMOH Academy, Dirk coaches and trains in the areas of temporal data, data modeling certification, data modeling in general, and Data Vault in particular. He is co-author of the book "Data Engine Thinking," which describes modern data warehouse architectures with a focus on automation and best practices.

As a pioneer for Data Vault and FCO-IM in Germany, he has published numerous articles and is a highly regarded international speaker at conferences.

The Dimensional Modeling Fundamentals Class is a comprehensive training in dimensional modeling that we offer worldwide.

As a virtual training with English video materials and optional live sessions (in German or English), or at your location as a closed training (in-house).

No specific prior knowledge in dimensional modeling is required for this training. A basic understanding of databases and business intelligence is helpful but not mandatory.

The Dimensional Modeling Fundamentals Class is aimed at everyone who wants to design or develop data warehouses – from beginners to experienced practitioners who want to systematize their knowledge.

SQL knowledge is helpful but not required. The training focuses on designing dimensional models. SQL examples are used to illustrate concepts, but you don't need to be able to write SQL queries.

The focus is on conceptual and logical modeling, not on physical implementation.

To participate in the virtual Dimensional Modeling Fundamentals Class, you need a laptop, PC, or tablet and the ability to use Microsoft Teams (browser or client).

For the exercises and your design presentation, you'll need a tool for creating diagrams (e.g., PowerPoint, Lucidchart, draw.io, Visio, or similar).

The Data Modeling Master Class (DMMC) is a comprehensive training in general data modeling that covers conceptual, logical, and physical modeling for relational and NoSQL databases.

The Dimensional Modeling Fundamentals Class (DMFC) specifically focuses on dimensional modeling for data warehouses following the Kimball methodology with star schema design.

Both trainings complement each other ideally: DMMC for general data modeling, DMFC for specialized dimensional modeling in the Presentation Layer of the Data Warehouse / Data Solution.

After successfully participating in all sessions and your design presentation in a live session, you'll receive a certificate of participation from the TEDAMOH Academy.

The DMFC also optimally prepares you for working with dimensional models in real projects.

You'll present a self-designed dimensional model from your professional environment in a live session. You have 5 minutes of presentation time and will then receive constructive feedback from the trainer.

You can flexibly choose which live session you'd like to give your presentation in – there are multiple dates to choose from. The presentation takes place live via Microsoft Teams.

Detailed requirements and support for your presentation will be provided during the training.