Why do countless data solutions deal with temporal data every year, expending thousands and spending hundreds of hours developing solutions that don't work?
The often incomplete knowledge or the different definitions and interpretations of temporal data lead to a considerable additional effort and frustration for all parties involved.
Good definitions and methods as well as techniques for handling temporal data in a data warehouse prevent this additional effort and simplify the implementation significantly.
The training Temporal data in a fast-changing world! teaches the theory of bitemporal data and contains realistic exercises for the participants.
This training is taught by us in German or English.
Content
The Temporal data in a fast-changing world! training focuses on methods and techniques for handling bitemporal data in a data warehouse. This includes data modeling, loading bitemporal data into a target data object in the core layer of the data warehouse, and finally making this data available to users.
Nowadays, a data warehouse stores more or less historical data. But what about events that took place outside the represented time span? Or with data that arrives late in the data solution? Or with data that will be valid in the future? For example, planned prices for products and goods, or future special prices for discount promotions such as Black Friday in the USA.
The training addresses these questions in three modules and offers answers and solutions.
All modules contain realistic examples and the participants apply what they have learned in exercises. The SQL tutorials and solutions belonging to the exercises are made freely available to the participants.
After the Temporal data in a fast-changing world! training, you will understand not only temporal data in theory, but also how to properly load, store, and deliver it to users.
Modules
The training Temporal data in a fast-changing world! consists of three modules with about 10 exercises and min. 16 teaching hours.
In the first module, the basics of temporal theory are taught. In the second module, the acquired knowledge is practically applied and further consolidated. The third module teaches the preparation of temporal data in a Star schema.
Theory and concepts
Module 1 provides an overview of temporal theory and methods and an introduction to the basic concepts of temporal data and structures:
- Temporal concepts
- Bitemporal terminology and data structures
- Clock ticks and time periods
- Allen Relationship
Load temporal data
By completing Module 2, you will have learned and reinforced the basic SQL concepts for loading temporal data into (Data Vault) structures:
- Load and save unitemporal data
- Load and save bitemporal data
- End-Dating and Insert-Only
Read temporal data
Module 3 provides an overview of temporal data in a star schema - facts and dimensions - and how to merge different timelines:
- Merging and compacting temporal data
- Data Vault helper objects
- Supply of temporal data in the Star Schema
Exercises
In the 3 modules of the training Temporal data in a fast-changing world! about 10 exercises are carried out to deepen the theoretical knowledge.
For the exercises of the Temporal data in a fast-changing world! Training you get access to a download area with exercises (workbook) as well as practical exercises for implementation in SQL and extensive test data with which you can carry out the exercises. Some of the exercises are:
- Unitemporal data (theory)
- Bitemporal data (theory)
- Unitemporal data (SQL)
- Bitemporal data (SQL)
- Insert Only Data
- Merge bitemporal data
- Building a Star Schema with temporal structures
All exercises are explained in detail by the trainer and there is plenty of time.
Added value
By participating in the training Temporal data in a fast-changing world! you create added value for yourself and your company!
Your newly acquired knowledge of definitions, methods and techniques for handling bitemporal data in a data warehouse will make you an expert for temporal data in your company. This will help you avoid unnecessary extra work in the future and greatly simplify implementation in your data solution. You can thus ensure smooth communication about temporal data and the associated requirements between business experts and IT experts.
This includes:
- You understand why bitemporal data is needed and when it makes sense to use it.
- You can read the Allen Relationship with the same confidence as a shopping list.
- You can validate temporal processes using test data.
- You understand the need to define clock ticks and time periods.
- You can identify issues related to structural robustness and temporal guideline violations.
- You will use a set of templates to create and validate your own temporal processes.
- You will be able to travel through time - correctly create and bvalue queries over time.
After the Temporal data in a fast-changing world! training, you will not only know that temporal data exists, but also how to handle it correctly.
Target audience
Temporal data in a fast-changing world! is a comprehensive training course that teaches both the theory and practical techniques for implementing bitemporal databases or temporal data.
The training is intended for all beginners and advanced users who are substantively concerned with the methods, concepts, and terminology of temporal data or who have one or more of the following terms in their job title:
- Analyst
- Architect
- Data Architect
- Data
- Developer
- Database
- Modeler
- Data warehouse
- Business Intelligence
We also welcome people who do not have these terms in their job title, but are interested in the topic and would like to expand their knowledge to integrate temporal data, historize data in general, or make this data available to users.
You are a student, trainee or work at a university? Then ask Dirk about our education discount!
Trainer
DIRK LERNER is an independent and experienced consultant and coach. With more than two decades of experience in BI projects, he is a proven expert in BI architectures, data modeling and temporal data. Dirk is committed to 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.
As a pioneer for Data Vault and FCO-IM in Germany, he has published numerous papers and is a highly regarded international speaker at conferences.
Available worldwide
Temporal data in a fast-changing world! is a comprehensive temporal training, which we offer worldwide in German and English.
Either as open training (Open Class) or at your location, in your company, as closed training (In-House). On the one hand as a virtual training in four parts or on the other hand as a two-day classroom training.
WORLDWIDE
Temporal data in a fast-changing world! is offered individually for you as virtual training or on-site at your company around the world.
In-House
Would you like a closed, private training? Contact us and together we will find a date and a form of carrying out.
We will be happy to make you an individual offer.
Open Class
Twice a year we offer Temporal data in a fast-changing world! as an open training.
All current dates can be found at the bottom of this page.
Testimonials
What participants are saying about Temporal data in a fast-changing world!
Since more than 15 years I’m working with bitemporal data in Data Warehouse solutions. Meanwhile it is easy to design, build and populate tables for bitemporal data. But how to design and build bitemporal dimensional modeled Data Marts was new to me. Dirk Lerner does a very good job in explaining complex bitemporal stuff.
Dirk Lerner and his presentation on bitemporal modeling at first gave me a brain freeze. However, his explanation of using a Data Vault satellite to track changes over time and collapsing the changes into a dimension for analytics was not only a requirement for financial reporting in Germany but also quite ingenious.
Frequently asked questions
Is prior knowledge required?
No prior knowledge of temporal data is required for the temporal training. Basic knowledge of SQL is advantageous for the exercises.
Is SQL a prerequisite in the training?
Yes, basic knowledge of SQL is beneficial for the exercises.
For the exercises in the Temporal data in a fast-changing world! training you need a database in which the exercises can be done. The exercises can be carried out on most relational databases.
What are the technical requirements?
To participate in a virtual training Temporal data in a fast-changing world! you need a laptop, a PC or a tablet and the possibility to use Micrososft Teams (browser or client).
For the exercises in the Temporal data in a fast-changing world! training you need a database in which the exercises can be done. The exercises can be carried out on most relational databases.
Is there a cloud database for the exercises?
A cloud database solution is planned for 2023 for the exercises in the Temporal data in a fast-changing world! training.
Upcoming trainings
There are no events in the selected category