Definition of Seminar, Training and Workshop
Training, seminar and workshop - these terms are often used synonymously. They all refer to further education and training events, but the objectives differ. Roughly speaking, seminars convey theoretical knowledge, trainings are practically oriented, and workshops provide a framework in which the participants can acquire knowledge themselves.
If you would like to be trained in the usage of a new software (tool) or method, such as dealing with temporal data, training is a suitable option. Because you can learn and practice how the program or method works by yourself.
You want to create a new data model for your data warehouse or an application for the customers of your data warehouse and don't know how it should be designed? Then a creative workshop, e.g. with the domain experts and/or design thinkers for the BI team is exactly what you need. Detached from everyday business, (completely) new ideas and solutions can be developed.
Start DWH Automation - Expectation and Reality
Many data warehouse project teams today are considering the automation of processes. How can you simplify the same tasks over and over again, leave them to an automatism and put as little permanent effort into development as possible? The desire for a solution, an automation tool, is then usually very quickly present.
Temporal data in a fast-changing world!
This training will focus on methods and techniques for handling bitemporal data in a Data Warehouse. It includes how to populate and afterwards get bitemporal data out of the Data Warehouse’s core layer.
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.
A matter of time
What exactly is temporal data? In this session, Dirk Lerner provides insight into what temporal data is and why data is a matter of time for certain business scenarios.
With simple examples, Dirk uses these business scenarios to visualize the differences in temporal approaches to historizing data and their implications.
Finally, Dirk Lerner presents the technologies available today that have implemented (bitemporal) historization of data.
DMC - Complete Bundle (2022-Fall)
With this package you book all webinars and the DMC exam in the period September to November 2022 for the package price of 499€ instead of 568€ for an individual booking.
A further booking of the individual webinars as well as the DMC exam is not necessary. You will receive a separate booking confirmation for each webinar. If you book by invoice, you will find the payment instructions in the booking confirmation for this complete package.
If the webinars are fully booked, no booking will take place.
Please note: The webinar series is currently only available in German.
The following webinars and the exam are included:
- DMC (00) - Overview
- DMC (01) - Categoy Syntax
- DMC (02) - Category Components
- DMC (03) - Category Process and Approach
- DMC (04) - Category Conceptual, Logical, and Physical
- DMC (05) - Category Relational and Dimensional
- DMC (06) - Category Notation
- DMC (07) - Category Abstraction
- DMC (08) - Category Standards
- DMC (09) - Category Definitions
- DMC (10) - Category Best practices and pitfalls
- DMC - Exam
DMC (00) - Overview
In this webinar, Dirk provides general information about the Data Modeling Certification (DMC) and the ten categories that the certification exam covers. Learn about the requirements for and benefits of the DMC, and learn more about preparing and registering for the exam. He presents the added value of the free performance assessment answers all your questions about the certification during the webinar.
DMC (01) - Categoy Syntax
In this webinar, you will familiarize yourself with the necessary, basic symbols for data modeling using sample exam questions in order to convert ambiguities into precise information. In the process, you will learn to check the technical assumptions and the representation in the data model. At the same time, practice answering the Syntax category questions, which are very similar to the questions on the Data Modeling Certification (DMC).
DMC (02) - Category Components
In this webinar, you will use sample exam questions to familiarize yourself with the components of a data model, including entities, relationships, attributes, keys, domains, and subtypes.
At the same time, practice answering the component category questions, which are very similar to the questions on the Data Modeling Certification (DMC).
DMC (03) - Category Process and Approach Webinar
In this webinar, you will use sample exam questions to familiarize yourself with the techniques for eliciting data modeling requirements and validating a data model.
At the same time, practice answering the Process and Procedure category questions, which are very similar to the questions on the Data Modeling Certification (DMC).
DMC (04) - Category Conceptual, Logical, and Physical
In this webinar, you will use sample exam questions to familiarize yourself with the purpose and characteristics of conceptual, logical, and physical data models.
At the same time, practice answering the questions for the Conceptual, Logical, and Physical category, which are very similar to the questions on the Data Modeling Certification (DMC).
Temporal data in a fast-changing world!
This training will focus on methods and techniques for handling bitemporal data in a Data Warehouse. It includes how to populate and afterwards get bitemporal data out of the Data Warehouse’s core layer.
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.