Nowadays, most data warehouses already store some kind of history of data. But what about events that took place at a different time than what the data warehouse represents to us? Or data that will be valid in the future? For example, future planned prices for products and goods or special prices for discount battles or sales promotions like the “Black Friday” in the United States.
Dirk Lerner, the teacher of Temporal data in a fast-changing world! will focus in this class on methods and techniques for storing bitemporal data in a Data Warehouse and afterwards merging timelines of bitemporal data, e.g. Data Vault Satellites, to get data out of the Data Warehouse’s core layer. He will show bitemporal basics for a better understanding of loading data as well as the concepts to develop SQL queries to insert and update temporal data within a Data Warehouse. Finally, concepts to provide Star Schema Dimensions as non-, uni- or bitemporal objects will be demonstrated.
On the first day of the Temporal data in a fast-changing world! training the attendees will understand the basic temporal concepts. They will practice how to model uni- and bitemporal database objects with Data Vault and how to load bitemporal data into a Data Warehouse.
The second day of the Temporal data in a fast-changing world! training will focus on how to get data out of the Data Warehouse. How to merge timelines of Data Vault objects and provide temporal data within a Star Schema. The attendees will understand the concepts by doing a lot of practical exercises.
On both days real world examples will be shown and attendees will do several exercises and SQL-tutorials.
Arrival, departure and overnight stay are not included in the training.
the training includes a course material set, an eBook and SQL examples to download as well as drinks, lunch buffet and snacks in the breaks. Of course, there is also plenty of room for exercises, discussions and questions.
Every participant has the exclusive opportunity to join the Temporal Data Alumni and participate in the Temporal Data Alumni Meetups.
Please, note: You need to take your own laptop into the course!
As a Data Architect, Business Analyst, Data Modeler, Data Vault Expert, ETL developer, Data Warehouse Manager, BI Expert or BI Consultant you will get most out of this class.
If you are in doubt get in touch with us!
Public training classes will take place in Frankfurt, Hamburg, Munich, Stuttgart, Cologne and Berlin. If another city is interesting for you, please get in touch with us.
In-house training classes can be offered on request.
Thanks to everyone who took part in one of our presentations about temporal data, or has taken the time to reach out to us. Your positive feedback and success stories are what keep us striving to set up this training class and get even better!
On these conferences we presented or will present about temporal data:
|Datum, Uhrzeit||2019-11-25 10:00|
|Ort||Design Offices - Stuttgart Eberhardhöfe|
|Anzahl der Teilnehmer||Kosten/Person (€)|