ADVANCED DATA VAULT MODELING SEMINAR & LAB

The next level beyond the Certified Data Vault Data Modeler course is the Advanced Data Vault.  This course has been totally redesigned for 2017 and consists of two (2) intensive days of interactive modeling and group case analysis.

Teacher: Hans Hultgren
Location: Top of Minds, Stockholm

Special Price 14900 SEK (12900 SEK Early Bird)

FOCUS

The focus of this course is modeling.  In particular this course is focused on providing students a deeper understanding of the various options available within the Data Vault Ensemble modeling approach.

GOAL

The goal of this course is to enable data modelers and architects to make the most informed and best possible modeling decisions when establishing their specific modeling pattern in their organization.

APPROACH

This course follows an example-driven approach based on over a dozen real-life modeling cases.  For each modeling scenario there is a business case that leads to a set of alternatives.  Through interactive group analysis and discussions, and drawing on the experiences of the students in the class, the various alternatives are uncovered, considered, often ranked, and ultimately classified and categorized based on best practice considerations, pros & cons, and how appropriate they might be given the specific business scenarios.

TARGET AUDIENCE

This course if for data modelers, data architects, information modelers, and other data warehousing and business intelligence professionals who work with the design of conceptual, logical or physical data.  Students attending this course should be comfortable with the Data Vault modeling approach and the broader concepts of Ensemble Modeling.  Ideally certified CDVDM modelers, those actively working with Data Vault or those who have spent time working with data warehouse modeling ensembles.

UNIQUE VALUE

This course provides the unique opportunity to leverage decades of Data Vault modeling experience from around the World to gain a deeper understanding of Data Vault modeling and the impact of various different patterns.  It also provides a venue for connecting with other modelers to share experiences, ideas, models, challenges, discoveries, and to work together towards a common better understanding of ensemble modeling.

SELECTED TOPICS

1. Modeling Events (and the role of links)
2. Modeling Context Arrays (impact on satellite design)
3. Modeling for Big Data, Cloud & Streaming Deployments (leveraging new platforms)
4. Modeling UOW – Event based UOW  (advanced link design)
5. Modleing UOW – Keyed Instance UOW (hubs vs links)
6. Modeling Address  (context close to key)
7. Modeling the BK in and EDW  (dealing with lack of Enterprise Key – also include Anchor/Focal alternatives)
8. Modeling the Shuttle for Fuzzy Integration (dealing with realistic integration)
9. Modeling the SAT BOK  (alternate, degenerate keys, etc.)
10. Modeling for Personally Identifiable Information and Privacy (PID)
11. Architecture – Defining and Deploying the RAW and BDV (establish approach)
12. Ensemble Logical Form (ELF) and Virtualization (in memory)
13. Modeling Automation – the Play Book  (how and when to automate)

FEES

Special Price 14900 SEK (12900 SEK Early Bird, six weeks before event)

Fee includes course materials, coffee, and lunches.

Data Modeling for Operational Systems, Data Warehousing, and Data Marts

Teacher: Hans Hultgren.
Location: Stockholm

This course covers the core principles of data modeling through lectures and hands-on labs and exercises.  Providing a solid overview of current techniques for modeling operational systems, data warehouses, and data marts.

In covering these areas, the course considers data modeling and design using normalized data modeling 3^rdNormal Form for Operational Systems, Ensemble Data Vault modeling for the Data Warehouse, and Dimensional modeling (Star Schema) for Data Marts.

3NF Modeling. The course will start with the core fundamentals of database design including identifying the core entities and relationships, creating logical model designs, defining attributes and key structures, and developing entity relationship diagrams (ERDs).  Within the scope of this modeling approach, the lessons will cover business rules, normalization, validation rules, reference tables, key constraints, identifying and non-identifying relationships, recursive relationships, redundancy, subtypes and supertypes, and relationship cardinality.  Students will become comfortable with the core rules and best practices approach to 3NF modeling.

DataVault Modeling. The training will continue with the fundamentals of data warehouse modeling for the enterprise data warehouse (EDW).  Within this section the core concepts of data warehousing are presented including the focus on integrated, non-volatile, time-variant and subject oriented data. Ensemble Modeling techniques are optimized for these requirements. The most popular of these, the Data Vault modeling approach, is presented including business keys (Hubs), relationships (Links) and context/history (Satellites).  The course continues with core business concepts, ensembles, unified decomposition, concept constellations, and natural business relationships. The course considers how to model your enterprise data warehouse, modeling techniques for agility, operational support, auditability, and enterprise data integration. Lessons, exercises and labs are focused on best practices for architecting and modeling your data warehouse for long term success.

