/ tedamoh

Academy & 

A new data model for the data warehouse is necessary, but how do you model data? Understanding temporal data and learning methods and techniques to do so? Or a certification in data modeling?

We support you with coaching, our academy or with consulting!!


TEDAMOH Team - Stephan, Kim and Dirk

Blank sheets of paper for notes during seminars at the TEDAMOH Academy - Photo by Brandi Redd on Unsplash


Get the latest updates

Our latest updates of all categories - including our blog articles.

Secret Spice

  • 5th anniversary of TEDAMOH

    5th anniversary of TEDAMOH

    Dear readers of my blog,

    five years ago a long cherished idea of mine became reality. On July 1, 2017, TEDAMOH saw the light of day.

  • 8 Gründe, warum man bitemporale Daten benötigt

    8 Gründe warum temporale Daten benötigt werden

    Diesmal beschäftigt sich das Team des Data Management Center of Excellence (DMCE) von FastChangeCoTM mit der Frage: Was sind die geschäftlichen Anforderungen an bitemporale Daten?

  • 8 reasons why you need bitemporal data

    8 reasons why temporal data is needed

    This time, FastChangeCoTM's Data Management Center of Excellence (DMCE) team looks at the question: what are the business requirements for bitemporal data?

  • Blog

  • CDC verstehen, um Daten in Data Vault zu löschen

    Change Data Capture erkennt Änderungen an Daten. Im Falle von gelöschten Daten stellt sich die Frage: Wie sollten wir Löschungen in Data Vault verwalten?

  • Change default value

    At FastChangeCo, the data modelers within the Data Management Center of Excellence (DMCE) team are constantly designing new database objects to store data. One of the data modelers on the team is Xuefang Kaya. When she takes a new user story/task, she usually models multiple tables, their columns, and specifies a data type for each column.

  • Coaching Serie


    Coaching - Wie denn nun?

    In loser Folge veröffentliche ich meine Gedanken und Erfahrungen rund um Datenmodellierung, temporale Daten oder viele andere Dinge aus der Welt des Coachings. Dazu gehören für mich Lösungsansätze unterschiedlichster Art, die manchmal generell, manchmal ausschließlich für eine bestimmte Situation geeignet sind.

    Sehr oft wichtig und nicht zu vernachlässigen sind die fachlichen Anforderungen, die den Lösungsansätzen zugrunde liegen.

    Wie die bereits veröffentlichte Serie zum PowerDesigner und die Serie zu temporalen Daten ist diese Serie für mich eine Art, kleine Schätze aus meiner Coaching-Welt, das ‘Secret Spice’, mit euch zu teilen.

    In dieser Serie werdet ihr wahrscheinlich nicht so oft wie in den anderen Serien auf die Teammitglieder des Data Management Center of Excellence (DMCE) meines Lieblingskunden FastChangeCoTM treffen.

  • Coaching Series


    Coaching - How to do it?

    In loose order I publish my thoughts and experiences around data modeling, temporal data or many other things from the world of coaching. For me, this includes approaches to solutions of the most varying kinds, which are sometimes suitable in general, sometimes exclusively for a specific situation.

    Very often important and not to be disregarded are the business requirements on which the approaches to a solution are based.

    Like the already published series on PowerDesigner and the series on temporal data, this series is a way for me to share with you little treasures from my coaching world, the 'Secret Spice'.

    In this series, you probably won't run into the Data Management Center of Excellence (DMCE) team members from my favorite customer, FastChangeCoTM, as often as in the other series.

  • Customize table comments

    In several projects, FastChangeCo's data modelers on the Data Management Center of Excellence (DMCE) team had an issue with the way PowerDesigner generates comments for tables and columns for the SQL Server database. Xuefang Kaya (one of the data modelers on the team), asked about the problems, says to the DMCE team:

  • DBMS resource file

    PowerDesigner offers the possibility to edit the properties for a database in the so-called DBMS resource files. The DMBS resource files contain all information for PowerDesigner to generate DDL, DML and other SQL artifacts. For many databases, there are pre-built, included DBMS resource files for the different database versions.

  • DBMS-Ressourcendatei

    PowerDesigner bietet die Möglichkeit, die Eigenschaften für eine Datenbank in der sogenannten DBMS-Ressourcendateien zu bearbeiten. Die DMBS-Ressourcendateien enthalten alle Informationen für den PowerDesigner, um DDL, DML und andere SQL Artefakte zu generieren. Für viele Datenbanken gibt es vorgefertigte, mitgelieferte DBMS-Ressourcendateien für die unterschiedlichen Datenbankversionen.

  • DWH Automation - Expectations & Reality (1)

    How can repeating tasks be simplified? The question of automating processes in a data warehouse (DWH) keeps project teams busy.

  • DWH Automatisierung - Erwartungen & Realität (1)

    Wie können wiederkehrende Aufgaben vereinfacht werden? Die Frage nach der Automatisierung von Prozessen in einem Data Warehouse (DWH) beschäftigt Projektteams.

  • FastChangeCo - A Fictitious Company

    The company FastChangeCo is a fictitious company I developed in 2015 to illustrate problems, challenges and opportunities our customer had in their projects. I used FastChangeCo successfully during my talks, workshops, trainings, coaching and projects.

    FastChangeCo is a company founded in the early 20th century. Today, we would say it was a Start Up. The founder, Mr. Fast, had great ideas for building assembly lines which came up in the early 20th century used by Ford and others. During the following decades his company grew to become a big player in the nineties of the last century.
    Nowadays, FastChangeCo has thousands of employees and thousands of products in different industries and billions of revenue.

  • Fünf Jahre TEDAMOH

    Fünf Jahre TEDAMOH

    Liebe Leser und Leserinnen meines Blogs,

    vor fünf Jahren ist eine lang gehegte Idee von mir Wirklichkeit geworden. Am 1. Juli 2017 erblickte TEDAMOH das Licht der Welt.

  • How to choose a timestamp for a Data Vault timeline?

    TEDAMOH - Secret Spice Data Vault timeline - Picture by Parrish Freeman on Unsplash

    Does the Load Date Timestamp (LDTS) data element in the hub, link, or satellite capture the timestamp of the batch, or rather the transaction timestamp at which the data originated in the operational system?

  • PowerDesigner auf Apple MacBook - M2 Chip

    Der PowerDesigner ist derzeit nur für das Betriebssystem Windows verfügbar. So weit, so bekannt. Amal Leyla Qasim, Datenmodelliererin im Data Management Center of Excellence (DMCE) Team, hat sich zum Ziel gesetzt, ihren Arbeitsplatz auf einen Apple MacBook umzustellen.

  • PowerDesigner on Apple Mac - M2 chip

    PowerDesigner is currently only available for the Windows operating system. So far, so familiar. Amal Leyla Qasim, a data modeler on the Data Management Center of Excellence (DMCE) team, has set her sights on switching her workstation to an Apple MacBook Air.

  • PowerDesigner Serie

    / SECRET SPICE - PowerDesigner Serie

    Tipps und Tricks rund um PowerDesigner

    In loser Folge berichte ich hier über meinen Erkenntnisgewinn mit dem Datenmodellierungswerkzeug PowerDesigner. Für mich selbst ist diese Serie eine Art Tagebuch, eine Wissensbasis und das ‘Secret Spice’, in der ich meine Entdeckungen, meine für mich selbst dokumentierten Tipps und Tricks rund um den PowerDesigner festhalte: Für Probleme des oder mit dem PowerDesigner, die ich während der Bearbeitung von Aufgaben in der Datenmodellierung hatte.

    Erwartet hier daher keine Neuigkeiten über das Datenmodellierungswerkzeug PowerDesigner selbst.

    Natürlich, und wie immer, aus meiner persönlichen Sicht oder aus Sicht einer der Team-Mitglieder des Data Management Center of Excellence (DMCE) bei meinem liebsten Kunden: FastChangeCo!

  • PowerDesigner series

    / SECRET SPICE - PowerDesigner SerieS

    Tips and tricks for PowerDesigner

    In loose order I report here about my gain of knowledge with the data modeling tool PowerDesigner. For myself, this series is a kind of diary, a knowledge base and the 'Secret Spice', in which I record my discoveries, my tips and tricks around PowerDesigner documented for myself: For problems of or with PowerDesigner that I had while working on data modeling tasks.

    So don't expect any news here about the data modeling tool PowerDesigner itself.

    Of course, and as always, from my personal point of view or from the point of view of one of the team members of the Data Management Center of Excellence (DMCE) at my favorite customer: FastChangeCo!

/ Testimonials

Feedback from our clients

What customers say about TEDAMOH!


With his expertise as a coach for Data Vault and flexible data warehouse architectures, Dirk Lerner can be fully recommended.

Read more …
TEDAMOH - Data Modeling Certification (DMC)

The data modeling certificate helped me a lot to get an overview of the different data modeling categories and to deepen my theoretical knowledge again after the practical work experience I made.

Read more …
TEDAMOH Data Modeling Workshop - patrick-perkins-unsplash

From our point of view, there are two reasons why the workshop with TEDAMOH was a complete success. TEDAMOH manages to present complex topics of data modeling in a vivid and clear way and thus to pick up and carry along all participants with different backgrounds in equal measure.

Read more …
TEDAMOH Data Modeling Coaching - diego-ph-unsplash

I know that I learned a lot from you and truly appreciate all of your generous and patient coaching. 

Read more …