Dimensional Modeling. Next the training will cover dimensional data modeling based on current best practice interpretations of the Kimball Star Schema dimensional modeling approach.  First lessons will begin with the fundamentals of dimensional modeling including the purpose and structure of Facts and Dimensions, denormalization, the concept of Slowly Changing Dimensions (SCDs) and the main Dimension Types (Type 2 and also covering Type 0, 1, 3, 4 and 6), and then the modeling and design of solid dimensions and encouraged forms of Star Schemas.  The course continues with defining and designing Snow Flake models, the encouraged and acceptable practices for deploying these concepts.  Lastly, the course will cover physical data model considerations and DW/BI deployment topics.

Modern Data Modeling. Applying these techniques now and into 2020 includes a fresh discussion on Conceptual Modeling, Logical Modeling and Physical Data Modeling/Management. These topics are presented including how they relate to modern architectures such as Big Data platforms and Cloud deployments. This includes a discussion of Ensemble Logical Form (ELF) as applied to these new architectures. This topic also addresses the role of Data Modeling for the Data Scientist.

The Target Audience for this class includes Data Modelers, Business Analysts, Data Analysts, DWBI Managers, Data Architects, Database/Data Warehouse Designers, and Data Scientists.  Note that unlike other data modeling courses, this course takes a global view of database across the organization to include the enterprise initiatives (big data, data warehousing and business intelligence).

Course Fee: 21500 SEK (18500 Early Bird, sign up six weeks in advance) excluding VAT.

Associated labs, exercises and assessments are included with the course materials


Lär dig Data vault modellering av Hans Hultgren.

Uppdaterat kursinnehåll
Denna nya uppdaterade kurser innehåller ett utökat material som inkluderar Big Data integration med Shuttle Hash, den expanderade Unit of Work analysen samt SAT_BOK och många andra uppdateringar. Lär dig bygga bättre mer skalbara och agila datalager som kan samexistera tillsammans med dina andra data lösningar för Advanced Analytics.

Registrera dig för en tredagarskurs och bli Certified Data Vault Data Modeler (CDVDM) med det senaste versionen av Data Vault.

Genom lärarledda lektioner, omfattande labb-övningar och förberedande videolektioner online kan du bli certifierad i vad Bill Inmon kallar “optimal choice for modeling the EDW in the DW 2.0 framework“.
   Läs mer om kursinnehållet här.

Data Modeling for Operational Systems, Data Warehousing, and Data Marts

Teacher: Hans Hultgren.
Location: Boulder, Colorado, USA

This course covers the core principles of data modeling through lectures and hands-on labs and exercises.  Providing a solid overview of current techniques for modeling operational systems, data warehouses, and data marts.

In covering these areas, the course considers data modeling and design using normalized data modeling 3^rdNormal Form for Operational Systems, Ensemble Data Vault modeling for the Data Warehouse, and Dimensional modeling (Star Schema) for Data Marts.

3NF Modeling. The course will start with the core fundamentals of database design including identifying the core entities and relationships, creating logical model designs, defining attributes and key structures, and developing entity relationship diagrams (ERDs).  Within the scope of this modeling approach, the lessons will cover business rules, normalization, validation rules, reference tables, key constraints, identifying and non-identifying relationships, recursive relationships, redundancy, subtypes and supertypes, and relationship cardinality.  Students will become comfortable with the core rules and best practices approach to 3NF modeling.

DataVault Modeling. The training will continue with the fundamentals of data warehouse modeling for the enterprise data warehouse (EDW).  Within this section the core concepts of data warehousing are presented including the focus on integrated, non-volatile, time-variant and subject oriented data. Ensemble Modeling techniques are optimized for these requirements. The most popular of these, the Data Vault modeling approach, is presented including business keys (Hubs), relationships (Links) and context/history (Satellites).  The course continues with core business concepts, ensembles, unified decomposition, concept constellations, and natural business relationships. The course considers how to model your enterprise data warehouse, modeling techniques for agility, operational support, auditability, and enterprise data integration. Lessons, exercises and labs are focused on best practices for architecting and modeling your data warehouse for long term success.

Dimensional Modeling. Next the training will cover dimensional data modeling based on current best practice interpretations of the Kimball Star Schema dimensional modeling approach.  First lessons will begin with the fundamentals of dimensional modeling including the purpose and structure of Facts and Dimensions, denormalization, the concept of Slowly Changing Dimensions (SCDs) and the main Dimension Types (Type 2 and also covering Type 0, 1, 3, 4 and 6), and then the modeling and design of solid dimensions and encouraged forms of Star Schemas.  The course continues with defining and designing Snow Flake models, the encouraged and acceptable practices for deploying these concepts.  Lastly, the course will cover physical data model considerations and DW/BI deployment topics.

Modern Data Modeling. Applying these techniques now and into 2020 includes a fresh discussion on Conceptual Modeling, Logical Modeling and Physical Data Modeling/Management. These topics are presented including how they relate to modern architectures such as Big Data platforms and Cloud deployments. This includes a discussion of Ensemble Logical Form (ELF) as applied to these new architectures. This topic also addresses the role of Data Modeling for the Data Scientist.

The Target Audience for this class includes Data Modelers, Business Analysts, Data Analysts, DWBI Managers, Data Architects, Database/Data Warehouse Designers, and Data Scientists.  Note that unlike other data modeling courses, this course takes a global view of database across the organization to include the enterprise initiatives (big data, data warehousing and business intelligence).

Course Fee: $2,195 USD

Associated labs, exercises and assessments are included with the course materials


Lär dig Data vault modellering av Hans Hultgren.

Uppdaterat kursinnehåll 2017
Denna nya uppdaterade kurser innehåller ett utökat material som inkluderar Big Data integration med Shuttle Hash, den expanderade Unit of Work analysen samt SAT_BOK och många andra uppdateringar. Kursen går igenom det senaste inom Data Vault 2017 och går även igenom vidareutvecklingen som skett sedan den gamla ”Data Vault 2.0”.

Lär dig bygga bättre mer skalbara och agila datalager som kan samexistera tillsammans med dina andra data lösningar för Advanced Analytics.

Registrera dig för en tredagarskurs och bli Certified Data Vault Data Modeler (CDVDM) med det senaste versionen av Data Vault.

Genom lärarledda lektioner, omfattande labb-övningar och förberedande videolektioner online kan du bli certifierad i vad Bill Inmon kallar “optimal choice for modeling the EDW in the DW 2.0 framework“.
   Läs mer om kursinnehållet här.


Lär dig Data vault modellering av Hans Hultgren.

Uppdaterat kursinnehåll
Denna nya uppdaterade kurser innehåller ett utökat material som inkluderar Big Data integration med Shuttle Hash, den expanderade Unit of Work analysen samt SAT_BOK och många andra uppdateringar. Lär dig bygga bättre mer skalbara och agila datalager som kan samexistera tillsammans med dina andra data lösningar för Advanced Analytics.

Registrera dig för en tredagarskurs och bli Certified Data Vault Data Modeler (CDVDM) med det senaste versionen av Data Vault.

Genom lärarledda lektioner, omfattande labb-övningar och förberedande videolektioner online kan du bli certifierad i vad Bill Inmon kallar “optimal choice for modeling the EDW in the DW 2.0 framework“.
   Läs mer om kursinnehållet här.


Lär dig Data vault modellering av Hans Hultgren.

Uppdaterat kursinnehåll
Denna nya uppdaterade kurser innehåller ett utökat material som inkluderar Big Data integration med Shuttle Hash, den expanderade Unit of Work analysen samt SAT_BOK och många andra uppdateringar. Lär dig bygga bättre mer skalbara och agila datalager som kan samexistera tillsammans med dina andra data lösningar för Advanced Analytics.

Registrera dig för en tvådagarskurs och bli Certified Data Vault Data Modeler (CDVDM).

Genom lärarledda lektioner, omfattande labb-övningar och förberedande videolektioner online kan du bli certifierad i vad Bill Inmon kallar “optimal choice for modeling the EDW in the DW 2.0 framework“.
   Läs mer om kursinnehållet här.

OBS! Detta är en fördjupad tredagarskurs.


Lär dig Data vault modellering av Hans Hultgren.

Uppdaterat kursinnehåll
Denna nya uppdaterade kurser innehåller ett utökat material som inkluderar Big Data integration med Shuttle Hash, den expanderade Unit of Work analysen samt SAT_BOK och många andra uppdateringar. Lär dig bygga bättre mer skalbara och agila datalager som kan samexistera tillsammans med dina andra data lösningar för Advanced Analytics.

Registrera dig för en tvådagarskurs och bli Certified Data Vault Data Modeler (CDVDM).

Genom lärarledda lektioner, omfattande labb-övningar och förberedande videolektioner online kan du bli certifierad i vad Bill Inmon kallar “optimal choice for modeling the EDW in the DW 2.0 framework“.
   Läs mer om kursinnehållet här.